Here is my situation. I have a form (frmHotline) for each case I work. On this form (frmHotline) you can input Points of Contact (POC1, POC2, POC3, etc) in a...

Is there some way to show the Total of check boxes selected on a form in real time rather than having to close the form and then re-open it? For...

In the following line of code, is there a way to search the meterID field for a value = to 1 rather than a specific value. meterFind = Nz(DLookup("",...

Hello, I have a main report that needs to add a field from a sub report. I keep getting #error. This is what I have on the Main Report to test for...

Hi all im at my wits end and need some help when i put this into a unbound text box it causes a #Error =Sum(*/100) if i change to =Sum(*) #Error if i...

How many Select Case's can you have before the whole thing starts getting funky? 10? 20? 30? Thanks DS

Hi, I have about 15 check boxes on one sheet. When the box is checked, I want to add a sheet with a certain name using the code: Sheets.Add.Name =...

I am the manager of a small warehouse and am using a access database that a former colleage wrote to track inventory. I would like to modify what he has...

I have databases with dates as their names. I entered the dates in the format yyddmm and now i want to change them to yymmdd. How do i change all at once

I have set up a form to search for a record in a combo box under field Request ID. When the field is unbound i can carry out the search and find the record...

I have a row of 60 controls which I need to duplicate using different names. I then need to overlay this second row of 60 controls exactly on top of the...

I have several forms/sub forms open and a set of parameters on the screen that when changed requery the forms displayed. However when I go out to print one...

Being relatively new to Access, I am trying to make a form auto fill several fields for me. I understand this is possible yet, I haven't had any luck in...

I need to enter data into several 'date' fields in a subform--time in and out on several days. It will accept the time but will change the dates back to the...

I have set up a form to search for a record in a combo box under field Request ID. When the field is unbound i can carry out the search and find the record...

I'm trying to handle a Date field if it's left blank with SQL. I've looked around but I still can't find the solution. Any help...

I need to include in form a place to record when 2 different reports are due. It is based on grants that have mulitple reports. I want the user to be able to...

Is it possible to have 2 things run in the OnOpen event of a form? I need to add Application.SetOption "Default Find/Replace Behavior", 2 to the OnOpen...