If you turn an insert query from design view into SQL view, it will look like this
INSERT INTO participants ( projectid, person )
SELECT 1002471 AS Expr1, '1453703' AS Expr2;
Now the select statement is a bit ugly for a single line entry. Following is a more elegant way to add values.
Insert into participants (projectid, person) values ( 1002471,'1453703')
Tuesday, June 19, 2007
Saturday, June 16, 2007
Sometimes you want to make a button with a favorite (small) image and you don't have a bmp file or a ico and cannot make one. In this case add the image that you want to your form.
Set the following properties on the image,
size mode = stretch (if the image is too large)
special effect = raised
name = "Something meaningful"
Now setup the following code for the onclick event.
Private Sub fetch1_Click()
'Make an image behave like a button
fetch1.SpecialEffect = acEffectSunken
YOUR CODE HERE (ie docmd.openform )
fetch1.SpecialEffect = acEffectRaised
Here is a sample of an image as button
Tuesday, June 12, 2007
Saturday, June 09, 2007
I have updated the page that shows you how to find a record using a combo