Microsoft Access / VBA Forum

I thought I posted this, but I can't find it anywhere, so I'm going to post it, again. I hope there's not some kind of delay, and they both show up! I am fairly new to MS Access 2007, and, as I get older, I am starting to have problems with my logical thinking. That being said, I would appreciate help with a budget I am trying to build. I...

Ok, sorry folks, but I simply can't wrap my head around this no matter how much I research I have a ComboBox cmb_CxLookup whose row source is SELECT qry_CustMAIN.CustID, qry_CustMAIN.CustName, * FROM qry_CustMAIN ORDER BY qry_CustMAIN.CustName; The Bound column is 1 CustID, which is hidden from the user My AfterUpdate code is Private Sub...

Hi Everyone, All my research leads to http://www.lebans.com/alternatecolordetailsection.htm BUT it's a .mdb file I can't open so I'm not sure if it will help my learning curve or not. I also looked at this topic frim Michael R. but couldn't decipher it. Can anyone help me access the content please or guide me in the right direction? For...

Ok, I have spent way too much time on this, so reaching out for guidance. When I run the code below it does everything I need it to do, except close the form... Before I added the required fields, I had originally used DoCmd.Close on the btnCxSave button, but now it closes the form before the Validation Code finishes running. Thoughts? ...

I have a form displayed in datasheet view where the user can modify all but a few fields. In the form's BeforeUpdate event, i have the following code: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctrl As Control If Me.Dirty Then For Each ctrl In Me.Controls With ctrl If .ControlType...

The next Access Europe meeting will be on Wednesday 1 Feb 2023 starting at 18:00 (6PM) and finishing at about 19:30 (7.30PM) UK time (UTC) The start time is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8) For local times, please check https://www.worldtimebuddy.com/ I am very pleased to announce...

Hi all my favorite Access elves, and happy NewYear. Im trying to modify a tabledef by code, and I seem to be running into some trouble. I am still in the early phases of getting an understanding on how to do it, and im allready stumped at simply refering to the tableDef. I have tried this: With CurrentDb.TableDefs("hist_tbl_Obs") ...

Could not import msacces 2007 tables and receiving the error above. Error disappeared when I imported empty tables without data. Conclusion: It's also a data-related error.

HI i am ajitvyas . i am using ms access 2019 . i am preparing for data entry programe in access for my business(small) my data entry has following head ( bill no. party name , name of item qty in bag weght and amount) ,Now one pary brings more them one item at the sametime for exmample in the same bill bill no. partyname item qtyin...

Access DevCon: Thursday 27 + Fri 28 April 2023 Today, Tuesday 25 April, is the last day to register for DevCon, the largest English language Access conference and open to the world. It's organized by Karl Donaubauer with expert assistance from Peter Doering and Philipp Stiefel. Join 150 Access experts and developers who love Access from...

Hello. I have the following code to save my Access query, export it to my Excel spreadsheet and rename the tab: If Me.Dirty Then Me.Dirty = False End If DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "InvoiceData", "X:\Spreadsheets\Invoices\InvoiceData.xlsx", True, "DailyData" What I would like to do is have the Excel...

Hello, I’m sure this is a relatively easy fix, but I have an unbound combo box on a form that runs numerous queries in the After Update section. Everything there works fine. All I need to do is have a command button on the form that advances the focus of the combo box to the next record in the query its row source is based on (plus I’m sure...

I am working in MS Access 2003 and I want to use the update query to change part of a value in a field. I have a last name field that contains a lot of records. Someone entered the values De Pedro and De La Rosa etc. and my boss wants them in lower case de Pedro and de la Rosa. I want to update De to de without having to manually change them. I...

The next Access Europe meeting will be on Wednesday 3 May 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check World Time Buddy I am pleased to...

Is there a way to make the find box (Ctrl+F) default to match "Any part of field" instead of "Whole field". Thanks in advance. Matt.

Hi, I have an unbound combo box that I would like to navigate back and forth through the records populated in the combo box. I currently have an advance button thanks to this post here: https://bytes.com/topic/access/answers/649962-advancing-unbound-combo-box. Does anyone know how to do the opposite and create an previous record VBA code? ...

Hi All I have a text file which has multiple records. Each part of the record is separated by a comma. I am trying to import this data to an access table using an upload button for the end user. The end user will use a form to find the file & upload it which will then append the data to an access table. I am getting a Type Conversion Failure...

I have conditional formatting in a textbox based on a value of another textbox. > When this code is true in turns the font Bold and Red of the txt box What I need help with is how do I trigger a msgbox based of this conditional formatting? Or would it be better to do an after update code that does the conditional formatting and trigger the...

Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what was the control clicked and then, take an action. In my case, I have a form and a subform inside it and the controls are inside this subform. I have...

I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If Nz(r(2)) = "" Then Stop 'Need to move form to this record. Bookmark?? Form_frmABCD.RunSelectForm (1)

I had my database that I created on one of the server. Recently we have to moved it to another server. Ever since I lost the ability have multiple users access (open) the database at the same time. Can anyone help to fix? Thanks

I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent to them so they can answer the questions. Once finished answering the questions, the user would return lesson 1 and we send them lesson 2. As the...

Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the code. Visibility is not adhering to the record checkbox value. Screenshot also below. Any ideas? Private Sub Form_Current() Dim db As...

The next Access Europe meeting will be on Wednesday 7 June 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check World Time Buddy Topic...

I have been asked to publicise the next meeting of the UK Access User Group which will be on Thur 22 June from 16:00 to 17:30 UK time (UTC+1) The meeting is free and open to all (both members and non-members), whether or not you are based in the UK, but you do need to register in advance to get the connection info for the meeting I encourage...