Search results

I have a parent form that has the following [Category],[Event],[Name] In the sub form i am also storing the same values [Category],[Event],[Name] & [Contestant ID], [Score1],[Score2] I do not want to enter the [Category],[Event],[Name] each time i enter a record into this sub form i would...

To Start i have read extesively all related password protection within the site. Did not find anything exactly like this. Have Employee records with the following fields [Name] [Department] The department field is where i indicate Hourly or Salaried What i would like to do is when ever the...

Have a form with several fields within, would like all fields to be unavailable for entry until the first required field is complete. [Department] [Job] [Classification] Would like to have no access to [Job] or [Classification] until [Department] field is completed.

Simple set up, I have a Sub form titled Training that has the the following two fields: [Department],[Jobs] The jobs is a pull down select box that contains all of the job titles for the entire plant. What i would like to happen is for the user to be forced to select the appropriate...

i have a Form where i log accident reports, the reports require action / response from certain people within 3 days. my thaughts are run a query on a daily basis maybe autorun that searches for [Date initiated] that are more than 3 days old and pulls out the selected records. send the results...

Got It Sorry, had the query expression correct, had to put the code into VB editor for the page. thanx Works Great

Public Function zmax O.k This looks like what i need zmax code but how do i put this code into a querie ???

O.K i know this may be a normalization problem but i need to find a way to work with what i have. Situation: Each time my AGV's move they send a data transaction to a data base that logs the Date, Time, AGV #1 Sec, AGV#2 Sec, AGV#3 Sec. Problem: I would like to know the AGV that had the maximum...

I have a query, that displays Date,Time, Station 1 Value, Station2 Value, Station3 Value, Station4 Value I would like to add to that query an expression that identifies which station had the highest value for that record.

Thank you Thank you very much

Would like to put a box on my form that tells me how many records are in the under lying form.

I have a form with a sub form I would like to put a control box on my form that will display a certain value depending on the values in one of the fields on my primary form and another field on my Sub Form Scenario: [SHIFT] this field is on my Main Form [CURRENT SHIFT] Variable control i...

have a field on a form [Text21] Would like to use this field to set criteria on a query Tryed Forms!Form Name[Text21] But it won't work

I have a form with some pull down menus [Date] [Start Time] [End Time] [Machine] Once you have specified the criteria using the above pull down menus, you then click print report. Problem i have 25 Machines and i have to select each machine and then select print report. Is there a way that i...

Working on a Shift Schedule in access have a few box's [Name] [Date] [Start Time] & [Finish Time] Would like to calculate the number of people on shift at a given time. ie Employee 1 starts at 7:30 am and Finishes at 9:00 am Employee 2 Srarts at 8:00 am and Finishes at 9:30 am The frequency...

I have a report for which i calculate the total hours worked in a week and show the total in an unbound box on my report. I do not show the individual daily hours i just make them visible "NO". The formula in my unbound box currently is as follows...

I have a table that has [Total Hours Week1] [Total Hours Week 2] [Total Payable Hours] What i would like to do is have the total payable hours calculated automatically when i input [Total Week1] & [Total Week2] Any Help Appreciated

Have many reports that users print regularly some multiple at a time sometimes one at a time. Would like to set up check box's on my form ,when the person clicks the reports that they want to print and then hit the PRINT button the selected reports will print? Any help appreciated thank you

I have a form that i use to pull the criteria for a query to print a report. Currently i have [start date] and [end date] what i would like to be able to do is also have a list box where i could pull down a list of the months jan, feb, mar, apr ect. and when i select the desired month in the...

Have an option group with 3 department options would like to have a unbound box on my form use the Choose() function to convert the option group value to corresponding text value, then have my query criteria point to the unbound box for what department to print the desired report for. but i...