Recent content by LittleJonny

You can use the Format(timestring, "HH:MM:SS") to get any format that you want. Hope this helps LJ

I am trying to make a MDE file out of a MS Access (office 97) App that I have created. I keep getting a message "Compile error in hidden module: modImportData". modImportData contains several Functions and Subs. Anyone got any idea on how to track down this hidded module ? The code functions...

Yes it does work in acdialog mode. I was using form open & thought that they would be the same. thx fizzio

does on load work when you open the form in acdialog mode ?? docmd.openform FormName:="frmCalendarControl", WindowMode:=acdialog, OpenArgs:=Date I can manage ok with the regular form but the acdialog is needed for operator control. LJ

You could use a for loop with a step of 15 for i = 0 to 2145 rst.edit if rst.fields(i).value = xxxx then ... ... ... rst.update next i

You can open the access DB with VB and keep all the tables. you can do anything with the tables (even create new ones) with VB. I can give you some more assistance (?) if you can give some more info on what you need to do. E-mail me if you still need the help. LJ

I am trying to use the calendar control from Actctrls.mdb. This app opens a calendar form in acdialog mode (which I need to keep). I cannot get the default date to = todays date. I think there is a problem with the openargs:= date. Anyone ever used this little thing from microsoft or does anyone...