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...
I am trying to filter a report based on criteria selected from a form. Here is the basic query I am using.
SELECT [Technician Table].[Tech ID], [WorkOrder Table].WorkOrderNum, [Services Ta...
I'm trying to create an Access 2007 form that allows a user to work on the content of an order (tables stored in SQL Server Express). Because I want to allow the user to "change their mind" an...
Within a form, will be changing the record source of a combobox. I'd like to have the combo box set to the value in the first row of the recordsource. Is this possible, without opening the un...
I have a subform that is based on a query which looks to the value in the combo box.
Combo Box OnChange event contains subform.requery method
The combo box on the subform from a column...
How do you tab to the next control on your form using VBA code in an event subroutine?
I am using Access 2003 on an XP machine.
I think I have done this before, but I can't remember for sure. I have a long form that I would like to beable to use the mouse scroll ball to scroll through, but when I move the mouse down, i...
How do i code the "OnClick" event of a command button to open a hyperlink. I know i can set the hyperlink address to a web site but i need this in the "OnClick" event property.
Hey All!
For some reason I cannot get CDO to resolve the Alias name in this VBA code. When I put the actual email adress in, it works wonderfully but I need to put the alias in and have it ...
I have a pivot table which is showing totals on the left hand side (even though I am not displaying numbers) and I need to get rid of the totals, any help would be appreciated. I then need to...
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...
Hi!
I have two tables: PatientData table with NumberID as unique primary key with no duplicate, LastName, FirstName etc; ProcedureData table with NumberID (Duplicates YES), ProcID (primary ke...
Message box from Visual Basic code includes the control box "X" so that uses can close the box without selecting "OK".
How do I remove or disable the "X"?
I have other pop-up boxes using "O...
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...
So I have a table called Requirements and in the table there is a field called Description which is type Memo. As listboxes can't display more than 255 char, I want the Description field to s...
I created a text box (txtText) and pasted this function in the Control Source:
=GetTestType(Nz([cboTestType]). This text field is used only for display purposes.
When user selects an item ...
I'm using tabs in a VBA message box:
EXAMPLE:
MsgBox "This is the header line" & vbCrLf & _
vbTab & "* an indented line" & vbCrLf & _
vbTab & "another indented line"
...
I'm teaching myself how to use recordsets
A form, frmRecordset has a single command button, cmdRecordset, and a text field, txtName
This form uses a table, tblProspect, as its Record Sourc...
I am using access 2003.
I have a database with just one form, switchboard form.
I am using this switchboard form as portal to open other database.
What I need is to open switchboard form ...
Hello Experts,
I am creating a brand new database and my very first form.
It is a very basic form with only 2 fields displaying. For some reason the I can not get the page header to disp...
How can I force refresh form and 2 subforms in a MS Access 2003 with VB, I created a refresh btn with a wizard and it does not work. Access says "an action or cmd refresh is not available now"...
Would somebody be able to point me in the right direction?
I am in need of gabbing a vbcode to do the following:
I need to filter a listbox that will be contained in a form, over a ton o...
MS Access 2003 -
I have a sales order form. In the form footer, I have a complete button that runs several queries, but has two different If Then statements that fire off before they are al...
Windows XP MS Access 2003. I would like to dynamically create form objects such as rectangles or textboxes & labels at runtime and place them on the current opened form. MSDN states that: "You...
When I attempt to edit a specific form in the DB the application crashes with this error:
*****************
Faulting application msaccess.exe, version 11.0.8166.0, stamp 46437912, faulting m...
