Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: K3ith
  • Order by date
  1. K3ith

    Field verification

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

    Hyperlinks

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

    Opening a file automatically

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

    Opening a file automatically

    Great that worked perfectly GHolden much appreciated
  5. K3ith

    Opening a file automatically

    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 & " - " &...
  6. K3ith

    How to create a new output folder

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

    Filters and variables

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

    Getting some info to show

    Thanks, that solved my problem
  9. K3ith

    Getting some info to show

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

    Blank record

    Thanks, IsNull solved the problem. Much appreciated
  11. K3ith

    Blank record

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

    Automatically naming a folder with records

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

    Automatically naming a folder with records

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

    Tracking changes to Ms Access DB

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

    History Table

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

    Creating a history table

    Can anyone help please, What it is I am trying to record changes made to a tables data, I have two tables tbloriginal and tblHist. What I would like to be able to do is that every time a record is changed within tbloriginal the old record (before update) is written to the tblhist table. I...

Part and Inventory Search

Back
Top