Recent content by ericgeil

How can you run a program using "shell" and specify a "Start In" directory. For example, I have a win 98 shortcut that has the following info: Target : C:\KRONOS\APPS\tkcwin.exe Start In: x:\KRONOS\data witout the "start in" info, the program will not run I have tried shell...

If you want this field to be unbound, try the DLookup funtion. The Access help file for this function should get you there. Eric

I have a db that will create several instances of a form. I would like to refer to a field on a specific instance of the form for a query criteria. I have tried: forms![frmEmpInfo(1)]![SSN] This didn't work. Any ideas? Thanks in advance. Eric

Use the dateadd function: dateadd("h",-1,now())

This one should be easy. How do you use a common dialog control as an open/save as dialog? In VB6 I would just use the .showopen method, but this method is not available in VBA. Thanks

How do I use the common dialog control as an Open or SaveAs dialog? Why did this have to be different from vb (CommonDialog1.ShowOpen)? Thanks. Eric

place the information in the form header. To add the form header, go to View -> Form Header/Footer.

Thanks!

If you are wanting he starting and ending dates of the current week, try this: To get Monday place this as the control source for a text box: =DateAdd("d",(Weekday(Now())-2)*-1,Now()) To get friday use this: =DateAdd("d",6-Weekday(Now()),Now()) Weekday (now) gives you a number (1-7)...

I have a report that lists some dollar figure [Amount]. I would like the dollar amount to be written out, rather than in numeric form. (i.e. Three hundred forty nine dollars and 52 cents as opposed to $349.52). Can this be done with the format$ function, or is there any other way to do this...

OK, from the top.... As far as I know you cant type in any sort of formula for a criteria that will adapt depending on the selections/# of selections in a list box. You can however set the sql property of a querydef object to anything you want, including a string. So what we need to do is...

Create a textbox with the control source =Count([field1]) or =Sum([field1])

Maybe I'm misunderstanding the first one, but if the field is in the source table for our form, it seems you could just use me.[Record #] 2nd: I would use the After Update event to avoid firing an email if someone tabs to the control. Or, I would put it in your submit button, so the two emails...

Make sure you have a Form Footer visible (In Access 2000 it's View -> Form Header/Footer) In the footer place a text box and place this in the Control Source Property: =Count([Prodtype])