Recent content by bretto

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:)