Search results

Hello all, can anyone give me a simple answer to this (Access 2000) question... I have a form called "PurchaseQuotes" with a subform "PurchaseQuotesDetails" with a number of fields including things like 'supplier', 'item number', 'price', 'quantity' etc. - I'm sure you know the script. I am...

You know how you get Access to do something smart, then realise that the solution is not quite as simple as you first thought (happens all the time with me, anyway)? Well, after making Access fill in a field in a different table using After Update event on a form, it has become apparent that...

Hello forum, easy question for you guys (I hope). when I create a new record using a form, I think I need to use the 'After Insert' event to make access create a new record in a different table, passing thru' the OrderID field value to the other tables OrderID field. For starters, I don't know...

Hello forum, can anybody tell me the code I should attach to a command button to have it insert 'today's' date into a field? I'm sure everybody either: a)Knows what it is or b)Would find it incredibly useful! Many thanks in advance, Nick

Hello all, just a quickie... I have a command button on a report which prints off the form that corresponds to the order ID on said report using the 'Me' command. Is there an argument I can add to the code which will make Access print 2 copies of said report (handy for delivery notes etc.!)...

Hello forum, Can anyone give me a few pointers on the following... I want to print a report from a command button on a form, the number of which is taken from the 'OrderID' field on that form. I could be quite wrong, but I am assuming that if I attach a piece of code to the 'OnLoad' event on the...

Hello all, A quick question which is probably beneath most people on the forum... I have created a command button on a form, which I would like to print the specific form on which the button is clicked, not every record in the database! I would like a command which therefore filters that record...

Many thanks to Carol & pcs for replying to my last post - problem solved! Now for my next question... I have built my database using a similar model to 'Northwind'. I have around 160 records in my 'products' table, and in my order details form I would like to select one record from a combo box...

Hello fellow members, This is my first post so please be gentle! My problem is, as the title suggests, that my lookup lists are not displaying the correct number of decimal places for currency. I have set the properties in the table the list is taken from to 4, I have created a query for the...