Search results

Yes, that did it. Thanks so much.

I've got a form with a DATE field and the little icon for the calendar appears when I tab to that field. Is there a keyboard shortcut for today's date that I can use without having to click the little calendar icon? I know I can copy today's date and paste it but wondered if there's a keyboard...

Never mind. GOT IT! Thanks so much for the help.

YES! That did it. Thanks so much.

OK, thanks. I need just a little more help to cross the finish line. When I copy and paste "DoCmd.GoToRecord , , acNewRec" on the "On Lost Record" property line and try to use it, I get an error message, "cant' find the object 'DoCmd'". Am I supposed to click the "..." instead and paste it in...

My form contains a combo box that uses a RetrievalField to search records in a table. As I TAB through my form and reach the end of the form, I'd like to hit TAB again and go to a new, blank form. Currently, hitting TAB takes me to the next record in the table. Any help appreciated. Thanks.

Thanks for the help. But could you help out this relative newbie and either (1) describe step-by-step where/how to enter this code or (2) describe an easier, more user friendly way to accomplish the same thing? For instance, is there a setting in Properties somewhere that will accomplish this...

I am interested in the answer to this as well. Anyone?

Ah. Yes. Thanks very much. That helped. One last thing: As I tab down and complete the form everything works great. After the last field is complete, I would like to hit TAB and be taken to a new, blank form (for a new record). Currently, it takes me to the next alphabetical record. Is there...

My combo says, "unbound" and I think that should work. I believe my challenge has something to do with the combo box's "After Update" setting but I'm not sure. Any other ideas? Anyone?

Yes, I did that. I've created the combo box and it does, indeed, find data that's in the table and displays it in the combo box. Underneath my combo box on the form are other, blank fields for that record's address, phone, etc. Once I find the record record in the combo box, I would like for...

Hello. I have a form with a combo box containing a RetrievalFeild to look up data (name and birthday) that may already exist in the table. That way, if the data is already there, I don't have to enter it a second time and create a duplicate entry. When I am in the combobox and find existing...

Thanks for the feedback. Here's what it turned out to be. I opened the table and noticed TWO column headings with small "up" arrows on the right side indicating they had been sorted at some point. I cleared all sorts then created a new report from scratch (based on the original query) and it...

Hi. I have created a simple query using four fields from a table. I then created a report based on that query that displays those four fields. When I open the report, however, I get an "Enter Parameter Value" message with a field name that I'm not using in either the report or the query...

Sorry, guys. All this is doing is presenting me with the total amount of records. I have, no doubt, messed up something along the way. I have placed this in the FIELD name in design view of my query: HowMany: Count([SchoolName]) When that is the only field used it just counts the total...

Thanks for the reply. Sounds interesting. You lost me on "AS HowMany". I can't find a reference for that in the help file. Can you walk me through it a step at a time? Sorry for the hassle. Thanks.

Hi. Here's an easy one for you (that I can't seem to figure out). I've got a table with 1,000 records. One text field is SCHOOL NAME. I want to count how many records there are of each school. For instance, there may be several records that have Lincoln County High School, several more...

That didn't really help. Apparently the link doesn't work. I've been working on this particular challenge for some months and can't get all ten on one sheet. Any help appreciated.

And yet another thing related to this... After I finish entering a new record using the form, how do you get it to update the table automatically? There's some sort of "Enter After" property or something like that, right? Where is it and what is the correct syntax? Thanks. :)

Thanks. The find/replace definitely won't work. I don't want to delete records or fields. I had never heard of the "update query" so, "thanks". That worked great!