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 derfloh 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: *

  1. iain2003

    Gain a Forecast through selected variables

    Hi All, Unsure if anyone will be able to help with this but I will give it a go anyway: I am looking to build an Access user application that will allow data to be entered in specific fields and then churn out a daily planning forecast of response activity. Eg. Volume of activity entered...
  2. iain2003

    OPEN DBASE AND ACTIVATE TIMER EVENT

    Does anyone have any code that would help me open a dbase automatically on any pc at a specific time and then fire a macro to run an update process? Any help would be greatly appreciated!
  3. iain2003

    ACCESS TO EXCEL

    Thanks Guys, Dyarwood, your code works fine but I still cannot select the actual sheet I want the user to view. Cheers
  4. iain2003

    ACCESS TO EXCEL

    Hi, I am trying currently in vain to get an Access database to simply open an Excel spreadsheet located on a network and select a specific sheet. This needs to be achieved through the click of a comand button on a user form. I have searched through all threads with keywords "Access&quot...
  5. iain2003

    bold Access Problem, Splitting a Name Field

    Unsure if there is a solution to this but I am out of other options! I once had some inherited code that allowed me to split a name field into title first name and surname regardless of the text string length, I recall that this was a relatively simpe piece of code but I cannot seem to replicate...
  6. iain2003

    Splitting A Name Field Into Single Fields

    Hi, I used to have an inherited piece of code that would allow me to strip the salutation, first name and surname from a single name field regardless of the differing total characters. I have unfortunately lost this code and would very much like to split some records for a mail merge, any help...
  7. iain2003

    Code For Selecting Part Of A Field

    Thanks Birklea, Worked a treat! The constants for a name split function would always be the space between each part of the name, eg, Mr Joe Bloggs. I considered using a select case for any variables in the name itself, eg Mr, Mrs, Dr, Miss etc. in the first name case I would like either a full...
  8. iain2003

    Code For Selecting Part Of A Field

    I am searching for some code that will allow me to strip a single name field into title initial surname fields and also code that will allow me to extract domain information from email addresses, e.g taking ntlworld.com from iain@ntlworld.com. any ideas?
  9. iain2003

    Output Access 2000 to Excel with Automation

    I am desperately searching for a solution to output a set of query results into an existing spreadsheet that has already been formatted whenever I use the getobject function, my results are exported but the spreadsheet does not display the new results only existing results. Any ideas would be...

Part and Inventory Search

Back
Top