Microsoft Access / VBA Forum

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

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

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

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

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

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

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

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

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

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

I'm new here and will admit right off the bat, most of this is above my head, but I like Access and learning the ticks of the trade so to speak. Here is one and I’m sure there is a way, but I’m stuck. Below is triggered when a button is clicked in a form: DoCmd.TransferSpreadsheet 1, 8, "Employee", "C:\Manager.xls", True The “Employee” and...

HI: I see the term "Me!" in a lot of Access statements, bit don't quite know what it means. In the same contexts as wondering what the meaning if "is" is, I wonder what the meaning of "Me!" is. Can someone enlighten me? Regards

Hello, I'm into DB access now. I have a SELECT Query code here: Public Sub DBSelectUpdateListTable() Dim db As DAO.Database Dim rs As DAO.Recordset

Dear Access 2003 users, Can anyone assist me with creating either code (preferred) or a query that would remove a single field (called ID) from a table? And as a bonus question, can anyone assist with adding a field (called ID) to a table and then make it an Autonumber data type? I've been successful in adding the field via code, but...

How to check if No Value was selected from List-Box without using any built-in Events ?

So, I had this bright idea today that didn't quite work out. Or maybe it is working out but requires me to change a habit. I'm working on a form that will be a sub-form of another form. During initial development, I find it easier or better to work on the form as stand-alone entity rather than a sub-form. One reason is that I can edit the form...

I'm sure I knew how to do this once, but now I can't find the place to set it. A report has a group header for Organisation and then a detail section for each Contact in that organisation. The report shows up just fine, except I don't want it to break a page in the midst of the detail records, or before they start. That is, I don't want ......

Can anyone explain this error. I have the following code in a button on a form Private Sub cmdExit_Click() DoCmd.Close acForm, "ActivityMaintenance" End Sub

Hi folks. I have a query opened from a menu bar. Is it possible to make the query read only? Thanks Al

Hey Forum! In my project there is a table containing archival data. This table currently has more than 3 million records covering a period of 11 years. Each month our team scans equipment for inventory. Unfortunately, many times during the month the same piece of equipment is inventoried multiple times. What I am looking to do is to delete...

We have a query that calculates the percentage of customers we have in three groups. (Active, Inactive, Pending). The table we get the precentages from has over 1 million records. I need to design a query that will pull 100 records from a table using the percentages of each group. Ex. if the Active Group is 53% of the database then 53 of my...

I built a select query filled with fields from multiple tables and queries. I have one field in this particluar query that will filter out a single order number. In the criteria box I put and that does the trick for filtering for one single record. What would the criteria syntax be if I wanted to filter for multiple order numbers? I'm thinking I...

Hi, Can't seem to find a work around for what I thought would be something easy to do. I have a table that contains 3 columns of date values. The date values most often, but not 100%, include the time. I would like to truncate these values so that they are date only. By that, I meant that I do not wish to format or otherwise hide the time, I...