Search results

I have a table which contains an order no., each of which may contain multiple items, these items may be in 1 or more of the orders. For example: Say the table contains: Order No, Item No, Qty 12 AA 1 12 AB 10 12...

I'm trying to generate a crosstab (pivot?) table (WorktableB) from an existing table (WorktableA) in vba. First time I've tried this sort of thing! My code results in run time error 3126. Suggestions pls. Dim SQLText As String Dim WorktableACrosstab As String 'generate a crosstab query for...

Hi all I have a database that on closure automatically generates a backup from the following code: Option Compare Database Option Explicit Dim fso As Object Dim sSourcePath As String Dim sSourceFile As String Dim sBackupPath As String Dim sBackupFile As String Private Sub...

All I'm having a problem with the following very simple code the lines in red flatly refuse to trap a space followed by a lowercase letter. I'm trying to write the first set of words that start uppercase to a different field (the first letter in the read field is always uppercase) Option...

I'm getting inconsistent (i.e. not always repeatable) errors when (in VBA) I try to add data to a previously emptied table. The SQL statement includes three ascending sorts into a table which is not indexed and works OK when run as a stand alone Query. When run in VBA as a...

I'm using SendObject successfully to send an email from an Access database, but the form which contains a button which sets the action will only perform the action once without closing and reopening Access. Using Access 2000 SR-1 and Outlook 2002 SP3 Any suggestions? Regards Terry Lawson