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

...PC will have its own copy of the Access file to print the labels. Here's the existing coding, after which is my logic for the new procedure: * iNum is the # of labels (each with a unique #) to print. * Each pass through the For loop creates another record/row. * "LabelData" is then saved to...

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

...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 to... Start Date =DateSerial(2007,0,1) Nice try. I posted this one to see if someone's figured out a "better solution" (whatever...

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

...end dates will be the 1st and last days of the prior month. The End Date is easily calculated: End Date =DateSerial(Year(Now()),Month(Now()),1)-1 *Get to the beginning of the current month and subtract one day. The Begin Date gets a little complex, to calculate Year and Month I use the End...

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