Recent content by Late4Supper

Okay, I copied the code from ????. Easy enough to adjust.

If you're clearing ALL your input fields on a form you can throw this in a Module Sub ResetFormFields(strFormName As String) Dim ctl As Control For Each ctl In Forms(strFormName) Select Case ctl.ControlType Case Is = acTextBox ctl = ""...

Okey Dokey

Check out the work by Cosmos75 and Oldsoftboss in the Sample Data base section of this forum (search on common)

This is what I use to transfer spreadsheets so it should be similar Dim tmpFilePath As String tmpFilePath = Me!txtFilePath 'This is a field on my form DoCmd.TransferSpreadsheet acImport, 8, "ImpRates", tmpFilePath, False, "" I populate the form's field from a dialog box created from the...

Check this out in the Code repository http://www.access-programmers.co.uk/forums/showthread.php?t=62237 It adds work days to a given date and allows you to specify Holidays also

Thanks to Jon K.

Plan B (maybe) When I added several records with the format set to Short Time I got 12:00 PM = 12:00 + 01:00 AM = 1:00 + 02:00 PM = 14:00 = 1.125 [days ] * 24 = 27 Hours I've attached a ACCESS 2002 zipped file for an example.

Format Short Time worked for me for a 24 clock. 1:00 am = 1:00 2:00 pm = 14:00

Have you tried the format property for Date/Time data types?

NavyGuy, give a shout if you still need help. I've an app that does this and can strip out the important stuff for you.

Do a search in this forum on the key word Bloat, especially if you're updating your table/recordset via SQL. You'll find several good explanations on what may be causing it, which is half the battle.

Been there, done that, felt the same. Sometimes finding the right keyword is harder than the solution.

Search this forum for the keyword PARSE. There are several different ways others have solved this.

I found a machine with Excel 97 and you can do the same thing as XP for Save As format default, but like you said, you want to automate from within ACCESS 97 so it's just useless info.