Description:
Microsoft Office Access newsgroup.
|
|
|
Requery mulptiple forms Access 2007
|
| |
I have reviewed a lot of the blogs of requerying multiple subforms and have tried them and have had no luck. I am designing a db for a trucker that wants to keep track of trips along with mileage and revenue. My main form just assigns the trip #. The 2nd subform is for the data entry of the trips including desitnation, miles and revenue. There could be many... more »
|
|
|
DTPicker: Incrementing Time Value
|
| |
I have a form with the following DTpicker's InterviewStart (format= "mm/dd/yyyy HH:mm") InterviewEnd (format= "mm/dd/yyyy HH:mm") When the user inserts a record, the InterviewStart field updates to Now(). I would like to set the default value of InterviewEnd to be 1.5 hours from Now(). How does the VBA code look in order to accomplish this?... more »
|
|
|
set focus & screen movement
|
| |
in Access03 have tabbed page/control about half way in the screen form/detail area. There are 3 tabs and each tab has inset a subform. When one selects a tab, the focus moves to the first control in the subform; but the screen display slides up this control to the detail/header bar ; and thus the info above the tabs, and the tabs themselves no longer display...... more »
|
|
|
backup of database with multiple backend data bases
|
| |
I want to add a button to the main form that backs up 1 (ONLY) of 2 linked databases... It's a bit of an odd condition: the way the project has been set up, it is linked to 2 backend databases; fortunately, all of the tables in one mdb are prefixed [tbeTableName], and in the other: [tboTableName]... more »
|
|
|
last 20 entries
|
| |
I have a form that is a continuous form. This is used to show different sorts, searches, filters, and so on. The users today asked if on this form there could be a button that would display the last 20 entries made. The last 20 entries would be those are open and closed, status does not make a... more »
|
|
|
Event for scroll bars on text boxes
|
| |
Let's say that I have a text box that shows 2 lines of text, and in that text box i have 10 lines. The text box is set to show the vertical scroll bar. Using the timer event of the form, I would like to simulate clicking the down arrow on the scroll bar so that every few seconds, it scrolls the text... more »
|
|
|
Stop Form from Flickering
|
| |
I have a form with a fair amount of controls on them. 3 of them are clocks which get updated each second via the form's OnTimer event. Frequently, but not always, most of the form will flicker during the update of the controls. I have tried this on 3 different computers and they all do it. Has anyone seen this? Is there something that I can do to prevent it?... more »
|
|
|
vba types red and then backspaces
|
| |
When I start to type code into anywhere in a form the typeing turns red and then auto backspaces. if i close the dbase and reopen and then type it is fine for awhile and then it starts this again i close and the loop continues. why is this happening because my productivity level is decreasing. thank... more »
|
|
|
Passing rowsource to combo box without nulls.
|
| |
Hello all, I am in need of some assistance. I have 2 combo boxes on my form. Both are bound to fields. I am useing the following code to limit the second combo to the records associated with the selection in the first. This is in the after update event of the First combobox, On Error Resume Next cboSub.RowSource = " SELECT DISTINCT ItemMaster.Sub " & _... more »
|
|
|
|
