Search results

Fixed I removed a <>"" term and everything is grand...

Ok I can refine this a little further, after much cursing I've found that the values returning Null are from queries that have a where condition in them that contains a LIKE statement.

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

Thanks for your help I'm almost there... well sort of. The cost_centre field isn't in any relationships at the moment, and I've got to the point where my second query brings up the affected cost centres based on the join with the second table... However when I try to run the query I'm...

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

Has anyone written properties to a pdf file before?

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

You make a good point, worked great thankyou kindly!

Thanks Neil, the issue I'm facing is that when I run the query it wipes all of the records that currently exist in the main table. Eg if i have 10 records in my main table and run the query on the external table that has 2 records my main table will be left with these 2 records... and the...

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

Any ideas? Again, appreciate the support Tony

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

Thanks for the reply Pat sounds like a good package. Unfortunately we are just not in a position to distribute this version of access to our sites. This is hopefully a short term solution until a proper web based tool is developed. Thanks for your help with this i'll do some further searching...

In an ideal world we'd have access to SQL Server for this app... Basically the database is acting as a holding point, with over 1000 sites writing to it every day. It's kind of like we are using Excel as our web form and access as our back end. Not ideal but it works quite nicely. We then have...

Thanks Patt, I've checked the folder permissions on the database and all users have access to read and write to it. It seems that whenever someone is writing to the table it will 'lock' it and the next user wont be able to write to it until the ldb file has cleared itself. Is there anything...

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

Thanks for the heads up on the Jet utility worked a treat! It allowed me to open up the db and copy the tables into a new database, Thanks champ Tone

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

Legend. That worked, thanks for your help champ Tony

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