Search results

Hi, This really isn't complicated, though for anyone new to Access, everything seems complicated! All you need to do is create a new table with one row, and one column called ReportNumber. This table will hold the number of the last report printed. Then write a query to go and grab that...

Hi Skooterboy! I'm not sure if the term "normalization" is understood in this context. If you have ten fields in each row, those ten fields should probably be in another table instead, and linked to the table with "Store number" and likely using the Store number as the key. That way you can...

Hi! "Why would the image be loading for me and not other users on the network?" I'd first go to one of the other user's workstation, and see if you can load the image outside of Access. The "normal" network issues may be the problem: User does not have a share to the image, user does not have...

Bueller...Bueller....Bueller....

Hi All, I'm having a very difficult time with getting labels to work on Access 2007. I'm using continuous tractor-feed labels on a dot-matrix printer. the labels are 3.5" wide and 1" high. The first problem is that the Page Setup will not allow me to set a Top Margin other than 0.622 inches...

Well, I found a solution! When I include the form name, it works. Private Sub Form_Current() If (Me!chkMale = True) Then Forms![Client Form]!imgIcon.Picture = "c:\icons\man2.jpg" 'imgIcon.Picture = "c:\icons\man2.jpg" Else Forms![Client Form]!imgIcon.Picture =...

Well, no reason why split forms shouldn't have quirks - just like most of Access! Right! That's the part I don't understand. I'd expect this to work only one way, but not one way in one place, and a different way in another place! The image control is in the header of the form. I just tried...

OK, I've narrowed this down a bit. I put in some MsgBoxes to let me know when the picture should change. In the Form_Current(), the code looks like this: Private Sub Form_Current() If (Me!chkMale = True) Then MsgBox "Form OnCurrent - chkMale is True!" imgIcon.Picture =...

Hi Spikepl, I'll try it again... Thanks!

Hi vbaInet! Sorry for the confusion. The image is actually in the top part of the form, not in the spreadsheet part.

Hi missinglinq, Thanks for your reply! Third sentence in post: "The code to change the icon is in the AfterUpdate event for the male/female checkbox." Eighth sentence in post: "On the Form I tried ... OnCurrent, AfterUpdate... none of which would work." I'm not sure how I could make this...

Hi All, I'm using a split form to display client information. I have an icon for Female clients and Male clients, that I change in code to match the client. The code to change the icon is in the AfterUpdate event for the male/female checkbox I have custom navigation buttons, and when I use...

Hi vbaInet, Thanks for the follow-up! This application is only single-user at the moment, but we were discussing today an upgrade to multi-user. So, good that I chose the me.dirty way. (That sounds so weird.. "Me Dirty!" Can you explain how and why it works? I don't understand the idea that...

Hi vbaInet and Privateer, Great!! Both of your suggestions work! Privateer's actually updates the Sum() but the display flickers a slight bit, while vbaInet's does not. However, Privateer's updates immediately, while vbaInet's delays about a second. I'd rather avoid the flicker, so I'm...

Hi All! I'm working with Access 2007 on a form that is used to select the accounts to be printed. I've set up the form as "Continuous Forms" with a checkbox next to the account name. In the footer I have a "Total To Be Printed" text box, with the data source set to =Abs(Sum([PRINTNOW])) I'm...

Hi Smig, Thanks for the detailed analysis (in color!!) of the error processing. Two points: 1) DoCmd.GoToRecord , "", acNext line is not raised because there is no next record. I am testing this on the first record of a few hundred in the table, so that's not a problem. 2) The code I posted...

Hi vbaInet, Thanks for all of your input! A couple of things, though: That's not exactly what's happening. The problem is occurring on the first record of a few hundred, not on a new record. Oh-oh. I've tried it many times, and it very consistently fires a runtime error. Are you trying it...

Hi jdraw, Thanks for your response. Interesting thing, though. I tried to do what you suggested: I tried to "Save As" in mdb format, then tried to open the application in Access 2003. Unfortunately, it doesn't translate well, the mdb doesn't work, so there's no point posting it. Thanks!

Hi spikepl, Thanks again for your help. I just noticed where you're from....With this year's Independence Day being the 45th, there's probably going to be quite the party on the island! ;)

Hi Jr, You win the prize for coming closest to the answer!! I tried your suggestion of adding "ClearMacroError" in my original project, and it does work fine when canceling the update of an edited record! However, it does not pop up a message if you try to go to "Previous" when on the first...