Search results

Hi all was wondering if anybody knew of a simple database to download for entering orders. I am looking at building on the sample. Looked at Northwind but way to advanced for what i need Thanks all

sorry how do you mean and where do i need the primary keys

I want to create a new project but just need a bit of help as i am a bit rusty now.. I have a database for send out orders but need a little reminding on relationship for this database. Please note that the customer will order multiple items from the products on each order i.e. 1 x...

Hi all, Is there a tool to convert mdf to mdb I have a MDF file that i want in my database thanks simon

i have created a google maps account but where do i go from here cant find any information about access on link thanks simon

Hi all here is the code i am using from the second form which update fields on the first form then closes the second form Forms![frmdeliveryentry]![Consignee] = Me.Consignee Forms![frmdeliveryentry]![Del1] = Me.Del1 Forms![frmdeliveryentry]![Del2] = Me.Del2 Forms![frmdeliveryentry]![Del3] =...

Hi All, Can anybody tell me if there are any mapping tools i can use with Access Thanks Simon

yes i am as the field is highlighted on the form ???

Hi all i have 2 forms for one of them i use the setfocus event to take me to a field on the form that is still open the small niggling problem is that when i go to type it bleeps at me and wont let me enter anything i have to manually click on the field then start typing any ideas i use...

Hi all i am starting my new database project and would like to know if somebody can help with the following structure I would like to create relationships between my tables mainly for invoicing purposes we run a small transport company and these are the tables that i will be using the...

i have a form that shows me a distinct value which is the invoice number for a given customer as the same invoice number for that customer is in quite a few records and the query only shows me 1 of the records how do i create an update query so that say on a form the invoice number is 6145 and...

Hi all I have a form that has a control that is deaulted as "no" i want my button next to the control to open a message box that will ask me are you sure you want to mark as invoice if user is yes then the field will change to YES is user no then the field will remain the same thanks...

Hi all, How do i force a newline in my message in the message box funtion i.e. message would show like this Hello World Welcome to my World How is yours Thanks all

Hi all, I have a form and when i close this i want to goto a control on the form that is still open how do i do this Postcode Form on Close goto control "delcontact" on main form thanks simon

Hi all, Simple probably i know but i forgot how to do this my form is from a query how do i hide the blank record at the botton of the form that shows (new) thanks simon

no it is a query with this under the JOBId Field Criteria = [Forms]![fd]![fdsubform]![jobno] which looks up the JOBId in the subform I can edit the record if i enter the JOBId manually so think the problem is something to do with subform because when i open from subform it finds and opens...

Thanks for you reply Main Form = Not based on anything ResultsSubform (within Main Form )= recordscource is a query based on field value from main form fields i.e. JOBId, Customer, Town etc.. Edit Record Form=Seperate Query used from subform field value i.e. JOBId So when i open main form...

I have a form with a subform that displays search results from the main form and a button to the side of each record displayed that when i click on the button it opens another form that shows me the full details of the records the problem i have is when it shows me the record with all the...

i have a form that looks up records then displays them on a subform i want some sort of field to show if no records then display Not Found in a text box or something and Records Found if there are records thanks simon

We have 2 printers on the same PC On one of my report we print a parcel label which we use printer 2 which is a thermal printer the problem i am having is it keep printing from the default printer HP LaserJet I have tried using specific printer in page setup and chaging to thermal and...