Im having a problem with form filters in Access 2007. Ill try to explain it clearly&
- I have a form called Contact General whose record source is the table Contacts .
- On the f...
Hi -
I'm not so good with Access/VBA and need some help. I have a form that has a combo-box and a multi-select list box. I'd like the selected items on that combo box and list box to eac...
Would anybody happen to know of a way that I can have a form automatically display the "Default Value" on some text boxes in a Form?
The default value works like a champ, but the values are...
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"...
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...
Hi,
I have an access application that contains tables linked to an Oracle database. The ODBC driver I must use is the Microsoft ODBC for Oracle. When i sue the attached code to connect to Ora...
I am using a text box and a listview control on a form. The user selects an item from the listview to edit, this populates the text box with the text that can be edited. As soon as the user ...
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'm currently working on a small custom database for some specialized auctions. The auctioneer may sell one, or multiple items at a single price. In fact, during the middle of bidding, he ma...
Hi guys
Problem: Access 2007 does not appear to allow me to size forms in Form Design, so when I open a form modally it is those exact dimensions.
I have recently discovered Access 200...
I have to prepare a form for inputiting a particular piece of information at various tables / fields. Previosely, I had used check boxes for multiple selection and thereafter retrieved the inf...
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?
Hi guys.
Right i have a form with a tick box labelled [IN STOCK]
i also have a a field called [date packed]
using expression builder i would like to write an expression that when [in s...
I need to add a list box to an Access form that allows the user to select multiple choices. When the user selects from the list, are the results sored in a single field in the underlying table...
I have a primary form that if you double click on a drop down it opens a popup form to enter data in another table. When I hit save on the popup form I need it to requery the info on the subfo...
My form has bound textboxes which I would like to limit to 2 decimal places during the data entry process and not "formatting" afterwards.
The field in the table set to Double.
The form fi...
Let me preface by saying that I've been more of process and systems flow designer for the past 15 years and find myself without a developer to build my design. I'm building a prototype and kn...
Hi Experts,
I recently modified a form such that its record source used to reference only one table, now it references multiple tables. As soon as I did, I could no longer add or modify data ...
We have an access db that is growing. The issue we are having as we create more and more forms is a growing lag when switchin to design view on many forms. It also lags a lot when viewing the ...
I have a MainForm (data from tblMain) & a SubForm (data from tblDetails, 'Continuous DataForm). tblMain has a 1-to-Many relationship with tblDetails through primary key PKMain. A field on Main...
This question does not relate to the funtionality of my database, but I believe that it will increase the level of professionalism in the database's appearance. I have numerous subforms, all ...
I am wondering if it is possible to create a form that displays tabular records in the detail section. Then in the Form Header or on a main form (and the tabular would then be a subform) to h...
I am using a calendar (ocxCalendar) to enter dates into a form and the date is currently being displayed as 08/04/2008.
I need to be able to change this so that the date includes the day. S...
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...
I have a form/subform linked by Organization_ID. The subform populates the Donation table. The filter is working fine but I would like it to default to a new record in the subform when the c...
