Stack Overflow
Stack Overflow

Questions tagged [ms-access-forms]

This tag should be used for questions concerning forms & form controls in MS Access.

190 questions
5
votes
1 answer

ms access form: combobox to multiselect dropdown menu

I have an ms access db which was made a few years ago for my company. I am trying to change a form entry from a combobox to a multi-select combo box (Check box). Currently, only one value can be saved and I would like a number of values to be able…
Alex
  • 51
  • 1
  • 1
  • 2
3
votes
2 answers

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 forms. This is a problem because one of the forms…
Zachary Weber
  • 455
  • 3
  • 15
2
votes
1 answer

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 the following code in the BeforeUpdate for the…
Jay May
  • 41
  • 5
2
votes
2 answers

MS Access Error 3188: Could not update; currently locked by another session on this machine

I have a form bound to a table with a long text field (form_conversationDetail). I can add and then edit and save the same record until the number of characters in the field goes over 2000. After that, I start getting the following when I attempt to…
Ashwin Nirmul
  • 61
  • 1
  • 8
2
votes
2 answers

How do I get the 'Value' property from a MSAccess Form textBox while it's being edited?

How do I capture the value being typed into a MS Access Form's textBox control as it's being edited? I'd like to show results of a search (in a listbox) that's updated with each new character added to the textBox used for the search? The query is…
Matt Murphy
  • 331
  • 2
  • 11
2
votes
1 answer

How to Display all Query Results from Access Form

I have an access Form which I am using to filter a query by referencing the Form Fields in the Query Criteria. When the form is opened, the user can select specific entries from the below field drop down lists. However, where the user doesn't…
JDT
  • 107
  • 3
  • 14
1
vote
1 answer

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. Here's my current setup which only calls the…
Tom TK
  • 65
  • 9
1
vote
1 answer

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 comboboxes in the main form. But what I need to…
Christopher J. Joubert
  • 144
  • 1
  • 1
  • 9
1
vote
1 answer

Using unbound control value in an SQL statement

I would just like to use an MS Access unbound control as criteria in my VBA SQL command. The unbound control is named AssignInvoice Here is what I have: Private Sub Command64_Click() Dim InvNum As String InvNum = Me.AssignInvoice.Value …
BWSsteve
  • 15
  • 3
1
vote
0 answers

Hide text boxes based on data in a text field Microsoft Access

I am fairly new to Access and i am trying to make a form where the available text boxes depend on the data in a field. I have made a split form and i would like based on the existing data in the selected line "product" to have the boxes "author" and…
Alex
  • 21
  • 2
1
vote
1 answer

Update Caption of Page from Page itself

I need to update the Page Caption on a Tab Control in Access. I tried the following code: Private Sub tabName_AfterUpdate() MyTabControl.Pages(Me.MyTabControl.Value).Caption = Me.tabName End Sub This works well to set the Caption, but after using…
Blacksmith
  • 27
  • 7
1
vote
0 answers

Formatting only First Row of table

I have an MS Access continuous form on onload event i am getting MyTable Record, upto here its fine. But i want to change the color of only first row MyTable Id ¦ Name ¦ Months ¦ Years ------------------ 1 ¦ Ali ¦ 01 ¦ 2020 2 ¦ Umar ¦ 02 ¦…
Usman Saeed
  • 23
  • 5
1
vote
1 answer

I Cannot Select An Item In An Access Combo Box

I have an access form that includes a combo box. I load the values in the combo box from a value list. While the combo box opens and I can see all the values, when I click in it I cannot select a value. I click but nothing happens. The combo box…
Bytor
  • 33
  • 4
1
vote
1 answer

If a date field is empty then how can I compare the date from another field

I have form where a user puts in a date but I want to stop the user from inputting a date which is more than the date on the main form if the date is mentioned and the date shoud also be less than the date already on the same form which is the Date…
jef
  • 27
  • 5
1
vote
0 answers

Sending access form as pdf with pdf restrict editing feature

I have an application in Microsoft Access which sends forms as PDF files via DoCmd.SendObject to outlook. It works fine, but now, I want to add protection (restrict editing) for the PDF's to my program code. How can I do that because of the…
rashesh
  • 11
  • 2
1
2 3
…
12 13