Search results

I'm creating forms to allow users create queries on the fly allowing them to select the fields they want to appear. When they select the fields it creates the SQL and then uses this to create a querydef which then open to display the results. I want to have the number fields formatted as...

I just tried it on W2K myself and as you said all it does is cause the icon on the taskbar to flash, while in NT it will set the application window as the top one. If you search on MSDN for SetForegroundWindow it details that the flashing cursor is the standard for 98/ME/2000/XP but it can be...

The testdb works as follows on my PC, NT 4 with A2K. If application is behind other windows and is not minimised it will be set to the active window and brought to the front. If the application is minimised then it just causes the icon to indent on the taskbar but does not bring it to front. I...

Not sure if this is what you want but it might help you. It uses a table for each question's answers and allows you to set the values you want for each answer. At the bottom of the screen it will total the values of all the answers. It is in A97.

Your line assigning the value to strSQL is not actually using your variable lngContactID, rather it is setting a where clause of ContactID = lngContactID. You need to set the strSQL as follows: strSQL = "ContactID =" & lngContactID This will then use the actual value in the variable lngContactID.

Here is some code I have used for checking for multiple instances of the application when it is opened, if it is already open it will set focus to the previously opened version. It might help you to do what you require. ' Module mdlCheckMultipleInstances ' © Graham Mandeno, Alpha Solutions...

Your function already has most of the functionality to allow one to save a copy to Sent folder, you just need to set a value for the variable it uses. This variable is called SaveIt which is dimmed but no value is set on it. So you have two possible solutions 1) Set a value for SaveIt of True...

Apologies but I had left out one of the functions and am only after seeing your reply now. You need the function below as well as the other 2 given earlier. Function EndOfMonthPrev(D As Variant) As Variant ' Returns the date representing the last day of the previous month. ' Arguments...

The following code will return the date of the first specified day of a month. Example: To find the first Monday in May FrstDay("May 2003",2) = 05/05/2003 To find first Monday of current month FrstDay(Date(),2) Adding 7 to the result will give second Monday, 14 will give third, etc...

I have read through most of the 'Record Locking' posts I could find but still would like some clarification on my issue. I am creating a database for tracking staff absences. The HR department want it to be possible for each staff member (over 500) to enter details of their absences and then...

Create a new field in your query made up as below and group on it. Year([YourDateField]) & Format(Month([YourDateField]),"00") You can use a second field to give the format you want of MMMYY for use on your report/graph. Format([YourDateField],"MMMYY")

Does anyone out there know why the following is happening and if there is any solution to fix it? Over the last 6 months or so various reports on different Access 97 databases have been giving a similar error and nothing we do seems to fix it. What we usually end up doing is restoring a...

Use an update query and update the fields you want emptied to Null.

The following should help to do what you require.

I have made a few changes to the code in the two main function to allow the user to set no. of weeks and no. of offences. So essentially you will just need a form to allow setting of the date (a calendar control might be best), and 3 combos; one to allow selection of no of months, another to...

The following should solve it for you, if you need any further explanation just let me know. I've assumed the school week is Monday to Friday. The date you enter should be a date after the last Friday you want included in the report, eg. if you run for 17/01/2003 for 3 months then you will get...

You can import specification files from one database to another in the same way as tables, queries, etc. Just use the import wizard as normal and when on the 'Import Objects' screen click on the 'Options' button. This will add a few further options at the end of the screen, one of which is...

Assuming that it is only the last character that may be non numeric then you could use the following in a query IsNumeric(Right([YourField],1)) Set criteria as True to get records where last character is numeric, false to get those where last character is a string.

Check out the following http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q147143&PR=ACC

This often is referring to the fact that one of your references is missing. Search under missing references here and on microsoft.com for details. Some sample solutions http://www.mvps.org/access/bugs/bugs0001.htm http://2fix.bvu.edu/help/apps/access/EA4DF6XCJ.ASP