Microsoft Access / VBA Forum

Every time I use VBA, my IQ drops a few more points. I wrote a macro that pulled in an inventory file and then converted it to VBA. The problem is the file I want to import will be in a different directory each month. I have a list box that allows me to pick the folder and then I wanted to run the below VBA but I wanted the VBA to use the...

Hi, I have a form with subform in which I made a combo box through which I am populating 2 fields in sub form using SQL query from a table which has multiple rows. There are 3 more fields in sub form which i left for manual entering the data. I am facing issue when the data of first 2 fields get populated using combo box function then when I...

I am using some code developed by Alan Warren and modified by Armund Dezii. Using MS Access as a front end to an SQL Server backend, it allows me to import graphic files and store them in SQL Server as BLOBs. I can pass along all the code if desired. This works fine but I would also like to import PDFs and DOCX files. When I modify the line...

I am trying to use the mid function in order to get a field on a form to populate. The field I want to reference is on the same form. For example: field 1 is 3ABCD4 and field will be ABCD. I would like to have it auto populate when I click on the field. I have created an event "On Click" but can't seem to get I got "Expected: Text or Binary"...

I Created a report from 3 tables named customer,agent and gaurentor also group by Branch and DT on the customers table. Customers table has agent's Primary key as a field., like wise gaurentor's too now i want to print the filtered report based on the two combo-box's selection . i have tried this code Option Compare Database Private...

Help, I have a form that has a graphic with pump images. If I click on a pump it brings up a form with notes on the pump. If I enter a note when I close the form it will display a command button indicating a note for that pump. The question I have is when I close the form with the note, it causes the background form to update but it doesn't...

Hi - I searched the web and could not drill down to an answer to this question. In later versions of MS Access, for some reason when creating a form using the wizards the text boxes are now twice as tall as normal. In earlier versions, only fields with a memo data type were taller than one row of text. It is very irritating to have to manually set...

I have tested the code below but would like a working example. Ref: Relinking ODBC Tables using VBA I have tested this but it does not seem to work for me. My question: Is the strDBName the database name I have to modify to suit my main database? Like "myAccess.mdb" Is it rude to ask for an example mdb? Comment NeoPa 'ReLink() Updates...

Hi I am designing my first database. I'm trying to create cascading combo boxes in a form and display the data inside the subform. I have 3 combo boxes on the form. I'm trying to make them dependent on each other so by selecting one combo box updates the others in the series. Diagrammatically the model is: 1. Context of Approval----<Type...

I have the task of creating a database in which users can quickly obtain details about a certain part by searching for the catalog number. The issue I am having is that when the catalog number is selected via combo box, the parameters from the fields below are not updating to match. I have tried coding to update the fields based on other...

Hi, I have a problem. I have created macro which copies text from one cell and paste it to other cell in other sheet.This macro is called from other macro so that if you change any cell in specific range then it will call this macro. Now it works every second time but when does not run time error 1004 occurs. it seems that error occurs...

I am a PE teacher and am trying to create a more efficient way of keeping score for our Cup Stacking tournaments. I have started the database, but am now a little stuck. Cup stacking has three categories and I will need to keep track of three times from each student. The categories are the 3-3-3, 3-6-3, and the cycle. They get three tries in...

I have a database with two tables, Tubing, and connectors. Some tubes use multiple connectors resulting in a many to many relationship. I have reviewed multiple videos and forums online detailing the process of creating this relationship and they all involve using a third associative table. This information comes from sources using older...

I want to ask two question {Admin edit - This is not acceptable} when we are adding an OLE Object in a form: 1. can we directly by pressing the button add a word document not giving a choice dialog box

Suppose I have a table of three fields ID; Seller Name & Daily Sale in Rupees. There are many entries in a day. At the end of the week I want to see sum total of specific sellers' sales in a TextBox on a Form.

I'm new to access and am wondering if this is possible. Basically, I have a main table where the majority of info goes. But then there needs to be a second table with additional information. I want to make it so every time a new record is added to Table A, a blank record also gets added to Table B, so that when editing in a form, the user can have...

I have an MS Access 2016 database with Person and Organization tables (PERS and ORG respectively) and a relationship table (PERS-ORG_RLTNP), which stores data about relationships between people and organizations, for example, relationships that show when particular people were members of an organization. The PERS and ORG tables have autonumber...

Hi, I am very inexperienced with vba. I am trying to save a generated report to a pdf using the following code. The report is generated perfectly and is displayed on the screen. Private Sub Report_Unload(Cancel As Integer) Dim FileName As String FileName = "C:\Data\Personal\report.pdf" DoCmd.OutputTo acOutputReport,...

All of sudden, many vba functions in my Access application using query are not working with error message "Query is Corrupt". Google results has one page from Microsoft dated 11/14/2019 referring the issue to a patch updates for MSI of several builds. Does anyone know when MS will fix this issue? Will it be automatically repaired when fix...

Hello Friends I have to create a Transmittal to send some drawings to our Subcontractor. Now what I do.... when I press AddNew Button, it work like this.... Main form open with fields..... User.... = by selecting from combo box Today's Date = Automatically toddays Receiving Department = By selecting...

In Microsoft Access 2013 I have a report with multiple instances of the same subreport. Based on which control contains the subreport, I would like to apply a different filter using code. (This would prevent having to create multiple queries and subreports that would be very similar.) From within the subreport, is there a way to know which control...

I have the start and end dates on my report forms set at the first and last days of the current month. I also have three buttons for these dates: One that advances forward one month at a time One that goes back one month at a time One that returns to the current month (same code as I use in "OnLoad") Private Sub CommandBack_Click()...

I have a report with a rich text box - see sample below; ="For Work performed Contractor has been paid " & "<u><b>" & Format(,"Currency") & "</u></b> " & " (“Payment”) and " & "<u><b>" & Format(,"Currency") & "</u></b> " & " remains (including taxes and freight) to be paid under the terms of the Agreement for work to be performed." If the ...

Warehouse shipping application. In the master table, I have Purchase_Order, Planned_Ship_Date, and Actual_Ship_Date. I get a daily update that I load as a staging table which contains updated Planned_Ship_Date and Actual_Ship_Date. Purchase_Order doesn't change, so it becomes the index.I have tried multiple queries to update the master table and...

Here is the code As a whole... Private Sub cmdEmail_Click() On Error GoTo EH Dim strSendTo As String Dim strSubject As String Dim strEMailBody As String Dim MyDB As DAO.Database