Recent content by whimbrel

Thanks RuralGuy, you're right. The problem wasn't date formatting it was the syntax of the copyobject expression. Although I'm copying the table to the same database I still needed to signify the presence of the argument by inserting a comma, like this: DoCmd.CopyObject , MyNewTable, acTable...

Thanks for the suggestions, guys. I have tried both but unfortunately still get the type mismatch error. It seems such an innocuous piece of code, too. Any other suggestions gratefully accepted. Regards, whimbrel.

I am trying to copy a table, appending the date to the destination table name in VB code. However I get a Type Mismatch error. Here's the troublesome code: Dim MyDay, MyMonth, MyYear, MyDate, MyNewTable As String MyDay = Format(Date, "dd") MyMonth = Format(Date, "mm") MyYear =...

Additional information I have attached simplified examples of the database and the carrier schedule report. I added the Premises 1, Premises 2, Premises 3, and Premises 4 Yes/No fields with the intention of somehow using fields these to get the addresses for the schedule but they aren't...

I have what I think is a complex problem and no idea how to solve it as I am a novice in this area. Any help would be greatly appreciated as a have a deadline and time is running out. I require to be able to print out a carrier schedule report on a daily basis. This consists of up to 4...

I require to be able to print out a carrier schedule which consists of up to 4 premises and a consignment numbers in a specific layout on the printed page. The premises are held in an address table and the consignment numbers are held in a consignment number table. There is no relationship...