Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by NewfieGolfer

  1. NewfieGolfer

    Excel Text Color Filter

    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
  2. NewfieGolfer

    Excel Text Color Filter

    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...
  3. NewfieGolfer

    Multiple Lines in a Message Box

    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...
  4. NewfieGolfer

    Using Shell Function on Network File

    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...
  5. NewfieGolfer

    Export to specific Excel worksheet

    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...
  6. NewfieGolfer

    Copying Modules

    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...
  7. NewfieGolfer

    Export to specific Excel worksheet

    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...
  8. NewfieGolfer

    Why is Access 97 so Dumb on Debugging?!!!

    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
  9. NewfieGolfer

    Copying Modules

    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...
  10. NewfieGolfer

    Copying Modules

    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...
  11. NewfieGolfer

    Copying Modules

    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...
  12. NewfieGolfer

    Copying Modules

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

    Copying Modules

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

    Copying Modules

    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...
  15. NewfieGolfer

    Copying Modules

    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
See more

Part and Inventory Search

Back
Top