Search results

DLookup Or My Stupidity ??? Next Problem: After I put it in the form and got it to work they told me that we are going to have a problem with multiple cities having the same zip code. (Now They Tell Me !!!). Can't I Make it so when the zip code is filled in the city box (ComboBox) drops down...

Thank you very much for you response. I'll try it out in a little bit. Also I'll keep in mind about posting my code. - Charles P.S. Here's the code... Private Sub HomeZip_AfterUpdate() Me.HomeCity = DLookup("[City]", "tblzipcodes", "[Zipcode]=" && Me.HomeZip.Value) Me.HomeState =...

Hello Everyone, Someone must have put a stupid pill in my coffee this morning. :eek: Here's the problem. I put the zip code in and it is suppose to autofill the city and state but it doesn't work. :mad: Can someone look at the attached file and tell me what I might be doing wrong? I've...

Rich, Thanks a million. I like you solution and plan to keep it for future projects. It's neat to see 1 problem and multiple solutions. Attached is another solution I found. Again Thanks A Million !!!

Sample Here's a sample of what I'm trying to accomplish...

Re: Hello Again, I can't use the company database so I will make a dummy database to show you what I am trying to aqccomplish... Give me a little bit to get it together. - Charles Williams

Hi RichO, I'm sorry for the lack of a response. I was out of work because of illness. Yes, I see now that it is trying to count 2 fields that are not there. I excluded the details area because my boss did not need to every record. Is there a way to have it count the SourceShort Footer ...

I am trying to get a total count of the source for 2 different items in the report footer and cannot seem to figure out the correct code. Please see the attached file to see what I am asking. Any help would be greatly appreciated. - Charles Williams

Hello To All, Has anyone seen the message in the attached file? I got this when I was trying to update the row source on the field after I had a problem with data in a report coming up inaccurate. I've been developing in MS Access for about 7 years now and have never seen this. Any explination...

I did a quick search on yahoo! and found these. I don't know if they help but they might get you started in the right direction.