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!

Search results for query: *

  1. Ahliana

    Nz - When did this appear?

    We do have an icon for the user to use that sets several options, including which Access they are using. I'm wondering why the Nz might now be an issue, and how the order of the references could get reset. We have added 2 references, but they should be added at the end, and we have only had 3...
  2. Ahliana

    Nz - When did this appear?

    We have an app in the field that uses the Nz() function. Some users are now getting an error using that function. The order of the references somehow gets reset, with OLE Automation now at the bottom, which then causes Nz() to throw an error. There is discussion that this may be because they...
  3. Ahliana

    DoCmd.TransferDatabase corrupts on receiving end?

    We have an app in Access 2000, and we email an update database. The application pulls in parts that it needs, it has done this for quite some time. Then, because we need to replace a module with global variables, we shut down the app, start up the update mdb, and push objects using...
  4. Ahliana

    Can't access or update data from the database

    It looks like you need quotes surrounding your text1.text. Try something like: sql = sql & " where [Serial_Number]=""" & Text1.Text & """" Two quotes is the escape sequence for a quote. You might also be able to use single quote marks. Or, you can use Chr(34), as in: sql = sql & " where...
  5. Ahliana

    Character to write multiple lines on one line?

    Hey, a simple question! I can't find or remember the character to allow you to put more than one command on a single line of code. It doesn't seem to be a semicolon or a colon. I last did this many years ago, but it would be helpful at the moment. Example (pretending the character is a colon)...
  6. Ahliana

    Bypass Autoexec programmatically?

    Thanks very much for your suggestions. I may suggest that to the team lead, although for now I have managed to solve what I needed. You do have a point, though. I appreciate your advice. Ahliana Argue for your limitations and, sure enough, they're yours! - Richard Bach
  7. Ahliana

    Bypass Autoexec programmatically?

    Thanks very much, I appreciate your time and suggestions. I am one of a team working on this app, which has been in production for some time. They would not give up the autoexec, even for something as important as this added functionality. The AutoExecStart function drives a large number of...
  8. Ahliana

    Bypass Autoexec programmatically?

    My overall goal is to programmatically import objects (modules and a form) that are called from the autoexec function (that is called from the autoexec macro). Unfortunately, since they are called from the autoexec function, then once these are loaded into memory, you can't bring in new copies...
  9. Ahliana

    Dynamic form, keep col and row headings still, scroll crosstab data?

    Access 2k, WinXP. Due to the fact that we are deploying this worldwide, including very remote sites with SLOW dial-up connections, I am not able to use extra controls, which is why I am so limited in this. So here's a challenge... I am dynamically creating a form that represents crosstab data...
  10. Ahliana

    Access 2002 Pivot Table

    I have just started exploring this (and I thought I knew Access). When I open a pivot table view of a form, I then open up the field list (sounds like perhaps you need to enlarge that window?), then I can drag fields to be column headers, row headers, and data. Look for thin areas where you...
  11. Ahliana

    Have VB open Access db with pw, import objects from another

    Parts of the puzzle that I tend to forget about when I focus on a specific aspect: Access security is in place, with a Security.mdw. I didn't write this part, and although I've read a bit about Access security, I'm no expert there. There is a UserID being used. Access automatically brings it...
  12. Ahliana

    Have VB open Access db with pw, import objects from another

    Hmmm, I'm still having problems. It still asks me for a password. However, parts of the puzzle that I tend to forget about when I focus on a specific aspect: Access security is in place, with a Security.mdw. I didn't write this part, and although I've read a bit about Access security, I'm no...
  13. Ahliana

    Have VB open Access db with pw, import objects from another

    I am trying to have a vb app open one access database, read a table that is a list of modules and forms in another database, then import those objects from a second access database. Even though the objects already exist in the first db, I want to import them, rename the originals, rename the new...
  14. Ahliana

    Have VB open Access db with pw, import objects from another

    I am trying to have a vb app open one access database, read a table that is a list of modules and forms in another database, then import those objects from a second access database. Even though the objects already exist in the first db, I want to import them, rename the originals, rename the new...
  15. Ahliana

    Opening a access file from vb6

    I have vb6 code for opening a shelling to a database, including finding it by the shortcut and opening it with any extra bits there, and adding a password if necessary. But this code is designed to shell out, not give you an object with which to work programmatically. If this code would be of...
  16. Ahliana

    RDO - use to manipulate Access objects?

    Ok, maybe I missed the big concept here. I was thinking RDO could manipulate access objects. RDO is JUST for datasets, isn't it? I do enough Access and VB and other things that they ran together in my brain this morning. Ergh, I think I'll slink away now while I'm behind. Yes, of course I need...
  17. Ahliana

    RDO - use to manipulate Access objects?

    Thank you very much for your time and consideration. What's happening is that we have deployed an Access application, and we send out updates that must be processed BY the application. Well...it can't update objects (modules, code behine forms) of something that is loaded into memory, it will...
  18. Ahliana

    RDO - use to manipulate Access objects?

    I need to have a VB executable copy several modules and a form from one mdb to another. I need to replace existing objects (or copy them in, delete the old ones, and rename the new ones). I'm thinking I should use RDO at this time, since I believe it's MS's current ODBC wrapper of choice. I'm...
  19. Ahliana

    Appending Tables in Access

    You need straight brackets [] around any identifiers with spaces, such as the table name MASTER EDI FEED DATA. I generally recommend against spaces or special characters in identifiers (names of things). I suggest underscores instead. Hope it helps. :) Ahliana Argue for your limitations and...
  20. Ahliana

    Appending Tables in Access

    There are two ways you could go about this. You'd have to test to see which was faster, or which was easier for you to maintain. First, you could set up a function to create a recordset based on "SELECT Name FROM MSysObjects WHERE Type = 6 and Name LIKE "*_txt". Walk the recordset and...

Part and Inventory Search

Back
Top