I have a form and it is divided in parts by a line I drew. Is there anyway to color the background of each part with a different color? When I go to...

I have a combo box on main form that populates a subform with datasheet. The db is linked to another db with fields JobAssignment and MachineAssignment and...

How can I enter a condition for two fields? I want a lt green background with red text if the following conditions are met: HotJob = Yes (redtxt) and...

I am having a problem with the following code: Private Sub Combo32_Click() If Me.PumpType = "MANUFACTURING" Then DoCmd.OpenForm "fGeneralInfoManufacturing", ,...

Using the following code, will someone please let me know why I'm still getting an error msg "Text you entered isn't an item in list" Private Sub...

Using the following code, can someone please tell me why I get the msg "Can't Assign Value to This Object". It was working fine and we had a glitch run thru...

Hi, I am looking for a way to lock, hide, or remove records from datasheet view. I have a subform in datasheet view set up as follows: Tech StartTime ...

Hi, I have a report that returns a list of work done weekly. The expression I am using now is only good for looking at the report on Monday (7 days prior). ...

In my 'Repairs Tracking' database entry form I have a drop down field called 'status' which establishes whether the repair is 'current', 'on hold', 'pending'...

I'm sure I must be overlooking something very simple, but I have a field formatted Percent and everytime I enter 25 it displays 2500% and returns $2500.00 on a...

Is there code for the OnClick property of a combo box to print a report when selection is clicked? Not sure what to put after DoCmd.PrintOut "ReportName"...

How can I send a form through Outlook? When I try to send it, it sends all 50,000. I only want to send the form showing on the screen. If I choose edit,...

I have a form created and the users what they type to be in all caps and if they type in lower case when they tab out it formats to upper case. I cannot find...

I have 5 loications that have multiple people associated to them in a query. I want my combo box to only show the 5 locations not the same location over and...

I have a comand button that opens a form in print preview and has a filter that asks a user to enter a location. How do I add a combo box to let the user...

I'm looking for a way to be able to press a command button and the current time be entered into a field. Example: Form that contains technician, work codes,...

I'm looking for a way to relate a dialog box that will pop up with notes for a specific job when that job number is entered. Example: Form that opens with...

I have a combo box and a list box on a form. The combo box lists tech names from a tech list table. The list box lists jobs related to each tech as they are...

I have a hyperlink on a command button on a form that opens a server with folders that have the same number as a field on the form. Is there a way to open the...

Hi, First, please forgive the long explanation as I want to explain in detail what I have and would like to change. I currently have a database that has...