Recent content by macsta

thanks I will try that :)

hiya all I am having another problem only this time it is with SQL in a VBA call I hope someone can help 'MYCODE: Private Sub form_load() Dim unitSQl As String, groupSQL As String, deptSQL As String ''''''''''''''''''Unit''''''''''''''''''''' unitSQl = "SELECT tb_Main.Unit...

tried that and got runtime error : 3077 syntex error

I am trying to copy email data from one table (exchange import) to my main table for each record I am using a system I set up for puting page numbers from the report into a table however for some reason I get the following error: The Microsoft Jet database engine does not recognize <name> as a...

crap me being a idiot!!! my apologies I posted the above thread in the wrong page ( Not to bright sometimes head is full of crap) I wanted to post it in the search box thread Mac

Only Got 97 I know its a lot to ask Mile-O-Phile as I have seen you are super busy but could you convert your example of the search database into 97 so that I can incoperate it into my Staff list database thanks in advance MAC ps. looking at this forum for about 3 hours now and I think...

count I have been looking for an easy way to do that for months you are a Star Mac

as above thanks for the speedy help the site was a great help and had a lot of other stuff too thanks again Mac

This is my first post to this forum but after reading some posts I think you are a brainy lot hehe what I am in need of knowing is are there anymore variables within the "advapi32" LIB? I am using "GetUserNameA" to get the Login Name. but what I need to do is be able to detect what user acces...