Search results

Hi Rich, Nothing in particular really, just trying to figure out what I can use whne I create forms for the user. I just can't believe there is no way to register all of the Active X components listed under More Controls without installing Visual Basic. Thanks! Big Jim

Thanks Alexandre, but my problem revolves around licensing. I would like a good 40 people or so to be able to use the Active X object in multiple locations across the country, but I cannot install VB on all of their computers. Maybe Active X objects just weren't meant to be for me. Big Jim

Thanks Pat, Your explanation makes sense. I wish there was a way to install the controls without having VB6. Some sort of patch code perhaps. Thanks again for the explanation. I appreciate it! Big Jim

I took a look, but there is nothing there that will help me. It is disturbing that there are so many controls available in Access97, but none of them work without VB being installed. Thanks again! Big Jim

Hi Pat, I made the techies come up and re-install Access 97 in front of me. We made sure that all checkboxes and sub-categories were properly checked off. Still, I could not get most of the "More Controls" to function properly, including the Calendar Control and the Progress Bar. I will take a...

Hi, Big Jim here: On any computer with VB6 on it, my active x controls (such as the calendar) work fine. Without VB6, they do not. I have tried registering the ocx, but nothing seems to work. I was wondering if there was a file that I could download that would allow me to register all of the...

Doc! Big Jim sends his many thanks. I wonder if this command is related to the Echo On/Off statement from the days of DOS. However, Big Jim's boss is looking for a way to do this without having to put ECHO in between every step. Any further thoughts? Thanks again Big Jim

In case anyone was interested, I solved this problem by adding some pauses in the code. I guess something in the background was not getting completed before my code moved on to the next line. Hope this helps someone out! Big Jim

Hi, Big Jim here: I have a macro with 200 queries in it. Some of these queries take close to an hour to run. Big Jim's boss wants to know if there is anyway to determine what query the macro is on. The Query status bar in the bottom left-hand corner doesn't provide much info. Is there...

Hi, Big Jim here! I am attemptint to run a query below in code. I kept getting an error that Access could not find the table. So...I ran through the tabledefs to make sure that Access could see it. Access could see the table, but when I attempted to run my SQL after it found the table, it said...

jat! Big Jim and his colleagues figured it out. It seems that the database had an AutoExec Macro on startup (I have never heard of those before, but it seems to be a Macro that is set to run automatically on startup). This autoexec macro somehow prohibited some of the other code from working...

Hi, Big Jim here: I am receiving the 3011 error (could not find table error) when I attempt to run this code: Docmd.Rename [New Table Name], acTable, [Old Table Name] However, in break mode, if I step through it, it works. Why would this not work in regular run-time, but it will work in break...

Thanks llkhoutx! It worked like a charm! Big Jim can move on now. Thanks again! Big Jim

Perhaps I can rephrase this: I have this application which goes into a server and compacts all 800 or so Access Databases (not all in one night of course). The problem is that when searching through the databases, when I come to one with a password on it, the program terminates as it cannot...

Hi, Big Jim here: I was wondering if there was a way from code to determine if any given database file has a password on it. Thanks in advance, Big Jim

Jack, Big Jim sends his many thanks! Big Jim

Hey, Big Jim here: I have two columns in a table. It looks like this COLUMN A COLUMN B 20020215 20020312 20020421 Both A and B are text fields. When I attempt to use the MID, LEFT, and RIGHT Functions to UPDATE COLUMN B to show the date as "02/15/02", I get a Type Conversion Failure...

Shep, You have been a great help! Big Jim was glad to hear from you. Thanks again! Big Jim

Hey, Big Jim here: I have read some other messages about this error, but none seem to help me. I am simply trying to click on a check box and have the on click method send set the focus to a text box, change what is in the text box, and then return the focus to the check box. But I get this...

Hey, Big Jim here: I need a nice easy way to open another mdb file. Catch is, I don't necessarily know where Access is on the computer, and it may be on a server. Is there no way to set this process up so that it is the equivalent of clicking on an mdb file in Explorer (Which then opens up...