Recent content by Scadadude

I started a thread in teh Report forum but i did something wrong and now everytime I try to design, delete, or open this report it crashes access. How can i remove the report????? Thanks Scadadude

I did the following and now the database crashes everytime I try to access the report or even delete the report Create a form (call it SelectDates) and put 2 unbound text boxes on it. Call them txtStart and txtEnd. Then go to each of the queries and put the following as the criteria for your...

I am running a report based off a query and my query prompts me for a First Date and End Date for it to know what time frame I am looking for. How can I show on my report the dates that I put in for the query. It isnt a constant date so I am puzzled. Thanks Scadadude

I am running a report based off a query and my query prompts me for a First Date and End Date for it to know what time frame I am looking for. How can I show on my report the dates that I put in for the query. It isnt a constant date so I am puzzled. Thanks Scadadude

Probably simple for the pros again. I have several spreadsheets that are all built the same however the data changes on them everyday. I am wanting to either import or link the one worksheet from each of the spreadsheets into one table in ACCESS. How can I do this in one fatal swoop? Thanks...

This is a work in progress for now the "LIKE" method will work I read up a b itit on the InStr() method and I think when my table is complete that method will work best but I havent tested it yet. Scadadude

Works great I knew you guys would know what to do. Thanks Scadadude

Doesnt work, comes back with a blank table. I did confirm there were @aol.com email addresses in the column.

Hi, I have a simple table with contact info with a column their email addresses. If I wanted to perform a query that pulled out all the @aol.com email address how would I do that? Thanks Scadadude