Search results for query: *

I have a form that will navigate through records. Each record is in a division (division is displayed on the form). Based upon which record is displaying, I will need a VBA query to run and display in a subform the results of the query. I need some assistance knowing which event to place...

Date Loaded, date/time ProductID, text ProductDesc, text Dept, number Class, number ClassDesc, text

Form Product A View Class: 4 Description: Red bucket Product B Class: 2 Description: Blue Bucket Segregation Table (this is the logic I need to essentially 1 2 3 4 5 code into the app) 2 3 4 x 5 x - designates products...

App is Access 2003 I have another query stored that designates Product A as 4 and Product B as a 2. The classes are static material that comes from another source. I currently have it tied to a form so as you scroll through the records of Products, when you see Product A, you will also see...

I hope this makes sense. I have a segregation table: 1 2 3 4 5 2 3 4 x 5 I have a form that has product in it with classes. Classes are 1,2,3,4,5 in the segregation table. Product conflict is created if an 'x' falls in place on the grid. Product A and Product B conflict if A is a 4 and B is a...

I have a report designed in Access. I have six tables that populate this report. The data for each table comes from six separate excel files. I have designed a macro that uses the TransferSpreadsheet to import the excel files. I wanted it as automated as possible. Here lies my problem. The file...

I think I've found that a procedure I created is formatting my time and therefore making it a string so multiplying times the result returns an ERROR. I am working on adjusting my procedure.

That's what I thought. Thanks for the information.

If you have more than one subform, but you have the uniquekey in each table, is it possible to create joins between all tables to retrieve all the data from the tables.

I have a database that I developed that will have forms with subforms. I also have an export feature that will export the data from the respective table. However, I didn't realize that the subforms throw a twist on a simple SELECT * query. What is the best way to export out all the data from...

This returned no records

Yes, they actually do have values. I have it set up to save and add the record when a command button is clicked. In the event procedure of that button, it records the time rst!ActualTime = Time() that the button is pressed which is the person's login or logout time.

I was able to enter the first set of code and it returned everything and the TimeDiff field displayed as a decimal, but the second set of code gave me a data type mismatch error, So I could not even run the last query.

WorkHours is a computed field but comoputed from a date/time field. This query computes my time difference from a function: SELECT qryLogData.RealDate, qryLogData.ActualTime, qryLogData.ID, qryLogData.emp_name, NextRec([ActualTime]) AS LogOutTime, Format([LogOutTime]-[actualtime],"Short...

I tried multiplying the "WorkHours" by 24 and my query returns a column full of "#Error"s. This is my last roadblock.

I have a calculated "WorkHours" in my time application. In an effort to create a Productivity measure, I need to divide this time into a single integer. (ie, WorkHours = 2:15, CompletedTasks = 20; CompletedTasks/WorkHours=20/2.25=8.89 audits per hour