If I bind the results of a query to a form. (Data Sheet View). How do I then allow the user to change field contents?
I have a database where we store client issues and a data access page where we can view, edit and enter issues. There is a field for clinet name, account manager, account manager phone and ac...
I'm using a list box (List0) Multi = Simple. How is the selected data stored and how can I access it.
I have a complex database with heaps of forms and extensive use of subforms.
I sometimes have to use continuousforms in a subform and generally this is fine for simple lists of records.
Howe...
I have a continuous form that select 28 rows from a record source. When I apply a filter to this record source, I get 1 row and the navigation button count says "1 (filtered)". However, when I...
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 ...
I have an unbound list box that was populated by an ado recordset, then disconnected. When a row is selected, I would like the user to click an arrow button to apparently move the selected ite...
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 ...
The TextBox control in an MS Access form can have a scrollbar but does not recognize the mouse wheel for scrolling. I would like to scroll with the ctl-Up/ctl-Down keys, but can't find anythin...
I want to create a shortcut in Excel that will open a database to a form. I currently have shortcut that looks like this"F:\FrontEnds\Inspection - Front End\F824000.mdb" but I want the hyperli...
I am creating a simple database and form in Access 2007. Can anyone offer me assistance in figuring out how to display a radio button or checkbox horizontally on the form.
Right now if I ha...
OK so I'm obviously making a very basic error here - but all I want to do is programmatically add some controls (such as a cmd button) is response to a user click.
So searching around, the ...
I can't believe I haven't seen this bug reported yet for Access 2007 - am I missing something?
Each tab in the tab control has a property "Picture". Click the builder icon (...) and select...
Hoping this is simple
I have a field in a form and a record(string) in that filed and when I double click on the particular record in that filed (note it is a continous form) I want the stri...
I have a combobox on a continuous subform. I would like the dropdown list to be different on each record depending upon another field in the record. I have a query that accomplishes that (see ...
I have a continuous form where there is a combobox in the header that contains only SS#'s. The continuous form has the data record for all SS#'s.
Whe I select a SS# in the combobox, I want...
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 a series of controls (text boxes) that require the user to type a single number. Currently the user needs to press enter or tab to move to the next control.
How can I save users the...
I have an access database that was created using Access 2003. I have installed Access 2007. When I open my database using Access 2007 the command buttons on forms do not work. Even a comman...
How can I determine which control currently has focus on a form?
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 ...
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...
is anybody aware of how to use a list box column as a criteria in a query?
basically i have a list box based on a query, and the 2nd coloumn (column(1)) i want to use as a criteria....this ...
Hi,
I have a table, "Websites", that has two text fields: "DisplayName" and "URL". I want to use this table as the source for a combo box (i.e. Select DisplayName, URL from Websites) that w...
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...
