Recent content by A|ex

but that is the problem ;)

yes your assumption is correct with a 1 to 1 relationship (for the time being)

i am having some problems with some code i am trying to write. I want to open up a sales form for a customer. I am keeping it to one sale per each customer. the problem i am having is i want a NEW form to open for each customer. After the new form has been opened and data has been entered and...

did you get the email because i am going to write another?

How are people creating Access 97 > 2000 databases? are they doing it in say Access 2000 and saving as Access 97? if so i can do that too

ive got web space free and bandwidth and i dont think we will be using bucket loads of bandwidth! the only problem is choosing a access format? atm i am using Access 2003 but save all access files in 2000 format just because the 97 > 2000 jump is a lot greater than 2000 > 2003. yeah pm me ur...

Need to sort out contact information, i can offer web space to store the database so whenever we update it or have code we can share it to people within the group. I can also sort out a mailing list too so we can email between ourselves etc. if the people who want to be involved in a project...

does anyone want to get together to design and create a diary or journal?

what i want to do is when you fill in customer details you press the appointments button to open the appointments form. if there is no appointment for that customer i want it to create one. then if you ever go back to the same customer you can open up the record to view and edit without it...

if i removed the acSaveRecord would it work then? maybe add a save button on the appointments form?

i never thought about that: Private Sub btnOpenAppointment_Click() On Error GoTo Err_btnOpenAppointment_Click If IsNull(Me![CustomerID]) Then MsgBox "Enter customer information before entering an appointment." Else DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord...

Hi i seem to be having a problem with my database. I have a customers, appointment and appointment details table and forms. Whenever i enter a customer and add appointment details, close. Reopen it and click the appoitment button to bring the appointment form up and it will create a new record...

is it possible for a mod to move this to general forum? i want to know if this is possible or not? i dont think VBA supports sockets so i guess its make a c# dll addin for access?

yes something similar but for UK addresses. Type in a postcode and it will automatically populate a combo box with possible STREET addresses. After choosing one it will fill in the city etc for you. If not all i want it to do is log onto a web site (map site) punch in two post codes...

i'm not really after a database all i want to do is log onto a web site and validate some details or read in some details. For example postcode to postcode find the difference and display in the database