I don't understand what causes this, since I have not added any code yet, and it seems to be an issue with the sub-form or its detail properties, however I have attempted changing each by tria...
Access 2003 - I have a form with two text boxes and a list box on it. I want one text box that looks up a company name (or even a few letters of the company name), and the other text box look...
I have been working on this ONE issue for over seven hours. I'm on the point of exploding.
My main form has tab controls. Tab1 is a subform, Tab 2 is not, and Tab3 is another subform. ...
I have a form in Access 2003. THere will be two names / email address associated with each form. When i am on the form I want to be able to click a command button and send some of the infomra...
For a mulit-select listbox, is it possible to write code to automatically select certain values from it based on information stored in tables? If so, what would that code be? I can give furt...
I have a field on a form that stores a directory. What I would like to do is use a command button to open this directory.
Please see the attached picture.
Basically all you would do is clic...
Hi ,
with Access 97 , I can open a query and the get value into a record set
Dim rsttest As DAO.Recordset
Set rsttest = CurrentDb.OpenRecordset("qselContactFeeder", dbOpenSnapshot, dbReadO...
Greetings,
I have a 2 forms, one form and a subform, that calculates time equations on the fly. I needed the values to allow for null values that works also. I got the visible field to w...
Hi,
I have Excel spread sheet with Cust_ID, Name and Address Column.
Cust_ID is unique but ther are multiple records for Name and Address..
How do I get Unique record please ??????
I want...
Hello,
I'm trying to create a new ID for any additional records we add into our database. I started out by creating an entry form that (all unbound text boxes) with 2 buttons one which I wi...
Hi
I Used a Tab control in my form and I want these tabs starts from right to left. as u know It stat from the tab that is in left side of this control, by defult.
Is there any way That I ca...
I have a text box that has the datefield of the table in its control source. When the user use my form they see a little calendar on the side of the text box and click on the date of their cho...
Ok a great query was written for me in this thread.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23616492.html
I have been able to build off of this and c...
Rick_Rickards has stated that he needs to examine code in more detail to better determine what still needs to be cleaned up before attempting to gain scaleability for the form. I have made th...
I have a search form with a subform in MS Access 2005. The subform is based on a pass-through query and is set to datasheet view. On the main form I have a reset button that clears the field...
I have an OnCurrent Event that states that under a certain value the background color changes on a form. I have made it so that the background color is either white or gray for printing. It ...
I have a form that has its data coming from a query that has a "name criteria". I recently added buttons to the top of the field columns in the form that allow you to sort each field by clicki...
Hello Experts,
I've been working really hard on my first Access database.
Everything looked really good, until a few minutes ago. I just realized that my
combo box selections are not be...
Hi,
I have a form in Microsoft Access 2003 with a button when the user clicks on the button, the button runs a macro, the macro prints out a report. However before the report is printed id ...
The "related question" in blue below is causing issues with the spell checker if it is removed. I don't wish to use the spell checker any more for other reasons. Is there any way to remove t...
I'd like to make some changes to the form's cosmetics. Any single fix will be accepted as a solution and I will post follow-up questions as required.
scaleability:
scale frmTasks to expan...
Hi all.
I have an access2003 form, the end user enters a value in a text box, I want to be able to search a query or table to see if what the end user entered is in the query or table. If i...
Please excuse me as I have very little, actually no exp. with Microsoft Access. This seems like it would be an easy question for you experts to answer, but a EXTREMELY difficult one for me. ...
Hi,
I have a form with a listbox on. The listbox has an evet on the doubleclick set. It opens a second form whch is filtered on the item that was double clicked.
My problem is that it ...
I NEED TO SELECT FROM TWO COLUMNS. MY EXAMPLE IS 'SSN' AND 'SSN2'. THIS IS TWO PEOPLE IN THE SAME FAMILY THAT WOULD BE ELGIBLE FOR MY CRITERIA. i HAVE TRIED PRENTHESIS, AND/OR AND OTHERS. ...
