Microsoft Access / VBA Forum

At the request of ADezii, I wish to duplicate some fields from the Main Form and some fields from the Subform into a new Main & Sub Form I have tried using Allen Browne's code but get an error message of "Run-time error 3022".

Hi. I wanted to create a calculator with ms access that works both on click and when pressing the key on keyboard and I have no idea on how to. Can you show me or send a video please?

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

I have a report in Access that is grouped by customer with a page break after each customer so only their data is shown on the page. I would like to email the report to each customer with their individual data(page). I can get Access to email to each customer, but it emails the entire report and does not email only the specific customer. I...

I am using this vba code to prevent double entry: Private Sub BusinessName_AfterUpdate() Dim NewBusinessName As String Dim stlinkcriteria As String NewBusinessName = Me.BusinessName.Value stlinkcriteria = " = " & "'" & NewBusinessName & "'" If Me.BusinessName = DLookup("", "Sheet1", stlinkcriteria) Then MsgBox "" &...

Hi all, I have a form with a few Listboxes on it that acts as my Main Menu if you will. I created separate queries for each list box with one field to count all the records in that list box. Works great until one of the Listboxes is empty, then the form goes blank. Can I create a calculated field on my form that has criteria - IE: ...

I have one user who inputs her dates using a period (today would be 4.27) and Access is taking that as 4:27 AM. I don't want to change the input mask and mess up the other 8 people using the same input form. Suggestions are appreciated.

This is such a simple basic thing I've done for decades yet now a problem? I'm sure it's something silly I'm missing. A search provides no answer for my situation. Library reference is to Microsoft Office 16.0 Access database engine object library. I removed that and changed it to DAO 3.6 library. Both compiled. Both gave me the same error. ...

What is the simplest way to implement credit card payments in a Microsoft Access VBA POS program?

I have found the record in a table, but I need the correct syntax to display it on the form What I have is the Forms!frmBadWater!Vaults = rst!Vaults I have tried for days old Access 1.0 Program stopped worked with last Microsoft Update Any help would be appreciated Thanks

Hello all, thanks for the add. In trouble here and cannot find an answer anywhere which sort of surprised me. I put about 8 hours into a new DB yesterday for a work project. Get to work this morning and cannot open it (Access 2019 at home/Access 2016 at work). I work for the us government (DHS/USCG) so I dont anticipate their upgrade to 2019...

I need help setting a validation rule to accept the values 2021 or 2022 or 2023 (in that order) only.

Hi I have tried all kinds of formats and syntax I just can't get DateAdd to work with ODBC drivers... System Windows NT PICWEB01 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) i586 ODBC library Win32 ODBCVER 0x0350 EG Too few parameters. Expected 1. SELECT DATEADD ("dd", -2, '#1969-12-31 20:00:00#') AS NextCalibration FROM...

I have a question as to the best way to go about solving a problem. MS Access. I have query with the following fields place, date, payment, frequency aaaa, 1/1/2022, 1000, monthly aaaa, 2/2/2022, 1000, monthly bbbb, 1/1/2022, 12000, annual bbbb, 2/1/2022 0 , annual cccc, 1/1/2022, 4000, ...

Hello Experts, Kindly provide guidance on how an append query with multiple criteria can be formed, this to append four fields data from Table A to Table B and Table B can have duplicates for 3 fields but one field has to be different. In the fields mentioned below the DocStatus will always different. PrjectID MemberID MemberStatus ...

Hi I had posted this issue last week, I got a response but I was having issues with login so had to created another account, I had sent email to the "contacts us" for help awaiting response. I do see a response from Neo Pa but I was unable to respond back. Below is a query and the I have for a subform displaying results. SQL SELECT...

Hi I created an MS Access database in the 90's and it has gone through many Access versions and has always had the following fault that I do not know how to correct. On one of the forms I created a custom Shortcut Menu designed for that form only, but it also appears on the other forms too even though it is not selected in their Shortcut Menu...

Hi I am having issue with New record " #ERROR " The logic works fine except that on the new record row it displays #Error. I know it's doing that because the EOIDate and EOIDueDate is blank as (New) and will be so until a new record is entered. Is there a way that I can get it to show blank (or 0) for the new record row? EOI due date is auto...

I have a report that lists names of people who are out of compliance in 6 different categories. Sometimes nobody is out of compliance in category 2 or 3 but I still want the report to show the header for that category. Whats the best way to do this?

Private Sub ExportCP_Click() On Error GoTo Proc_err Dim strSQL As String Dim rs As DAO.Recordset Set db = CurrentDb() DoCmd.OpenForm "Web Bruce", acNormal, "CP_FEMA_PF_OutPut-QRY"

Hi everyone. It's been a while since I had to consult with Bytes and I have missed my buddies! (You know who you are!) :-) I have an access database that I use to run my rental management company and I have several condos. I had my first double booking last weekend due to a typo so it's time I set my software to help me. I have reviewed...

The code will not accept the top line inside the Do While loop. I am open to suggestions. I would like the user to type in a collection of 1 or more numbers that will need a common index applied. (forming part of a one-many relationship). Public Sub ValveLink_Click() Dim db As Database Dim rs As Recordset Dim IndexFocus As...

Hey guys I am new here and I have been working on my database for under a year. I did split it and it's working well so far. One of my co-workers that I did train on how to use the front end of it, we both filled out some of the forms and I explained to him what field to fill and what field is automatically filled in and locked. We have 2 forms...

Hello All I have a access database for pensioners there are 7 different categories of pensioners. I have a report by daily transactions of all category one by one and i want to summarize these reports in one report by category or amount only. categories are A,AF,F,FF,FC,N AND NF Please help me on this thanks

I use code to select image and store its file path in a text field of ms access form However this code uploads one file path only I like to know if there is any code which selects multiple images and store their files paths to text fields in form ..lets say 4 text fields to store 4 image paths with one command button ?