Recent content by mdb4me

You must be thinking of TimerInterval that's milliseconds but the Timer function is seconds:

Something like the following will do it, you may need to add some criteria to the DCount depending on whether you delete your messages or flag them as read. Private Sub Form_Timer() Static lastRun Static BlinkTrigger As Boolean 'Debug.Print lastRun, Timer 'check for...

Under Queries in the database window, select New and the dialog box lists a number of query wizards. Choose Find Duplicates Query Wizard.

Use the DateAdd and Date functions to specify a period 2 years prior to current date. SELECT tblItems.Code, tblItems.Item, tblItems.Date, tblItems.Price FROM tblItems WHERE (((tblItems.Date) Between DateAdd("yyyy",-2,Date()) And Date()));

In Access you could create an Excel object in code then create a worksheet then select a location within the worksheet and loop through a recordset to populate the worksheet. Though it maybe easier to approach it from Excel, if you want to easily specify where in a worksheet the data should go...

You need to add another parameter to the TransferText to include the column headings. Adding ,TRUE after the export filename will add the header row. DoCmd.TransferText acExportDelim, "ShawDrum Export Specification", "ShawDrum", "C:\Documents and Settings\Peter\Desktop\Shaw.txt",TRUE

I use the Form event as I like to manage all the Keypresses I'm interested in, in the one sub.

Set the form's Key Preview to Yes, then use the following code to alter the Keyascii value, I'ved used ActiveControl.Name here just to restrict this to a specific textbox. Private Sub Form_KeyPress(KeyAscii As Integer) If ActiveControl.Name = "txtCaseMgr" Then KeyAscii =...

A union query would do it e.g. SELECT Drawing, "Block1" as Block, Block1 as Utensil FROM tblDwg as A Union SELECT Drawing, "Block2" as Block, Block2 as Utensil FROM tblDwg as A UNION SELECT Drawing, "Block3" as Block, Block3 as Utensil FROM tblDwg as A;

Access will pull all the records from all tables referenced in your queries over the network to the individual workstation before it can resolve the query, so if many tables, complex joins and thousands of records then performance will be poor. Even if Access is installed on the server the...

You can specify the mmm-yy order by bringing up the properties dialog for the query and typying in the order in the column headings property or you could do the same if you construct your query in code. See the PIVOT line below:- TRANSFORM Count(Orders.OrderID) AS CountOfOrderID SELECT...

Other ways to avoid this problem would be to link to the spreadsheet rather than import it, so if the columns of the spreadsheet never change and you use the same file name then everytime you open the linked spreedsheet in Access it will display the current data. Then depending on how you want...

Maybe you could setup the application so the users logon to the frontend and it uses a special account that has been setup with appropriate permissions to access the backend to read and write data that the users know nothing about.

I haven't had a need to do it before but just tried this and it works. Private Sub Form_Load() Page1.Caption = "hello" Page2.Caption = "bye" End Sub

Hi, Thanks for responses, I'll have a search for previous threads and see what I can find out. I recently commenced working at this health related research organization and they haven't had anyone with database expertise so the databases they have setup for thier research aren't normalized or...