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

I have a main form (Orders), a subform (OrderDetails) and a separate form (Products). The OrderDetails is a child form of Orders. Products form is opened via a button on Orders. There is an image of the product on the product form that on the On_Click event loads the product into a combo box on the subform OrderDetails. I use SetFocus...

If I type !! in my query criteria and query deals with its value which may be (Like "" & "Raj Poot" & "") Or (Like "" & "Malak" & ""). Is it Possible? Actually, each of my clients has different demands (Criteria), so I want to type their demands in their forms field in VBA coding format. Such as (Like "" & "Raj Poot" & "") Or (Like "" & "Malak"...

Hello all I have create custom serial number but it stop when it reach 10 I don't know why I have button generate this expression Me.txtSerial*= Nz(DMax(“”, ”tblOrders”, ” = ‘“ & Me. & “’”),0)+1 Me.Dirty*= False Could you please help to fix this expression..

I have button I want to add shadow only when hover How I do it?

Dear friends, I am using MS Access 2022 (office 365), I am having trouble with creating shortcut menu command for report. I tried to follow the same thing posted by Beacon (How to create a custom shortcut menu command that identifies the calling form/report?), I used MS Office 16.0 object library as reference. The code causes no error, but when...

"I'm not programmer but I'm interested to work on Ms Access" I have table on that table there are many cities I want each city to have unique serial E.g. New York city, serial start N125 then serial like this N125-0001 next N125-0002 and forward Then Another city

I use two access databases. 1 Rolodex (Client Info and related jobs, etc) - 2 is Timeclock (Employee timesheets with hours, rates etc and all necessary info for creating the various forms and reports for distribution). From time to time I have to take the above home to make changes to the frontend. Right now I use the built in Linked Table...

how to send email to each person with query result . please support to create a access VBA code this is query result EMAIL Requested Date Inovoice no Doc user arun@gmail.com 2/26/2023 41164 Arun arun@gmail.com 2/26/2023 41165 Arun arun@gmail.com 2/26/2023 41166 Arun raj@gmail.com 2/27/2023 41167 Raj...

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

I am generating multiple pdfs from MS Access report, but files keep overwriting each other and the code seems to run forever. Please help. See Code below: Option Compare Database Private Sub Command0_Click() Dim rs As DAO.Recordset Dim sFolder As String Dim sFile As String

Hello - I have made something that opens an excel document that was just exported. The workbook has 10 tabs. I wish there was someway to edit all the tabs instead of doing it tab by tab in the code. Is there a way to do that? Right now I am only able to do "Sheet1" of course. Private Sub OpenAndFormatExcel() Dim filePath As String ...

I have this simple query: strSQL = "INSERT INTO tblEngParRole (Eng_ID, Person_ID, ParticipantNumber, Role)" & "VALUES(" & Me.Eng_ID & "," & .ItemData(n) & "," & 1 & "," & '" & Me.txtParRole1 & "' & ")" What I am expecting to be inserted into the Role field in the table is the information typed into the text box, but what I am getting is...

I am stuck on this and would love some help. I have a customer who has 3 rates of pay and personnel can in theory go across all three. Working out the rates 1 & 2 are simple as they are in the same day but the 3rd rate goes across midnight. Rate 2 starts at 18:00 and runs till 00:00(24:00). The code below works until we cross this time and then it...

Access Lunchtime – Translation Tools in Microsoft Access​ Tuesday, 31st Jan at 18:00 UK time (UTC) or 12 noon CDT (UTC-6). The session will last about one hour Join us when Colin Riddington, Mendip Data Systems, https://isladogs.co.uk, Microsoft MVP 2022, will be our presenter. In the first half of this session, Colin will demonstrate a...

I'm running the following code in the timer event section when my database opens. It works on the my Office 365 version, but doesn't seem to fire on the run-time version of access. My database is on a network in a FE/BE setup. There is a yes/No box in my table called "ztblSystemStatus". When I uncheck this box and close out the timer should run...

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

I've been working on a problem and want to try using the docmd.gotorecord to get to a certain record in a table. I've got that figured out but I don't know what to do once i'm on the record. I want to select a usernumber from that record. It should be fairly easy to but I can't figure it out. Any help would be appreciated. Thanks

I have three related tables, ATI, WPH and Selected Event. API and WPH are related through the common field PersonID, while WPH and SelectedEvent are related through the common field WalkNumber. I want to create an Access SQL DELETE query to delete all records in WPH where WPH.WalkNumber = SelectedEvent.WalkNumber and ATI.Response IN...

Hi Everyone It's been a while since I've been on here, or have been doing any coding for that matter, so I apologize up front if I forget to post something correctly. I have "inherited" a database and despite all my research I am not sure how to proceed, what I am doing wrong/missing logically, or if what I am trying to do can even be done......

Introduction: How do you randomise a set of numbers without having any attempts clash with earlier ones? For instance, if using a random number generator (Rnd(SeedCode]) in VBA.) and you want to emulate randomising a pack of cards without any card being selected more than once, as would be the case if simply using a random index into the...

I have two tables, one with tasks and the other with some relative data as below: Task Client Date Hummer qty Made something a X1 01.02.2022 Made something b X2 05.02.2022 Made something c X3 05.02.2022 Made something d X2 07.02.2022 So this one represents daily activity for different clients. I need to...

this is a general example of what I am trying to do. I have a group of 50 people and have 12 tables, I need to put two people at each table but can't have the same two people together. I've tried doing a random numbering, but I still end up with the same two people at the same table. Does anyone have any idea how I can do this. Any help would...

If anyone is interested, I’ve spent some time testing the new VBA Project Signing feature which is currently available to anyone running Office 365 on an Insiders channel (either Beta or Current Channel Preview). It will soon be released more widely to all those on the Current Channel. The feature requires the developer to add a digital...

I am trying to create a digital board with configuable columns, if the columns are too long, I want to scroll them one at a time and refresh that column. Each column is displayed in its own sub-form. I have a table with various information about the column including the subform name (or what I believe is the subform name) as a string. I can...