Custom Collection in Form Module not working
Fri, 5 Dec 2008 18:20:10 -0800
Access 2003
I am unable to get a custom collection to work in a Form module. The code
snippets are:
Dim colBaseThemes as Collection
Set colBaseThemes = New Collection
Dim strBaseRef as String
open the recordset (it works)
With rstBaseSectionThemes
.Find strBaseRef (it works)
Do While Not .EOF
...
|
Return to record on main form
Fri, 5 Dec 2008 17:14:00 -0800
Man, here it is 5pm on a Friday and I'm stuck!
Here's my problem. I click a button on one form, frmIntegration, to launch
a 2nd form, frmUse_Case. After I'm done editing and close frmUse_Case I want
to do two things: requery frmIntegration (which I know how to do) AND return
to the record that I was on wh ...
|
how to call sub
Fri, 5 Dec 2008 16:46:39 -0800 (PST)
Hope someone can remind me how to do the following.
From an after_update event of a control on a form, I'd like to call
the 'on current' sub of the same form.
richard ...
|
Remove filter before comboBox finds record
Fri, 5 Dec 2008 16:28:01 -0800
I have a unbound combo box used to find a record on a My form F_Parts
it uses the rs.FindFirst "[PartNumberID] code that the Wizard Supplies on
the after Update,
I also have code on my forms "On Current" that keeps the combo displaying
the correct info if navigation buttons are used Me.SelectByPNID_Combo ...
|
Data table on a web server
Fri, 5 Dec 2008 13:54:01 -0800 (PST)
Is there a way to have a data table saved on a web server and have it
constantly updated by individuals submitting data via the web as an
XLS file? I'm guessing there would be some scripting involved with
this. Does anyone know if this can be done, and if so, is there a
resource somewhere to help with it? ...
|
Inbox issues
Fri, 5 Dec 2008 11:09:01 -0800
I have a form with a button used to open a second form. The SQL code behind
the button opens an input box for user input of an "FCSI Number". When the
user enters a valid FCSI number, the second form opens correctly. There are
two instances during which I recieve an error. The first is if the user
cancels t ...
|
IsLoaded compliance error
Fri, 5 Dec 2008 09:54:02 -0800
I need to have one subform automatically filter information based on the
"filter by selection" of another subform that is open. I copied the
following code and put it in the codebuilder for the form called frmClients.
When I try to filter by selection on frmClients I get the following
Compliance error mess ...
|
|
|
Embedded excel spreadsheet will not update when form is opened
Fri, 5 Dec 2008 08:21:01 -0800
I have a number of forms that have embedded excel spreadsheets in them. I
took over modifying these forms and apparently they use to automatically
update when the form was opened. But now with the new excel spreadsheets in
them they will not do that. How to I programically force the spreadsheet to
update whe ...
|
Maximizing Forms
Fri, 05 Dec 2008 15:46:41 GMT
Is there a way to have ALL forms (I have dozens) maximize. I've heard about
using the docmd.maximize code for an individual form, but looking instead for
module language (or similar global fix) that would have all forms maximized
when opened.....THANKS!
...
|
Saving Content of Embedded Excel Control on Form
Fri, 5 Dec 2008 06:44:01 -0800
Hi,
I have a Microsoft Office Spreadsheet 11.0 Object on my Access form and I
can't seem to save the contents. I have the following code in place:
[CODE]
xlsReceiptContainer.ActiveWorkbook.Worksheets("ETSReceipt").SaveAs
uploadPath & "\" & fileName
[/CODE]
I've got to be close. Everything clicks alon ...
|
