Recent content by mikejerez

Hi folks, I have a new problem I have been working on for a while. I have a table which contains the weight tolerances for 4 different age ranges based on their height. So, the first field (column if viewed in Datasheet view) has the height and the subsequent fields (Columns) have the maximum...

I see but I need it to use the 15th of the current month as the criteria regardless of the month. If today is the 20th of November it should use 15 Nov as the criteria, If today is 27 Dec it should use 15 Dec as the criteria, etc....

I see, but I want to make sure that it will use the 15th of the current month as the criteria regardless of which month I am. Example: If today is 20 November then it will use 15 Nov as the criteria. If today is 17 Oct it will use 15 Oct as the criteria, etc...

I am trying to setup a query with the following criteria: I have a FromDate field and a ToDate field and I want all the records either the from or the to date fall on or through the 15th of the current month. Example: FromDate ToDate Include 13 Aug 16 Aug...

I did this and it is the answer I am looking for; however, it is not updating the ParentID on the ChildrenInfo Table. I have the follwing fields in the ChildrenInfo Table ChildrenID (autonumber) Primary Key SSN (Text) Foreign Key to Parent table ChildName (Text) ChildDOB...

I have a table which holds information about employees. When it comes to some information such as children names or phone numbers there can be more than one value. Instead of having child1, child2, child3....fields in the table I want to create a different table and store this information...

Thank you very much.

I have completed a personnel application with a couple of tables, reports and forms and now I want to make it a stand alone so that I don't have to open Access and then open the application. Instead I want to be able to click an icon on my desktop and have my application open without Access...

Thanks, that worked nicely!!!

This the scenario I am trying to create: I want a checkbox to change the Enabled property of a textbox to 'Yes' if the checkbox is checked and to 'No' if the checkbox is unchecked.