Recent content by Snufflz

Hi David, I'm aware that Access doesn't like colons very much but they make my lists look neat! I've never had a problem so long as I put square brackets around the names. I've got lots of code in the database and it's quite happy so far. Regards. Elaine.

Hi there, I am trying to create a password login screen for my database. I have found code to do this on the internet but I cannot get it to work. Please bear in mind that I am not a code expert! The version I found online is: If Me.txtPassword.Value = DLookup("strEmpPassword"...

Hey, that's perfect! Thank you so much. x

Hi everyone, I am trying to make things a little easier for my users on a data input form. I would like a command button to enter a value of '1' into a particular field when pressed, and another to enter a value of '0.5' into a different field. The input form is called 'F:holidays_input'...

You do not surprise me. I did not have a clue how to go about it so I took my best shot and got it completely wrong. Thank you for your reply. I've changed the code but nothing happens, which is better than the errors I was getting before! Should the macros be an individual file each or...

Hello, I would really appreciate some help with coding problem. As you can see I am not very well up on it! I have a combo box on a form returning three values - Engineer, Medical, Both. I also have three matching macros which will print a particular letter (form) for the relevant client...

Oh, that's brilliant, thank you. Now I just have to add thirty or so fields from the all_records table. Will I need to put any new information into that code? Set rst = db.OpenRecordset("T:all_records") rst.AddNew rst("Client name").Value = Me.Passenger_name.Value rst("Client...

Trevor, you are brilliant. Thank you so much for your help. I also appreciate your comments about the database. I love using Access and when I come across something I don't know how to do I usually get busy with Google but this time I haven't found anyone with the same problem. Like a...

Sorry about that. I've stopped the switchboard starting on load and I've made the data local as well. Many thanks.

I've sorted that and they are now just c:\. I've also changed the name of the add field to 'New record'. Because the information about the accident applies to the passenger once he is made into a client, I have to copy the relevant information into the new record. I know it seems wrong to...

Stupidly, I never thought of zipping it. There are two databases - Accident data (tables) and Accident admin (the workings). The main tables in this instance are T:all_records and T:passengers. The append query is Q:append. If you go into F:fault and go to the Passenger/Injury tab, you...

Many thanks for that. I knew about Yes/No fields, I just didn't get how you meant to attach it to the query. Unfortunately it did not work and when I run the query it says that 0 records will be exported. Typically also the database is too big to be uploaded here. Even stripping the data out...

Thank you for your help. I'm afraid that I don't have a clue how to set the query to look at a tick box though. A hint would be very much appreciated.

I am using an append query to make a new record in my database. The database is to list clients who have been involved in car accidents. At the moment the vehicle owner is entered into the database (table:all_records) and the passengers in the vehicle are entered into a separate table...

Sorry to be a pain but I've created an append query to take information from both tables and that works OK. The problem is that the button on the passenger subform wants to append all the passengers and not each individual one. Not every passenger will become a client and the users need to...