Search results for query: *

Never mind, I found the registry entry that controlled this; it wasn't related so much to Access as it was to the software package that created the .ADP front-end module. Found it in HKEY_CURRENT_USER\Software\[software name]\[software version]\options Thanks, anyway.

Hi, I have a client running an ADP front-end with a SQL Server 2000 back-end. At some point, they opened their Access project, logged on as a particular user, and selected the "Do not show this screen again" checkbox. How do I make their login screen re-appear?

Thanks, I'll give that a shot. I can make the focus go where I want it by tinkering with things, but doubling back through the code a second time concerns me. Somewhere down the line, it's going to cause problems.

The BeforeUpdate event doesn't fire until I try to close the form. Since it's a survey form, and they'll be filling it in while talking to the subject on the phone, I need to stop the operator before they proceed to the next field, rather than waiting until the form is completed, then having...

Hi, I have an app that I'm working on that enters a survey questionnaire. There are a number of fields that must be filled out if certain answers are given in previous fields. For example, if the answer "15" is selected in any of the three fields 151, 152, or 153, then field 15-2 must contain...

TonyWhite: Yeah, we found one that works, thanks. (Obviously been a while since I looked at this thread...) hoggbottom59: I know that Access runs VBA rather than VB. The scenario we were in was running a VB application using an Access database to store the data. The client didn't have...

In the process, I came across something else that works for me, at least so far: <IFRAME> I can retrieve the parameter from the URL, use it to build the filename to be included, then concatenate an HTML string and use document.write to write the HTML. <script language=&quot;VBScript&quot;>...

Thanks, I'll give that a shot and see what happens.

Is it possible to use variables to set an include page? For instance, if an alpha character passed through the URL is used to build a filename so that any one of several pages could be included in one basic header page, is there a way to use this variable in the include function? So far, I'm...

That's it! Thanks. I knew there had to be a way to do that, but could find *no* reference in my books. Basically, it's a simple little page that has a single 1-character parameter in the URL that I need to reference in order to include a page in the body.

Anybody know how to do this, or if it can be done?

I'm not sure where to find &quot;file and printer services,&quot; but they should be enabled, since the &quot;new&quot; machine actually came from another office, and had both local and network printers running there. The printer was shared already on the old machine, so step #2 checked out...

Have a really starange problem. I have 2 computers, both running windows 2000 Professional (just got the second.) I have the two networked and talking fine, but the new machine will NOT print to my DeskJet printer. I've tried it as a local printer on the LPT1 on the new machine, tried it as a...

Does anyone know an easy way to combine all the user profiles on a Win 2K Pro machine into one? Network went down a few days ago, when the connection was restored, I ended up with the same userid, but for some reason, a different user profile. I would like to tell this thing to use the same...

I thought about that, but this is a fairly extensive database (not mine, by the way, my client's in-house guy put it together.) There are probably twenty or thirty tables and sixty forms, so I don't know how much trouble they'll be willing to go to. Thanks for the input.

Scenario: In Access 2000, using edited record locking, one user has a record locked and wanders off while another user tries to edit the same record. Second user gets the locked record symbol. Is there an easy way to show the second user who is locking the record, like when two users try to...

Yes, I got it figured out - you're right, the prefix was the problem, and since I was opening a separate instance of the database, I had to use the prefix for the database type as well. I didn't realize that I needed this, and I didn't find it anywhere in the Access help text. I ended up...

Thanks. That seemed to solve that problem - but now I get a &quot;type mismatch&quot; when I try to use the OpenRecordset method, even though I've added a reference to the DAO 3.6 Object Library. Whatever happened to backwards compatibility???

Just installed Office 2000 Premium, full version, and converted a small, simple database from Access 97. I have a macro which runs a code module to import some ASCII text files into Access tables. I get some kind of error (doesn't give me ANY message) which opens the code debugger window. If I...

Speaking of compacting an Access database from within VB, does Access have to be loaded on the machine doing the compacting, or is there a way around this? I know that some of the Access-specific commands don't work in VB without Access being loaded, but so many apps use Access databases, looks...