Search results

So long as you link the external table to you main FE, you can use a UNION query to merge both datasets together to view or as a recordset for a form, combo/list box.

You can use the FORMAT() function to alter the format of date, numbers tec

in a query use The BEWTEEN AND Keywords e.g. Year(YourDate) BETWEEN Year(Date()) AND Year(Date()) - 1

Brian, It just goes to show that when you hit on a technique that works, you tend to use it forever. Next time I have to develop queries for age ranges I will try the SUM method.

what is the form's angry message to you?

far easier to have each count in a seperate query the bring all the counts together in one final query. been doing this way since 1992, never had a problem.

Firstly never use a reserved word as a column (Date is a reserved word) Dates are bracketed by #, numbers by nothing, Strings by ", unless the string is in a string then you can use a singler quote '. you are using T SQl notation and not Jet SQL notation

As both lists are populated via queries you can reuse the query as a recordset and use ADODB or DAODB to 'find' the record. Find is a method or both recordsets.

in english the logic would be if the Datefrom <= To Days Date AND Dateto >= todays date then the cat is still in the cattery.

There are a number of steps to consider. 1) create a form and place a combo box on the form listing all the records. Ensure that each record has a unique identfier and have this as the first column in the combo box. Hide this column by setting its width to zero. Create your report. Use the...

Here is an example of reading a table row by row Sub Test() Dim db As DAO.Database Dim rst As DAO.Recordset On Error GoTo Err_Handler Set db = CurrentDb Set rst = db.OpenRecordset("SELECT StaffID FROM tblStaffBooked WHERE [DiaryID] = " & DiaryID & "AND [StartSlot] = " &...

if you open two recordsets you can compare the values in the various columns. So when you open the recordset, and the cursor will be positioned at the first record. then you can step through one record at a time or find a unique records or froups of records. Search help for recordsets, ADO and DAO

You may not want to create links to your photos, but when you see the bloat to your db you certainly will. As far as I can acertain Access up to 2003 will only store your photos as BLOBS with no compression, so a 100KB jpeg may generate a 1mb BLOB. I think Access 2007 will store the photos in a...

Access does indeed have a status bar which is not tied to any particular form. Use the status bar text property to display information to the user.

probally best to use either DAO or ADO. This will allow you to use recordsets with a variety of different cursors.

This is not normalised. Each recurring pair of columns should be in a seperate table linked by the ID from the main table ie call this a grades table GradesID - Primary Key id - Foreign Key Grade GradeReceived Then the select statement is simple SELECT * FROM tblGrades WHERE...

Any function in the VBA library or a user written function that's public can be used in a query SELECT DateValue(myTime) as DateOnly FROM YourTable

If this is to be performed regularly then Initially Create an import specification fo the text file, and an import file the general outline is as follows Delete contents of import file Run import in code using the import specification (if the filename changes then you will need a file...

its called 'Hide Database Window'

Move the trigger code to a standard procedure. Then when you update the text box, run the procedure e.g. Text4.text = Something Call YourProcedure()