Search results for query: *

The above Function works great, but it doesn't refresh if I change the color of the text in the cell. Is there a refresh command I can put in this function? Thanks, NG

Hi, I was wondering if there is a way to filter a row by the color of the text contained in each cell. I think if there was a way to determine what the cell text color is using a formula then it would be no problem, just use the criteria in the advanced filter. But, is there a way to find out...

Hi, I was wondering if it's possible to display multiple lines in a message box.. I need the message box to display information that is inputted on a form. Once the user is finished entering information in the form, they click a button. Then the message box with the information the user...

Hello, I'm trying to run a batch file located on a network drive using the shell function in Access 2000. I get the commmand prompt window to appear but in the window it says: "Your Data Access Path - C:\Docume~\User\MyDocu~ - is Invalid Press any key..." Is this error occuring...

Sorry about taking so long to respond, i'm working on an important project right now. I checked out the code above it works with exporting tables to spreadsheets. I also tried it with queries and got the same results as you did. I'm not sure why this happens. A quick fix would be to append...

I finally got it to work!!!! Here's what i did, this code is run from my main database: file2 = "c:\FormsDB.mdb" modulefile = "c:\modules.mdb" Set AppAccess = New Access.Application AppAccess.OpenCurrentDatabase file2 AppAccess.DoCmd.TransferDatabase acImport...

You can use the TransferSpreadsheet method to export to the specific excel file. In the range for the export, you can specify a worksheet by using the name of the worksheet and an exclamation mark. example. DoCmd.TransferSpreadsheet acExport, 8, _ "Table&quot...

Maybe one way to alleviate this problem is before you close the code, stop the debugging process by hitting the stop button. Then try saving your code, close it, then open it again to see if the changes saved. Hope this helps, NG

I went back and read my thread and it was a very ambiguous statement and i'm sorry for that. What i meant to say is that i need to make a reference without using VBA. So i need it in the event procedures as an expression or macro or something, but not VBA. Sorry again. So, as an expression i...

That's what i need help with. I need to make that reference but i can't do it with VBA since when you copy anything with code, it messes up the database u copy to, unless you open the database, compile the code, etc (excellent perk of A2k). The reference to DB3 must be created when the db2 is...

If I do the above I'll get an error that the procedure can't be found. It's because the module with the procedure is in another database. Here's what i gotta do (The database with the modules will be on the network, we'll call it Module DB) 1) Open Database 2) Click a button. 3) Make...

Ok, but how do I reference the database with the modules without using VBA? NG

Quick question. How do you call procedures in another database? Here's the catch, how do you do this NOT using VBA? NG

Jay, I'm aware of this problem. And, i knew how to fix the problem if i was to manually open the database, goto debug, compile, etc. But, my problem is that i need to do this procedure via Visual Basic Code from another database. Just a note, it's interesting that they fixed this problem with...

One thing I forgot to mention, the 3rd database will be creating many different front ends, and back ends. So the procedure calls would have to be set up in the front ends when they are created by the 3rd database. Thanks NG

My last resort would be to put the 3rd database on the network. I'm afraid that someone who shouldn't access this database will cause more problems if they happen to fall upon it while browsing the network files. I guess I could set up limited user access to this 3rd database. I'll give this...

What about the database, once created, is copied to a completely different computer? I know, all i have to do is copy and paste the file, as is, to the other computer and not create a completely different database, but i'm creating two databases from a third database. One database has the...

Hi, I'm trying to copy modules from one database to another database. The problem i'm having is that i'm getting that nasty "Error accessing file" message when i try and open the modules after copying them. I'm doing the copying using VBA (I need to copy using VBA). I know that in...

Hi, I'm having problems with my forms after I copy them to another database. When I try to open the copied form I get a nasty error "Network connection may be lost". I was wondering if the event procedures in forms are copied when you perform the CopyObject function or the...

ROOKIEDEV, maybe you could use the following for the criteria in the query design. iif(isnull([fieldname]), 0,[fieldname]) fieldname is the name of the specific field criteria you are placing this code into. Hope this helps, NG ps. i'm not too familiar with Cross Tab Queries, this works...