196 questions
0
votes
0
answers
50
views
On Click in subform to add another row of data entry fields to enter new record
This is all data entry of new records. I have a form frmLoad, enter the truck, driver, miles the load was, date, etc.
SubForm - subfrmStops each load has from 1-? stops, that subfrm needs the StopNum, ...
- 1
0
votes
1
answer
23
views
MS Access Form size maximised
In MS Access I have several forms, and when I start them, they are always maximised in size. They take up the whole page, although the design view shows that they should be a lot smaller. I would ...
- 150
0
votes
0
answers
119
views
ACCDE error 3625 The text file specification 'X' does not exist
Using MS Access 2019 to deploy an .accde form that I developed.
It checks the value of the current form's version from a .tab text file that is hosted in a shared folder and imported as a linked table ...
- 124
0
votes
0
answers
14
views
How to populate fields in tab control when entering firstname in text search box; VBA7?
So,I have btnSearch when click it will populate myTabControl23. I been trying to search by first name and to populate the tab control but it cant.
Private Sub btnSearch_Click()
SearchAndPopulate
...
- 113
0
votes
0
answers
45
views
Access Multiple records from a single form input, with some fields differing
I have a form in which customers can submit testing with me. There are multiple test methods they can choose from, and they may want multiple methods on the same sample.
This in and of itself isn't ...
- 35
0
votes
0
answers
42
views
Filtering a form
I have a form that is fed with a query and depends on a single table, the query looks like this:
SELECT Documentación.Fecha, Documentación.Categoría, Documentación.Médico, Documentación.Paciente, ...
- 19
0
votes
1
answer
92
views
Refreshing Microsoft Access forms
Option Compare Database
Private Sub Form_AfterUpdate()
Me.Refresh
End Sub
Private Sub MedicalCondition_AfterUpdate()
If Me.MedicalCondition = True Then
' If Yes is selected, enable ...
- 113
0
votes
1
answer
64
views
I want single field should equally distributed on all over the form in MS Access
I have a table having only one field say "Program Name", I wanted to change around is the format of the screen. Like since all the programs are in a line on the left side, the right side of ...
- 29
0
votes
1
answer
119
views
How do I add Unbound Column in a Continuous Form while allowing each row in the unbound column to be a unique user input
I have an Excel table with Planned production information. I have an Access DB where I want to store this planned production information as well as Actual production information. I am using an Access ...
0
votes
1
answer
39
views
Adding an "Other" field within a survey question in Microsoft Access forms
I am putting together a survey using Microsoft Access. Within a survey question, there are defined options for the survey respondent to select and also an option of "Other - Please specify". ...
- 23
0
votes
1
answer
571
views
MS Access open record in a form based on current field value
I have the following New Departure form in MS Access:
I want to be able to enter an Item ID (we can be sure that the entered value is valid and such a record already exists), and based on the entered ...
0
votes
1
answer
210
views
Microsoft Access - don't find newly created form in VBA Project Explorer
I am new to MS-Access / VBA (inherited an old project). I just created a form with buttons and text boxes etc. I was expecting it to appear in the VBA project explorer window, but it doesn't. I need ...
- 1
0
votes
1
answer
48
views
How do I fix my code so I don't receive an error when opening a backup file that was created automatically?
When I open the backup file created from the code, I get this message:
If ‘AutoExec’ is a new macro or macro group, make sure you have saved it and that you have typed its name correctly.
The code ...
0
votes
0
answers
51
views
access vba sql-string with "'"
my second question for my baptisme app.
I made a form with two comboboxes to search the name en first name of a child.
The problem is when a ' character comes in the name I get an error. I think I ...
- 11
0
votes
0
answers
23
views
Get values from text/combo boxes on form to different table
Dim strSQL As String
Dim strSQL1 As String
Dim strSQL2 As String
Private Sub Command208_Click()
strSQL = "INSERT INTO PKR([Claim Number],[WANDFNF],[WANDOUP],[WANDEA]) VALUES ([Forms]![Form Level]....
0
votes
1
answer
120
views
ms Access: Switching between subform recordsource when changing records
I have a main form and a subform on it. I want the recordsource of the subform to change depending on the value of an ID field of the main form. This works when I do it in the Form_Load event of the ...
- 49
0
votes
2
answers
680
views
MS Access: Resizing dialog form from within module
I am trying to open a form in dialog mode, and then resize it to a desired size using DoCmd.MoveSize from a module. Ideally I would like this all to run from said module.
Currently the form opens, but ...
- 49
0
votes
1
answer
1k
views
How to keep MS Access Forms only in the MS Access Window/Canvas?
I have created my MS Access Program but I have multiple monitors and so do the other people who will be using the program.
Just so you know my forms are popup style, have no borders or record ...
- 17
0
votes
1
answer
514
views
Enable / Disable Field based on Combo Selection
I am new to Access and need assistance in enabling / disabling a field based on another field's selection.
I have a combo box called RegistrationType and if "Individual" is chosen I would ...
- 1
0
votes
1
answer
799
views
Create a history /Log table based on status change
So my client wants is
If a user changes the status of the case then a log needs to be generated in a history table.
Basically, a new history record needs to be made in the history table as soon as the ...
0
votes
3
answers
957
views
ms access: pop up form is cut off in form view
I have pop-up form for data entry. The form has a subform on it that is surrounded by blank cells of equal sizes similar to padding. (Why not use padding instead? Because I want to add functionality ...
- 49
0
votes
0
answers
661
views
Data entry using a combobox displaying values from a related table
I'm new to ms access and have started a little project to learn how it works. It's a small database that stores safety datasheets and other documents for a number of chemical substances.
An overview ...
- 49
0
votes
1
answer
238
views
How can I make a form instance open a specific record on creation?
I'm trying to optimize the performance of my access frontend. One of the problems I'm stumbling on is how to set a multi-window form to open immediately to a specific record, because at the moment it ...
3
votes
2
answers
691
views
How can I cancel a button's action on an Access form if the button is double clicked?
I have a MS Access database that has a switchboard on it that opens different forms within the database. For some reason, some of the users like to double click the buttons that open the different ...
- 470
0
votes
0
answers
190
views
How to take values from an open Access continuous sub form, and "paste" them into another form?
Okay. Let me try to explain what is happening here.
User will select record in form 1 and click button.
That will open form 2 to a detail form of that record.
User will then select one or multiple ...
- 21
0
votes
1
answer
312
views
Append Strings and values together to target a form control in VBA
I'm so close to getting this code working, I just need a little push please. I would like to
take the name of a combo box and then add a string to the end, But then get the value of a textbox with ...
- 65
1
vote
1
answer
758
views
Call a function with 2 Variables
I'm trying to create a dynamic function that's based off on what dropdown you interact with on a form. I need to pass the name of the dropdown to the function along with the form name when I call it.
...
- 65
-2
votes
1
answer
770
views
Save new record to different table with button macro
I have an Access database and one of my tables is connected a form. I want to delete a record from my table and add it to another table with just one button. Deleting it is simple but I can't find a ...
0
votes
1
answer
239
views
Unable to make Ms Access form blank to enter new records
I have a problem. When I open the Ms Access form to enter new records, it is showing old records. I need it to show a blank form, I have tried me.Refresh, me.Requery and call DoCmd.GoToRecord(,, ...
0
votes
2
answers
964
views
Create multiple records from a single record, with one field based on a second table
I'm completely new to creating MS Access databases, so please bear with me while I ask my (probably silly) question.
I have a table for commodities that also groups them into CropGroup and Class, and ...
- 3
0
votes
1
answer
164
views
Blank forms for certain users
I created an MS Access Database with around 1000 entries. This database has forms that can change or add new entries, some forms only allow users to view data.
I released this database, however a ...
- 3
0
votes
1
answer
268
views
MS Access: Count selected items in multi-valued field on a form
I have a Microsoft Access form with a multi-valued field. I'd like to display the number of items a user has selected to the right of that field. The field is called [Description]. The control ...
- 35
0
votes
2
answers
2k
views
MS Access: Add attachment to record from Form field using VBA
I have a bounded form with property 'Data Entry = Yes' which has a multiple textboxes, and one field of type Attachment.
I have a "Save" button that prompts confirmation to save the record.
...
- 77
0
votes
0
answers
312
views
How to select field based from combobox in MS Access
I want a user to be able to choose the field they select from a table through the use of a combo box in an MS Access form. My combo box contains a list of all the field names in the table, and when ...
0
votes
0
answers
270
views
How to disable one field by filling a value in another field in a MS access for
I have created a pharmacy database table. In addition to other fields, I have three fields: 'TypeTxn' (Text field) with Receipt, Issue and Loan Issue as three options in a drop down menu, Qty_R and ...
0
votes
1
answer
191
views
MS Access Forms Date/Time Entry Trouble
So I have a couple tables that I want to filter on their Date/Time fields. Here's a snapshot of the form controls that I'm experimenting with.
This will report will probably end up run on a monthly ...
- 83
0
votes
1
answer
170
views
(Microsoft Access) How to Input multiple new records with 2 out of 5 fields from being reset
I am trying to create an input form to input new entry into my table.
Basically, I have a simple table with 5 field. DATE, PERSON, Value x, Value y, Value z.
Every time I finished input a new record, ...
- 1
0
votes
0
answers
110
views
Why would MS Access Split form show different values in Form and Datasheet views?
I have a split form, one of the fields is price. In Form view part of that form, I get 4,000.00 €, but in Datasheet part I get 4,00 €. The correct value is 4,00 €. I didn't do any formatting of that ...
- 1
0
votes
0
answers
368
views
Which form event to use to update a form once form has loaded
A text box on my MS Access form needs to display a value once someone enters information onto the other fields in the form. The text box has a control source from a table so once someone enters ...
- 47
0
votes
0
answers
564
views
How to update a form field in MS Access once condition has been met
I need to update the Completion Metric field once a SubjectID is specified. Here is a sample of the data :
There is a form that is connected to this table and I need the Completion Metric field in ...
- 47
0
votes
1
answer
1k
views
MS Access - Passing Data from a Subform to another Form
I have a main form (Form1) which is used to search records and the subform to that form contains all records searched. Editing or adding data is not available in Form1.
I want to be able to click on a ...
- 1
1
vote
1
answer
1k
views
I have encountered #Name? error in access form
In Access Database I have main Form named "frmMain" and child form "frmPaymentsToAllAccountsTotal". The Child form is continuous Form I create a textbox on Main form and named &...
- 29
0
votes
2
answers
1k
views
MS Access form conditional formatting of textbox based on date not working as expected
I have an Access DB I've been working on that tracks the preconstruction work for each project we are awarded. I've included a form that is a quick glance at the status of some of the initial tasks ...
- 1
0
votes
0
answers
30
views
Create mulitiple nondefault Instances with New operator for Microsoft Access Form [duplicate]
I've a Microsoft Access form named frmProducts. To show simultaneously 2 products, I need 2 instances of this form. I've also frmMembers, frmOrders, ....
What's the general way to create a new ...
- 8,741
1
vote
1
answer
421
views
How do I hide/unhide a subform based on the input from two comboboxes?
I have a mainform, called TrainingsSU
In it I am calling subform qry_TrainingSU (built from the query of the same name)
I have it set up so that the records auto populate the subform based on the two ...
0
votes
0
answers
142
views
How to cause a subform to update in Access after filling in a combobox on the main form
I have a Query that I am using to fill in data on a subform. The query references in its WHERE statement two hidden textboxes on the main form:
SELECT *
FROM qun_TrainingSU
WHERE ([qun_TrainingSU].[...
2
votes
1
answer
523
views
Ensure Unique Records in Form (MS Access)
Using a Form in MS Access, I need to ensure only unique records are entered into the table.
It's unfortunately in a situation where I can't enforce unique records via the table's primary keys.
I have ...
- 51
0
votes
0
answers
33
views
Access Form don't create new entry because a one-to-one relation is not complete
In my database I have a tblCrewInformatio related one-to-one to a tblCouserExpireDate (Auto filled from another source and no edition available).
Not all Crew have Course information (because they are ...
0
votes
1
answer
457
views
How to create a new tab in a Microsoft Access form
I am learning about Microsoft Access and need to create a user menu to access other forms. I know how to make buttons/controls to open the needed form, but I cannot get it to open in a new tab
How do ...
- 274
0
votes
1
answer
1k
views
Make access subform only populate with button click [closed]
I am annoyed because I have done this previously but can't remember. I have an Access database with linked tables to SQL server database and a form which has a sub-form that is populated by a query. ...
- 1,921