Sigurd- You're correct. In my example, I *divided* by 24 when I should be multiplying. Duh. John Viescas, author Microsoft Office Access 2007 Inside Out ...
Hello all :) I have a form named 'Purchase Orders'. This form has a Subform named 'Inventory Transactions'. In the subform is where i enter orders. The...
John I uploaded a .jpg of the report into 2_AssistanceNeeded it is named Tony's Report and have circled the field that I am refering to. I would like to take...
Dawn- I assume the Unit Price is in the Products table. If so, include it in the Row Source of your combo box, but don't display it (set the display width for...
Peter If you are keeping Access 2003, you can still save a report as a PDF. Stephen Lebans has a sample database and the necessary DLL files to do this. If you...
Tony- Do you want to do this for every row? Which column are you testing for less than 40? What are the names of the fields behind the circled columns ...
John I would like to do this for every row Where TTCRun is less than 40. The column that is being tested for less that 40 is TTCRun which is the Running Sum of...
@ Sigurd: That does the trick for opening. I didn't expect it, because I thought shell did the same as a batch file. But... I added the command without the...
Tony- I looked at your .jpg file. I can't help you if you won't tell me the control names, the criteria for "less than 40", and the Record Source of your...
John I would like to do this for every row Where TTCRun is less than 40. The column that is being tested for less that 40 is TTCRun which is the Running Sum of...
Tony- What is the SQL for query ExpFabProd? John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft...
John ExpFabProd is the SQL. Sorry for any confusion I am new to this and I am not familiar with everything. Thanks Tony ... a Report ... 40. ... GPPH, ... ...
I hate doing this . . but I need quite explicit directions . . lol When you say to include Unit Price in the Row Source, are you meaning on the Products table...
Include the Unit Price in the Row Source of the combo box, as John says. You refer to the combo box as a drop down box. Sigurd ... [Non-text portions of this...
I've never needed to bother with the bat file window staying open. If I recall, it closes after you exit Access. I'd be curious if someone else has an answer...
Hi All, I am in need of some help and advice. Developing Access Databases has been a "second job" so to speak for me, except almost all of my work has been...
Thank you very much Sigurd! Yes you are right, the person using this database is the person who updates and add data for this database. The way you guided me...
Thank you very much Sigurd! Yes you are right, the person using this database is the person who updates and add data for this database. The way you guided me...
Thank you very much Sigurd! Yes you are right, the person using this database is the person who updates and add data for this database. The way you guided me...
Somehow 3 copies of your message got to the group. Without a network connection, there's no way to have updated information from your front end. To have that,...
Hello: I recently deleted an unnecessary fieldin one of my tables. This table was included as a part of a query, which was the control source for a report....
Hi, I'm trying to use a Dlookup statement in an Access 2000 db I'm building. I've used this statement in other db's and it works fie, but in the new one I get...
Tony- Find the query named ExpFabProd and open it in Design View. Choose SQL View from the View menu and copy and paste what you see in a reply. John Viescas,...
Hi Nige, Me.Name returns the name of the Form the code is in. You need to declare a variable and use it instead and to rename your field and/or TextBox. ...
Dawn- Open your subform in Design View. Select the Product combo box and open the Properties window. Click in the Row Source property and click the Build ...
Hi Chanell Solomon, I have had a few of those problems before. Often I found that the field was used in the Report's Grouping and Sorting. Right click on the...
Chanell- Did you check Sorting and Grouping? I bet the field is mentioned there. John Viescas, author Microsoft Office Access 2007 Inside Out Building...
Nige- CurrentUser will always return at least "Admin" - the error occurs because the DLookup can't find a matching user, so it returns a Null value. You can't...
Hi AD yes it's indeed the same issue. I must have missed your reply the last time. I've since looked at using a multi-day record from the outset (as per...
