Search results

As I am only a Jr. Member, fairly new to Access, I recommend posting the sample data for all to look at. I will try to look again in about an hour for your post to see if I can help though.

First of all, my apology to ebartlett for misunderstanding what you needed. Second, it was not a DUMB question. As a matter of fact, thank you for clarifying and thank you David R for the answer because that is what I need to do next in the database that I am working on.

By cascade, do you mean you select a value in the combo box and it automatically updates another field? In your combo box, you would select all of the fields you want to update. You hide the ones you don't need to see to make your selection. Then you create an Event Procedure using VBA in the...

If you hit the Escape key, then your data in your form will revert back to the original and no updates will be saved (a useful tip if you change a form incorrectly and you either can't or don't want to save the data).

Um, if you think about it, it is hard to group without sorting as that creates the groups. You can have several layers of groups and you can change the Group Interval (Each Value or Prefix Characters) and the Group On (# of characters to group on) options. If this does not help, can you post...

Check your Headers and Footers, Force New Page option is probably set to something other than None. The other possibility is that one of them is really long, not giving you enough room to keep them together on one page.

What ties table1 to table2, the date? To get your report, you should then need to have a query with both tables listed, showing the join relationship between them. Use the query as the basis for the report. Your report should no longer be blank.

I had this one happen to me last week. Select the Subform, change the Propeties, Default View to Continuous Forms (instead of Datasheet).

When you set the page margins, do you go into Design view? That seems to keep them for me.

Is it possible to sub-total every 8 records? For example, if the field is Invitemtotal and their are 10 records to list, I would need a sub-total for the first 8, then the 2 that are left, and finally a grand-total. Records are grouped by vendor#, which is where I Sum(Invitemtotal) for the...

I have an Approach database that I need to convert to Access. I need to start with a Purchase Order that may have more than one item on it. Then, when the invoice(s) come in, I need to display the items (and be able to change them) from the Purchase Order on the invoice screen with the...

Thanks for pointing me in the right direction. While the label is listed as 3 1/2" by 1 1/8", that is not all printable space. I had to bring up the bottom margin as well as bring in the side margin. Now it works fine.

I am trying to print Dymo labels. The labels are 3 1/2" by 1 1/8", continuous feed. The catch is that they print landscape. Here is the setup (which does fit on a label): ---------------------- Name Address1 Address2 City, State Zip ---------------------- What it does is print label, blank...

THANK YOU! I did not know that you could do that, but it worked like a charm!

I want to duplicate a record and then blank out a date field in it. I found the duplicate record option in the command buttons, but if I try to set the field to blank, it gives an error; setting it to 0 gave me 12/31/1899. Date(0,0,0) does not work either. Even though I don't know much VBA, I...

This database is being converted from Approach and was developed by someone else. There are three tables: VENDINFO, VENDTP, & VENDTYPE. VENDTYPE has the vendor type and abbreviation (this is the key). For example: Printer Supplies and PRINTERSUP. VENDINFO has the vendor name, street...

That worked like a charm! Sorry it took me so long to get back to you, got your message this morning, but then our Internet connection was down. Just one thing that I did not think of, I have some duplicate records (the query combines two tables, so I have some vendors listed more than once...

I have a database of vendors and have created a form to find records using the filter from form option. For example, all vendors that are in the city of Rochester or all service vendors. Now, I want to see a report of JUST those vendors. I have created an unbound report where the text box...