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

there are lots of different ways of tackling this, but I would suggest that the best thing to do is to use the autonumber and set the forms so deletions cannot be made - see following topic: http://www.access-programmers.co.uk/ubb/Forum4/HTML/005993.html The reason I say this is because your...

Thanks for reply, DBL! Ah, a Scotish person(?). Your hubby probably saw the better game. Me? I fell asleep. Still, it beats working. Many thanks once again! Nick

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

Thanks for reply 'llkhoutx'! Access didn't like this line - set rs=db.openrecordset _("YourTableName",dbopendynaset) but I found a different solution that does work using SQL statements, searching the 'knowledge base'. Is this because I am using a different version of Access than yourself? I am...

Hello sonata2002, make sure that the format of the field you are copying the price into is set to some kind of number format ie. long integer and not text. I think that should solve the problem? Or perhaps the formula you are using to add the figures together needs tweaking. HTH Nick [This...

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

Always wondered how you do that myself...

Sorry, just answered my own question by searching the forum... Private Sub Command120_Click() Lastattended.Value = Date End Sub Thanks all the same!

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

Thanks Chris, I think this is just what I need. Much appreciated, Nick

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

Thanks Shep - I could do with using the 'OnLoad' event on the form itself to set the order ID as there are a number of different ways to arrive at the form I wish to print. Is this possible? Any help / advice is always much appreciated, Thanks again, Nick. [This message has been edited by...

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

Thanks for your reply Pat, still having problems though! The combo box is called "ProductID", it has 4 rows, the fourth of which is "UnitCost", and I have created a new text box called "UnitCost1", so I have written an after update event procedure that looks like this- Me.UnitCost1 =...

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