Search results

I have a button on my home form that when clicked, it exports all records in a certain query to excel, and also opens a report based on the same query so I can view the exported records in a more organized format. The query is based on a status field where the value is "new". I need to change...

Wait a minute. does the on format event of the detail only work in the print prieview view of the report? I was testing all along in the regular report view and it was doing nothing, but in print prieview I got some results, but still not EXACTLY what I was looking for. With my original code...

Thanks for the reply. I messed around with conditional formatting a little, but couldn't get anything to work. Can you control labels with conditional formatting? I couldn't find any way to do so. I also moved my code to on format event of the detail section and it did absolutely nothing...

I'm trying to create a report base on a form that amongst other data, has 4 check boxes and each has a few associated fields. If all of those associated fields are blank, then obviously the checkbox would be blank. In my report, based on that form, I want to hide the checkbox and its...

Yeah I know, thats exactly why I had to come here and ask what im doing wrong. Two reasons... First when the preview window opens, it "locks" all access to other open forms, menu bars and any other region of Access outside the preview window until that window is closed, hence cannot click File...

I have code that opens a report for the current open form. It works fine, BUT, I would like for it to print directly to the printer rather than prieview it. My code attached to my print report button is: DoCmd.OpenReport "Card Charge Form", acViewPreview, , "[Order ID]=" & OrderID, acDialog...

I think that did it, thanks. I tried it on just one record so far, and no errors. Will let you know if there are problems on other records. Thanks!!

Yes its in the after Update event of the Customer ID field which is in the main form Yes the name of the field actualy is Card_Type with no spaces. Here's the database...

Thanks for the suggestions... I used this: Private Sub Customer_ID_AfterUpdate() Me.OrderSubform.Form.Card_Type.SetFocus End Sub And it did nothing, and I used this: Private Sub Customer_ID_AfterUpdate() Me.OrderSubform.Form.SetFocus End Sub And it gave me the error: Run-Time...

I have a delete record button (slightly modified code copied form the northwind sample database) My form has an order details subform attached to it, and when i click my delete button it throws up an error, which I'm assuming is because its trying to delete the "parent" record and cannot due to...

I have a form with subform. In the After update event of my Account Number field I set the focus to the first field in the subform like so: Private Sub Customer_ID_AfterUpdate() Me!OrderSubform.SetFocus End Sub Everything works fine, but here is my problem... the entire form...

Thanks!!! So it kinda works, but only if I put it in the BeforeUpdate event of the form and with nothing else. That also makes it prompt me after every way I navigate away from the new record, even if I intend to save it. I need it to work only when I click the Cancel button. If I click close...

I'm trying to create a button that will cancel/erase data entered on a NEW record, and close the form without saving, but only on a new record that has not been finished or closed yet. Currently I have something that works, but not exactly in the manner explained above... Private Sub...

Yes that is exactly what i am looking for!!! Customer ID, as well as Name and Address fields Sorry for my ignorance, but how??? I dont mind doing whatever needs to be done in VBA, but I am still in the begining steps of learning it and have no clue on how to "push" or "pull" values. Any...

I asked a similar question a little while ago, and some answers made me decide to basically just start over with a different design/structure. I have a customers form, and an Orders form, with Order Detail subform. I am trying to put a button in my Customers form that when clicked, it opens...

Re: help with this code to automatically populate fields I was thinking oh how to accomplish this in the Access 2002 format, and I came up with something. I don’t know if it would be the correct way to do it, but theoretically it should work, but I just need help with the code and the syntax...

Oops!! I meant to say tab groups before, where each tab I guess would have the same subform, but different filter/query.

Ok I think I found out what was/is the problem. I found an article explaining the List Items Edit Form property of a lookup (which is apparently new to access 2007) field and how it works in conjunction with an embedded macro in the onOpen event of the form being opened (link here). I am using...

I have a home screen/summary form that I want to display order detail option groups. Group 1 have display all new orders, group 2 display all active orders, group 3 display all closed orders, etc. Instead of having 4 different forms based on 4 different queries for each subform in the option...

Thanks for the suggestion, but all the field names in the table haven't even been changed, except for the company name, which is now account number, all others are exactly the same. I basically went throught Northwinds event controls line by line to see if I could find any code that did this...