Microsoft Access / VBA Forum

I think I may have lost the plot. Just a few years ago I'm sure I wrote something similar to the following code: dim rst as recordset set rst = currentdb.openrecordset("mytable") ' blah blah blah rst.close

Aloha, I have a DB in Access 2000 consisting of about 1500 lines of code and 65 tables, 95 queries and 60 forms and want to "merge" with another persons program written in Access 2 with about the same size, (code, tables, queries, etc.) We would have in common one table "customers". My friend with the Access 2 likes it because he claims it...

Trying to figure out the best way to accomplish this... I have a Purchase Order form that we need to place an item "imprint" into with formatted text, so that the manufacturer will see the exact imprint needed (size and font). I felt that the best way to handle this was to place an OLE field into the table, then place it on the form and have...

Access 97 If I select New on the Query tab of the db window, and go staight to sql view and type in the following for example: INSERT INTO tblMyTable ( dtDate, txtAny) VALUES (#2003-09-03#, 'blah'); and then save the query, close it, and then reopen by clicking the design button so it opens in sql view. The sql has changed to:

I have imported a title list from excel to an access database table and would like to know how to change the imported URL which is long and ugly into html hyperlink code with the title name as the actual hyperlink. eg <a href=URL><u>TITLE</u></a> The title and url are different for each record. At the end of it all I want to be able to...

Hi all. Could someone tell me is this number fixed when the item is created, or can it be changed? So for example if there are three forms, with index 0,1,2 and form 1 is deleted, does form with index 2, now get index 1? Is the answer different depending on what the object is, eg Form or control. Thanks in advance.

I currently have a form with several combo boxes. I have the background properties and boarder properties of all form fields set as transparent. Therefore, the only part of the controls that are visible, is just the drop down arrow button on the combo boxes. Is there a way of hiding this button until the field has focus? Thank you for...

Good morning, I have a table with three fields, Buildings, Floors and Rooms. This is what I would like to do; in my form when I select Building1 in my drop down box for Buildings, when I go to the next drop down field which is Floors, all I would like to see is just the floors that belong to Building1 only and then once I have selected a...

I have a query written in MS Access that has a few calculated fields. Is it possible to refer to that query in a form field. I'd like the form field to show the sum of one of the columns from the query I've written. I've tried to put the following in the form field's control source property but I'm getting an error. Query1 is the name of...

I just want to know how many records an MS Access database can contain ??? Thank you, Serge

I am trying to print multiple copies of an invoice. (rather than the tractor feed multi part forms that keep causing problems) I need to print two invoices at one location so that there are two colors for each invoice. Can this be done in Access utilizing two trays in one printer or will it require a second printer? Thanks.

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

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

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

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

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

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

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.

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

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

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

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