Recent content by ScottyJones

Hi All!! Sorry I went Silent for a while - I needed a break or I was going to delete the entire database, quit my job and go live in the woods somewhere... yeah it got that bad.... So after a time of cooling down I finally figured out my issue. You ever play "Where's Waldo" and there is...

Plog, Not sure I understand your goalpost comment. So I apologize if I am doing something wrong or rude or if I am misunderstanding you. I mean no disrespect. I have already tried DateValue() on 2 different fields and I have 2 different issues with it. 1. On the field I really need this to...

Thanks Plog for the Explanations. I appreciate it. I guess I have to live with it this way. I just find it difficult to believe that I can't extract a [date] out of a [date.time] and use it as criteria for a query with out having to do 'between' and prompt for 2 dates every time. Anyway...

Hi all, I have a query based on a query based on a table. The table has 2 fields of date/time... "PStart_Time" and a "PEnd_Time". In the first query I am splitting the Start and End Times into 2 fields one being the same field as before (untouched) and the other like this: StartDate...

Mark_: Thanks, That works perfectly. Why I forgot about the "Me" tag I don't know {smh}..... Anyway it works now. Ranman256 - That would work but as Mark_ deduced I have the user making two more edits prior to closing the form. Thanks all for the help!!

Hi all, So I have a query of a table that has data that is imported from an external system. This table has a Primary Key that is also imported from the other system. (so I can update it to whatever I want) From the query I am displaying a form that has the few records of that query. At times I...

Thanks to the Mods for keeping a site like this going, it has proved helpful as a 'lurker' for a while. Now it is time to ask a question so here I am... I have written several Access DBs from scratch for a couple different companies that I have worked for. I would not consider myself a newbie...