Search results

How do I format the elapsed time between two Date/Time fields? The hours will only go from 0-23 but I want it also to display hours greater than 23. What are my options? TIA

I've been used to Access 97 and just went to Access 2002 and need some help on a basic issue. I'm trying to create and open a recordset, but I'm getting errors. Here's the partial code. Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("Holidays", dbOpenDynaset) These are the...

OK. I got a solution figured out that will work.

I don't have experience in Access, but I'm trying to learn. I would like to be able to display the records of a table on a form. I have a combo box to choose which table I want to display, but I am not sure where to go from there. Please step me through the process. Thanks in advance. Let...

Never mind...I didn't create a primary key in my tables.

I'm an Access newbie. I have two tables that have a one-to-one relationship. What I want to do is delete all records from Table 2 where the first field is present in Table 1. So in Table 1, I have an employee number listed. I want to delete the entire record in Table 2 with the corresponding...

Never mind...I figured out how to use the functions in the Criteria field.

Access rookie. I want to run a query that filters records. Basically I have a field in a table that has text records. Some have a format of E#####, or C######, (an E or a C, followed by 5 numbers) while others have random formatting and lengths. I want to have my query only show the records...