Search results

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

so does anyone know if this is possible? i mean there are many sites out there which offer addressses, postcode lookup etc. Cant i just import the data into access?

Is this possible in Microsoft Access? i know its possible in c# but ive never really got into Microsoft Access until now. Enter a Postcode , logs onto a website and fills in a combo box full of possible addresses

http://support.microsoft.com/?kbid=209871 all details and code there

OR! you could just create another table storing usernames and passwords then checking the fields of table values. Its much better doing it this way than having the actual password as a string in VBA code because there could be loads of usernames and password combinations, adding new ones would...

do you have any ideas where to start? i mean how would i start on a form or would i not even use a form? ive never done something like this in a database before. I know its possible doing it other ways where users enter dates etc but this way is diff?