Recent content by Ahliana

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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