Search results

What is the Table ProductLaunchCrossover Data types of of the fields [GATE ID] and [PRODUCT ID]? I am not 100% positive but it sounds like to me you are trying to Append in to the wrong data type. Another possibility is your ProductLaunchCrossover may contain data and a field is either primary...

You can count both fields in one count. It depends on your requirements and what they contain. In my count version 1 you will find that The Paid Field contains a total of 15, The Use Field contains a total of 23 out of 26 records. I use similar counts like this routinely. In count version 2 I...

In a query as long as your data type is numeric, say a Long Integer, you can do [FieldName] +1 as an update query using specific criteria to single out 1 record. Really need more input from you, otherwise the above VBA code would still work if you strip the strings out of it. Unless of course...

you looking for VBA or Query?

Sounds to me like they want to add each field to a query and set both fields to count?

If you are using the Query builder you can do this: The Query I propose will update each record to 0 whose Length is 0. See the picture:

In VBA you might try something like this: Dim NumLng As Long, DocNum As String, strDocNum As String strDocNum = "QM00156" 'Grab the number from the string NumLng = Right(strDocNum, 5) 'Increment the Number by 1 NumLng = NumLng + 1 'Add the 00 to the QM as the leading Zeros will no...

Mine may not be the best solution, but I do not see why it would not work.

I would use a Make Table query with the table you want split. It should have an ID field so you can tie the new tables together. Place your fields and the ID field in the Make table query and run it. Then repeat the process until you have all of your fields duplicated into the new tables you need.

Quite true and undoubtedly easier than using VBA.

Generally Linked tables take on the name of the source table, provided you or whoever did not change it. You should be able to track down the source database by rt clicking on the linked table and Click the "Linked Table Manager". From there you should be able to view the path to the source DB...

Form_frmName.PublicSubName(anyVars) That’s always worked for me.

One way to help you track your errors is to debug.print your SQL Query. You can then copy/paste it into the Access query builder. From there you try to view in design mode. The method is not a 100% but I have solved more than one error, without seeking help, using this method.

I run into this problem when trying to add an Autonumber field to large tables in table design view. My method to get around that was to use vba and a form to add my Autonumber field. Perhaps you could clean your table as you desire through vba instead of the analyzer?

Ran into this once or twice but never knew what the cause was. It would be interesting to know why this happens.

You could try saving the excel file as a CSV and see what happens when you import. Provided you are trying import to access, most of the errors I ever get on import are related to field datatype issues.

I have never tried to get around this, but it has always been my experience that Access will not let you add/remove fields from linked tables. For me it was simply quicker and easier to just change the field in the source table and update the linked table. I did not have a reason to spend the...