I want to create a command button on my access form that when clicked opens a folder on my directory that relates to the record currently being viewd. The name of the folder is the same as one...
I have been pulling [what's left of] my hair out trying to reference a fourth-level-down Sub-Form in a Form using VBA and keep getting road-blocked. Can anyone give me the correct syntax? I ...
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 created an Access 2007 database for a Client that has a form to add or edit records. The source of the form is a table. The first day there were no problems, but the second day, the client...
Hi i have a table called InvoicedCommDue and also have a form called InvoicedCommDue that displays certain fields from the table. Most of the table is populated from an append query but there...
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...
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 ...
Hello All:
I've been running into the following problem; I have a MainForm which has a Tab Control, in it, there is a SubForm which is based on a Query which in turn gets its data based on ...
I have crated a database from new, I have picked Date Picker in the table and on the form, I have placed a date format in the table to 01/01/2008 format. How every my Date Picker does not come...
Hello experts
I'm sure this is the simplest question ever, but I'm short on time so here it goes:
I have a table of information on teachers (Name, school, and notes). I want to have a f...
I have a form where the values are entered into a table called TblTrainingInfo. The form has a Combo box which has a SQL statement which provides the training types to pick from a table calle...
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...
Hi Experts,
I have a calendar control I want to become visible when the date combo box is clicked. Below is what I have, nothing happens when I click the combo box. Thanks for your help. T...
I have a list box with four columns. The first three are ID, Address and City. The fourth is a sales number that I would like to be right justified for ease of reading. Is this possible? T...
How can I do this?
I have a form with three tabs.
I want my users to be able to change records on tab one, but not on the others.
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...
Hi
I have an Access database which I am trying to migrate to SQL Server 2000 for the back end, but keep the front end in Access 2003 for now. We have a query which runs and selects the las...
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...
Right now I am using a temporary table, but I suspect there is a way to do it with a recordset. I'm using Access 2007 DAO FE with SQL Server 2005 BE. I have datasheet subform based on a temp t...
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...
I am trying to format a MS ACCESS form label or text box in the vertical position, with the text begining on the bottom and reading upward. The build-in property VERTICAL , sets up the label v...
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...
Dear expert!
I am stumped on this one - I have a continuous form, and users happily use the right-click on a given field to sort Asc/Desc on that field.
However, there is a combo box on ...
I have 2 issues both relating to an unbound form. The project is in Access 2003.
I have a product table that requires multiple serial numbers as well as a note field. The note field in th...
I have an Access database with a single table containing 13 fields. I need to design a form which will update its contents when the user changes on of the input fields.
The form will have s...
