Search results

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...

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...

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...

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...

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...

i am recreating an existing Excel spreadsheet report into Access. Everything is perfect except for one thing. i have 3 places that are colored white, bluish gray, and a darker bluish gray (neither of them are standard pull-down colors). i need these three areas to be formatted like the rest...

I have data from a .txt file which is a report from a mainframe system. I have no control over the format of this data, and it is not something that will make a priority list for the mainframe people to change, so I'm stuck with it. The report is by product line, approximately 10 items per...

We access MS Access through a Citrix server, primarily for speed. I've been searching for a solution to the Security Warning and found the code located here: http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning, which works in a test database through...

i have a form that is giving me trouble, and has been for ages. Everything looks good in design view, and the Properties for all fields and items are set to Visible? Yes and Display When? Always. However, when I open the form in form view, it appears to be blank. Only the background can be...

I am writing code to determine the average sales over a 12-month period, with one field per month (derived via crosstab). However, some items were only made available for sale at some point inside the 12-month period, and thus we only have a few months of sales data for those items. We don't...

i have a query that i need to send 38 different field names to a module function. The module is set up where the passed fields go into an array and are used in the function. (The function determines the name of the field that contains a value equal to that of the first passed). But i get an...

i have 4 crosstab queries which all open correctly without issue. However, when trying to execute DoCmd.TransferSpreadsheet code, it suddenly started producing the "Too many fields defined" error. The crosstab queries have an ID field followed by one column for each business day within the...

I have transfer spreadsheet code that creates an Excel workbook with 4 tabs (Tab1, Tab2, Tab3, Tab4). i then want to format the worksheets where the first row of each is bold and all columns are autofit, however Tab1 should have columns C and beyond be formatted with two decimal places, and...

This is kind of a weird one. i know that to call a module through a query (say it's a module to find the minimum value amongst a number of fields), you would put: ModuleName([Field1],[Field2],[Field3],...,[Fieldn]) and the code would be in the form of an array: Function...

My hope is to be able to systematically compare a forecast with historical data. We will receive each in the form of a table and import them. The first step is a combo box that lists the names of the tables in the database, and the user will then select which table is the forecast for...