| Thread | Last Post | Replies |
|
| Making all fields blank when form is loaded | 28 Feb 2006 21:58 GMT | 3 |
This is probably quite simple but i just can't work it out! Basically, I have a form with 2 text boxes, 1 combo box and a sub form (which reads from a query. The query reads from a table). What I'd like to do is, when the form is loaded, for the text boxes and
|
| How do I run a query from the switchboard | 28 Feb 2006 21:45 GMT | 2 |
I built a number of queries that I want o add as a submenu to my switchboard. I can't figure out how to run a query at all from a switchboard
|
| What does Me. mean? | 28 Feb 2006 21:39 GMT | 4 |
I'm new to using VBA and have a question. What does Me. mean when used in code for forms? I've seen that in several postings, but have no clue what it means.
|
| not seeing all of the quoteid for a given job# | 28 Feb 2006 21:11 GMT | 2 |
I have put in the following code to filter a quoteid drop down list based on the job # selected in the previous dropdown. There may be 5 quotes for example for one job# with the below code I am only seeing 1- the first quote for a given job#. would like to be able to see all ...
|
| I always have the top of the form in hiding when opened | 28 Feb 2006 19:55 GMT | 3 |
I've created a form with 5 tabs at the top of the page. Everytime I close the form and re-open it, the form shows up with the scroll bar NOT in the uppermost position, thus hiding my top tabs. Any solution for this?
|
| Display in subform insted of popup-table ? | 28 Feb 2006 18:56 GMT | 7 |
I have a mainform with two subforms on that shows all about a customer. I have now made a Dialogbox with a combobox where I can choose to see all the customers from the 12 different months. The result is being displayed
|
| Form/Subform - Two reference fields | 28 Feb 2006 18:11 GMT | 1 |
I have a form that has two relevant fields on it. "FILE" and "PROJECT" Linked to the "FILE" field is a Subform with a note. Because of the link, the subform table automatically records the "FILE" in which it was entered. I also need the "PROJECT" to be recorded in another field ...
|
| Limit Records in a Subform | 28 Feb 2006 18:09 GMT | 1 |
I have a subform as a datasheet within a form. I want to limit the number of subform records that a user can edit to three for each main form record. Any suggestions? Thank You for your time in advance...
|
| Subform will not requery | 28 Feb 2006 17:49 GMT | 3 |
I have a form with a subform. On the main form I have a command button that imports an excel file into the table that is the RecordSource of the Form and imports an excel file into the table that is the RecordSource of the SubForm. After the import process I do Me.Requery and ...
|
| Microsoft access record-locking. | 28 Feb 2006 17:36 GMT | 1 |
I am lost here. Even when i have closed the db it still shows as it being locked. I have been trying to inout some new data into the db and it does not allow me due to some MawRecords exception. Could anyone give me some advice? I think the 2 may be related.
|
| Editing data in a form that is linked to multiple source tables | 28 Feb 2006 17:26 GMT | 1 |
I've created a form in a database that pulls information from multiple tables. I'm now trying to set the properties in the form to allow the user to edit data in the fields on the form, which would then cause the field in the corresponding table to be changed. For the life of me, ...
|
| Changes to form causes slow opening | 28 Feb 2006 17:12 GMT | 2 |
I have a form which opens very quickly, unless I make any changes to it. Then it takes 10 - 15 seconds to open. Even such a small change as moving the field around. I tried making a blank new form, copying the fields and VBA code and this form will also be slow to open. I have ...
|
| Set Focus to the Form not the Subform | 28 Feb 2006 17:04 GMT | 3 |
I have created a form that has three subforms. Upon opening, the focus is on the first field in the first subform. I want the focus to be on a text box that resides on the main form so that I can easily use a command button to search the main form. How do I set the focus to be ...
|
| DateDiff to produce answer in 'yrs, mths, dys' | 28 Feb 2006 17:01 GMT | 5 |
This expression below works perfectly, but what I need to add to it, which I seem to have difficulty with, is to show how many days as well. =DateDiff("m",[Date of Joining],Now())\12 & " yrs " & DateDiff("m",[Date of Joining],Now()) Mod 12 & " mths"
|
| How do I stop changing records in forms with the mouse wheel? | 28 Feb 2006 16:35 GMT | 11 |
When I am in a form I don't want it to change records when I roll the mouse wheel. I would rather have it just slide the page around but if nothing else, I'd be happy just disabling the wheel function. Any suggestions??
|