Search results

Thank you so so much! This forum is the best; I will try that and let her decide which is the better, more seamless approach.The web page is not letting me add to your reputation!

Yes, thank you so much. I was just coming back to correct this; I realized that as I played around with it. (where is the embarrassed icon?) I actually would like it to be the last tab stop, but it's only the last tab stop for data entry, then there are several command buttons, one of which...

I have a nasty bug on a form, and would be grateful for help. The last field on the form is a combo box. When the user enters data, and presses tab or enter, it goes right to a new blank record with focus on first blank field ready to enter new data. BUT if instead she goes to a different...

I have a form with a tab control and need to cut some controls out of the tab control and put them on the form. Is there a way to do that so that the associated events move with the controls? Access 2010 Thank you very much. Jojo

Perfect! Thank you John Big Booty! I did get close, but only after trying numerous different combos of forms, fieldnames, and ! s. I am stunned by the simplicity and logic of this answer, and amazed by how many extremely helpful answers I have gotten from this forum-some of which were answers...

I'm sure this is a simple one. I have a button on a form that calls a macro. The macro only has to print a roport of some fields on this current record. The report of the macro works. In the macro, the OpenReport where condition is =Id = [currentrecord]. Id is the autonumber, primary key...

beautiful! works perfectly thank you so much! You have given me several answers to pesky coding situations!! The Word doc opened up perfect-- ready for them to format for their printing purposes!! Thank you!!! jojo

thankk you for replying, TheHub. That will open the report in Access for preview. I need to be able to look at it and format it and make changes in Word.. thank you Jojo

I wonder if anyone can supply the code to open a simple access 2010 report in Word to PREVIEW, using a command button. Thank you and thanks to all the responders of this great forum! Jojo

thank you to all of you for this great site! I have a report that's based on a parameter query using a start date and end date. If the user enters 9/8 when prompted for the date, the query works but they want the year to be required ie 9/5/2012. It works without typing in the year, using...

I am setting the properties at design time on form's property sheet, then i changed it to table design thanks for any help jojo

In Access 2010, i have a form that calls a form for data entry and it opens to a new record for data entery. I have put some default dates and a combo box value into the properties on the form. When the form opens, it already has an autonumber, so if the user closes without adding any fields...

30000! Congratulations to Bob Larso and a personal thank you for the answers to my questions. You helped me iron out some kinks in my system; thank you so much, congrats again Jojo

Thanks so much for that explanation adn your earlier answer. This forum is so amazing, helpful! It took me till now to reply bec yesterday i tested so many times, i neededa break, and i put your before_update code in, so I had to go back to an older version, and test out the numbers. I put in...

Thank you very much, Bob Larson! I struggled with that for days. Works now. But if I open, close, then reopen (using the button that opens the form to a new blank rec exc for defaults), i don;t understand why it actually skips 2 numbers the next time I reopen. (It's ok that the numbers skip...

I have menu form with a button to open the data entry form to a new, blank record. The record displays with the fields blank, but with the defaults filled in, and with the autonumber incremented. If the user then decides not to do any work, but closes by clicking the X that new record is...

I agree with you totally, but the one thats paying the bill wants this button, and knows the probs with it, so i follow orders! Thank you again, it's such a relief having it look so seamless now. The forms look normal sized, and come forward and go backward as they should. this forum with you...

Thank you PBaldy!!! That did the trick! All this time (2 months) that i have been working on this system with forms calling other forms and reports, and things opening up looking decent on the screen, it was this access 2010 frill that gave me such a hard time! thank you for your post of...

This is to pbaldy, who replied on 12/15/08!! to someone who was trying to open a query, but then retreive the calling form when the user closed the query. I am trying to do the same thing now!! Is the same true for a table? There are a few limited events regarding updating data for a table...

thank you GohDiamond for your reply. All i need is a line of code that says If 'a condition is met Then delete this rec endif How does one say "delete a rec" without a delete command button? thank you in advance!! Jojo