Search results

Hello Again I've searched the forum but can't quite find what I'm looking for. I have one main table (tblFOBData) with the fields Material, MarketCode, Vendor and Cost. I also have a form that uses the Material and MarketCode fields in cascading combo boxes and this works fine, However, If you...

Hi Guys, I've tried searching the forum to no avail, I have a table (tblBarcodes) that has two fields, Barcode & Material The Barcode field is already populated with specific numbers, but what I need to do is when I enter a new material on my form it will assign it a barcode from the tblBarcode...

Thanks for the quick reply, sorry mine is so slow (connection problems at home). I found that the reason my open form wizard wasn't working was because of the mutant way i had designed my form that was being oppenned, this has now been sorted and it works a dream. Thanks for your help on this...

Hi All I'm currently working on a product catalogue, i have a product data screen (frmProductLookup) one of the field s i have is "Replacement" for when a product is superseeded. What i want to achieve is to be able to click on a button and open a second product data screen that automatically...

Hi all, I have 2 tables, tblCustomers & tblPriceChangeAuth. The database is for auditing purposes where by we have to be able to trace any price changes we make. The problem is as follow's: tblCustomers CustomerCode e.g. 1000001 CustomerName e.g. Joe Bloggs DIY PossibleCat1 e.g. All...

It's ok, I have no calculated data in my table, if theres one thing I've learned above all others in this forum is that you don't want to be storing calculated values :eek: the total is purely as a reference on the form and is not actually stored anywhere, the calculation itself does occur...

Answered my own question I linked my date column to the forms OnCurrent record [SODate] = Date This updates the date on entrey to the form, which in turn creates a record key. Might get some sleep tonight after all.

Hi I've searched the forum but haven't come across this kind of problem. I'm creating a sale and inventory system for my mates shop. My sales form is a main for frmSalesOrders this has Order no. Date and Totals, and then I have one subform frmSalesOrdersSubform with the sales data on. My...

Cheers Chris Second code worked a treat, many thanks

Hello below is the code I am using to update multiple records on a sub form so that QtyReceived=QtyOrdered when you click the ReceiveButton, now my understanding of VBA is a little limited and the code I'm using won't work in my main form "frmReceiving" only in the subform "frmReceivingSubform"...

The command in excel is =now() You then use the cell properties to dictate how you want it, ie just date or date&time etc. However Excel is always live, so unlike access that can record the date/time at a set point excel is always live, so every time you open or update the sheet the date will...

Should probably have said, the error message I get is: "Compile Error" "User defined type not defined"

Hi, Thx for the speedy reply still having problems I'm using the code below, like I said I want a button that automatically changes the QtyReceived for every line of an order to the same as the QTYOrdered. I'm very much a Newbie to VBA and am doing my best to teach myself as I go. I've found...

If rs("QtyReceived") <> 5 Then .Edit rs("QtyReceived") = [QtyOrdered] .Update End If Thanks for your help guys I'm going with the recordsetclone idea at the moment. I've looked up all that I can find that relates to what I'm trying...

Hoping that this is a simple problem :confused: I have an orders form and subform, ie one order can have several product records with the following firlds Product Ordered Received At the bottom I have a command button 'ReceiveOrder' What I want is on click of this button that the received...

Thanks for that. I've put in the ammended coding and i know its correct...in VBA mode if I hover the cursor over the code it tells me its pulling the right value, however can't get it to show on my form. What do I use to link it to my Nett field on my form and in turn my table...

Can anyone help? I'm having trouble storing autofilled data from one of my forms and I was wondering if anyone has any ideas. My data is as follows tblProducts ProductID Description Nett tblPurchaseOrders PurchaseOrderID PODate Supplier tblPurchaseOrderDetail PurchaseOrderID ProductID...

Thanks for the quick response The problem I have tho is ProductID will have about 10,000 records, so this field needs to be a text field that I can key :confused:

Hi all Am currently having trouble with a DLookup function as follows Table ====== Products ProductID Description Nett I have a form (Purchase Order Detail Subform) where by I want to enter the Product ID manually and then for the Description and Nett fields to populate automatically I've...

Hi all, I'm currently working on a simple inventory system that i keep trying to improve and making it much less simple :( In my product table I have a min and max level. What I'm trying to achieve is to set up a form where i can select a Supplier, then hit a button (or another form of...