Search results

Keep in mind that field you are using in the WHERE clause for the subquery needs to have a unique value for every record. Say for example you had two people with the same first name, they would have the same count. For that reason, an autonumber field works best. Or concatenating several...

There is also this KB article - ACC2000: Sample Code to Check for Table or Query in a Database

Maybe this will help. 'Conditional Formatting' of controls in a continuous form

Where are you getting the value that you want to pass to your parameter query? If you have created a stored query, and want you just want to set the value of the parameter via VBA, then this KB article might be helpful. ACC2000: "Too Few Parameters. Expected 1" Error Message

boblarson, Really cool way of providing an answer! BTW, there is a free screen capture utility that I use - MWSnap. Doesn't have all the features of SnagIt, but it's free!

You can also use SQL to do this, which I think is faster than using an aggregate function such as DMax(). Previous Date & Sum of Month/Year to-date using a correlated subquery Example: SELECT dtDate, lngValue, (SELECT TOP 1 a.dtDate FROM tblData As a WHERE...

Well, I've subscribed to the game. Picked up the full game really cheap (< $10), which is worth it since I get 30 free days to play. So far I like it, so I'll probable continue after the 30 days is over.

Just FYI, there are limitations to the built-in conditional formatting. You only have 3 conditional formats to use. It won't work for continuous forms. The formatting applies to all rows in a continuous form based on the currenylt selected record.Not sure what your situation is but I...

Are you just wanting to create a new table or use data from a table/query to make a new table? Create table using SQL CREATE TABLE tblAutoNum (lngAutoNum AUTOINCREMENT); Make-Table Query SELECT * INTO tblNew FROM tblData; Alter existing table using SQL ALTER TABLE tblNew ADD COLUMN lngAutoNum...

You can simulate multiple conditional formats in a continuous form, but not in a datasheet view as others have already pointed out. Conditional Formatting of controls in a continuous form

This can be done in a query, but a report is better if all you need to do is display the data. Running Calculations (Total/Sum, Average, Count) in a Query

Seems like the crosstab query gets you what you need, even though it isn't what you are used to seeing. How are you performing your validation, manually or via some sort of automation? Do you only have these three names that never vary? If so, I guess you could do something like this (even...

Use DateDiff() DateDiff("n", [TimeIn], [TimeOut])/60You need to determine the difference in minutes as DateDiff returns a LONG value. Just divite that by 60 to get the difference in hours. If you wanted to, you go even determine the difference in seconds and convert that to hours but that is...

How do you identify the first record? You can use criteria to in a delete query. DELETE tblData.* FROM tblData WHERE [PK]<>1;This example deletes all the records from tblData except records where [PK] = 1. In this example, [PK] is an autonumber so only 1 record will not be deleted.

"Tutor = '" & Me.ComboStaff.Column(1) & "'" Using .Column(0) refers to the first column.

Here's a method from a KB article ACC2000: Sample Code to Check for Table or Query in a Database

Here's my two cents - VBA Rounding Functions :)

API: Call the standard Windows File Open/Save dialog box API: BrowseFolder Dialog

File Name, File Path, And Microsoft Access Version Number Of Current Database File And Microsoft Access Application

TessB, HAPPY BELATED BIRTHDAY!! :)