Search results for query: *

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

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!

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

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

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

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

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

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?

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