Search results

I'm not quite sure what are trying to do but the way i deal with chinese character/xp/access issues is simply to do what i'm trying to do a different way!! I'm sorry that's not very helpfull but i've banged my head against the wall loads of times with this.

That makes sense, thank you :)

Hello, I'm doing some error trapping at the moment and i was wandering if there was a way to determine the current module/module type/proceedure name etc at runtime. Cheers Ben

I did something similar to this a while ago and I think if memory serves me correctly it would have worked something like; -db opens and creates a 0 byte file with pre defined name -when the renaming event occurs control passes to a vb script or similar -the script recursively checks if the...

Point well made, i'll go and stand in the corner for half an hour ;)

Appologies for clouding the issue :o maybe it's still too early in the morning ;) Going back to the " thing, while the original does work; rec.FindFirst "[acct_num] ='" & strName & "'" also works unless i'm losing it which is highly likely :rolleyes:

Try replacing; rec.FindFirst "[acct_num] = """ & acct_str & """" with rec.FindFirst "[acct_num] ='" & acct_str & "'" When qualifying (is that the correct expression???) text within a string you need to use single quote ' instead of double quote "

Do you know how to retrieve records using ADO or DAO? If not do a search on here as I expect there will be numerous examples. When you’ve got your head round that, create a function that returns a string (in this case the bcc list) and use ADO or DAO to build said string from your table. Then...

Sub out_example() 'outlook stuff########## Dim myoutlook As Outlook.Application Dim mymsg 'message contents####### Dim myto As String Dim mysubj As String Dim mybody As String Dim mybcc As String 'create outlook Set myoutlook = CreateObject("Outlook.Application") Set mymsg =...

Sorry that reply was totally off the top of my head :o , i would use the second idea, a lot tidier and easier to do ;)

Use a unique id for each message and place this in the subject field, then at your chosen time of checking, check the sent items folder in outlook for this unique id. I havent got time to do an example :( but do a search on here for automating outlook and i'm sure your'll find something...

Either, on unsecured db's where everyone is admin you have to use network id so it depends on your situation. Using access users is easier syntax ("currentuser()") because to get the network login you need to make api calls, this may sound a bit daunting but there are loads of examples of this...

If it's one user i would check the username (there are loads of examples of how to do this on the net) and then execute which ever path based on this information. if username = myfunnyuser then shell(c:\blah.exe) else shell(m:\blah.exe) end if Not great or ideal but fairly simple!!

You could use something like the add in found here; http://precisioncalc.com/ It's designed for excel but works fine in access via vba (results are returned as strings) and gives you massive precision. They do a free one which has a popup and various paid for versions which have varying levels...

Ah Ha!!! Cursor location Cheers for that Travis, works a treat:)

Hi, I vaguely remember reading somewhere that you can use ADO to create a "connectionless recordset" in code. I have come across several situations recently where this would be handy but have been unable to get it to work with trial an error or found an example. What I’m basically after is an...

Hi, I've been trying to coax a bit of speed out of some of our applications. At present I do most (95%) of queries like this; mycon.execute(mysql) where mycon is an ADODB connection object and mysql is a sql query stored as a string variable. I do it this way because I find it convenient and...

This i what i want to do and how we usually work, unfortunatly we are rather pushed at the moment and i'm trying to justify the time it would take to do this! Does anyone know why this type of corruption occurs?

Hi, We have inheritted a self contained (i.e all data/forms etc are in the same file) mdb based application that is shared by 5-10 users and accessed quite heavily accross the network. Twice recently it has become corrupt and we have had to import all objects to a new mdb in order to fix it. So...

True you cant manipulate data on a web server directly with access but you could get an ftp object library and use this to download the text file and then connect to it locally. Not great i know but just an idea!!!