Microsoft Access / VBA Forum

I am throwing a blank on an easy one. tblHours has 2 less records than Machine Hours table. I would like to say if . has a record not in tblNotes. then add it. I don't want any dulicates. Keeps saying there are zero records to add when there should be 2. INSERT INTO tblNotes ( ) SELECT . FROM tblNotes RIGHT JOIN ON tblNotes. = ....

Hello experts: I came across a 10+year old posting in this forum (https://bytes.com/topic/access/answers/911063-how-create-automatic-dynamic-union-query). The solution offered by @Steward Ross is fabulous and perfectly fits my current need. However, I need to slightly tweak the VBA in order to NOT process *string* values vs. *integers*...

Hello I have an access database for transactions I want to prevent duplicate entry against any account Suppose i have an account (4422A) and i want it to pay only one in a month If i enter this account twice access don't allow this entry. please help me Thanks

How to add a word "Continued...." or any other indicator if some of the rows go to next page or column on a report? Can anybody help me? Thanks in advance.

Access Europe (AE) is a new online chapter of AccessUserGroups.org. Further details are available from https://accessusergroups.org/europe/ All meetings will be on the first Wednesday of each month from 18:00-19:00 (UK time – currently UTC/GMT) and will be co-chaired by Alessandro Grimaldi & Colin Riddington. Whilst Access Europe is...

Hello, I'm trying to set the visibility of controls in a subform with a combobox in the main form. I had it working but i needed to move some table fields from the sub to the main. Ive tried researching but Ive had no luck in finding an answer that is related to the controls directly. This is what previously worked when the combobox was on the...

Currently I have a report created from a query with a filter based on a single unbound listbox which is working. I tried to add a second unbound listbox for additional filtering but it is not functioning - no errors just literally seems to do nothing. The code that does nothing is a replica of the posted working code with exception of the control...

My end user is using a filter on a sub-form (SearchQSubform) then pressing the "PrintPDF" button that is located on the form (SearchForms). However, all the searched data in the sub-form is printing. I only wish to print the user's filtered data. I tried putting the following code in the "On Click" event procedure for the "PrintPDF" button: ...

In recent weeks Access 365 (and I believe earlier versions) has become unable in certain circumstances to create a backup (File>Save As>Back up database>Save As) or create a .accde file (File>Save As>Make ACCDE>Save As). The symptoms vary depending on whether the FE has a password or not, and whether you are making a backup or a compiled version,...

Hi There is a simple task, you need to run the access 2003 database on access 2019. After the conversion, before starting the application, I get 2 errors 5: CM_replicator.Class_Initialize: Invalid procedure call or argument and 91: CM_replicator.Get_replication: Object variable or With block variable not set. The question is how to fix them?...

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 ?

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

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

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

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

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"

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?

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

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

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

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

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 need help setting a validation rule to accept the values 2021 or 2022 or 2023 (in that order) only.