Microsoft Access / VBA Forum

I have 2 tables, Orders and Order Details, the same as with the database Nortwindtraders shipped with Access. The table order is linked with the table Order Details through the filed OrderID. It is autonumber in the table orders and number in the table Order Details.I have a very good function deleting a chosen order from a list box called...

My client wants the Access 2000 database to be accessible only thru the vb application that I wrote. No user should be able to copy, delete, move, open it from any client machine, not even from the server in case he is away. So whats the best way to protect that file while letting the VB app to connect to it from client machines?? thx

Using the following SQL can the results be explained? Using A97 (with the SP2 for Jet 3.5) or A2002 CREATE TABLE Test (PK Number CONSTRAINT PK_TEST PRIMARY KEY, ParentID Number, Child Number); INSERT INTO Test VALUES(1,1,1); INSERT INTO Test VALUES(2,1,2);

Hello! Since days I'm looking for a solution for the following problem for Access 2000: Can I starting by Code a database B.mdb (protected only with a simple database-passwort) from a database A.mdb by Code. The database-password must be a part in this Code. - Database: c:\ablage\test.mdb

Hi, I have a form with a large number of subforms inside it (around 20 subforms), There is the possibility of filtering the data using a pop-up form that create/change a query (all the subforms are linked to that query), Once that I create/change the query, Is there any easy way to update all the 20 subforms on the fly??. Normally I use...

I would appreciate any help from anyone with the following: I have an external program (window32 based) that I am executing with the VBA SHELL command. This program produces a text file which I have to read after the external program finishes. I use the transfertext method to read the file. The problem is that the SHELL command executes...

"Marshall Barton" <marshbarton@wowway.com> wrote in message news:9as9lvgpnp783kogctb88c8giaepb5uf6g@4ax.com... > William Bradley wrote: > >I have two cells on a form. One of them is the "Production Date" and the >other is the "Expiry Date". The "Expiry Date" is 183 days after the >"Production Date." > >On an Excel spreadsheet, the "Expiry...

Hi, I have a MS Access 2000 database on the network, it is secured and the mdw file is on the network. The database works for most of the users on the network, but does not open for two of the users. It gives "CANNOT LOCK FILE" error. There is really no difference between these two users and the other users who can log on to the database....

Hi I know this has been done to death....but obviously at some point in the dim and distant past! I wish to program a retail database for my shop, I have trawled many forums and I only manage to see "search for inventory, this has been done many times before...", without ever actually coming across the method ;( Could some kind person...

Gudday, I have an Access 2000 database which I am using as a phone directory of residents in the hostel where I work. The front end for this directory is a form with a text box (the search name etc) and two combo boxes that let you choose options relating to the search name. These three controls are referenced by a query, the results of...

(Hope I can ask this clearly...) I have three tables: tblPayments, tblCompanies, and tblPeople. tblPayments contains a field called lngPayeeID that needs to relate to records from tblCompanies and tblPeople. Why? Because a "payee" (lngPayeeID) can be either a company (tblCompany.lngCompanyID) or a person (tblPeople.lngPersonID). I know...

I have a form, with subforms, wherein I use a filter to select certain records. Then I can browse trough the selected records, and, if nessecary, change them. The form is based on a table with primay key "EventID". When finished, I want to open a report, based on the same table How can I make my report only shows the records with those...

I hope I can explain this clearly. I have this database that calculates Bids for construction jobs. You log in, (login id and password) select a project, go into that project and create a "bid" where they can add items that will be needed for construction (2x4, 4x4, nails, etc). They have the ability to create multiple versions of the...

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

OK here's what I have so far... I have a query named TEST1 that runs on a table named 10251_IP_Range. I get a list of "Machine" names that all have certain data in a field. What I need to do now is take the data (The "Machine" Names) that the query gives me and run it against two other tables. The two tables are NO_Norton_Ever and...

Hello- I am creating an application in English, using English Windows 2000 using some VB code, for MS Access 2000 but the application will be used in China under CHinese Winodws. Will the English VB code execute properly under the Chinese Windows environment? Thanks very much.

Using Access 2002. I have a chart in a report that is currently based on a query in which the user enters the start and end date for the chart to display. Both the start and end dates have been identified as parameters so that the date range can be found without causing an error. So far so good, report works as it should. Here's the...

I have several Access 2000 databases where some kind of version control software needs to track changes to code. These databases are not split and includes data tables which happen to contain sensitive data. What would be the best action to take to implement the version control?

I have an Access 2000 MDE that I can deploy via Wise 9.0 for Windows script successfully to 95/98, NT, 2000, XP, Xp/pro, and Me. This works fine in all environments on any number of pc's so I am convinced the app and the load process are working fine. There is one pc running 2000 servicepak 3 that gets the error, "The expression you...

I've just started using Stephen Lebans' RTF2 control in a database, linked to a Memo field, and am finding it extremely useful (incidentally, in ACC2002 I'm using the class and withevents rather than the ACC97 backward-compatible module). I do have one question for Stephen or anyone else familiar with the control: what is the best way to...

Hi folks- this will be a piece of cake for you: The tables tblOne (Number, Name) tblTwo (Number, Revenue) are connected through a query, using one field as connector:

Hi I'm new to visual basic and ms access, and was wondering if some of you could aid me here, I tried using the supplied access help file without any success. I want to make it easier inserting a date, i.e. that one gets a drop down menu with the current month and can click the desired date and afterwards a date for instance 21.07.2003...

Whenever i try to install a package created using the above onto Win9x I get the following message; Internal Error 2721: Please contact product support for assistance I have built a fresh Win 98 system to test this and have tried installing on other Win9x systems in various configurations. I have mailed Sagekey but they are not...

Hi, I was just setting up a test system on a client's machine yesterday and as ever noticed a few problems. One that has thrown me is to do with the order of records in a subform (datasheet view). The main form holds the parent records. For each parent record there are 10 (and always 10) related records. When these 10 records appear...

I have a report that I created that has no data, just boxes, lines and one date field not tied to anything. Basically this report will just print pages according to the dates you entered. Then according to the day, it will hide certain boxes. Here is the code (BELOW) I've drummed up, but how do I use it to print out a range of pages? ...