Search results

Just when you thought there weren't enough questions in this forum having to do with date range. :) No snide comments please, I've been searching the forum for a couple days now and still coming up with the same info I keep trying and then some. All I'm trying to get is records for today's...

I have searched through and read as many posts as possible to find my answer, but am not coming up with my scenario to determine the resolution. Going back to my db that contains the address book I got the record selection to work correctly when I click on "A", "B", "C", etc., but the problem is...

I have an address book in my form that I am trying to get working and have come to a dead end. It is the same address book as the one in the Access standard test database. I have attached the db for assistance. I have the form separate for now as AddressBook1, but it will eventually need to...

I have a form where I created a button to open a diff form w/in my db. The form I want to open contains a subform also, so I'm not sure if this is what is giving me grief. When I click on the button I receive the following error: "The expression On Click you entered as the event property...

I have a command button that I created with the wizard and put on the main window form to open a data entry form that has a subform in it and when I click on the button I get the following error: "a problem occurred while Microsoft Access was communicating with the OLE server or ActiveX...

I am trying to calculate a field based on specific criteria....thought about in the query, but not sure how, so I figured I could put it in the Control Source in my report. I want to multiply my Service_Performed field * $1.00 if = to "Disconnect" or * $2.00 if = to "Move" I only got this far...

TOTAL Brain Freeze here! In my report I need to pull ONLY those records where the selection on the data entry form equals "yes". What's the expression I need? I've tried tons of things I could think of and am losing my mind!

Sorry, but I've been looking for over 2 hours trying to figure out the exact code I need and I'm sick of looking, so here goes. Form: CustomerOrders SubForm: Equipment Someone enters data into the CutomerOrders/Equipment forms and when they go to a new record the focus should be to field...

My form contains the field Bill_Date, which may or may not be input during data entry. What I need is to run a query (I think) that allows me to input a specific date that will automatically populate all Bill_Date fields that are currently null with the date specified. Eventually this will end...

Well, they scrapped the whole other form and went a somewhat different direction, but still an issue at hand for my IIf statement calculating correctly. *I have two Account Groups: MHTL and MHTLCM *I need to count the number of installs and subtract the number of disconnects. *The following...

I have different fields in a table that I need to combine and count as one item. For instance, I have check boxes on my form for POTS/DSL_In and DSL_In that I want to combine in my report as just DSL and have them counted. So, if my records have 4 check boxes total selected for POTS/DSL_In and...

I have read the many posts here regarding creating a simple COUNT function and am still unable to get my calculation to work. I have check boxes in my report that I am trying to count if selected. The calculation is in the footer. I have read in the forum and tried to use the following as...