Microsoft Access / VBA Forum

In an existing Form I want to show every field and data.. For that I have to go Form Design View and Insert Existing Field and manually drag and drop every field to the current form.... I wonder if there is any chance to Insert Existing Fields to a Form via a VBA code.. Because I created the table using import from excel and the field name...

The error i get is runtime error 3061. "Too few parameters. Expected 2. here is the code: Private Sub Form_Load() Dim dbs As DAO.Database Dim TstVal As String Dim StrSQL As String Dim rsSql As DAO.Recordset

I use a similar technique to ADezii but I create the form with around 50 textboxes plus associated labels plus 50 labels in the header and 50 textboxes in the footer - so around 200 controls altogether. Labels are named in a similar way T0, T1, T2 etc for textboxes, L0, L1 for associated labels, H0, H1.. for header labels and as you may guess...

Let me first explain the application, and state early on that I am an amateur at VBA. I am creating an Access database that will function similar to Computer Aided Dispatch for small police agencies. I have a table called TourT with a PK of ID. I have a form named CAD_UnitSetup with its record source as the above table, TourT. I have...

My SubForm has Multiple TextBoxes, but the there two I need info from for the TextBox in the Footer. TextBox1 Name - txtComponent TextBox2 Name - mAvailQty TextBox3 Name - txtBrass What I'm trying to do is fill txtBrass with the value of mAvailQty when txtComponent shows Brass and fill txtBullet with the value of mAvailQty when txtComponent...

I have a parent form called CAD_CallDispSlitF with a subform called CAD_Log_DispF. When the user tabs through all the controls on the subform, I would like for it to trigger an event that either refreshes or requries the parent form's records source, and at the same time, make those changes immediately visible on the parent form. Any suggestions...

I have a from called CAD_CallDispSplitF. As the name implies, it is a split form. The form has a subform named CAD_Log_DispF. Link Master Field is ID Link Child Field is ID_Activity The link works fine. The record source for the subform is SELECT CADLogT.ID, CADLogT.EntryDateTime, CADLogT.Notes, CADLogT.ActionID, CADLogT.Dispo,...

I have a very large excel file runs from A to GV. Is there a way to bring this into my database. I would like to split this into maybe two or three tables. Now the excel file comes from an online registration system and I have no control over the size of the file. I would like to do this through Access VBA so my end user doesn't have to do...

Getting the values from a ComboBox's columns works to fill in a TextBox but can't get the results from a calculation in another TextBox. I don't know why I get an #Error in TextBoxes 3-4 unless the value from a column is not a true numeric value but a string value and if so, how can it be converted to a numeric value for calculation? Here is...

I have a customer with two computers, my program is loaded on both computers, however when he tries to print on one computer he gets an error "There was a font installation error". his other computer works just fine. I've had him switch printers from the computer that works to the one that he gets the error on and he gets the same error. I've...

What is the data type for the .Value element of a multi-value field? I am using Access 2019.

I have a report that loses it's group count. In the Group Header there are two TextBoxes, "txtMfg" which is bound to and shows the names of manufactures in the table named "tMfg", the second TextBox named "txtMfgCount1" counts the number of times "txtMfg' changes in the (Mfg Group), and it's property settings are "=1" in it's Control Source and...

Hi, I have a drop down list with different status for a process., and the date field on the form for the status. how can i save the dates for each status(step) when different option from the dropdown list is selected? BR

Hi Team, This is the code i am using to transfer data to a excel template, the data is pasted from cell A1. i wanted the data transferred from row 11 and onward. Private Sub Command18_Click() Dim filepath As String Dim sSheetName As String sSheetName = InputBox("Enter Sheet Name") filepath = "C:\Users\msheikh\Documents\Fremont...

A ComboBox with five columns, three of them are numeric in a Table. The ComboBox shows the Columns as numeric (1,200.00), but when the TextBox shows the value, it drops the coma (1200) and the decimal. Do care about the decimal because in the table the numbers are formatted as a numeric whole numbers. The problem I'm having is trying to get the...

I was curious if there is a way to use a form in access and send that data to the default outlook calendar as an appt. I have tried this code but it doesn't seem to work. Dim olApp As Outlook.Application Dim objAppointment As Outlook.AppointmentItem Dim objAppointments As Outlook.MAPIFolder Dim objNameSpace As Outlook.NameSpace ...

I have a form named CAD_CallDispSplitF with a primarey key as ID in the underlying record source. The form has a command button, btn_addVehicle. I have another form named frm_CAD_CallerAndVehicle that has two subforms: frm_CADcaller and frm_CAD_Vehicles. The subforms are NOT on individual pages. Each subform is linked to the parent form on...

Hello all, Hope you all fine I have an access database for pay pension to pensioners in my database i have some inactive accounts my format is: account number= 1274A name of pensioner= umair khalid in my transaction form combo box hide my data as 1274 but when i put 1274A transaction will done.

I'm getting runtime Error 2487: The object Type argument for the action or method is blank or invalid It triggers at line 36 I have been using this code for awhile, but all of a sudden it stopped working. Can anyone see something I have wrong? Private Sub btnAuditEmail_Click() On Error GoTo Error

Hey there, I am dealing with two forms in access. One of them has a "Date Code" field which asks the user to enter a date. I want it to be such that if the date entered by the user is greater than a "Fix Date" date which appears in another form, I would like to throw a notification saying that the DateCode must precede the Fix Date. I am trying...

I am updating an old Access application with a backend sql server. In a report, I have a subreport based on a very complex query. I would like to run the data source as a pass-thru query. When I do, I get this error: "You cannot use a pass-through query or a non-fixed column crosstab query as a record source for a subform or subreport." ...

Hi All, I have a table NonReworkableparts with 2 fields of interest , Program Number and PartNo. On my form the idea is to select a program number from a combo box and when I type in a part number if it is in the table then it gives out a msgbox. There will be multiple part numbers, that's why I need to make sure I match against the...

I have an Access database that I send out emails to our customers. When the command button is selected it opens Microsoft Office and generates the emails for me to send. We have now created a general email address (like info@abccompany.com) that is shared among my team. It is possible to change the from address in Outlook for the emails generated...

I have a form with several combo boxes, all with Limit to List on. If a user enters invalid data into one of them, of course he gets the "not in list" message. If he then decides he was on the wrong track and tries to cancel the form (Cancel button click event = Me.Undo), Access still keeps insisting on a valid entry in the combo box. I can't...

hi all i have database with linked burble sheet pic object all i want how i can detect this pic content to remark pic on to my data base like remark office and form scanner