Description:
Microsoft Office Access newsgroup.
|
|
|
Updating a field in a Table with a subform field
|
| |
Hi, I have a form that has a subform. I would like to update the Table that is bound to my form with the info from the subform once the use is done entering the info on the main form. Ex. I want the stockcode field in the subform to update in the stockcode field in the main form's table. Thank You... more »
|
|
|
How to start a split form when I click on a menu page
|
| |
I'm using the 'page' menu of 2007. I want to automatically start a particular split form when I click on a particular menu page. I have tried to place a subform on the page, but I could not get the form to open as a 'split' form. I would prefer doing this with a Macro. Bob
|
|
|
Display billing month based on start date and end date
|
| |
i have 3 textbox in a form with date type as date. 1- StartDate (bound to table) 2- EndDate (bound to table) 3- BillingMonth (unbound) i want to display billing month based on start and end date according to criteria that if startdate is 1/1/09 (format dd/mm/yy) and enddate is 28/1/09 (format dd/mm/yy) , billingmonth should display [Jan-2009]... more »
|
|
|
Cannot enable editing of some fields
|
| |
I am working with a application that I did not create (Access 2007) I cannot seem to be able to allow editing of some fields on a subform. I changed the properties to Enabled (yes) and Locked (No); but I am still unable to edit the desired fields?
|
|
|
Combobox Value Will Not Change - Until I Right Click?
|
| |
Not certain how to describe this one. A combox is placed on a form. The form is called from a continuos list via a mouse down event. If Button = acRightButton Then DoCmd.OpenForm "frmTask", acNormal End If The form, frmTask, has absolutely no code behind it. It has a combobox with a row source type of "value list" and a row source of... more »
|
|
|
format headings in datsheet view for subform
|
| |
Greetings again, For a subform in datasheet view, is there a way to format the column headings of the form? I have a control named txtName,so of course the subform dispays the column header as txtName. Is there a way to change this without renaming the control? Also, can the justification be changed. Cannot find any way in... more »
|
|
|
intermittent error message when editing data in a form
|
| |
I'm running Access 2003 with the back end on a network server, and multiple users running their individual front ends from their local C drives. The users sometimes get this message when they try to edit data in one of the forms: Write Conflict This record has been changed by another user since you started editing it.... more »
|
|
|
Need an unbound text box and command button (Search)
|
| |
I need to create an unbound text box with a command button (Search) on my form which will enable the user to find the current record for a space no. I would like the user to only have to type in the space no. My fields are: SpaceNo Current "Yes" I am not experienced at writing code. Thanks so much.
|
|
|
Ways to Start a particular form?
|
| |
1) I want to automatically open a particular form when the Access file (Access 2007) is opened. I would prefer doing this with a Macro. 2) I would also like to start a particular form what I click on a menu page to open it? Suggestions PLEASE?
|
|
|
images on a form
|
| |
Alright I have a db that is pretty basic. It has a First and Last Name field a Title Field and seven YES/NO fields. What I want is that when I run a query on a specific employee name it will pop up a form displaying a photo of the employee and another image or something displaying (basically pass or fail) whether they have completed all... more »
|
|
|
|
