Search results

The DateAdd function should provide what you need. In the criteria of the "ExpiryDate" field in your query try using: <=DateAdd("w",12,Date) This should return only records where the "ExpiryDate" is less than or equal to the date that is 12 weeks from the current date.

Beiing an Access Developer with years of experience I would immediately say that Access is the perfect place for the "Work Roster" type application you are describing but that simply means that I feel comfortable starting the project and completing the project. One of the first things you need...

First, I am glad to hear that the light just came on. Also, glad to here you got it working and I am always glad to help. Good luck with your project.

It is not clear to me exactly what event you are using to call your code. I would assume that you have a command button that is calling you code. If you have a command button that is being clicked, put the code I provided at the very start of the code in that event. For example if you are...

"Dirty" means that some modification has been made to the data that is being represented in the form. The code first checks to see if any change has been made to any field represented by any control in the form. If that is true, the changes are saved with the statement: Me.Dirty = false...

It still sounds like you have a bound form and you are entering data in that form, but then you are attempting to run a query against the data before actually saving the data entered into the form before actually saving the record to the table. Try adding the following code before calling your...

Am I correct that this is a bound form? If it is then you should be able to read the value from the form, if it is not then you may have to set focus to the control that has the value you need and then reference the "text" property of that control rather than the "value", The only code I see...

Have you tried saving the data in your form instead of doing a requery of your form?

Try creating the function below in your forms module: Function GetTextBoxName() tbName = Me.ActiveControl.Name End Function In the Property window in "On Got Focus" event of each textbox put the follow: =GetTextBoxName() This will assign the name of each text box to your variable.

Here is a function that you can use with any Unbound text box to do what you want: Function ChkCharCnt(ControlName As String, MaxLength As Long) 'declare a variable to use when calculating Dim lngCharsUsed As Long 'calculate the number of characters used lngCharsUsed = MaxLength -...

As always, glad to help.

Try adding an ampersand sign (&) in front of the character in the Caption of the button you want your use to cause the on click event of the button to fire. For example if you have a command button with the caption of "Close", and you want users to use Alt + c to activate the On Click event of...

Open your query that is providing the row source for your list box in design view, right click in the criteria row of the field that holds the initials and use the Build option to add a reference to the "CounselorInitials" combo box as the criteria. When you have finished providing the...

I would suggest that you add a Date/Time field to the "tbl_PolicyDetails" table and have this date field to be updated anytime the PolicyStatus field changes. You would then be able to retrieve the most recently changed or modified record. You might also want to consider creating a table of...

I tested The code from the link that I directed you to and I would suggest that you take another look at it because it does not return just the "last day of the month". It returns exactly what you said you wanted. It will return the last "Thursday" or which ever specified "Day" you specify...

Take a look here: http://forums.codeguru.com/showthread.php?335395-VBS-Find-last-Thursday-of-Current-Month-VBS I tried it and this will return what you are looking for.

Please take a look at this modified version of the database. I did not fully test the conditions and had to make changes to how the user input is being evaluated. It now works as expected, requiring the correct combination of Username and Password. You will need to add a field or two...

ariansman, Take a look at this modified version of your database. I made serveral changes. Some were strickly for "best practice purposes" while others were to meet requirements. First just open the attached file. You will be presented with the modified "Login" form. Enter "Jack" as the...

Create am unbound form. Add a combo box that will display a unique list of your equipment from the equipment table. Use one of your existing queries or build a new on that returns the data you want but for the criteria, right click in the criteria and use the "Build" option and create a...

Please explain a bit more. Queries and reports are not normally record specific so I am not understanding what you are needing.