Search results

I have a field in my tbl [DateAdded] which is automatically given a date/time stamp when a new record is created in my table. I want to make a simple query which will show me all records entered in the system over the past 16 hours. I am not sure how to write the query criteria so I want...

That did it. Thanks.

I may not have done this correct but I did... Private Sub Command10_Click() With Me.frm_HISTORY.Form .Filter = "[COLOR] = Blue" .FilterOn = True End With End Sub And when I execute I get a "Enter Parameter Value" error.

Please see the demo. I am not sure how to describe things sometimes, but the demo will make it more clear. I have a form [frm_MAIN] with a subform [frm_HISTORY] which each tied to 2 different tables. The tables and forms are linked by a field called [CLIENT] When I have the frm_MAIN open...

MAN!!! It is always something small that I overlook. THANK YOU Peter, that fixed it within seconds. Thank you again.

I have a button that my user will click to add data from an entry form to a table, then send an email out to my clients. I am 90% done, but stuck with one problem. This email will go to one of two people depending on the [DEPT] field. If my user selects "ACCOUNTING" then the email will go to...

Nevermind. It was a NULL issue. Once I removed all null records from my query the errors stopped. I think I should be good. Thank you for your help. As always I will gladly donate to your cause for all of the help Bob.

This was originally a Access table that was later converted to SQL. In the SQL table the field type is "datetime" if it matters.

I have still been having problems with this. I think I figured out why. It looks like some of the records have the current formatting of "mm/dd/yyyy" while other records have "mm/dd/yyyy hh:mm:ss: PM" So when I write these small scripts it is not working correctly due to the different date...

Here is my code Error: The expression is typed incorrectly, or is too complex.... trying to simplify the expression by assigning parts of the expression to variables.

Good morning everyone. I need some help PLEASE. I have a front end Access 2000 DB and Backend SQL 2005. My Form Prompts my user to enter company name and a start and finish date. Then my query will run using information entered into that form. To spit out a dataset. Query SELECT...

This seems to take care of it. Field: RecordDate Criteria: >=#7/1/2010# And <#10/1/2010# Can you see anything wrong with this set up?

Field: DateForRange: DateValue([RecordDate]) Criteria: Between #7/1/2010# And #9/30/2010# Error: "Data type mismatch in criteria expression."

I have a field labeled [RecordDate] which saves date and time. I am setting up a query and I want to see all records for a set date range of Between #7/1/2010# And #9/30/2010# IF I use this criteria expression for the field [RecordDate]it will drop off all records from 9/30/2010 because they...

pbadly, I see what you are saying. I thought you had reservations about the VB. Instead it is about my DB set up which I can easily see you questioning. I am still trying to learn the best way to set things up. Bob has been helping me as well. Thank you for the explanation.

THANK YOU both. These are great options and they both worked really well. I was able to get both ways to work. I will see which way will work the best overall. THANK YOU both for the quick and excellent answers. This is why I love this place. "Doesn't everyone deserve the good life?" - DMB

OK I will try this. Why would you have reservations about doing this?

So there is no way to simply say something like on button click look at current form make any box with a current value of 0 = invisible I know this is extremely watered down, but it is what I am trying to get to.

I have a form called "frm_CLIENTS" tied directly to a table with about 40 checkboxes and one ID. so the first couple fields in the tbl look like: ID (unique ID for each of my clients) BB CC CPT DEW FRE FZ HYT ect for about 40 total of these shorthand codes. My form has all 40 of these...

OK thank you very much so far. so if BOTH are wrong what is the correct way? Will you PLEASE take 2 minutes to make a sample3 the way you think it should be done and upload it? I would LOVE to see the BEST way to do it.