Search results

Thank you LPurvis... your simple solution >=Date() AND < DateAdd("d",61,Date()) was the most practical and worked the best for what I needed. Although there is a range it requires no key strokes from the operator, which is perfect.

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...

Worked like a charm! I was afraid I was going to have to change a bunch of form and subform relationships if I had to use a query. Thanks again.

I tried that yesterday and it didn't work. Thanks anyway. Any other thoughts? Anyone?

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 don't know why this db keeps getting corrupted every time I turn around, but it's getting REALLY annoying having to pull everything into a new db. I also don't know why it didn't work yesterday even when I wasn't getting the errors. All I know is I'M HAPPY NOW!!!! THANK YOU!!!

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'm sorry did you say "DON'T USE SPACES IN NAMES?" Pretty crass, but I get the point... even though I have never had a problem w/ spaces in my form names before. At any rate, I removed the SPACE and it didn't work. Added the [] around the name and that didn't work either.

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'm sure this would work if I had a number field to multiply the data by, but I don't. I'll have to think about this some more. Thanks anyway.

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...

Thanks. I created a query instead.

Let me just clarify..... i CAN'T set the criteria up in my form in the Expression Builder to pull just those records whose answer is "Yes", i HAVE to use a query? I thought I would be able to use a SELECT expression, but haven't been successful. My field is: Has_Service_Been_Less_Than_1_Year...

Hmmmm.... sorry, not much help. I'm not extracting the data into a query and then pulling it into a report, I'm setting the criteria up for a specific field within the report that's pulled from a form. I need to know the statement I need to use, i.e. =IIf(..... Does this make sense?

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!

THANK YOU! I did try Account_Number.SetFocus, but had it paired with other code AND not with the right event. Vic, thank you for clarifying that.

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...

Good News! I finally got it. I started over and followed an example on Microsoft's web site and everything works correctly. Same steps, correct result. Still not sure what the initial problem was though.

Ok, I did the initial scanned read, but have moved on to getting my OnClose command to work properly for my switchboard at the moment and will come back to it when I can actually think. I work on a help desk team and half our internet customers have been up and down for almost two days and the...