Search results for query: *

I’m confusing myself! All I’m trying to do is a Select Query from a large table with a matching field in another table. My large table is SalesDetail, and my other table is MexicanZips. There are too many Mexican Zips for me to place in the criteria row of my Select Query, so I put them in a...

Hello, Is anyone aware of a patch to fix subtotal errors in Excel 2002? I have a spreadsheet with columns (left to right): Region, TerrNo, RepName, Distributor, Customer, Jan-Dec totals. The first 5 columns are text, and are sorted in ascending order, starting with Region. The last columns...

I have a Select Query from a table that chooses a part number, a customer name, and a sum of the Dollar Amount. It is in order of part number, and then descending dollar amount for each of the customers of that part number. See SQL below: SELECT [POS Detail].PtNo, [POS Detail].CustName...

I am using VB code behind a button on a form in Access to create an Excel file (from a query) and format it. Part of the formatting is to place formulas in a column, using cell contents from another column. For instance, starting with cell N2, the formula should read “=L2/$L$15”; cell N3 would...

Hello, I don't work much in Excel. I program in Access most of the time, but this task requires me to stay in Excel. I have 2 files. I must compare the cell column of one spreadsheet(it's a PartNumber) to the cell column of a Master List of Part Numbers. If it's not found in the Master List, I...

Hello all, I have a form in my DB with several list boxes (where the sources are each simple Select queries from a table). The user clicks on selections within each list box, then clicks a command button that runs VB code to create a report based on their selections. I want to add a new list...

Hello all, Can Union queries have WHERE clauses? I tried to insert one, and the "union" part doesn't work. The one query I use grabs data for the current year, and one query grabs data totals for the last year, and I merge, or union, them together. It works great until I tried adding a...

Hello, I don't even know if this is the right forum to ask this in, but here goes: Does anyone out there use Microsoft Money? I am a volunteer treasurer for my daughter's swim team (non-profit). I need to know if there's a way to "batch" a job to print a set of customized reports. Otherwise, I...

I have a database with a form used by my customers where they can select certain criteria in several list boxes. When they’re done choosing their criteria, they push a button that runs code to create a report with a list of items from a table that meets their criteria ( I used DoCmd.OpenReport…)...

I am using VB within my Access database (behind a button on a form) to run a query; output the results to Excel; open up that Excel file; format the file, and close it using the code below: DoCmd.OutputTo acQuery, "RPT_BR002_Report", acFormatXLS,"C:\Brady\RPT_BR002.xls", False, "", 0...

Hello, I have a make-table query, with fields for that new table chosen from 2 different queries. I want to add a "blank" field to the new table, that isn't derived from either of the other queries. The values will be null to begin with, and manipulated later on in my process (with an update...

Hi, I have Access 2000. Isn't there a way to rename a table and have that change traverse thru the rest of the database and update any queries, reports, etc that used the old table name? It seems so straight-forward, but I can't figure it out. I didn't understand the help menu concerning...

I need help with the code behind a form, more specifically on an After Update event. Basically, I want a form that has a textbox that I can enter a simple string. I then want the code to create a list of items (in a subform? in a list box? I don’t know) that satisfy the criteria based on the...

Hello, I have a query with names and birthdates in the MMDDYYYY format. I would like to sort them by month, but I don't know what to put in the criteria box for that field to do that. I looked in Access Help, but found nothing. It seems simple, but I cannot think of how to do it. Thanks for...

Hello, I have inherited a report that is based on a query. When this report is run (OnOpen event), it calls a macro that uses a form to prompt the user for some inputs (which are used as criteria for the underlying query). I have a new request where I have to prompt the user for how many rows...

Hello, I am using VBA code to run queries and format them off the click of a button on a form. One of my queries is a quarterly report that has many records (over 29K). When I try to run it, I get: Run-time error '2306': There are too many rows to output, based on the limitation specified by...

Hello, I have a form with an unbounded list box that I want my user to be able to quickly get to the record they want. (There is a LARGE number of records...) I know that if they type in the first letter, Access will jump them to the records started with that letter. Is there a way to let the...

I am using VBA to run queries, output them to Excel, and run a subroutine to format the results in Excel. I'm having a problem with one of them that I do not know how to fix. I am getting a run time error (#2306) that states: "There are too many rows to output, based on the limitation...

I am using VB code to run a query, but I want to put a Where clause in, so it only runs the query for the RepNo=100 (then RepNo=120, then RepNo=180, etc). Originally, (before I applied VB to it), the query had a parameter that prompted for the RepNo. (RepNo is one of many fields in the design...

Hello, I have a presentation where I need to add samples of Excel and Word reports. I have created these reports in Access, exported them to Excel (and some to Word), and I want to add just the first page of the report as a slide in my presentation. I don't want to be able to interact with...