|
ACCESS, HAVE BLANK FORM AND CHOOSE A TABLE OF MY CHOICE I have a client that created 8 databases and can only be viewed in the data sheet view. I want create a blank form that I can use a pull down to select anyone of the databases into the form and view and perform any functions that are attached to the form. Then blank the form so I can open another database etc.... 11 Oct 2008 00:22
Combox box filtered based on other combo box Hello, I have 2 combo boxes. One is a category, and the other is a subcategory. category combobox is cmbotype subcategory combobox is cmboreason My goal is to have cmboreason be limited only to the reasons that pertain to the cmbotype category. I have 2 tables: the category table is ContactID Cont... 11 Oct 2008 00:22
Wrap text in field label some of my field names are longer than the data contained in the field, how can i increase the label row height and wrap the field name text. in a datasheet subform. can this also be done on a table?? ... 10 Oct 2008 20:18
Updating data via email I know how to send out the email to database contacts to have them update their data but is there any way to further modify the form that is sent? Most importantly, can you make it so that the responder can tab from one field to the next? Thanks for any help! ... 10 Oct 2008 18:14
Copy a record into the same table Hi All, i am trying to copy a record into the same table prior to updating the original with a form. To achive this i am using the following code; Dim fld As Field With Me.RecordsetClone .Bookmark = Me.Bookmark Me.Recordset.AddNew For Each fld In .Fields ... 10 Oct 2008 19:16
Combo box Issue I have a different problem. My Combobox shows the correct data and delivers the correct info to each field that gets filled after my selection. The issue is some of the fields are not visible. They are entered but invisible. ... 11 Oct 2008 00:22
Sub totals on sub forms Hi All: How do I put totals on a subform. For example, I have an sales order form with the order details on a subform. I would like the Quantity and Extended Price of all the lines in the sub form to sub total for the order. Any ideas? Ed ... 10 Oct 2008 17:13
color codes I've been give, by the client, a color to be ued as a form header background (and a second for the menu form text). They aren't recognized by access... The RGB numbers are standard stuff, the #___ is something that the website guy uses(?) Is there a way to translate them to something Access understands? t... 10 Oct 2008 16:11
Alias or type of lookup question I know this has probably been covered there but I wasn't really sure how to phrase this so wasn't very lucky searching for an existing topic. And I'm not really sure how to ask this to convey what I'm wanting to do. I have values in a table, Field Name is Priority which contain L, M and H (for Low Medium and High... 11 Oct 2008 00:22
Many-to-many on form What is the best way to input data on a form in a many to many relationship I have three tables: Cell CellID - PK, AutoNumber Node NodeID- PK, AutoNumber Cell_Node CellID - Number Long integer, PK NodeID - Number Long Integer, PK Cell and Node both have their own forms. Node will become a subform of Cell... 10 Oct 2008 13:05
Form to look for similar addresses Im trying to create a form that will look for similar addresses to one entered and allow the user to choose from those addresses or use the original address that they entered. My database stores information on businesses, the businesses are organized by address. I have a addresses table and a businesses table, one ... 10 Oct 2008 11:02
Dfirst and DLast function Hi, Can anyone tell me how to get the first and the last record on field 'date' of my table 'table1'? I can't find it in help menu in my Access. Thank you in advance. KF -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200810/1 ... 10 Oct 2008 12:04
Form Control Default property problem Access 2003 (SP3). I have a Continuous form as a subform on a main form. The Continuous form has several bound controls, i.e. Text, Currency and Date/Time. The Default property of the date/time field is set to =Date() as I want today's date inserted when the user starts a new record. I have set the form's Fetc... 10 Oct 2008 06:56
Date and Time not updating I have created a switchboard in access 2007 and inserted the Date and Time, but as the database is on a company server, the time does not update itself as it does on a local machine. I find I have to shut down the switchboard and restart it to get thetime to update. Any solution to this problem please? Thanks... 10 Oct 2008 10:00
2000 database running inside 2007 runtime I have a access 2000 database that needs to run inside 2007 runtime, I do not have access 2007 full install. It runs ok in 2000 runtime and 2003 full install. When I run it in 2007 runtime, and i open a certain form, it request i enter a parameter called "Name", I understand that "Name" is a reserved word,. ... 10 Oct 2008 04:53
Problem getting a tab control subform to display correctly Hi all, I have a main form with a subform which is a 3 tab form. When the subform is opened by itself, the tabs display correctly. But if the main form is opened, the tabs disappear leaving only the controls from the first tab visible. In other words, there is no way to access the other two tabs. But if in view ... 10 Oct 2008 14:07
Option group on existing form I have recovered my database from my earlier memory issue. I am trying to add and option group to the form to add a check box for 4 options. I have two other option groups already on the form. When I try to save the form, it "crashes" wanting me to report the error to Microsoft, repair and re open the dat... 10 Oct 2008 01:50 |