Microsoft Access / VBA Forum

Hi! can you help? I am looking to write a parameter in an append query to assign a value to one of the fields I leave blank. I need to replace CHID with IID Example - I have an NB (not billed)order, CHID 10, with three lines, description, price, etc: CHID 10,1,Tomato Sauce,2.00,EA CHID 10,2,Spaghetti,1.00,EA CHID 10,3,Chianti,7.99,EA When...

Hi All, I have a main form and subform the subform needs to get a value from the main form it is similar to the Northwinds invoice database, It updates the first product in the subform but any additional products that is added will not update.I am using the below to update the subform Me.!.Value = Me.cboShipperName.Column(10) is there a...

I have an excel report where I created a VBA component that is supposed to open an Access (Office 365) database and run a macro in that database. On my computer and another colleague's it works perfectly. On two other people's computers, everything works except that their machines will open the database, but it won't run the macro. We have...

I used this code to successfully run a report on a single record on one table/form but when I applied it to another table/form it comes-up with: Syntax error (missing operator) in query expression 'FirmName=Smith Management Corporation'. What am I missing? Private Sub Command364_Click() On Error GoTo ErrHandler DoCmd.OpenReport...

Hello friends I want to make a report which display data as below Column 1 Jan to till today. Column 2 Last 30 days like 16 Jul to 15 Aug. This report is completed and all data is being displayed... see attachment But I have to mention 16 Jul to 15 Aug manually. How can computer write itself this sentence automatically from query or...

Here is what I have for each combobox: Private Sub CmbLineSearch_AfterUpdate() DoCmd.ApplyFilter , " = " & Str(Nz(., 0)) End Sub Private Sub cmbSearchDate_AfterUpdate() DoCmd.ApplyFilter , " = " & "#" & Format(., "mm/dd/yyyy") & "#"

I was wondering if it is possible to open a subform via clicking a command button on the main form? Just looking for a yes or no here so that I have a better idea of what possibility to pursue. Thanks!

I want user to enter a date on a form and have that date repeat for each record on table column and new records on form. Is this possible?

I have developed access application using VBA in office 2010 and make it ACCDE but can not work in computer with office 2013. for any help appreciated in advance

Hi everyone, Thanks in advance for any help you can give me. I have a table "tbl_CHcontactlist" connecting in a 1-many relationship with another table "tbl_CHchecklists". I have build a continuous form that I intend to show all records from tbl_CHcontactlist" on. My manager has asked me to also show the most recent date a checklist was...

Good morning, I have the following structure: Form Frm_Production_Main which has two Subforms SbFrm_Production_Sub_MLCD and SbFrm_Production_Sub_TB. These forms are linked to tables: Tbl_Production_Main Tbl_Production_Sub_MLCD Tbl_Production_Sub_TB

Private Sub ApplyFilter_Click() On Error GoTo ErrorHandler Dim strFilter As String strFilter = "" If Not IsNull(Me.cmbSearchDate) Then strFilter = _ " AND = " & _

Using basic Access tools - I developed a small system using Access 2013 - it ran fine Took it to a client who is running Access 2019 (365) - imported from my system some queries and forms All worked well Tries to edit a form on their system - suddenly the query had an error Invalid use of '.'etc. Had two other unrelated queries - both...

Hi all, i am building a Employee Book for tyhe company i am with right now and i have a table with all of the Catagories in it First and last name, department email, ect... and i want to create a form that will search through the database and bring up a the most relevant form. (Example: If i type in sam in the text box it will bring up a list of...

I am trying to select from a dropdown in IE from Access VBA. You cannot right click on the dropdown and inspect element. I ended up using something on found online, and it worked for a while, but it has now stopped working. Here is what I was using... IEWindow.Document.querySelector("div div div form select").Focus...

I have a button on a subform that opens another form (PastMedicalHistory) I want to change the border color of this button after a user post information into this form. This way the user will know that the task has been done or that information is available for review. I've been trying to accomplish this by using the On Paint event on the...

I have a Search form "SearchF" with 2 fields Equipment # and Location. I build the query "SearchQ" with criteria (Like "*" & !! & "*") and (Like "*" & !! & "*") Then I built the form "SearchQF" The search button is in the main form. I have the sub form "results". The command works great using vba Private Sub Searchbar_Click()

Hello im trying to figure out a sql that if in the same table (tbl_ComponentParts) and same record a number in the field (ComponentID) and text in the field (Part) are the same in another record in that table then count those records. Example: ComponentID Part 1 test 2 36 test 13 1 ...

Hi. Hope somebody can help, cos this is driving me insane Using a Navigation Control form, as the user clicks the navigation button to load the appropriate form, I want to be able to control the form's recordset. I cant get the following to work - I get an error message to the effect that the object does not exist Code line as follows, where...

I am attempting to update a table that keeps an inventory using a form that creates records for for a different table. I'm pretty weak on the programming side, but I have been looking around at other posts and thought I came up with what would work. My goal is when pressing a button, the number entered into the "Amount Distributed" box on my form...

I have a text box control on a form. I would like this text box to display a value from a table that is not the form's record source. To do this, I am attempting a DLookUp expression. The table that contains this target is called DateCodes. The field that I would like returned is called OutputDateCode. I would like the OutputDateCode that matches...

In MS Access 2010,I am trying to write some code to a module that I can then use RunCode to run from an AutoExec macro. I have written the code that I think should go in the module and get no errors when I debug/compile it. But when I try to use Runcode and run the macro I get error message 2425 which states "the expression you entered has a...

I work with VBA in Access 2003 My question: field func contains a value entered by user. How can I get a symbolic name e.g. f1 if the value is 1, f2 if thw value is 2, and so on

Hello Friends, One more problem to solve and I need your help. I have a crosstab query is below that runs and give me my results. TRANSFORM Sum(qBG.SumOfBG) AS SumOfSumOfBG SELECT qBG.Company, qBG.Region, qBG.Territory, Sum(qBG.SumOfBG) AS FROM qBG GROUP BY qBG.Company, qBG.Region, qBG.Territory PIVOT qBG.HeldOn In...

My MS Access app shows information about payees including the recurring day of the month payments are due for each payee. I want to limit the payees listed to only those whose payment day of the month matches the day of the month value in a ListBox on the same form (Example: Today is 8/30/2019 - so the day of the month value is 30. I have to pay 2...