Search results

Hi, I have set up a database and tested the forms etc to make sure they are working. When I did this, the Invoice Number (Auto Numbers - Indexed) went up to 6, because I entered 6 invoices. How do I reset the AutoNumber back to 0:banghead:

It is just a standard query made using the query wizard, then entering the formula into one field. I don't know how to make it an Append, Update or Totals

Sorted! Thanks

Sorted! Thanks very much

When my query didn't allow me to add new records I tried to set the default value in the table to : [AmountBilled]-[ReceivedFrom] but it didn't work in the table. If I go to the table I can add new records, but I can't add in the query - don't understand why.:banghead:

Ok, so I set the criteria to : [Patient Details Table].[PatientLastName] It didn't work, I was not prompted for the PatientLastName I tried SELECT [Patient Details Table].PatientLastName and it didn't work. Do you know what I have done wrong? I know that it is better to not have spaces in...

Hi, When I make a calculated field on a form eg: [AmountBilled]-[ReceivedFrom] the form stops me from adding new records. I have tried to make a query with the calculation and then base the form on that, but I still get the same result. Can anyone help?:banghead:

Hi, this may sound like a rudimentary question, but I would like to know: Once you have created a database using Access, when you take it to a new computer does that computer have to have Access or will the database run without Access. Thanks

You're a genius! Thank-you:p

I am trying to select parameters for my query to prompt. Under Criteria I typed : PatientLastName It said that there were two tables from the parameter could be called, so I added: Patient History Table.[PatientLastName] Result is that it either prompts me for the last name or says there is a...

Hi. I have created a mainform which opens up when you enter the database, the form has commands which takes the user to forms and reports. The only problem is that when I try to access the database to make changes to queries or forms, I can't access it because it has the mainform and I can't...

Thanks - you set me on the right path. I needed to enclose the Default field in "".

Thanks, I'll give it a go.

It is a text field.

The Format Field is set to "00". It is a text field. I changed it to a Number field, but still got the same result - no leading zero.

Hi Bryan. It took time, but I eventually solved my problem with the following : SELECT [Patient Details Table].PatientLastName, [Appointments Query].PatientLastName, [Appointments Query].PatientFirstName, [Appointments Query].PatientDOB, [Appointments Query].MedicareNo FROM [Patient Details...

Hi Bryan, Just when I correct one thing, another goes wrong. I am working in Appointments Form. I have set up the following Row Source: SELECT [Appointments Query].PatientFirstName, [Appointments Query].PatientLastName, [Appointments Query].PatientDOB FROM [Appointments Query]; When entering...

Hi Bryan, I deleted the combo box and then used the wizard again, but still came up with the same problem. After many hours of troubleshooting, I found that it was as simple as : Under Properties, Format, Change Column Count to the number of fields you want to show in the combo box! Thanks...

Hi Bryan, Thanks for your help. Your suggestion worked. I am having another problem with a combo box. I have put PatientFirstName as the control key. Then I want it to display the following from Appointments Query : PatientFirstName, PatientLastName, MedicareNo I have got the combo box to...

Hi Bryan, I am setting the control source as MedicarNo. I am also making combo boxes on the form and am getting the same error. On my combo box for Australian State form I have : SELECT [Australian States Table].State FROM [Australian States Table]; this combo box works, but in my new form...