Search results

Welcome Welcome to the forums! I'll tackle the first of your inquiries. Place a button in the Form Header. Name it "cmdDataEntryMode" with a caption of "Data Entry Mode". Then attach this code to it's OnClick event: Private Sub cmdDataEntryMode_Click() On Error GoTo...

The users of this forum are, in general, a really bright group. It seems only fitting that there should be a category in the forum called "Access Wish List" whereby users can post ideas that they would like to see within future versions of Access. Even if the posts do not strike the ear of...

Got it working! FYI - I was able to reset the autonumber using a variation of the code provided by the kb link that RoyVidar posted (thanks Roy). The code provided by Microsoft didn't exactly work for me initially and therefore I'm going to publish the code that did work below. Important...

Pat, I tried your code on the link, but ADOX is not in any of the libraries I have installed. Any suggestions? I'll try a kb article method in the mean time. Thanks, Jeff Access 2003 XP Home

Thanks for contributing DonK. I had exactly the same problem and your solution listed above was just the ticket! Jeff

Is this more tab control problems? Many may have seen my post about the improper rendering of the tab control in Access 2003 with Windows XP SP2. Now I seem to have run across another "error". ControlTipText only works on controls listed on the topmost tab of a tab control. You can set the...

I've got SP2 too. My screen resolution is 1280 x 1024 which allows one to see a 7.5 " tab control on a single screen. The rendering anomaly continues to occur when I set the resolution lower and then scroll downward to the offending area. To add to the intrigue, your comment Pat triggered...

Not much to e-mail you Crilen007. I just created a blank database and placed a tab control on a blank form with a height of ~ 7.5 inches. (refer to the JPG)

I haven't seen this problem defined in the forum so I'm going to throw it out there... I'm using Access 2003 on Windows XP Home. When I create a tab control the background color is a subtle blend. The top of the working area of the tab control is the same color as the tabs and then the body...

1) Close the main form. 2) Open the form that represents the subform ib datasheet view. 3) Choose Format->Fonts on menu. 4) Make changes. 5) Close the subform. 6) Open the main form (your changes should be reflected). HTH, Jeff

Right on OldSoftBoss! That's exactly what I was looking for. I think my problem was... I never use "Select Record" or "Select All Records" from the menu bar so I didn't even know that that RunCommand existed. Thanks Much! Jeff

Thanks for the reply llkhoutx, Yes, I am referring to the record selector column at the very left of a form (if Form.RecordSelector = True). I'm not looking to color it, I'm looking to duplicate what it looks like when a user clicks it (on my computer that means turn it black and invert the...

Not sure if this is a "duh" question, but I can't find an answer in the archives: How can you hilite the record selector from code (as if the user clicked on the record selector himself/herself)? Thanks for any help, Jeff

CustID is primary in customer table CheckID is primary in check table Set CustID relationship one-to-many between customer and check table And yes, if you just want to use the table to enter data, click the (+) sign and enter in your checks. Jeff

If you need the hyperlink to be dynamic (and that sounds like what you are getting at) try: Private Sub myButton_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) myButton.HyperlinkAddress = "http://www.mysite.com/page.html?variablename=" &...

In your check table have a field for the customer ID. Easiest way to implement this is the make a form based on you customer table then add a subform that is based on your check table. Assign the parent/child based on the customer ID number in each table and voila! Hope this helps, Jeff

I'd like to have a shortcut key (Ctrl+O) for my custom menu. I can functionally achieve this by creating a macro "AutoKeys". What I can't do is have the caption of the menuitem have a right justified "Ctrl-O" appear. The Access Help file says you cannot assign shortcut key text to a custom...

An old post, but thanks for leaving the answer Itchy... This is an awesome forum! Jeff :D

If I read your post correctly... sure a fancy form can do this with a minimal of VBA. I envision your 3 comboboxs splayed across the top of the form with a single button next to them that says "Go!". Make a query like you normally would but instead of hard wiring the search criteria put in...

I just wasted 3 hours of precious sleep only to discover the OrderByOn property!!! I must have gone through every macination of object.Requery, DoCmd.Requery, and SetFocus on my form and subform only find that there is an OrderByOn property!!! Now why would Bill ever think that if I go to the...