Recent content by timo1999

Thank you very much, this works great!

I have two tables, one shows the every time a machine was worked on since the year 2000 to present (planned maintenance), and the other table shows every time a machine broke down since the year 2000 (Forced). I can link on the machine name because they are identical in both tables. I want...

Re: How to prevent truncation of memo field (field > 255 char) on export to text file You can also export the file as a "Paradox" file (latest version, probably 5.0). The file will be saved with the extension .db and there may be a second file saved with the same name and an extension of .mb...

I see, that does make sense even though I don't understand the code that well. It would be OK if the click was not working if I deleted that piece, however I just don't need for that form to open up at all. What I really want is for the "formCover" to be launched first instead of "frmStartUp"...

Would it be OK to remove the second part of the code in red? I think this will make it work but am not sure if it is important. _______________________________________________________________________ Option Compare Database 'Use database order for string comparisons Option Explicit...

There is no AutoExec, but I did find the first step using the other method you gave me. It turns out that the very first form that is set to launch is actually the form that I am trying to stop from popping up. I changed the start up to begin with the other form I want to see first, and that...

I just recently upgraded from Access 97 to 2007. Our department inherited and application program programmed in Access (user interface for extracting specific data) that was programmed by somebody else using lots of VBA code. There are only 2 things suprisingly that are not functioning...

OK, so I'm in the code, and I go to TOOLS;REFERENCES. The REFERENCES text is ghost text, and I can't click on it.:( I can click on the other choices such as "Active X" "add-ins" ect. I'm so close, yet so far...

Yes, FracToNum is defined as a common module as a public function. You can see the code in the jpg I attached titled, "define" If it is a reference problem, then I guess I am stuck, because I don't know VBA that well to check that. I will read the link you sent and hopefully try to gain a...

You were right, I do have an older module name with the same exact name. What I did was change the name of "ConvertFraction" to "FracToNum" in the VBA code (that I did not write), but now I'm getting a new error that says, "Compile Error: Sub or Function not defined. I do not know how to...

I am trying to write a cross tab query, with expressions that are saved as moduels in VBA form. Does this mean the expression is not recognized or possibly I have a syntax error? You can view the attachment to see what I have on the screen. Thank you for your help in advance.:rolleyes:

I think the suggestion of adding the "00####" to the first row was on the right track. I have had this problem before, and all I did was instead of changing the format for the column with the zip codes in Excel, I would type in a word like "bogus". As long as that record was in the first row...

I have a module named "ModFractions" that goes through 3 different calculation sub sections (PriceGrouper, FractionGrouper and ConvertFraction) that someone wrote for me. The code looks great, but I don't know how to make this VBA program to work in a cross-tab query. I am trying to add this...