Search results

Paul, Outstanding. It works perfect. I was saving the record before running the test. Thanks so much for the help. One thing about living over there there is so much to see and do that you can't see/do it all if you're ther for only a few days. I would go back in a heart beat. Thanks again

It works; however it pops up a conflict no matter who we try to load. Even new personnel. Any thoughts? I was stationed at Mildenhall from 1989 - 1992 and Lakenheath from 1994 - 2000. I loved it over there. Change 1 - I cleared the Orders Table and started new. Each time I load a person it...

Yes the table (ORDERS) is where we keep track of the appointments. What we want is some type of check when we use the form (frmOrders) that the individual selected does not have an appointment already for that time period. The three boxes I believe we would use is customerID (which is the...

here it is. I compacted and zipped and it is still 428 kb. I appreciate all the help

Well after spending about an hour on this my mind is mush. I can't even get a query to come up with the results I need. I have three fields EmployeeID, Start Date, and End Date. I know the criteria i want is start Date >=[forms]![frmOrder]![end date] and <=[forms]![frmOrder]![start date]...

Double check my thinking. In the "SELECT * FROM line table name would be the name of the table I'm using, IDField would be the fields that I want to check for conflicts, and Me.controlname would be the criteria (i.e. employee name, start date, end date etc.)? Or am I missing something. And...

I'm embarrassed to say but I do not understand what you mean by open a recordset on a query.

OK I used this test as a filter in a couple of queries where I want to list appointments between two dates so I got the general idea. How do you suggest using this as a test for conflicts? I have never been any good code writing so I am trying to find an easy way to do this.

Thanks for the response PBaldy. I need a little more clarification on your suggestion. Are you talking about running query to find these conflicts?

I have been reviewing previous posts covering this subject but can't seem to find any with my "unique" issue. I have a table [Orders] used to track employee's appointments. We use a form [frmOrders] to update the data in this table. On this form we have theses fields: EmployeeID Event Start...

I am having difficulty with the date variable. I have never been good at writing codes. would you mind giving me an example? Thanks

Sounds doable. Thanks. I will give that a try.

Apologies. I didn't realize that putting it into a different forum constituted a double entry.

Hello everyone. I need help trying to get my head around this. I have a table which we use to track our employee's appointments. We use a form to fill in pertinent information into this table. Once filled in another form designed like a calender pops up listing each of these appointments. Our...

Hello everyone. I need help trying to get my head around this. I have a table which we use to track our employee's appointments. We use a form to fill in pertinent information into this table. Once filled in another form designed like a calender pops up listing each of these appointments...

Looks great Thanks for the help

Thanks. It looks like what I am needing, however when I ran the query looking for the class "TIP" it came back with 103 records found when in fact it should have been more like 70-80 records. Not sure why that is. Also Is there a way to use a combo box to select which class I want so I don't...

Both would be nice but what I originally wanted was to have a list of those people who have not taken the course.

thanks for the help

Thanks KeithG.