Search results

Hi, A client of mine is using Access 2002. I haven't used Access 2002 until now. I am having a problem that I have never had before. I am trying write a make-table query that links tables containing autonumber fields. Running it in datasheet mode is not a problem. When I try to run it as a...

Hi, Once the new records are appended, run a delete query on the laptop table where you join the records of the laptop table to the database table and delete from laptop table the records that are in both tables. If this doesn't work then you will have to use a cursor or code. Do a DLookup on...

Create a limited front end for the laptops. It should only contain a preliminary customer table and a link to the customer table in the back end. When they are off line, they can add customers to the preliminary table. When they get on the network, they can run an append query to attach the...

Hi, I read the "solution" and immediately thought that the real problem is putting the right data into the "rank" field. I have solved that problem and it does not require a cursor or a table ( unless, of course, you want one just because you want one ). Here is what is needed to rank states...

I'm doing the same as Autoeng except that the shortcuts on the users desktop access the frontend thru a security file that is on the server. The front end file is also on the server. The reason is that in this arrangement everyone absolutely uses the same front end. The second is that...

Thanks ghudson! It turns out that Access 2002 will load an Access 2000 app in 2000 format. Because Access 2002 adds info to the file when it is converted to an MDE and because this would confuse Access 2000, MS disables the ability to convert to an MDE whenever an Access 2000 file format is...

Hi Rich, I don't understand. I'm a little surprised by your question. When an Access application is run as an MDB, it has to compile the code as it goes along. Because the MDE is the compiled version of the MDB, this is not necessary and therefore the application runs faster. This is...

Hi, A client of mine has an Access application that is an MDB. I tried to convert it to an MDE to improve performance but found that the "Make MDE" menu selection was disabled. How is that done and how can I reverse it so that I am able to make an MDE with that application? Any Ideas...

Thanks Rich, I got it set up. My problem was that I needed to log on as the server administrator. I also had to just type in that the mdw path was to be \\server\drive\folder\name.mdw rather than pressing the network button; the network button would only set up a mapped folder as the location...

Hi again, Now that I know that I don't need Access 97 on the server to use Jet security on the network, I need a little help on how to proceed. We have both the frontend and the backend on the server. The users will have a shortcut on their desktops to the frontend. How do I install Jet...

Thanks Rich.

Hi, I am implementing an Access 97 app over a Win NT 4 server driven network. In order to implement security on the network for this app, do I need to install Access 97 on the network server? Thanks, Mike

Jim, Thanks for your help. I have a Kit table and a KitDetails table with a lookup to a Materials table. These materials may or may not be in any given Kit. The fields in the KitDetails table are KitID and MaterialsID. These fields combine to make a key to ensure uniqueness. I was able to...

Thanks Jim, I don't know why I didn't try "Before Update". Also I'm not very familiar with the form's Cancel property. I find no reference to it in the index of the Litwin et al book. Anyway I got it to work thanks to you. However, I would like to take this to the next plain. How do I...

Hi, I have a few forms where combo box lookups are used to enter values from another table to the form's table. The combo box also represents a part of a multi-field key. If users don't pay close attention, it is possible to select the same item from the lookup list twice. Any attempts to...

Hi, Using code in Access 97, how do you make sure that all the data in a textbox is highlighted after the textbox receives the focus? The idea is that the user will be able to change what's in the textbox merely by typing. No need to use the mouse. Thanks.

Hi, I need to allow users to change their minds after they had changed the data in a field by pressing a cancel button that closes a form without updating or adding a record. Set the cancel property of a command button isn't enough. I have five very popular books on Access and, surprisingly...

Thanks Rich. The "me.undo" worked.

Hi, I have a form where I have Me.AllowAdditions is set to False at load time. The form also has a button that changes Me.AllowAdditions to True to allow users to add records; the button then becomes a "Disable Record Additions" button earmarked for when the user has added all the records...

Thanks Travis. Your advice worked very well.