Recent content by SirDrums

Strange problem. I have a link table in my DB that seemed to be working fine. I referenced the table in a query and the query worked fine. I close and reopen access and run the query and I get a message that access can't fine the link table. Then when try to open the table directly it...

The macro just runs a create table query. Very simple and runs fine when it actually runs. I do not know of another way to get this macro to run when a another program opens a connection to the mdb. The reason it need to run is so it can refresh the table (delete, recreate).

Is there a way to get the autoexec to run in this scenario? We have an app that opens a MDB programatically and I want to run a macro when it 'opens' the mdb. I have no control of the app itself so I am trying to find a way to run this macro.

I have created an autoexec macro that runs just fine when I open access directly. However, when the .mdb is accessed by another application (.ldb placed on file and the access program itself isnt run) the macro does not run. Is there a trick to this? How do I get the macro to run even if the...

Two plus computers are involved but they all create there own version of the mdb on theri C drives when the app is launched. THe app i would like to write would have to sit on everyones machine individually.

Hey guys, I was wonder if the following is possible: 1. Monitor a certain folder on C drive. 2. Look for a certain MDB to be created. 3. When the MDB is found create a link table in it. The reason i need this is because we use a application that creates a local mdb. In this local mdb i need...

When I launch one of my reports from a form, the preview displays in a very small window. THe report in the window is zoomed to 75% but the window it self is something like 1"x1" When I turn thr auto size property on the report to OFF the window is created larger (not perfect). When I open...

I think I will try adding a label that does not print. THough I do not know how to set the label so it will not print. Is there are hidden property? I didn't see one for labels that controls wether its printed or not.

Thats my problem. When I right click on the preview I do not get an option to print. actually I do not get a right click menu at all. I can go to the report directly and preview and I get a right click menu but when I open the report from a form the menu is disabled.

I am sure this is real simple but I am triping up on it. I have a report I open from a form in print preview but I cannot get the option to allow the user to go ahead and print the report when they are done reviewing it. I though you should be able to right click on the report and get the...

I figured it out and how this happened I do not know. THe table Piping was listed in the query design as Piping_1 just like I brought the table into the query twice. But the sql string said piping. When I forced the table to be called Piping instead of piping_1 and ran it, it freaked out and...

yup. i just use it. I didnt program it. It works though.

inner join returns the same mess that left join did. This is fustrating but I'll keep at it.

Sure SELECT PIPING.COMP_ID, RELATIONSHIPINSTANCE.RELATIONSHIPTYPE, RELATIONSHIPINSTANCE.ID1 FROM PIPING LEFT JOIN RELATIONSHPINSTANCE ON PIPING.COMP_ID = RELATIONSHIPINSTANCE.ID2 WHERE (((RELATIONSHIPINSTANCE.RELATIONSHIPTYPE)=3)); This returns what I expect, just a small list of items...

I checked SQL and it is a Left join SELECT PIPING.COMP_ID,[QUERY1].COMP_ID FROM PIPING LEFT JOIN [QUERY1] ON PIPING.COMP_ID = [QUERY1].COMP_ID The COMP_ID's in the table and query match and when I run this manually like stated above I get 1 record. When I run it through the sql above I...