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

Thanks. I've been reviewing my design issue and the faq and have figured out how to incorporate the FAQ's coding into the current design of this app. Got a syntax question. There's a statement: Const NumReTries = 20# Can't find any resource explaining the # sign. Help.

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

Oops. :-) Thanks.

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

Duh!!! (To myself) This would be an application of something we learned in algebra - the law of distribution. Now I understand how to read the "picture" - how to interpret the design view in the grid. Remou's is the solution I needed - Thanks Remou. Thank you all for your replies. The report...

You can't believe how excited I am!!! :-) (Then again, you've passed this way too, so you do know, ha, ha). With all this help I've just taken my skills - and the product the end user uses - to a new level. Added straybullet's technique to check and close the report. Browsed around Tek-Tips...

I changed Modal and Popup values to "No". Ran the form, which ran the report. (Preview/display) Clicked on the form to bring it to the front. (This is what I want to have happen). Changed the dates and clicked [Run Report] Nothing happened. (The report window was still open.) Closed the report...

Hmmm. The problem no longer exists. Case closed (although the issue is not solved, unless all I have to do is close the file and re-open it later).

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

My mistake - I abbreviated out all that detail. I used Expression Builder to build the formula, so, you know it had all the details. Dang! Nice try.

Sounds like what I want is as straybullet suggests - No for both Modal and Popup. Thanks. BTW - Here is what I am attempting to achieve: Background: Access is being used to generate reports using an ERP database. Currently I create a file for each report (or report set of the same basic...

Thanks for the instructions about placing the SQL statement into the Record Source. About the query, design view, reply: I would interpret it to read ... Where STATUS = "A" or ( MaxPODATE >= "1/1/2005" and ENTDATE >= "1/1/2006" ) What's needed is: ... Where STATUS = "A" and ( MaxPODATE >=...

My failure to communicate clearly. My apologies. I'm setting the default values that will be displayed on the form when it opens. ? I noticed for the end date you used a zero (0). Did a little Googling and learned more about the argument values. THANKS!

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

This is a good time of year to be developing this technique because January is a different situation - Month# is 1 and going back a month also changes the year. So, your formula would not work in January, here's what happens: Start Date =DateSerial(Year(Now()),Month(Now())-1,1) * Evaluates...

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