Microsoft Access / VBA Forum

1 High Priority 0 Views Last Modified: 2019-02-13 Edit Question I have many queries were simply to come up with a number that is a count of records with a specific criteria, to be used later in a calculation. Because those criteria are so lengthy, and change with each variation of the dataI am collecting, I’m not sure if an IIF structure...

Hi, I am trying to send separate Employees a PDF of their section/page of their report. The information is based on their EmployeeID. So each person has their balance information on a page then there's a page break, and then next page shows the next person's details. With the code below, it does email each of the employees one page but it so...

I have a form with two combos. Both source from a single table (the same one). When the first on the top is selected it enables the ones below. The issue is that I would like to link the two. In other words the first combo is Projects and the second one is Supplier. Right now when I select the project all the suppliers show in the combo below...

hey there! im new in ms access. can you help me with my access data and i want automatically put a remark "expired" text in the (status field) after 5 years from the (date issued field). how can i do that? thank you in advance ^^

Hi - I've adopted some code from font stuff to be able to select multiple rows in a list box to send to a query. I'm using an Autonumber ID field to identify the records I want from the list. Can anyone help me with my run-error 3075 on STMT2? Syntax Error(missing operator) in query expression ' in (100',102')'. Those are the correct...

I'm super new, treat me like so. (In advance, thank you) I'm creating a database for our bus information. So the form will have things like Bus #, VIN, Status (active/inactive), tire size, etc. I want to create a form that generates with assigned blank boxes and then populates information when you enter a bus # based on the bus you chose. ...

Good day I created a database in Access 2010 and now after opening it in Office 365 i found some of the functions previously done not working properly. I would be happy if I can get some help sorting out my problems. 1. I would like to display the current user of the database based on the person's User Login and not the Environ (computer's...

I've been trying to figure this one out for a while now and have finally relented to posting in here. I am developing an application for a manufacturing company and I'm working on an order processing routine. Their orders specify a product which is based on multiple processes. For each of those processes, I need to have user input on certain field...

Can any one pls explain how do i add "Add button" in an Unbound form?

Hi Folks, I keep getting the error when I select a name with an apostraphe, such as in the name "O'Connor" : Run-time error '3075': Syntax error (missing operator) in query expression '(='O'Connor')'. A Debug highlights the line:

I have query with the following field (ID, EmployeeNo, Date, daytype) Daytype field have one following Value (P,AL,A,SL,H,AWR) I would like to calculate the following from Type field: Working Days (P+H) Absent Days (SL+EL+AL,A) Payable Days ((P+H+SL)-(EL+AL+A+AWR) While Absent Without Reason (AWR) will be calculated with 2

I need to create a query using inputs from my form, it's check button. What I wish to do is when the check button is ticked it will show me open records or show me all records. Open records are those for which closure date is null. Expr1: IIf(!!=True,IIf(IsNull(),1,0),1) This code is working well but I am not understanding the '1' in the end,...

I have an Existing database.mdb table with 24 different columns. I need to be able to Import 1 record and up to 500 records to this table from Excel file starting after the last record. I can't find a VBA that will help with finding the last record. This will need to be fully automated. This is the format of both Users.xls and Users.mdb ...

In my last question (https://bytes.com/topic/access/answers/972172-split-ms-access-reports-into-separate-emails) I wanted to make separated reports from one big report and have them sent matching the EmployeeIDs and Emails... However after every email I get a message from Microsoft Outlook: "A program is trying to send an e-mail message on your...

I am trying to export a query to xml but when I hard code the filter on the vba it export, but when I want to use form it fails. the user will not have access to the code so its better if he can put parameter in the form and the code execute. This is my code, I use Access 2013 Application.ExportXML _ ObjectType:=acExportQuery, _ ...

I am creating a high risk pt list data base. the table is called high risk pts. in my form I would like a button that I can click on that will ask me for the chart# and when I enter it, it will then take me to that chart# and pt info in my form. I know you can do this with the find record button option already. but, other people will be using this...

Hi after my last question I am trying to separate PDFs in one report based on their Employee ID and have them saved to a folder and named based on their EmployeeID. I have made a query to make a report I have two codes that I am trying but both keep coming back with an error. This one at DoCmd.OpenReport "Balance", acViewPreview, , "EmployeeID =...

Hi, I have code which should open a form to specific value in combobox. But there is a mistake, because only show message "I don't know what to do with this combobox value". Maybe I should apply filter? But I don't know how? Could you please help me? My code: Private Sub ComboBoxColor_AfterUpdate() On Error GoTo Err_Handler Dim...

Admin:This thread was originally posted as a hijack in Calculating next x anniversary dates. Hello Stewart. I am trying to calculate a date in the past relative to a future date that has been determined by a calculated field in a query. The past date needs to be calculated exactly 1 (or 12 months) year prior to the calculated future date,...

I have created a report which opens with a click button and utilizes two parameters using the following string: Private Sub Doc2019_View_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "B_Edit" stLinkCriteria = "=" & "'" & Me! & _ "' And =" & "'" & Me! & "'"

Private Sub nPG2Used_Enter() Me.nPG2Used = (((( - ) * ) * ) / 2000) + End Sub Hello, The calculations work correctly but each form box must be clicked to update. Being that I have many such calculations on my form it could cause a error in the final calculations. I previously had everything in calculated fields which updated all...

Sorry to bother you all again... I am trying to create a login page where upon inputting the correct UserName AND password, it would filter a subform below so that they could see only their comments. Is this possible? I have it so that there are two buttons where one checks the Username and Password via VBA code and another button filters using a...

I have a shipping form that has a print preview button. I would for it to bring up the current record. In the macro I have tried =".=" & it works pulls all records with the current Shipping list Number. I have also tried with =".=" & and it pulls all the shipping lists under that job number. What I would like to do is combine them so that it...

Hello team Can someone help me with vba code with which I can export some selected records from the tblinvoices table to xml, with corresponding details from tblinvoicedetails table as a node under the invoice. For example if I want to export Invoice number 25 to 35, but only invoices belonging to customer ABCD. I would like to use a form to...

formula for opening balance and closing balance calculation from fiscal year to another fiscal year