Hi,
I have a form in Access. Everytime I need to open Access, then click on the form name to open the form.
How to make the form open automatically when I open Access?
I'm using MS Access...
When I try to add the Microsoft ActiveX control - Common Dialog (Comdlg32.ocx) the message appears:
"You don't have the license required to use this ActiveX control"
I have registered the ...
I am creating a book register for the office. Most of them are actually reports and guidelines from various government department. I have created a table called author to store the name of the...
I have a working login form in Microsoft access. When the user logs in successfully, they are presented with a splash screen that will be the main menu for the database. When saving new record...
This is simple but I can't figure it out. I created a form on MS Access, and I want to fix the AfterUpdate event of a control named UserID such that after entering a value in the UserID, the f...
Greetings,
I get a Write Conflict error that requires me to click the save option numerous times. The error indicates that "This record has been changed by another user...."
I think it is...
I have a subform (called Chemical Analysis which is associated with the ChemResults table) where a user enters a string into a text field (called Melt) and then presses the tab key. It then ...
I have a form that you can pull up specific clients and all their data.
There is a subform in this form that has data on service dates for a particilar client. If there are not service dates...
I am populating a list box using a recordset from a SQL Server database. when ever I try and remove and item using me.listbox.listindex it takes forever. Does anyone know how I could optimise ...
I have a command button (cmdPurchaseOrderPrint) on my form (Orders) that opens a print dialog box for a report. When I click 'ok' to print the form I see Error # 2585, This action can't be ca...
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?
I have a form that verifies username and password (from tblPeople) and this is working fine. I need to include in the button click event code that will add a record to the sub form or sub tabl...
I have a 4 column listbox which is populated from a recordset.
I can locate the index of the selected row.
What is the syntax for reading the value of one of the columns?
Private Sub ...
I have an Access database. Within that database a form has a control field defined as Dlookup. This field will not update the table. How can I use Dlookup and update the field in the table ...
Hello, I have a parameter query which is filtered by a form combo box. There are 4 tables with appropriate relationships and joins in the query. I have the following criteria in one of my fi...
I have an Access database created in version 2000. I am now running it in 2007 and when I go to add records to a table in datasheet view there is a field with a numbering sequence... 1, 2, 3...
I'm trying to create a function that hides and unhides subform columns through the use of a list box. It is working incorrectly as it is hiding and unhiding the wrong columns. This is a chal...
I have a one page report that prints out all the people in a phone number list. The list is made up of a query. The report groups the entries by location. There are 6 different locations, and ...
Greetings,
I am using the DTPicker and I want to avoid the checkbox that is necessary if a null value is needed. I don't want any null values and so I try to turn the check box off in the pr...
I am developing an access database and would like to have some forms / sub forms which do not display the standard MS Access navigation bar (with the first, next, previous and last buttons). ...
Hi Experts,
I have a form frmA. In this form I prompt the user to enter a caseID that will match to myTable.caseID.
When I click on Enter botton on frmA, another form frmB will pop up with...
I am dealing with patient accounts being denied by insurance companies. When the denials of payments come in they are entered in a form by account number (Account# - a long integer - 9 digits...
Hi Experts,
I'm creating a MS Access 2007 form. It's been a long time since I've done any Access so I'm struggling a lot. I need to have a combo box on my form that gets its values from a...
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!
Hey Experts, I am asking this on behalf of a friend.
She wants to change the color of a form in an access 2003 database if it is overdue?
we found:
if me.yourformfield > aCertainnumber ...
