Search results

Here's a strange one... I have a query that works fine when I run it from the database. However when I execute it from VBA some of the columns don't return anything... Code With rsCmd .ActiveConnection = CurrentProject.Connection .CommandType = adCmdStoredProc .CommandText = "qry_name"...

Hi Team I'm wanting to build an update query based on the below criteria: Table 01 - Cost Centres cost_centre C0123AA C0123AB... C0987AA C0987AB... Table 02 - Conversions store | new_store 0123 | 1234 0987 | 9876 Where all records in table 01 will be updated if they have a matching record...

Hi there, I'm currently using a database that is acting as a Document Management System. It's main function is to tag documents with properties and custom properties. I have successfuly been able to tag word, excel and powerpoint documents but have run into trouble with PDF files. It seems I...

Hi there I'm attempting to import records from an external database without losing the records that I currently have. Eg if I have 3 records in my main database and 5 in the external one, I only want to append the 2 missing records and leave the other 3 alone. Ideally what I want to do is the...

Hi there I have the following predicament, I want to run a crosstab query on a table that looks like the below: ID STORE RECEIVED ITEM RESPONSE 1, 123, 2006-03-30, Name, Tony 1, 123, 2006-03-30, Position, Baron 1, 123, 2006-03-30, Name, Simon 1, 123, 2006-03-30, Position, Mgr 1, 321...

Hi there, we currently have a database that users write to through an excel form. Each time a user sumbits a record to the database we open a connection up with the below code, insert the record and then close it. This creates a ldb file for 1-3 seconds depending on how long it takes. ' OPEN...

Hi there, we have a database that users are writing to through an excel form. We have been successfully writing to this for months however we have now run into a problem... We have tried opening the database outside of the timeframe that users can write to it and are getting an error: "The...

Hi there, I currently have the below tables: tbl_stores ID NAME 123 Store A 456 Store B tbl_returns ID NAME RETURN 123 Store A 9999 123 Store A 8888 789 Store C 9999 I want to find the stores that exist in the stores table, but not in the returns table WHERE the RETURN is equal to...