Search results

Combo box Using a combo box will do just that.

access As Bob's response indicated you can make a mde file. You can also make custom toolbars where a user only has certain options available to him/her. You can also password protect. A true exe file--No. Do a search on this forum and you should find plenty of info in addition to what was...

error the code should be tbl1 not frm1 =DLookUp("[Value1]","tbl1","[IDData]=Forms![frm1]![IDData]-1")

reports JC, Take a look at this possible solution http://groups.google.com/group/microsoft.public.access.reports/browse_thread/thread/16bb75a46e4241aa/1dab0d2b78e9ef7%231dab0d2b78e9ef7 In this case you would use forecolor instead of backcolor

time Access stores the time field as 8-byte floating point number. So, setting it to hundredths (atleast to my knowledge) won't work. You could store it as text and then use math equations to interpret it I suppose.

list box Transparent background...not that I know of. As far as Activex, I avoid using those like the plague.

forms Does setting your form as a continuous form give you what you want?

check box I don't believe a resize of the check box tick does anything in access 2000 or 2003. Maybe someone here knows if 2007 has that function

lines,lines,lines, ya I believe there is a me.drawwidth= anumber function for thickness. line (0,0)-(100,100),color.............I think

exists You could use the dlookup function to see if it already exists.

points I got an error for a missing reference when opening your form, but no matter. I have never tried printing a report with this format and code. Did you try using subreports instead? Atleast you would now have bound fields.

lock down Sounds like you should look at the allow additions and editing properties of your form.

reports Thanks for reporting back Keith. I did not have time to try it but looks like you got it worked out in case the rest of us need this solution at a later date.

copy cat Are you able to post your db so someone can take a quick peek at it?

Use the force Unfortunately we are not clarevoyent.

defs currentdb.TableDefs("table1").Fields("OldFieldName").Name = "NewFieldName" Hope this helps

iif You must specifiy what you want for your false value. Remove the > in the false part and replace with 0.

invoice number Place the following code first behind the on click event of the command button that prints the report. This will make certain the info on your form is saved before the print statement is carried out. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 On...

subreports Don't know if this will help, but............. http://www.groupacg.com/ARptTip.htm#SUBR1

Ring I work with a young guy in his early twenties. He told me his girl friend wants him to give her a ring. I told him that's OK, pick up the phone and give her a call.:D