Recent content by K3ith

Can someone advise please, I am after achieving the following: I have a field whereby a user enters a name of a file, but what I want is some verification on the field (just like the validation windows uses) to call up a message box if any of the following characters are entered in the field...

Can anyone inform me as to change the read only property of a hyperlink. When I create a new hyperlink through some code i keep getting this message, "The hyperlinkaddress or hyperlinksubaddress property is readonly for this hyperlink". I do not have the hyperlink open it is just...

If I wanted to open an Excel spreadsheet would i just change dim appword as new word.application to new excel.application. Any advise appreciated.

Great that worked perfectly GHolden much appreciated

Can anyone advise please, I have a word document defined in the variable newfile, this has the following assigned to it: "C:\misc\" & Me![Car_reg].Value & " - " & Me![user_id].Value & "\" & " Change Request " & Me![Car_reg].Value & " - " &...

Hope this helps, what it does it makes a directory and gives it a name obtained from a field within a form, so I gather in your case if you have a form with a text box displaying a customer by placing the code below behind a button it would create a directory and give it the name of the current...

Can anyone help I am coding a filter, but first a bit of background, what I have is a table of information such as Car_reg, Owner_id. When a user enters the database and wants to filter on all the car_reg relating to themselves, a filter is performed. What I have is some code that gets the...

Thanks, that solved my problem

Can someone help please, What I would like to achieve is for the result from the following code to be placed in a text box: MkDir "e:\car\" & Me![car_reg].Value & " - " & Me! _[car_make].Value The above code makes a directory, and I would like is for the directory path to...

Thanks, IsNull solved the problem. Much appreciated

Hello, Could someone help, the problem is as follows: I have a textbox within a form that is not allowed to be blank, the user must enter some info before they can save the record. I have validation on the field within the actual table, but what I want to achieve is when the user clicks on...

Thanks Robert this set me on the right path to a solution.

Hello, Could someone advise please, What I am attempting to achieve is the following: I have two separate fields, project_id and project_title. I click on a button within a form and this button will create a folder with the name made up from the two fields identified above, for example...

I have been trying to do the same thing for a number of days, look through some of the previous posts, that is what i am doing at them moment and if i make any progress i will let you know, if you could do the same and if you make any progress could you inform me. thanks

Hello, I am attempting to achieve very much the same thing, as yourself, if I make any progress I will let you know and if you could do the same this would be appreciated. Thanks Keith