Search results

Cannot successfully change the ColumnCount or ColumnWidths of a Combo Box after it is used in a form Interesting thing i want to do to a combo box- I want to change the combo box parameters so that I can see the bound column- but only when I press a Command Button. All other times, I don't want...

Thanks for the Help! Since all I wanted to do was subtract even hours, like 2, 6, 12, etc, your solution works great! I would still like, for future projects, to learn how to subtract exact time; example, subtract 2 hours 5 secs from 1:30 AM- how would i do this successfully (handle the 24-hour...

How does one handle rollovers when doing subtraction with time? I find that when adding time, VBA handles rollovers at the 24-hour mark gracefully; but when i subtract hours, VBA gives me weird results; Here is some code: ' subtract 12 hours, if resuting time is larger than current time then...

Thanks for the input; another way to do what you have done, as explained in the Access Developers Handbook by Litwin, Getz, and Gilbert, is to use the OnCurrent event of the first subform to update the textbox, that will then be used update the second subform using the LinkMaster/ LinkChiild...

Tough Problem With Two Subforms I have a form with a combo box and a subform; the combo box updates the recordsource of the subform with the AfterUpdate() event; no problems; I am trying to convert this into a form with two subforms, one subform replacing the functionality of the combo box- by...

Cannot Set Form Property AllowDesignChanges - Get Errors 'AllowDesignChanges 'is a new property to Access 2000; On MS website, it says that i can assign a value to the 'AllowDesignChanges' property of a form through VB...

Controlling toolbars On Off by VB Code In Access97, i created a URL Manager that opens many URls in separate IE instances; Access97 will display a Web toolbar when it does this; i would like to turn this toolbar off- i think it is annoying; is there a way in VB/ VBA that controls the on/off of...

Understanding of Bookmark and RecordClone Here is the code snippet in question: Me.RecordsetClone.FindFirst "TestID = " & numTestID Me.Bookmark = Me.RecordsetClone.Bookmark I use it all the time and know the end-result- a specific record is located fast; however, i do not understand...

Short-cut Key for View Code? Is there a short-cut key to View Code; i can bring up the debug window via short-cut, but it is not documented if there is a short-cut to view code; since i work with Access all the time, this short-cut would be a big time-saver; i hope someone has figured it out...

Try experimenting with subreports; this is the trick when making reports that have different formatted sections; example, main report lists convention info, subreport lists all attendees for associated convention;

If you are new to report design, make sure the Name of the field is different than the Control Source; because of the way Access defaults when making reports, it makes these two properties the same and this can cause problems; You may need to describe your report in more detail if you still...

Problem Making Subreport Display Something When Recordset is Empty The problem i have is how to display "none" when the recordset is empty for this subreport; All my present attempts result in errors or nothing being displayed; I have tried the On No Data event and others; What is the how-to...

Is it Possible to high-light current record in data-sheet view? I would like to improve my form that use datsheet views; how can i make access high-light the current record (like make it yellow)? when user moves through records, i would like to highlight record to make viewing easier; Can this...

Just to close this thread; the solution is to set RecordSetType to Dynaset(inconsistent updates), not just Dynaset; this is little documented and i cannot explain why Microsoft created two Dynasets to be used; I apologize if my wording mislead people; i was creating joins, not unions;

Why are Recordsets in Forms Read-Only when there are Unions involved? Through some tests, I have found that when a form is based on one table, the recordset can be updated through the form; however, when a form is based on a recordset with two or more tables, the form will treat the recordset...

How to prevent users from deleting more than one record at a time in a datasheet form Is there a way to disable this delete-more-than-one feature? Or determine if mutiple records are selected so i can write code in the delete events that check for this condition? Thank you! --Llyal

The problem deals with subforms updating other subforms; Access has some difficulties; the solution uses text fields placed on the main form that the subforms use to pass information and update themselves; not very elegant but works; Llyal

The solution has to deal with using unbound text fields on the main form, and having the subforms pass information and update themselves off of these; i found this workaround in a book i had; i must admit, having to do all this awkwardness to make Access perform sure is ghetto;

Problems when OnCurrent Event is Used in Subforms Access97 I get error when i open form that contains a subform that updates another subform using the OnCurrent event; The setup is: Mainform with two Subforms; Mainform does not have a RecordSource; only used to hold subforms; SubformA that has...

Subforms Updating other Subforms Problem When Opening a Form I have a form with several subforms; some of the subforms have OnCurrent events that update other subforms on the main form; when i open the main form for the first time, i get a run-time error 2455 - you have entered an expression...