When using access to work out the time difference between Start Time and End Time I'm using:
=DateDiff("n",[StartTime],[EndTime]) in the Control Source field in a form.
This returns the ex...
I d like that m'y forms open without any other Access element visible, just with navigation butons, preferably in full screen.
Is it possible and how?
I need to launch Excel from an Access form control and open a spreadsheet that has an Auto_Open macro attached to it without running the macro. I know I can do this by using the /safe command...
Hi All,
I am trying to run code that I have assigned to a button on an MSAccess form. The code creates an SQL statement which searches the database for an address. I want to run the code whe...
Hello,
I am having a touch of bother deleting a record from a form command
The code I want to run will ask a question before the code is fully run. Once the user presses OK, the script th...
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 ...
I have a form in MS Access 2003. On the form I have a combobox dropdown.
When the form moves to a new record, the query for the combobox list is automatically refreshed using a query 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 simple Access 2007 ADP connected to SQL 2005 server. I created a main form with a single subform ( an order with order details). Each has their own datasource (tblOrder and tblOrder...
I have a form with two combo boxes for users to select Client Name and Date. I would like the Date combo box to only show dates available for that client. If the user wants to add a new reco...
I have a problem with a pair of combo boxes that I am trying to use to query a table based upon the selections made in said combo boxes.
route_combo selects the distinct route from table In...
I have an Access 2007 form. On the form I have a ClientID field. I would like to have a Select Client button that the user will click and open a Select Client form. On that form, I would ha...
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...
Hello-I am building a database in MS Access 2003. I have a main form, "frmMain", and a subform, "frmSubDash". The subform is in the main form and displays two items, "txtReportName" and "txt...
I have a form which has five different "areas" on it where the user enters information. The first 'area' is a combo box (created via the wizard) where the user selects a customer name and th...
I'm looking for a drag-and-drop calendar interface (similar to the Outlook interface) that I can drop in an Access mdb file that fronts on a SQL Server Express DB. Alternatively, a VB.NET cal...
I want to have a pop-up window to add several data items into the open form. Here is what I am trying to do:
I open a form, click the new record button. I would like a window to pop up and ...
I am trying to perform a calculation in the middle of some text that will all be used to populate a text box on a form. Here's what I am doing. the overflow occurs on the line that starts with...
My form (frmAccounts) has a control button which opens another form (frmCommissions) - see code snippet.
However, if in frmAccounts the user has not chosen Commissions (AccCategoryID = 1) I...
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...
Morning,
I have already asked this question and had it answered but I am now encountering more problems. I had a text field with multiple lines. I want to add more and more data to it as my p...
I have a form with a query as the record source. there is an expression in query named TimeCalc. I am trying to place that field in the form with the text "hours" following it. I have tried...
Hi all,
I am trying to construct a dlookup on a text field to find the 'Attainment Comments' from the table 'risk2' where classcode(in table risk 2) is equal to the mondaytxt textfield on m...
Since installing Office 2007 yesterday I have been unable to modify the VBA code behind "on click" events attached to a field or combo box in an Access 2003 database.
As soon as I click o...
I have a multiple column list box. I need to iterate through each row and read the column values
What is the syntax?
For example:
Dim intCtr as integer
Dim strCol0Value as string
Dim ...
