Microsoft Access / VBA Forum

I have a form with a list (as per attached image) and a formula that according if the box is checked it either enables the button or disables it. I have implemented this on form load. But the issue is that although the formula works, it either enables or disables all of the form buttons on the list. What am I doing wrong?...

Hello! I have a multiple value form: sbfrmTests_multi *Please ignore sbfrm - at present that is the name, but it has no parent. - Form use: select tests and insert them into a template with the same templateID. I have a static table: tblTests -A table of tests, to populate the selection options (Checkboxes) on sbfrmTests_multi

there is a field called proposal name in the form.As soon as the name is entered,there should be a new table created for that proposal name.how to do it in VBA?

Hi. I had a quick look for this question on the site, but couldn't find what I was after. I have a Form where there are two fields and . (if need be there is also a field I would like to assist our old analyst by joining the fields so that they are clickable and will open into google maps. i.e. ="https://www.google.com/maps/place".......

I have a text box in a report that shows the name and job title of the employee issuing the report,as follows "Per: " & & " / " & The text box is set to be an 11 point font but I want the to be a 9 point font. How can I do that?

I created a machine parts database. I created the form and the table I use a subform to display the records within the table. Now my problem is how I build the search box using textbox that can search a specific data within the subforms. I'm new of data access I need more help. I appreciate any help from you sir...

Andd other I need to know is if there are specific data inside the subform how I create a subtotal or a total of input parts and pullout parts. Example if they search a parts how many pullout and how many are available. How I will create a subtotal or total of parts on hand and parts pull-out. Thank you for your help.

Hi, I have a problem that had me going around in circles for days now. I have a combo box which updates from another combo box correctly. I'm now trying to get trying to get a text box to display a value based on the selection from the second combo box. My after event code is: Private Sub cboActivity_AfterUpdate() Me.cboRateHigh =...

I am working in Microsoft Access 2010. I have a form called "Production Report." There are several input fields on this form, one of which is called "Format." I also have several other forms, Group2, that correspond to the different values that can be entered in "Format." For example, the "Format" field can be populated with either A, B, C,...

Hi Everyone, I have linked my outlook folder to a table in access. My problem is the body of the email is in a field called contents. I need to extract certain information from the body of the email or contents field. For example, within the body of the email there is a start date, laid out in the email as "Start Date/Time: 1/1/18 at 7:00". I...

I have a large body of text and am trying to extract parts of that into a field in my form. i am using the following code: If InStr(1, abody(j), "Extent of Work:", 1) Then strExtWork = Mid(abody(j), InStr(abody(j), "Extent of Work:") + 16) this works well in returning one line, but sometimes the extent of work that i am trying to extract is...

I have an Access 2010 database that our staff use to keep track of appointments and activities. Some events occur weekly, and I would like the staff to be able to create those entries by selecting the day of the week and the start and end dates of the event. I am relatively new to VBA coding. I have found some examples that appear to replicate the...

Hi, I have a form that is a combination of comb boxes and text boxes which functions as a means to to lookup records, taking the information from several different tables. The text boxes are all populated via Dlookup in an after update event from a combo box. What I want to be able to do is to be able to edit and add information to records...

Hello!! I have a mainform & subform and two combo boxes. Data: combo box 1 has user name and combo 2 has user id scenario: when I select user name (from combox 1) appropriate user id must display in combox box 2 and display the realted data in subform. example: Name1 User1 should display

Hi, I am building a parameter query in Access that refers to the controls on a form for its criteria. I am looking for something that lets the user pick one or more of the filters on the form that they want to use, so in the criteria for each field of the query I have the following structure: !! OR !! Is Null In the above example, the...

I am trying to copy from one forms text and pate it in a different form specific text box. here is my code so far DoCmd.GoToRecord Me.textbox1 DoCmd.RunCommand acCmdCopy DoCmd.OpenForm "Form2" DoCmd.GoToRecord "textbox2"

Hi, need help with the following: Access database: when entering in a preset form, it is determined it is not required but would like to retain the data entered but cancel the record, can this be done? Essentially would like it to do the following: OnClick DoCmd.SaveRecord

I need two reports to print at the same time. Repor1 is always the same. There is a button on Report1 that when pressed will open one of several other reports based on the value entered in one of the controls on Reprt1. This report becomes Report2, the second report that I need to print. Basically Report1 is a given and Report2 is a variable that...

I am working in Microsoft Access 2010. I can't seem to find what I am looking for. Would someone be able to tell me what the PrintObject macro action does, and how to use it? I have searched all over the internet and am not finding the information I need. I would love it if someone could help me out. Thanks so much!

Good day to all, Is there a way to display an attachment (image file) in a MS Access report in which the field will adjust based on the image size. and also to display this part only if there is an attachment? If I add an attachment field to my report the image will follow the size of the field and when there is no attachment it displays an...

I have a simple DB that calculates number of hours to use as a lookup for license requirements. It consists of an EmployeeInfo table and a calculation query to generate the hours based on workload proportions. I have a form to enter an employeeID and it runs the calculations fine. However, if you enter an employeeID that doesn't exist on that...

Option Compare Database Option Explicit Private Sub E_mailExt_Click() Dim strEMail As String Dim oOutlook As Object Dim oMail As Object Dim strAddr As String Dim MyDB As DAO.Database

I have a main form and a subform, I use a customers table to populate the name and address etc on an invoice, when I save the new record it creates a record in the invoice table and the products table which is good but it also create a new record in the customers table which is not needed, how can I correct this?

I'm trying to open a form that is filter by using VBA. I have tried using the following: Option Compare Database Option Explicit Private Sub cmdRabbitsDue_Click() DoCmd.OpenForm _

Hello I have a table that lists its component name and its value several times each but with different values each time then goes onto the next component and so on. I want to create a query that will just display the components name once and not each time its used in the table. Below is the sql... SELECT tbl_ComponentVar.ComponentName FROM...