Search results for query: *

I'm attempting to optimize the user interface on a form that prompts for a date for which a report will run. Normally the employee will run the report using yesterday's date. So, I set the default to = Date()-1. This works fine. I want to take this a step further. There is usually no activity...

Help! I looked at FAQ700-184 on how to retrieve a unique number (vs using AutoNumber). Problem I'm having is getting from the current design to a new design. The need for the change is that we are adding a 2nd PC/printer to generate labels and need to avoid duplicate numbers (NextNum - unique #...

Requirements: Retrieving a Next Number. Similar to a PO# scenario, except this one's for a few customers requesting a unique ID on each pallet. This is NOT an autonumber situation. There is a table CustLabelData with fields CustomerID and NextNum. One record for each customer requiring this...

I hope I provide enough information here. I am revising a program that gets info from ERP data source and prints labels that go on shipment pallets. Here's the key issue - a unique number assigned to each label for some customers. A few customers require this, no problem. There is a table...

Situation: Select for vendors who (1) had PO activity in 2006 or (2) vendor record created in 2006. So far my technique has been to create a Totals query (design view) to get the last PO date and then use that query in another to get the desired records. Here are the SQL Views of the queries...

When I started this report I thought I had the skills. Oops. :-) Want the 2nd line of the title to read the date range specified by the user. The values are coming from the form, txtDate1 and txtDate2. Line Example: 12/01/06 - 12/31/06 I tried the following in a text box on the report...

Darn! I was doing so well, now I forgot how... Have a form that gathers parameters for a report that will display on the screen. When the report runs the form remains displayed and on top, covering the report. I would like the report to be on top when it is displayed. I'm thinking to keep the...

I'm working on a form to prompt for report parameters and run a report. The report has Begin and End dates (and uses popup calendar learned here, thank you). I know that accounting will usually run this report as part of their closing process (the first few days of the next month), therefore...

Creating a report to print labels (to go on manilla folders) for "active" vendors. Our criteria for an "active" vendor is: 1. Status is "A" 2. Last PO activity on/after 1/1/2005 or Vendor record was created on/after 1/1/2006. (The "created on/after" criteria is to catch vendor records recently...

Using Access to query an ERP (SQL) database. After a variety of queries to pull the data together it ultimately generates a report. Anyway, what appears to be a dialog box now pops up. It looks like one of my debugging tricks - displaying the value of a variable. In this case the strSQL value...

After the statement: Set rs = db.OpenRecordset(strSQL) executes I would like to check to see if any records were selected, if not (no records selected) then display an appropriate message and exit. What is the statement to check if any records were selected? If records were not selected what...

Working on a project to take checks written (ERP SQL database) for a specified date range and create a text file which will be sent to our bank. In the VBA Coding I used: Dim db As Database *This works in other files. When I run this app/file get the error message: "Compile Error...

This goes out to the many people who have responded to my many questions. Your knowledge, time and effort is greatly appreciated. I just finished a project which required a variety of techniques that have been learned thanks to you. In short, using a form to get user report criteria including...

We have an Access file where all tables are links to our (ERP) database, SQL 2000. We gave the file to another company using the same ERP app and SQL 2000. They are having a problem: Our ODBC connection name is SQLBase_300 (a carryover from using SQLBase). Their ODBC connection name is not the...

New territory for me ... I need to create a text file of information about A/P checks we create. The file will be FTP'd to the bank. Created a query to retrieve the checks produced for a specified date. Now I'm stuck. Didn't see an example in Tek-Tips, nor in the "Access 97 Developer's...

Is there a way to use a calculated value rather than having to re-use the formula in each column of a query? For example... Need the following calculations: Layman's Terms: Maximum Quantity is the allowed quantity over quantity ordered we may ship and bill. Example - Overrun is 5% (.05)...

I know this has been asked before... Created a report which includes a totals query with Max on a time stamp field (transactions entered during the business day) - objective is to 'consider' all transactions for the group to be as of the last transaction date. Example: Multiple shipments of an...

Got a form for user to enter begin and end dates and click a "Run Report" button. This initiates code to check for valid dates and display an appropriate message. If a date is invalid, what is the best way to exit the sub and return to the form? Here's the code for checking, displaying, then it...

When SQL statement executes get an error. This is the command executing the SQL statement: Set rs = db.OpenRecordset(strSQL) ------- This is the error message: Run-time error '3075': Syntax error (missing operator) in query expression 'dbo_orders.spec_no = specs.spec_no inner join combo_specs...

I have two text boxes on a report: Grs Sht WxL 25.00 x 26.00 Net Sht WxL 25.00 x 24.00 Ariel 8 (all report items are in Ariel). The "problem" is that Grs and Net differ so slightly in size that the dimensions are not exactly lined up. Is there functionality, like a tab, to replace the 3 spaces...