Recent content by ttbeverley

Thanks for your help, havent had a chance to look in to it just yet, so will let you know when its tested, hopefully with good news. Thanks for the link as well. Tristan

Gday Guys, I have an issue, well i have lots, but only the one im dealing with right now. I have an access database that i have made with a form containing buttons, i would like these buttons to be able to link to other databases (external) using VB code, what i used to use was: Private...

Ok so i finally figured it all, thanks very much to Tuxalot for pointing me in the right direction. For anyone else looking to do this, the easiest way is to follow directions on address http://office.microsoft.com/en-us/access/HA102061091033.aspx This has step by step instructions of...

Gday Tuxlaot..... Union queries look like exactly what i want, but i have a beginners question for you..... The union query part is fine, i think i can figure out how to use that, but i am using queries already in this report, so when i go to the query for that report, and then go to SQL...

Gday guys, Had a very successful morning with the help of Mike375's expert help with queries, now i have a new problem. I have 2 tables, with a time field in both, what i would like to do is combine both of these tables into a report that is sorted by the shared field. If i was to use 2...

AHHH..... thats what i did wrong.... i put it in as a criteria..... Thanks heaps for that, will give it a shot and see what happens.

Ok Mike375, i have tried your suggestion and unfortunately i have not had any luck. When i add the string Mid([abc],InStr([abc],"IP"),18) to the query based on the MsgContext1 box, there was and abc box that appeared, so i changed that to the name of the cell for both abc's and it did not do...

Thanks very much Mike375. You have been a huge help. This should get me going for the time being......

That was really quick, either im clueless, or your a genius..... leaning towards the later..... Where do i put this to make it run? since i need it to run every time the table updates (note the field is located on a linked table called MSGSOURCE) Having just the IP Address will enable me to link...

Gday Guys. I have a cell in one table of mine called MsgContext1, this cell contains the content of an SMS sent by an external program that i have no control over, the cell contains: devicename(location, IP:xxx.xxx.xxx.xxx):ALARM MESSAGE(channel: xx,xx,xx,xx); I would like to know how to...

Gday Again. This Forum is AWESOME! I have got so much useful information from the people on this site. I have another question that i am having trouble findiing an answer on. I have created a report, but at the minute it is 4500 items long, each item being output to a single A4 page...

Sorry Ned Kelly, yep... didnt explain well at all. Basically the form created and posted by Thanos was exactly what i wanted, but i couldnt figure out how to make it work FOR me..... After a few hours sitting there staring at it, i got a friend in to bounce ideas off of, and i figured it...

Hello Again. I have a database that i have created a report in, the data is exported to the report perfectly thanks to Boblarson. Now i have another question. I would like to restrict this Report to a date range based on a user entered range. This will need to be very simple with user...

Thanks BobLarson. after reading the discription this sounds just like what im after. Will give this tutorial a shot and see what happens. Thanks for the quick response. TT

Gday peoples. I am currently trying to use Access to do some reporting on a database that i have no control over. There are 2 database involved, one contains all my specific details, the other is created by a third party application that lists alarms based on a system. These alarms are...