Search results

Hi wan2fly99, Try DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportTable", "c:/Tony.xls", , YourSheetName Taff.

Have you tried using sub forms?

Hi omyurs, Maybe this will help. Taff.

Hiya Jeo, Try putting your code in the after update event of your combo box but change the line 'BackColor = 13434828' to Detail.BackColor = 13434828 Hope this helps. Taff

no probs. Taff

Try using an Input Mask.

Glad to help.

Hi Carly, Make sure you have copied the module over to your database as well and hopefully that should work. Ant.

Hi Carly, Maybe this will help you get on the right path. Taff.

Try this thread:- Thread 78508 Taff.

Thanks again Pat. Taff.

Hi Carly, Will the name of the tables you want to append from change? Taff

Hi CarlyS, I have attached a small example. Have a look at the OnClick event of the command button. Taff.

Hi Dette, Try putting this in the control source of the txt box you are using to count:- =dcount("[your check box field]","[your tabel or query]","[your checkbox field] = true") Taff.

Hi Pat, Have tried the transferdatabase method but for some reason it does not seem to be working. A couple of questions with it:- Does the database you are trying to export to have to exist already when trying to use it? If so, does the table have to exist in the database? Taff.

Hi Crckrs9, Me.Undo

Hi all, Am having some real trouble trying to work out how to do this but I'm sure it's really simple. :confused: What I am trying to do is Export the table mytable to a completely new database which would be stored in the same location as the current database. Any help is greatly...

No Probs, Ant.

Try this. Anthony

Not sure if this is the best way of doing it but try this. Anthony.