Microsoft Access / VBA Forum

I have been searching everywhere to try to figure out how to use Access to open an existing Word document that is merged to an Excel spreadsheet and merge the data when it opens. I'm working with two different version, Word 2000 and 2003. I got it to work perfect in 2000, but when I use it in 2003, the Word document opens and it is not linked to...

The following assignment of data works well… rsadd! = rs! However, I need to substitute a variable, (eq. NF which has the value Sname) into the field name position of the rsadd!=rs!________ line. I cannot get the syntax correct. Any help would be appreciated.

Hi there, I'm having pain with the VB behind an Access form. The form is used to create reports in Excel based on the details entered in the form. This has always worked without error on my machine (NT4, Access 2k), however as soon as I attempt to create anything on another machine (NT4, Access 2k) which most users will be working from, I...

Hi I would like to be able to trigger the "on click event" of a button from the code within a different form. Does anyone know if this is possible and if so how. TIA Andrew

I have a database that I am using to store student data. There are two tables and two forms to display the data: Tables tbStudent tbRE Forms fmStudent fmRE

Hello all, I have made a form with a lot of entryfields and one button which, when clicked on, transforms all of the entryfields values into a MS Word document. All the formatting is done programatically and all works well, except for one thing: I don't seem to be able to make a paragraph apear in bold. I have tried: Selection.Font.Bold =...

I know On Error Resume Next is generally considered lazy. But can someone tell me why the resume next in Exit_Handler does not seem to work? It generates the typical unhandled runtime error message from Access. If I comment out the 1st On Error Resume Next and the x = 1 / 0 on the next line there is no difference, i.e. ther same unhandled...

Anyone know of a way to make a table read only after data has been entered? -- Message posted via http://www.accessmonster.com

I entered around 45000 records in a database. The database designed in MS access 2003. I deleted records most of them but accidentally I want to retrieve those records. Please guide me how to recover deleted records.Your cooperation in this regard is highly appreciated. Thanking You Dharmasiri

I am creating a form with a tab control containing 10 tabs. and what I want to do is on only on of the tabs, I want a sub section of tabs. So what it ends up being is one main tab control with another tab control embedded into only one of the tab pages. The problem I am getting is when I insert the sub section tab control into one of the...

Hey All, I hate it when my first post on a forum is me asking a question but it is a pretty simple question which I just cannot work out. The title of this post explains all; basically I need to change the icon of an Access Database (.mdb) from the default pinkish colored Microsoft one. I am aware that I could perhaps create a shortcut and...

The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE add-in MZ-Tools, Carlos Quintero, will be leading a presentation called Top 10 advanced features of MZ-Tools For more details about the topic and...

Hi, I'd like to know if there is anyway I can group records in a datasheet view ms access form. For example, i would like to view all records grouped by their product type after i finish entering all details and clicking refresh. Any type of help would be appreciated. Thanks.

Is there a way that I would be able to get the current directory of the database I am working in. Example: If my database were in "C:\MyDocs\MYDB.mdb" then I would like the code to return "C:\MyDocs\" thanks T Martin

Hey can anyone explain to me the difference between Mid and Mid$ ....i notice sometimes when i a running the update query with Mid$ it tells me that for example 3 records will be updated ( which in theory is the right amount based on the example) however sometimes only two records are updated! Also in the Mid function i am not specifying the...

I haven't found anything that would help me to understand the correct syntax for having a certain number of digits phone number validation rule. My input mask for this field is: \000\-0000000;; When I set the following validation rule: 9999999999 or =9999999999 it doesn't work correctly and it allows short numbers. How should I compose it...

I have a database setup that uses ODBC connections into SQL for read only views to compare information from multiple sql databases in our company. Most of the tables use the Employee ID as the primary key. The problem is, one database formats the EmpID with leading zeros so all EmpID's are 5 characters long. (ie, 00123, 01523) Another...

Hi, I'm new to access (2007, running on XP), but I've gotten some great help from this site on my project so far. However, the more I know, the more complex the problems seem to become.... I'm working with all of my data in a single table and, right now, I've got a form linked to a query that allows the user to input whatever search criteria...

I have a form "Finish" which has a record source "finish query". Criteria for the query is that they must enter an item # to view only that record at that time. I want them to be able to just type the item # into a text box to view that record without having to close and reopen the form. I don't want the records to be editable and I don't want...

Is there any way to create a pivot table in a report? I have a query with the fields Date, Name, and Data, and I am trying to create a report that has the dates running across the top (like fields) grouped by month, with the names running down the left, and the data values under each appropriate month. I am totally stumped on how to do...

Hi All, is there a way to run a module using a button in a access form? thanks in advance Ismail

I have an MS Access userform with 16 Check Boxes. Each of the checkboxes has a different option value, which coincides with the Check Box name (eg. cb01.OptionValue = 1). At the bottom of the form is a command button. When the command button is clicked, I need the VBA scripting to determine which Check Box has been selected, and then...

Hello all. I want to schedule an Access macro to run. The macro runs 3 make-table queries. The best way I thought to accomplish this is to create a shortcut, and then use the task scheduler to run that shortcut. I am working within a secure workgroup. Here is what my shortcut contains:

This seems like it should be an easy thing, but I think I'm missing something simple here...or I'm just going about it all wrong... Using Access 2003 I have a form that lists vehicle service dates for different company terminals. The form loads showing all records. In the form header I have a combo box named "CSCFilter" that is unbound,...

Hi all, I would like to know how do you go about calculating percentages in Access. For example, in a form I have 3 combo boxes with drop down menus where a user can select "Yes" or "No" and a text box where I will calculate a percentage. What I am looking for is something like this: If combo1 = "yes" then percentagebox = 1 / 3 * 100...