Recent content by mkdeneve

This is awesome! Thanks!:D

Galaxiom, I did some clean up as you directed and it is running reliably now. Is there a way that I can have the form hold the last value entered? This would really speed things up. Thank you very much for you continued assistance!

I made some changes to the form, now query returns all records except what I specified. I am stumped.

yes, all records have a date I did not have the form open when I ran the queries earlier. I opened the form, and I think that the form has problems. When I open it, it shows #Name? in the data fields. When I view the properties, I see the default values to be what I set them to. I think...

Making some progress...... I did what you said, changed table field back to DateTime and dropped the spaces too, and now I am being asked to "Enter Parameter Value" Forms!InputDataForm!StartDate when running the query. When I enter the values, I get the expected result. What I want is to not...

I entered ShortDate (was blank) as the format properties in the query and still got the same error. I then changed the table date field from Date/Time to Text. Now the query runs, but does not have any results. All the other queries no longer get results either. Ideas?

Galaxiom, Many thanks. I had trouble running your demo because of missing references to a DLL. Anyway, I ignored the error message and I am still confused. It looks like the form is looking for inputs (which I understand) but I not understand how to make my queries take the inputs, or what...

I have never created a form before. According to help text I need to create a table or query with the data. How do I do I crate the ext boxes like you say without referecing a table or query?

Thanks, Galaxiom. I agree with the rethink, but need to save on work to get time to do it. I'll try your suggestion. I am not quite sure of how to do it, but I'll try a few things and repost.

Galaxiom, Thanks for the reply. Here is the situation. I inherited this database from someone who has left our company. The main purpose is to generate billing reports that require a unique query to provide the data for them. These are the 100+ queries that I need to modify, so that they...

Hi, I am a novice now using Access 2003 for my job. Each month I need to modify and run over 100 queries that I must update with a date range in a criteria field. An example of the field that I must update is: "Between #5/31/2014# And #6/27/2014#". Question: Is there a way that I can update...

Hello! I am a new member from Minnesota, Unites States. I am a novice, and am now using Access 2003 in my job. I hope that this forum can help me build my skills so that I can help others like myself in the future.