Search results

Thanks David for your response. I will try your suggstion and repost when I (inevitably) hit a snag! Peter

No suggestions then ??

I am looking for suggestions on how to code this: I have a table that contains some base information used in pricing parts for various customers. (table SetupData) Everytime there is a price increase or change of terms I add a new record to the table and move my 'current record' flag (Yes/No)...

Thanks very informative. I have been through the dB and been able to remname all instances, though they took some finding! Don't you just love inherited code! pnb

Yes, that was it. Renamed and it all worked as expected Odd it worked with hand written SQL though? Thanks

The dB is too large to post. You can recreate my table from the text file posted If I write in the query builder : "SELECT [Parameters].* FROM [Parameters] WHERE [param_current] = Yes;" It works. I then checked it in design view and it is as expected. If I then create the query in design...

Happy to provide but if I cannot save the query and give it a name, how can I?

I created this on a button on a form "StrQry = "SELECT Parameters.* INTO [CurrentParam] FROM [Parameters] WHERE [param_current] = Yes ;" DoCmd.RunSQL StrQry" And it worked fine ???? I am totally confused ?????? pnb

I can't save the troublesome query so I can only manually write it as SQL and see if it still errors.

Thanks Bob, I had read 2007 was stricter. It will not even let me save the query to use your vba to debug print the code. The database compacts and repairs ok so could it still be corruption? I have tried copying again from the db from CD I was given, but same result. I have even exported the...

I am running it in 2007. I wanted to look at the SQL as well but it won't let me, it just complains about the Syntax error when I try to open the SQL!

Has something changed in the way queries are written in 2007? I am using it in 2000-2003 mode as I am working on someone else's database. I contructed a simple query using design view to Select a record from a table and Access complains about a syntax error. Syntax error in query...

Yes use the date from the form as a filter in a query.

Thanks both. I had allready used the Forms.FormName.FieldName method and opening the Form in the code prior the queries, but it does not stop on the form but go straight through ! David. Your code seems similar and as you say more flexible by using functions. My problem seems to be stopping...

I have some code running from a button on a form. It runs several queries updating records and outputing some text files. I want a neat way of passing a date into one of the queries. Does anyone have a suggestion? Thanks

I am exporting selected data to text files for customers use (they are price update files). It seemed the easiest way to select the data from several tables into one export table then convert them into named text files. They are not big, only about 5 cols x 120 rows. pnb

On reflection I need to maintain it as a number so it can be turned back into a barcode as I don't know what tech skills the recepients have. They have no leading zeros. My forms handles it ok and the table containing them handles them fine, it is just the Make Table query that is being...

Thanks for your reply. I will try and provide a sample, it is however part of a big dB. No arithmetic so maybe a text field might work, I will try when I return to work.

I am using a Make Table query and it incudes the numeric value of some barcodes. They are 13 digits long. I have tried formating the selected field with 0000000000000 in the query but it insists on recording it in scientific format. I can then alter it in the table, but as I want to export the...

Sorry Office 2007 not 2010 ! Found it only does it when the spreadsheet has been opened first ?? Just open Word and it works fine.