Search results

I found this thread http://www.access-programmers.co.uk/forums/showthread.php?t=44199&highlight=navigation after doing a search and everything is working great. I remember seeing code somewhere that turns the navigation buttons into "intelligent" buttons. Once you are at the end of a...

Thank you - the DeCmd works perfectly!

I would like to set the properties of a control on a form based on if it is opened in edit or add mode. For example I use one form for both editing and adding records (the mode is changed based on the command button that calls it). I have a command button on the form for searching records I...

Happy New Year to you too. I guess the New Year's parade is over! Shouldn't you be watching the Rose Bowl? Certainly more elegant - and it works (I just tried it). However I have left things as they are. Instead I will get permission to change the original data, then I can continue to use my...

I figured out a kludge. I have an invisible text box that gets its value from an if statement in VBA (if txtOLDQFLAG = "f" then txtOLDQFLAG2 = "g"). The query then gets it's values from either txtOLDQFLAG Or txtOLDFLAG2. Not elegant, but it means I don't have to change any of the original...

I realize looking for help on logic on New Year's Eve may be asking too much, but I will give it a whirl. I know I could solve this problem with an update query, but for the moment I would like to avoid that. I should be able to do this programmatically. I have a field that contains one of...

Thanks Mike. I have used similar techniques in other places in the program. This MsgBox is used to remind users to keep a copy of a specific Excel spreadsheet in a specific place (the program uses the path to load data into the spreadsheet) AND to load the Excel Reference Library. I was...

After some more searching the short answer is no. One solution is to use a form, but what I have will do.

Is it possible to change the font characteristics (bold, underline etc) or even the colour from one character to the next in a MsgBox? Or is this all predefined from the Windows properties?

Now my eyes must be getting to me - what was different from what I had? BTW Thank you - again.

Sorry - I got distracted. I guess I didn't finish cleaning the stripped down version. Now there are no extraneous macro calls etc. If you click on the macAddNewTransactions it should open the form frmAddNewTransactions and the pop-up form frmCompanyList. I also added the code in question to...

I didn't include all the macros and functionality. The double click opens a report that is a help file for that control. The macAddNewTransactions should open the form in add mode. It does work properly in the database. It also opens the frmCompanyList that is the popup.

Nothing comes easy on this one does it? You will get an On-load error when you open the main form frmAddNewTransactions - I didn't delete the calendar routines.

Maybe this is a control reference issue. The txtControlID is on the first page of a tab control so I have also tried Forms!frmAddNewTransactions.tabMAIN.txtContactID = Me.txtContactIDPOPUP but I get an error saying the property or method isn't supported. This first page on the tab is NOT a...

I can get the main form to grab the data from the POPUP. So it is not because of a spelling error. And since both forms are opened with a macro at the same time, I know the main form is open. Could it be because the POPUP has the focus? Although I have tried this with the second form POPUP...

The difference between them is FORM! and FORMS! The error is that Access can't find the frmAddNewTransactions.

Out of curiosity (and this may not be related) - have you tried creating a blank database and then importing everything? That fixed a few problems I was having.

Other than it's what my manager asked for - no. He comes from an Excel background so maybe combo boxes aren't his thing? But since he's the one who's going to maintain this beast as of April 1 (when I retire - yippee!), I am trying to give him what he wants.

I have a main form frmAddNewTransactions and a separate POPUP form frmCompanyList. I am trying to set up a routine such that clicking once on a field in the popup form will load the appropriate fields in the main form. So far I have: Private Sub txtContactID_Click()...

Thanks for that link. I am also importing your update routines (with appropriate recognition). Fingers crossed the power stays on. Have a merry Christmas anyway. Remember the old Dodgems/Bumper cars from fair grounds? You might appreciate this video from Portland...