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...

Forum as brilliant as ever, many thanks to you both. Problem solved by storing the crosstab and then calling that in the make table, having first corrected the stupid inconsistency.

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...

Thanks guys Use the sub, it works perfectly:) Terry Lawson

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...

Bob and David Immediate success with Option Compare Binary Many thanks to you both (and I've clicked your personal thanks as well!) I'm so impressed with the very rapid responses Ain't it easy when you know how. Regards Terry Lawson

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...

Thanks Here is the SQL Statement: SQLText = "INSERT INTO Worktable1 ( field17, field19, Field1, field2, field3, field4, " & _ " field18, field6, field7, field10, field11 ) " & _ " SELECT SFHGSTMA.[Gen Section], SFHGSTMA.[Gen Page], " & _ " SFHGSTMA.[Product...

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...

Boyd Access now updated to SR3 and problem resolved:) Many thanks for your help Regards Terry Lawson

Boyd Thanks for that but the only update that I can find for Access 2000 is: XpSp3-kb83267-client-enu.exe on the Microsoft website. Tried to download and was advised "Already Installed", should I be looking for something else? Regards Terry

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