| Thread | Last Post | Replies |
|
| Cascading Combo | 10 Aug 2007 16:24 GMT | 2 |
I have forms where cascading combos are used to select data in orderto create reports. I am now trying to create similar cascading combos but on a form that enters data to a table. Currently i have not been able to manage this. The two
|
| Change address fields in Table using Unbound Combo Box | 10 Aug 2007 16:18 GMT | 18 |
I have an Access Database populated with the names and addresses of approx. 12,000 names. The main Table is named "VoterInformationTable". The primary Key Field is "ID". I also have a Form named "VoterInformationTable". I created an unbound Combo Box on the form named "Combo316". ...
|
| Duplicate forms | 10 Aug 2007 16:02 GMT | 2 |
I want to ensure that two copies of a form are not running at the same time - I don't care of its the first or the second that runs, but not both, or subsequent. As always, I thank you in advance in for kind consideration.
|
| Control Source SQL syntax | 10 Aug 2007 15:20 GMT | 2 |
On the Control Source of an element on a subform, I've typed "Select Reason_Description from Reason_Codes where Reason_Code=[Me]![Reason_Code]", where Reason_Code is an element on the subform line. I'm sure my syntax is incorrect (or at least Access doesn't like it, lol).
|
| Repeating text in field | 10 Aug 2007 15:06 GMT | 10 |
I have seen many posts with this subject and many different answers. The answers always respond with Default Value and new records. I inherited a db that has a main form and subform. The records already exist in this db. There will not be any new records. Only be using ...
|
| User Criteria before Adding A Form | 10 Aug 2007 14:56 GMT | 3 |
Hello, I would like to have a checklist that appears once a user has completed the form fields and tries to go to either close the form or add another record. I would like to use this checklist popup that prevents the new record from
|
| Can't Edit in Subform | 10 Aug 2007 12:28 GMT | 5 |
I have a form with a subform, a one (form) to many (subform) relationship. I can edit the data on the form, I can edit the data on the subform when it is opened standalone, but I cannot edit the data on the subform when I open the form (with the subform).
|
| Place date on form when execute command button | 10 Aug 2007 10:06 GMT | 5 |
I have a form that has several command buttons that execute different queries and either displays in a report or export to excel. However, one of the command buttons "updates" - runs several queries to update the data tables. I want to be able to add an updated last field onto
|
| Linking Mainform and subforms | 10 Aug 2007 09:36 GMT | 3 |
Im a new user, Ive designed tables and several subforms. In the mainform, I have four tabs but they are separate source table.the first tab is the main form source employer profile, the second tab until the fourth tabs are subforms to allow multiple entries. The mainform and ...
|
| Cannot delete records in subforms | 10 Aug 2007 09:22 GMT | 2 |
We recently upgraded to Access 2007. After the upgrade, we can no longer delete records in subforms. It appears to allow the delete, without confirmation message though, but when the form is reopened, the data "returns". Watching the table, the data is never actually deleted. I ...
|
| Resize Forms in Access 2007 | 10 Aug 2007 05:31 GMT | 2 |
I thought I read somewhere that Access 2007 had a new function, or something, enabling you to have forms automatically resize to fit the screen resolution of the user. Is this correct, or am I wrong? If I am correct, how do you use this feature?
|
| Subform shows over control set to bring to front. | 10 Aug 2007 03:58 GMT | 2 |
I have a text box and a rectangle filled in. I also have a subform that I wish to be behind the text box and rectangle until called. Subform is set modal=no, popup=no. Problem is: Even sending subform to back and controls to front....the
|
| Hiding Duplicates Reports | 10 Aug 2007 03:34 GMT | 3 |
I have a form and a subform. On the form is the name of a report and details of the report, for example "Report 1" and then the subform contains any changes that are made to the report details over time so "change 1", "change 2", "change 3". I would like to print a report that ...
|
| Combo Box Input | 10 Aug 2007 02:56 GMT | 3 |
Hi I have a combo box that takes dates from a table. I want to put that date in the field of another table that i have created a form for. The format for the date in the [Date Table] is date/time short date. The format for the field in the table with the form is the same.. ...
|
| Email text from field in form? | 10 Aug 2007 01:04 GMT | 1 |
I am using my employee database to track messages I pass along. I have a Messages form that successfully creates a message for the person I have looked up in another form. I want to enter the message in the form I have created (becomes a record in
|