Search results

Hi all, I have the following forms below main form is call "Inward" with a field called "RMA" Also in the form I have a Subform called "InwardSubform" with a field called "SUNo" I am trying to create after update event of the RMA field on main form to then goto SUNo on the...

Hi all, When I scan a barcode into a field called "product_no#" I am wanting to remove the "1P" element of the part number that has been scanned. So basically I want this remove after update event? 1PA321354 1P654SD321 1P987ASLJ 1P9875QWD Any ideas please? Thanks

PLEASE NOTE THAT THIS IS NOT A COMPLEX DATABASE IT SIMPLY FOR CREATING DELIVERY NOTES AND THERE WILL BE NO INVOICING OR INVENTORY INVOLVED. WE BASICALLY ENTER DELIVERY DETAILS FROM A FAX AND WHAT TYPE OF GOODS THEY WANT. I have now sorted out all the field required and need to see what needs...

Hi all, Can somebody provide me with a simple orders database as i canot get to with the northwind All i need is a simple database to work on so i can then build/learn from it i.e. relationships and queries Just something with a customer, order and products on it so i place an order for...

Right here goes: we have a table that has the following: I do not want to get inton realtionships please i would rather use a query or something else that does not use relationship [TblPostcode] postcodeID, Postcode, Street, Town, County The customers table has 4 different postcode...

hi all, i have seen somebody elses database that when you open a form it minimises the main screen but leaves the form visable ( like a popup ) any body know how this is done thanks simon

we have a form where we enter new customers and create the account number as first 3 letters then 001,002, etc etc is there someway of when we enter the account number for a new customer it checks to make sure that this is already not being used so is i have a customer joe bloggs, somewhere...

i have a query that show me all records that have not been invoice so there is a field from the order that have a value of invoiced="no" so what i want to do is when i have printed these records i want to change the records field invoiced to "yes" any ideas at the minute i have to go into...

Hi all i have a form that get a value from a query which i use the dmax funtion for which works fine but i want to do this but it is not working if me.invoiceno - isnull then me.invoiceno = dmax ("invoiceno","query1")+1 but i am still getting a blank field, any ideas

Hi all, I am beginning a new database project based on the following tables below. My main objective is to assign an invoice number to orders which can be 1 or more orders per invoice customers orders invoice I am still learning access but would consider myself as advanced thanks all