Search results

Just a quick one, probalby really easy, but i'm new and kinda clueless to this so here goes: I have a form called "Suppliers" and a text box which displays the suppliers website address, i have put a comand utton on the form, when i click the button i would like it to open the default browers...

Okay thanks, i still dont understand the Query that i'm supposed to create?? Could you explain a little more please. Regards TrekMietta

Okay i'm starting to see what your getting at, just one last question: i know (slightly) how to create a query, how would i set up the query that you suggested? I'm going to try this you way having seperate forms/subforms etc. Also maybe i'm having a dumb moment but all the table are related...

Okay let me explain: i have three tables: customers, products and orders, the reason for this is that a customer always has the same billing address, the reason i have address info on the orders form is that they can haev there items sent to a different address, like there work address, or to a...

Just to check before i try this, as i think i understand what you were saying but.... my orders form is link to the table orders where it also hold other information like shipping address and order numbers, dates etc... currently the forms recordsource is "orders", if i change this won't it...

Okay, i have just looked at the code you posted, and i'm totally confused, also i dont need it to get the "qty1" value. Here's a little more information which might help: The form i'm using is called Orders, i need it to get information from a table called products, i only need it to get me the...

Okay i'll give it a try, i'm not very good with access, but theres no time like the present learn! Thanks Trek

Hello, I have a combobox named"sku1" and 3 textboxes named "item1", "qty1" and "cost1". The combo box allows me to select the correct product code from the list, i then need it to get that products information from a table called "products" and populate the three text boxes with this...

Thank you, It worked straight away, thank you for your patience. Regards Trek

hello, yes it is searching int field in a table i.e. "123456", here is the code i'm using: Private Sub Command3_Click() DoCmd.OpenForm "Customers", , , "custno = '" & Me.ipt_custno & "'" End Sub Thanks again

today must just not be my day, it now says "Run time error: 3464 Data type mismatch in criteria expression" Any ideas, its starting to drive me mad now, been trying to do this for nearly 3 days. Regards and thank you very much for you help and very quick replies. Trek

Just tried it and it says it "cant find the object Do.cmd" Regards

Thanks but it doesnt tell me where to enter the "expressions" or "Code" that he gives?? any suggestions? Regards Trek

Okay i need some help if you guys dont mind. I have a form named customers, i would like to have a seperate form (Not a subfrm) where i can enter the customer number then click a button (search) and it will open the Customers form and display the correct record. On the same form i wish to have...

I am the personnel department, and accounting, and the big bad boss! I run my own company just trying to make my life easier using a database instead of loads of excel and word documents. I'm not a large company and i'm not an expert in access, but you guys help a lot, can i donate towards the...

THANK YOU SO MUCH, that has been bugging me since this morning, thank you all for your help it's much appreciated. Regards Trek

Thank you for your comments and taking the time to help me, but so far none of the things you have said work: 1) =Count(*) : this only gives me a total number of records, i want to add up the SubTotal CONTROL. 2) =Sum(Nz([price],0)*Nz([qty],0) : This just says #Error, or if i'm lucky it gives...

Software: Access 2007 I have a table with these fields: orderno, sku, item, qty, price, sub whenever i insert an item it creates a new record: i.e. SKU ITEM QTY PRICE SUB RECORD1: PK999 Pink Dress 2 9.99 19.98 RECORD2: PK998 Black Dress...

Okay thank you for your help

OKay your probably going to shout at me here for suggesting concatenating two fields again but this would make life so much easier: Again I have the table called "Staff" with three fields "firstName", "lastName" and "username"; and a form with three bound text boxes bound to these values: How...