Search results

Hi. I'm revisiting this because using the link you provided only transfers over the header line for some reason. Perhaps it's because the queries are crosstab queries? But only the column headings transfer over. Also, the default is for 3 workbooks, and there are 4 queries that need to be...

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

It won't let me edit out the previous post. I got everything working with your code perfectly. Only issue is it still pops up the RESUME.XLW once per run. Thanks!

The reason why I saved and closed each step is, I believe, related to the RESUME.XLW issue. I am accessing the database through a Citrix server by necessity (nearly all of our reporting databases go through Citrix for speed and consistency), and for some reason Citrix is holding onto 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...

i think this is just what i was looking for. Thanks!

It is a data warehouse reporting database. i don't have control of the database tables or i certainly wouldn't have put them together as is! The vast majority of what i do is ad-hoc queries run from Access as a back-door to the data warehouse tables. That's an interesting link and would be...

i don't think there's an existing problem unless i misunderstand you. i don't know what you mean by a normalization issue. Everything works fine, but what i had to do yesterday was copy a row from Access into Excel, copy the header row with field names, and paste into another worksheet...

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

i think it will. Thanks!

Sorry, but that doesn't work. I need to know how to put in the Row Source section the value of a Combo Box. It doesn't seem to want to accept me.listObjects.Value (listObjects is the name of the combo box where the user selects the table). The combo box for the field names is blank. Thanks!

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

Here's the scenario: Each month, each customer gives a forecast for 6 months. Each month, our IS department generates a report that shows how many of each item the customer actually ordered for the past 12 months. The purpose of the database is twofold: First it will compare the...

Is it possible to have a form list the tables that are in the database and allow a user to select the correct one? I'm creating a database to take a 6-month demand history for many parts by customer, and compare it to each customer's previous demand forecast. Each customer does a 12-month...

i have a query built on 2 other queries and a table with appropriate joins. Each of the 2 queries runs fine (with valid records), and the table runs fine as well. But the query built from the 3 produces "No current record" error. Help?

For future people who search for something similar and get to this thread, i got it to work. First i unbound the form. Then i made an order exceptions table, with all of the fields from the analysis query plus a field called Keep (Yes/No field with default of No). The analysis query became...

i have a table called Orders. The purpose of this database is to upload orders (from a spreadsheet) into the Orders table, the determine through a series of criteria if there are any stock numbers in the orders that need to be canceled. Based on those we want to keep, it will then export a...

Brilliant! Thanks much!

My company has several locations, each with a number 10 through 24. i have a table (tbl1) which shows the inventory at each location, for each stock number in an order, and i've created a crosstab query that shows the value for that stock number at each location side-by-side (the table is a bit...

Good idea. Thanks!