Search results

Actually, without sounding rude or arrogant, the Air Freight and Sea Freight tables need to be different because they have different attributes in each table, anyway I figured out how to sort the problem now myself, however I thank everyone who has contributed help.

Hi, Kathy thanks for replying I would like it to happen for all orders, Thanks Ted.

Hi I need help with a query, that has been troubling me for ages, before I explain what I need help with I'll just name what Tables I have: (* indicated primary key) tblCustomerDatabase with the following attributes *CustomerID Title Full Name Address1 Address2 Country Telephone...

Does anyone know how to do this?

Sorry I didn't know where is was meant to go general or here, I deleted the thread now, well I will know next time thanks for your help :)

Hi, I have a customer input form which has record selectors on it, what I would like to be able to do is have a button on the Customer Input Form that when clicked that record (for example record 1) will be applied to the fields of mail merge. Is this possible? I hope so. Thanks in advance for...

Hi I have not made any queries yet for my system so this probably help for that aswell however I need some help with making a chart, I have four tables named tblCustomerDatabase with the following attributes *CustomerID Title Full Name Address1 Address2 Country Telephone Number E-mail...

Thanks, I've sent you a PM.

Hi, I have a form with two sub forms in it the main form is named frmNewOrder and the two sub forms are named frmAirOrder and frmShippingOrder what I would like to be able to do is ensure that when Data is entered into one subform it won't entered onto another form, could you please tell me how...

I can see what you are talking about however my Sea Freight and Airport tables have different attributes for example my Air Freight table has Airport of Discharge and Airport of Recevial while the Sea Freight table has port of discharge and and port of receival and I need them to be seperate...

Sorry I can't have one big form This is because there are three seperate tables one for Cargo Details one for Sea Freight and one for Air Freight as one order for cargo can only be sent through one means of transport (Ie Spare parts for a refigerator can only go go either by shipping or...

Hi! Ted here, I need some help with a form and some macros. Here is what I have I have a data entry form (frmNewOrder)where I enter the customerID then I go to a combo box which says Air Freight or Sea Freight what I would like to do is that when Air Freight is selected have the Air Freight...

I have come up with another solution for my dillema now thank you for helping however.

Thanks, I'll go get it

I checked it didn't.

Sorry I don't have the Northwind file on my computer I have Access 2002

Hi, I don't mean to be rude but that hasn't helped me at all! Article? Sorry I don't have a clue what you are talking about as you can probably tell I'm new!

Does anyone know how to help me, am I not talking properly or anything, I'm more of a veteran at Excel so is Excel terms I need a really big VLOOKUP table.

Hi, I would think it is possible, I accomplished this in Excel so I'll post the VB Code I used so you might be able to get an idea to do something with it. Sub sendsheet1() 'Declare String Dim sAddress As String 'Initialise the string with the address entered into box sAddress =...

Hi I have a problem which I really need resolved however I don't know if this is technologically feasable and its very hard to explain so I'll try my best I have two tables one called CustomerDatabase and CargoDatabase, the customerID attribute in CustomerDatabase is the primary key and its...