Search results

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.

In EXCEL XP you can set default Save As format which may help going forward (Excel 2.1 is an option). Right off the Help screen Change the default file format for saving workbooks By default, workbooks are saved in the current Microsoft Excel format. If you work with others who use earlier...

Can you send me your code? It runs under A97 with the following references Visual Basic for Applications Microsoft Access 8.0 Object Library Microsoft DAO 3.51 Object Library

This is how a former associate did the same thing. tblProposalNumber only has 1 field and 1 value. Dim MyDB As Database, MySet As Recordset Dim PropNum As Long Set MyDB = DBEngine.Workspaces(0).Databases(0) Set MySet = MyDB.OpenRecordset("tblProposalNumber")...

Try something like this if it's a bound field Private Sub Form_Current() If Me!RACFID = "KEYWORD" Then Me!lblRACFID.BackColor = 255 'RED Me!RACFID.BackColor = 255 Else Me!lblRACFID.BackColor = 16777215 'WHITE Me!RACFID.BackColor = 16777215 End If End Sub RACFID was a...

Do a search for IsOpen in the Forms section of this Forum. There's several that deal with this