Search results

Thansk but I need to filter on id_color content (text before the " " spacing)

Hi Pat, I've put a little bit more infos on my request. Take a look when you can. Thanks

My problem is (when doing a report): 1st record: If Machine_No content = "A-12345" & ID_Color content = "red/blue colors" I want to see: "A-12345-red/blue" 2nd record: If Machine_No content = "A-12345" & ID_Color content = "blue color" I want to see: "A-12345-blue" but not "A-12345-blue color"

1st fieldname is Machine_No 2nd filedname is ID_Color If Machine_No: A-12345 & ID_Color: red/blue colors I want to have: A-12345-red/blue Is it possible? Thank for your help!

DBGuy Temporary Database Download Link http://www.accessmvp.com/thedbguy/downloads/theDBguyTempDbDemoV1.0.zip

Hi Pat, can you advise on how to do it please? DL link for "Temporary Table" (from AngelSpeaks) is no longer working but I was able to find another link (see other post).

I never do it but is it possible to sent those specific columns back to access using SQL? I'm already oulling infos using SQL (several excel files each with its own SQL string and using ADO). I need to be 200% sure not to change any other columns (we're several users using it). perhaps...

Thanks for sharing

I know how to export a query in excel but how can I update specific columns (those modified in excel file) back to access table after? What's the best way to do it?

After looking carefully into his works, I found out than he put headers for 4 different reports. I think the best will be to split those fields into 3 new different tables and used specific keys on each new tables. reports: 1- instruments list (only one document, weekly issued) 2- instruments...

I have a friend which have reach the access headers limits into a table. What's the best solution (ex. split content into another one)? Regards!

Some add several new fields into the SQL server and also add those fields into existing SQL queries. It's becoming a pain to always revise forms when this occur.

Several guys are forced to update several queries (mostly for new fields) and I wonder if we must create forms again OR if there's a way to update existing forms.

Wow... Thanks a lot. I totally miss it.

Hi everyone, I made a report based on form inputs but it doesn't work (drop-down works partially and report doesn't filter at all). Can you tell me what I've done wrong?