Search results

Hi there, I have lost my records and thus my list of passwords = a bit of a disaster. Is there any way I can get around the password to reset them? When I click on the database file it goes straight to the password prompt box. Please can anyone help?

Hi, I have created a database and saved it to c:\Database\filename, using the full access 2007 version. I have made c:\Database a Trusted Centre. I then copied the database onto my thumb drive (I:\Database\filename) and made this a trusted cenre. I then added the Runtime version of...

I have field in a form called MedicareNo, based on a table (Appointments Table) where I have set the control source to a query. The entry is =[Appointments Medicare Query]![Patient Details Table.MedicareNo] When this returned a #Name? error, I changed the control source to MedicareNo and put the...

:confused:How do I put a password onto a database?

Hi, Does anyone know how to write a macro that saves a database to c:\My Documents\filename on exit.

I have a large text box field in a form where I want to be able to put paragraphs, however, as soon as I press enter, it moves to the next tab index. How can I put paragraphs in a text box field:banghead:

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:

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

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...

I am having problems with form design in access2007. My control source is "Patients Detail Form" My control is MedicareNo. In design view I create a form using Form Design, I add in a text box and under Properties, Control Source, I add the following =[Patient Details Table]![MedicareNo]...

Please please help! I keep getting a #name? error when trying to enter details on a form. What causes the error.

Hi, I can't set a leading 0 in my telephone area code. Access automatically resets the area code to a single digit (eg 08 is reset to 8). Can anyone give me a hand?

I'm a Access database designer, not new to it but still learning.