Search results

Join Brain Bender Sorry in advance for the length of this post. In my db I have an Invoice form and a Return form. What I want to do is output archived data from these two forms into a report. The report is sorted by the employee who did the sale and by payment type. The report prints the...

AnnPhil They are kind of the same, but not really. Requery loads the source file again. Refresh updates your controls. Its worth a try. In your after update event enter... Me.Refresh Tom

AnnPhil Try checking your Link Child Fields and Link Master Fields. Your problem must be with subform B. HTH Tom

Jeff You should add the SupplierID to your tblBatches. I added a form called test, give it a look. Tom

Jeff To get you started try this. step 1. ComboBox1; Set your controls source to your suppliers table. So it will list all your suppliers. step 2. build a query based on your two tables tblSupplier and tblProduct. Include your Product field and your Supplier field. In the Supplier fields...

wizcow is back Vassago WaHoo!! It works!!! Thank you, for having a long memory. Tom ps. I am locked out of my wizcow2 account now, so is it possible for you to delete it? I will not use it any more. Thanks once more for your perseverance.

What you want to do is a fairly big project. Personally I don't have any short cuts to offer either. Here si what I can offer: this is a great breakdown http://users.bigpond.net.au/abrowne1/AppInventory.html Don't get discouraged! Tom

Very cool. I like it! Tom

I am trying to get a textbox to list all the forms in the database. Can I do this! Tom

When I enter a number in a field, formatted to percent, it multiplys it by 100. If I enter 2.3 I get 230.00% Is this supposed to happen? Tom

Wesley In answer the question 1. Put a date feild in your main form's table. Put a date text box on your main form. Set the the text boxe's 'Record Source' to the date feild in your table. In the the text boxe's 'Default Value' enter Now() HTH Tom

Thanks Rich Your code did the trick. It works great. Thanks again Tom

Rich I couldn't find a function in the wizard that opens a specified record using a forms criterea. I hope I'm not missing something. My first post may not be very clear. Sorry. Let me try again. For example; Customer ABC's 'Invoice' form is open. When I click this new button, it will open...

Hi I have a Customer Lookup button on my 'Invoice' form. I want to open the 'Customer' form (single form) and display the Customer that is showing on the 'Invoice' I have fiddled with the GoTo method, with no success. Thanks Tom

RichB If it was working, and you haven't changed anything, and now you get this error, I would guess that Access, Windows, or your computer, have lost their mind. Try Compacting your databse Tools>Database Utilities>Compact and Repair... Maybe even restart your computer. Hope that helps Tom

I discovered a way to accomplish my objective. To quote Neileg, there are probably more eglegant methods, but this one works. I put a sub report in the header, with the Therapist info and the rest of the report looks after the Practitioner info. Thanks everyone Tom

Thanks for the reply. I need both empoyees on the same invoice, as two poeple can work on the same patient. I have an occupation field in the Employee table. I have tried to incorperate this field into my query but it comes up blank. ? Tom

My query has 4 main fields. 1. Practitioner (sales person) 2. Therapist (sales person) 3. PaymentType (cash,debit,creditcard) 4. InvoiceAmount ($) I want the report to sort by who made the sale. ( the Practitoner or the Therapist) The report wizard lets me sort by either...

Your syntax will be something like this Me!field1.BackColor = 8623747 Me!field2.BackColor = 8623747 etc... 8623747 is a green. When I don't like the color I'm using, I go to a field on a form, click on the ... button beside the Back Color property. This opens the color picker box. I find the...

Cary If you use a 'Form Wizard', the wizard asks you to choose a table or query from a pulldown list. Once you choose the table the wizard asks you to select fields from that table. After you have done that you may choose another table or query. A more accepted manner of using mulitple tables...