Recent content by kirsty

Hi everyone! PleaSe help if you can! I have a database which seemd to have been working fine for months and today I have noticed that when I enter text into the Forename control on my form and close the form, if I open it again several times, the name is still there, however, eventually, after a...

I am trying to add more controls on to my form and an error message comes up saying that I can't add any more! Does anyone know a way round this? Thanks, Kirsty.

Hi, can anyone tell me the simplest way to send the current record only to a report. Thanks a lot, K.

Hi, can anyone tell me the simplest way to send the current record only to a report. Thanks a lot, K.

Just a simple question for someone who knows!! My toolbox is disabled. Any ideas on how to enable this? Thanks, K.

Thanks a lot, this now works!!

I have tried using the vb code as specified by Travis (thanks for your reply!), however, it still doesn't work! It is now saying file not found and I have checked and re-checked it to make sure it is correct. Anymore suggestions? Thanks a lot, Kirsty.

Hello again! I am trying to open another database from a database on the on click event. I have tried the following vb:- Private Sub Command8_Click() Dim RetVal 'Run new database RetVal = Shell("S:\FINANCE\RISK\DATABASE\AVIATION.mdb", 1) End Sub However, this returns the runtime error 5...

Hi, does anyone know how to create a simple timer event that displays a start up form for say 5 seconds and then opens another form? Thanks a lot! Kirsty.

Hi, does anyone know how to create a simple timer event that displays a start up form for say 5 seconds and then opens another form? Thanks a lot! Kirsty.

Hi, I have written some code to ensure that data entry of a field is mandatory and if the user tries to close the form a message box displays to warn the user that this info, is missing, however, the form still closes. Does anyone know how to actually stop the form closing until this info. is...

Hi, If a put a validation rule on a control so that only one specific word can be entered into the text box, if I want the text to be automatically deleted before the user tries to type in the text box, does anyone know what code I can use to do this? Thanks, Kirsty.

Hi, I am stuck on what seems to be a fairly simple procedure! I have written the following code:- Private Sub pass_AfterUpdate() 'Validate data input - if correct password is entered then open 'Claim form' and if wrong password is entered add a msg box to tell user this password is wrong...

Hi, I am a bit stuck!! I am trying to write some code in access 97 which uses the on click event procedure of a command button to open a word document. When the user has finished with the word document I do would like it to be saved as one of the fields on my current record which changes...

Hi, I have created a command button on a form which when clicked, opens a word document and inserts relevant text from the current record into bookmarks in the word document. I am trying to write some code which ensures that the word document is saved as one of the field names on my record...