Hello
When I display a form and the fields are displayed as a datasheet if I click in the left most column it selects the entire row, I beleive this is called the record selector. I want to...
Hello,
I have a form and a subform. I would like to create a one-to-many relationship, however when I create a new record within the main form, my subform won't allow new data to be entered...
What I want is to require the user to enter 1 address(in a sub form) before leaving the main form. All but line 2 of the following code works if the cursor is on the 1st record. However if ...
Simple question: On a form in Access, I update the value of field 2 from an AfterUpdate event on field 1. How do I get the contents of field 2 to automatically display on the screen. At the mo...
Hi:
I have a form that I've converted over to HTML, but now some of the commands don't work bcs its obviously in a differnt language (originally done in VBA through Access).
The code that ...
My question is similar to question 21687496 but not exactly the same. What I'm trying to do is actually simpler but I'm still having trouble.
All I want to do is execute a stored procedure...
I have a form/subform linked by Organization_ID. The subform populates the Donation table. The filter is working fine but I would like it to default to a new record in the subform when the c...
I have an access database that is used as a front end for a SQL database. Part of its function is to store CVs in the database and I have a function that allows the user to view the stored Wor...
Have the following VBA, built from the wizards. Can I easily add a message box to indicate when input is not found. Thank you
Private Sub Combo32_AfterUpdate()
' Find the record that...
I have a Form where I can enter the "UserID" in a TextBox so the related info will be displayed.
I want to add Validation Rule to this TextBox. If the UserID entered is not in the Field [User...
I have a dropdown combo box. A user can either select a date from the list or type on in. The problem is when I start to type in a date, the box auto fills with the bound column which is not...
I have an Access Database with a lot of forms and I dont want to recreate them. Is there a way to convert the forms and further develop them in Visual Studio 2008?
Dear experts,
I have a web page that I display with an MS access form.
I have done this by inserting a Microsoft Web browser Active X control and placing the following code on click of a...
I would like to FIND and OPEN a SPECIFIC PDF File within MS Access. My MSdatabase is over 17000 records with many fields (this is a law firm). We have PDF files related to each account contain...
I am currently trying to alter my database to represent data better...
What I have currently got is a technical database with various tabs with client information. One of these is a broadb...
I'm having problems requerying data in a combo box on a form in Access 2007. The form (its a "continuous" form) is based on a table that stores two particular fields among several--a "SchoolID...
I am trying to develop an interface for Access where Engineers can enter test data. They are currently using an Excel version that is very cumbersome and non-standardized. This makes it impo...
I have form with a textbox bound to the Name of a client in a query (Client_Name) and a combobox with a list of ID's (Client_ID's). When a user wants to edit the record, he would choose the ...
HI Experts !
I don't know why, but I am trying to use a very simple method here called "select case" and for a reason I ignore, it simply doesnt want to return any value.
I am changing the...
Is there a way to change the rowsource of a subform?
I have an In/Out board subform whose rowsource is contingent upon a combobox in the parent form.
The records in the combo box are peo...
My form has bound textboxes which I would like to limit to 2 decimal places during the data entry process and not "formatting" afterwards.
The field in the table set to Double.
The form fi...
I need to add a list box to an Access form that allows the user to select multiple choices. When the user selects from the list, are the results sored in a single field in the underlying table...
For my department I built a simple MS Access database.
It contains a form with the ActiveX Control Microsoft Date and Time Picker Control 6.0
A coworker of mine can access the form but t...
Hi everyone,
I have a number of combo boxes on a form. When select there is a textbox for each one that grabs the column(2) value.
How do I sum these textboxes?
Thanks
Jetera!
Hi,
I have trouble with an Insert command when one of the fields being inserted is a DateTime Field. Here is my code:
command.CommandText = "INSERT INTO Book (UserID, CardID, Gr...
