Search results

Well the first two are the DocumentName value mentioned and the DocumentType value mentioned. I do not know the value in RecordID yet as this is an error that happens only ocasionally and so far I did not get anyone who got it to give me its value. In any case RecordID comes from CallID, which...

DocumentName's value is the string "rptInvfrm" DocumentType's value is the string "Document" RecordID is a string such as "234" or "100"

I have a database that uses a printing function but ocasionally I get: Error 5. Invalid procedure call or invalid argument. This is the way that I call the function from several subs: Dim DocumentName As String Dim DocumentType As String Dim RecordID As String DocumentName =...

I'll talk to the network admins to see if they can look into this. In the past I have not had much luck reliying on them for solutions to these kind of issues, so unfortunately I am not too positive that I'll get anything back. If I had the table that you mention automatically opened (hidden)...

I have a split database that's been in use for quite a while by 5-10 people. This is a database that is generally opened in the morning, used throughout the day and closed at night. It might happen however that a user opens the db in the morning, adds some data and then goes back to the "search"...

Hi Minty, Thanks for trying!

Does anyone have a suggestion to solve this complicated issue? mafhobb

Thank you so much. One thing...right now this is all done on the same database (two tables storing prety much the same data...not good...), but once it all works, the Address table will be on a different database and this database will simply be on a timer to import the xml files and then save...

Hi Minty, If you look at the code in cmdMergeData, which is what almost works, you can see that the code breaks up the process in three steps: 1) it will first insert all records with the "function" field listed as "INSERT". 2) it will then go through the UPDATE part also based on the...

Here is the database. It is meant to be used for importing xml files in sequential order into the table "customers" (called temporary xml import table in the main form) You do not have the xml files but I have already imported them into the Customer table. The code to then merge the data with...

It seems like the hard work was already done with the first query (first post)...all I needed was to get it done in order, and it is turning out to be much more complex than I thought!

I was planning to do this with code just as you see in the query in the first post. However, I find it useful to work it out in design view first to try to understand how it works. In this case, I created the first query in design view and it works:SELECT Max(Customer.Number) AS MaxOfNumber...

uhmm. can't do that. The minute that the select query is turned into an Update query the totals row dissapears

I can't find the syntax for an update query such as the one above with an ORDER BY or MAX() filter. Can it even be done?

So if on my customer table I have an incremental number like this: Number CustomerID AddressType PostalCode 1 001 Customer 20000 2 001 Customer 30000 3 001 Customer 40000 I could get it to do Number 3 last?

I use the following code to update data in a table (Address) based on another table (Customer): 'Look at the table "Customers", select all "UPDATE" and edit the table. CurrentDb.Execute "UPDATE Customer INNER JOIN Address ON (Customer.addressType = Address.addressType) AND...

It seems to do exactly what I needed... The values to change are in the Address fields but the criteria originator is in the Customer table. It's an inner joint query. mafbus

That's a good idea. In the meantime I have been tinkering with the following and it seems to do what I was hoping for: UPDATE Customer INNER JOIN Address ON (Customer.addressType = Address.addressType) AND (Customer.customerId = Address.customerId) SET Address.addressNr =...

Hello Plog, Sorry if I did not explain this well. I have a customer service database that works fine, but now the IT department is asking to expand its capabilities and I am very much stuck about how to do it. They use an AS400 system and they want to be able to insert, update or delete...

I am trying to do an UPDATE query by using the data from a SELECT query. I have a table called "Customer" which has several fields (ToDo, CustomerID, AddressType, CustomerName, StreetAddress,City,...). One of the fields (ToDo) may have a value of "UPDATE". I need to run a query that goes...