Search results

Second thought, this won't work either as different summations will need to be made for different products. The Type may be important for an orange but not for an apple, whereas the color of an apple may be vital but not so for an orange. Likes like I will need to go to VBA after all and...

No results. I think I'm resigned to putting multiple fields per criterion in the criteria table (there shouldn't be more than 4), and this will work though not as clean as I'd prefer.

Thanks for the response. I don't think I was very clear. The db actual has no users other than myself. I have taken on a new role with several Excel-based reports, one of which should really be written in Access, but because it's harder to find proficient Access users in our company than...

If I have multiple products with various categories, and ultimately I want one report which groups and sums and categorizes appropriately for each model, can I build a table to set up the appropriate criteria for each product? I know this can be done via VBA with Recordsets and SQL, but future...

I have a report built off one set of raw data, and I'm trying to verify it based on another set of raw data. One of the fields is "OPTS", which contains alphanumeric codes that identify options for each field (i.e. "X1" or "A8"). Some records can have more than one code in the OPTS field...

Oh, I've no doubt I could have set it up more efficiently, probably a LOT more efficiently. This is why I love this place; I always learn something great. I don't think I can briefly explain the reason it's currently set up with individual queries without either providing WAY too much detail...

I'm finding this a hard question to frame for some reason, though it seems a simple question, so I apologize in advance. I have a database with one query for each item that we sell (it is cumbersome but necessary for the imports I am forced to do from Excel); each query is titled the name of...

You are very right. Sorry to waste your time; not sure how I missed it :).

OK, I've dummied up my little database for you, if you don't mind looking at it. I've only left one report but it shows the issue. Thanks!

I have 12 reports that I need to make subreports within one report, and I need those 12 reports to print on two pages (single double-sided page). As it is now, it takes 2 1/2 solid sheets to print, and that is with the textboxes in the Detail and 2 footer sections (1 footer on some subreports)...

And yet, here I sit, frustrated as can be. I have an Excel document with a national worksheet and 10 regional worksheets. Each sheet has a chart associated with it called "Chart 1". I want to print all 11 "Chart 1"s. I can print all 10 regional charts, but the national worksheet prints the...

I have eight regions' sales data displayed in eight line charts on a form. The Visible property is changed to True or False dependent on which region is selected in a combo box, so all charts must be formatted and ready to go when a new chart is selected. Additionally, the user can select or...

I feel like this should be so easy, but I can't seem to make it work. I have a table called Current. The table includes an On/Off field called Display, and a field called "Name", which is usually the month of data in the row. I have an action to append the table to add a row with the name of...

Thank you ALL! This will make my life immeasurably easier!

I realize it would probably be a tome but is there a book that lists all of the possible options for all of the various properties of different objects? For example, I discovered through trial and error that in a chart on a form, the code for the MarkerType property of the SeriesCollection()...

I'm writing a database that has a form with a chart based on several weeks' worth of daily sales. The chart is based on a table, and one field is an On/Off field, another is the date at the start of the week (which becomes the series name on the chart), and fields for each day of the week...

On second thought, this won't work for all of the items in this situation. I really need to be able to do a DLookup or otherwise search for and find something with a wildcard, or a portion of a field. This is actually nested within 2 loops, and one of the looping structures loops through...

Thanks! It looks like I'll have to go this route.

Is it possible to use a wildcard "*" within the Criteria portion of a DLookup function in a module? Some background: I have a group of Excel spreadsheets that I would like to put into Access, however the data is not at all normalized. The data is currently set up with a group of items to the...

For future searchers: I found it. I needed to be using the Procedure Private Sub Totals_Format(Cancel As Integer, FormatCount As Integer) rather than anything to do with Report_Load(), etc. The .Value Property worked and all formatting worked as well. Thanks!