|
More site info...
microsoft.public.access.modulescoding | Forum profile
|
|
Forum profile page for microsoft.public.access.modulescoding on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.access.modulescoding, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "microsoft.public.access.modulescoding" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on microsoft.public.access.modulescoding:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
9
|
20
|
54
|
|
Post:
|
31
|
64
|
150
|
|
|
microsoft.public.access.modulescoding Posting activity graph:
|
Top authors during last week:
user's latest post:
Simplify an update from a...
Published (2009-01-02 10:12:00)
I am trying to update a field when a user select a record from a combo box... but I do think I have over complicated it... I want to update the date when the record = two types of members and any other it has a null date... I have but this on the after update property of the control... start cof code >>>>> Private Sub AWSAMembership_AfterUpdate() Dim rstAGA_AWSA As ADODB.Recordset Dim ctl_awsa_rod...
user's latest post:
how to stop an excel process...
Published (2009-01-02 17:18:00)
Change that line to Set xlBook = xlApp.Workbooks.Open(DirPath & xltfname) Do the same with the similar code step that appears later. -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "PR" <paul.raeburn@vodafone.net> wrote in message news:%23SqwRRQbJHA.5676@TK2MSFTNGP03.phx.gbl... > ken, > at the line: >>> > ' create a...
user's latest post:
Code to delete and import...
Published (2009-01-07 15:38:00)
"Larry Linson" <bouncer@localhost.not> wrote in news:e#6EY4PcJHA.1676@TK2MSFTNGP03.phx.gbl: ><aaron.kempf@gmail.com> wrote > > > splitting doesn't help. > > Splitting is part-and-parcel of the solution you recommend over > and over, whether or not it applies -- Access ADP with SQL Server > data storage. The ADP does not...
user's latest post:
Code to delete and import...
Published (2009-01-07 16:24:00)
Hi Douglas, You input with a possibility is appreciated! Clifford Bass "Douglas J. Steele" wrote: > One possibility would be allowing each user to create his/her own reports as > part of the application. You might then want to import some of the custom > reports back into the main application so that each user can take advantage > of specific reports. > > -- > Doug...
user's latest post:
Code to delete and import...
Published (2009-01-05 10:42:00)
Thank you both Doug and John. This was precisely what I was looking for and I greatly appreciate the prompt and very clear responses. Jack Cannon "Jack Cannon" wrote: > I would like to delete an existing report in my application and import a > different report as a replacement. > This can be done on the menu bar by going to File/Get External Data/Import. > However I need to accomplish...
user's latest post:
Code to delete and import...
Published (2009-01-07 04:31:00)
One possibility would be allowing each user to create his/her own reports as part of the application. You might then want to import some of the custom reports back into the main application so that each user can take advantage of specific reports. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Clifford Bass" <CliffordBass@discussions.microsoft.com> wrote in message...
user's latest post:
Code to delete and import...
Published (2009-01-05 10:34:00)
On Mon, 5 Jan 2009 10:11:02 -0800, Jack Cannon <JackCannon@discussions.microsoft.com> wrote: >Is there a means to use VBA code to delete existing reports in my >application and import replacement reports from an external database? Sure. Take a look at the VBA help for the Delete method and the TransferDatabase method. -- John W. Vinson [MVP]
user's latest post:
Help with code in...
Published (2009-01-05 03:07:00)
Hi, I am writing a function that allow user to edit a record in a subform. It appears that the code does not work cause I got runtime error 438 Function frmEdit() 'On Error GoTo Err_Edit Dim Vfrm As Form Dim ctl As Control Set Vfrm = Screen.ActiveForm Set ctl = Screen.ActiveForm.ActiveControl With ctl If ctl.ControlType = acSubform Then If ctl.Owner = fOSUserName() Then 'compare vaklue of Owner field with value from...
user's latest post:
Help with code in...
Published (2009-01-05 04:31:00)
"SF" <xyz@yahoo.com> wrote in message news:eeysnVybJHA.1528@TK2MSFTNGP03.phx.gbl... > Hi, > > I am writing a function that allow user to edit a record in a subform. It > appears that the code does not work cause I got runtime error 438 > > Function frmEdit() > 'On Error GoTo Err_Edit > > Dim Vfrm As Form > Dim ctl As Control...
user's latest post:
Mi R4ultra ds me va muy bien in...
Published (2009-01-07 04:10:00)
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>&nbsp;</P> </BODY> </HTML>
|
|
|
|
Latest active threads on microsoft.public.access.modulescoding::
Started 3 days, 16 hours ago (2009-01-05 10:10:00)
by Jack Cannon
I would like to delete an existing report in my application and import a different report as a replacement. This can be done on the menu bar by going to File/Get External Data/Import. However I need to accomplish these functions using VBA code instead of manually clicking on the menu items. Is there a means to use VBA code to delete ...
Started 1 day, 22 hours ago (2009-01-07 04:10:00)
by Pedro
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P> </P> </BODY> </HTML>
Started 3 days, 23 hours ago (2009-01-05 03:07:00)
by SF
Hi, I am writing a function that allow user to edit a record in a subform. It appears that the code does not work cause I got runtime error 438 Function frmEdit() 'On Error GoTo Err_Edit Dim Vfrm As Form Dim ctl As Control Set Vfrm = Screen.ActiveForm Set ctl = Screen.ActiveForm.ActiveControl...
Started 1 week ago (2009-01-01 10:28:00)
by PR
I am trying to stop an excel process after working excel through access 2003... it does not seem to matter what I try to do an instace of excel stays running... canyone suggest what I maybe doing wrong here is my code: >>>code start>>>> Function transfer_aga_corps_data() On Error GoTo transfer_aga_corps_...
Started 6 days, 16 hours ago (2009-01-02 10:12:00)
by PR
I am trying to update a field when a user select a record from a combo box... but I do think I have over complicated it... I want to update the date when the record = two types of members and any other it has a null date... I have but this on the after update property of the control... start cof code >>>>> Private Sub ...
Started 1 week, 1 day ago (2008-12-31 10:21:00)
by PR
I have some code that does the following: kills a spreadsheet if it exists, opens a template, saves it, opens the spreadseet, transfer data to it, runs a macro then I save it... I am using the following to save the spreadsheet: xlBook.SaveAs DirPath & xlsfname xlBook.Close I ...
Started 1 week, 2 days ago (2008-12-30 10:28:00)
by PR
I am trying to delete, open, save and transfer data to excel I am using the following code but I am getting some errors... could someone suggest what is wrong with the code... Many Regards - PR My Code: Function export_aga() On Error GoTo export_aga_Err Dim db As Database Dim objApp As Excel.Application...
Started 2 weeks, 5 days ago (2008-12-20 11:50:00)
by Ronald
Hi. To select/find data in a table, what will be the fastest method: 1. By query: "SELECT * FROM Table WHERE Field1=""" & Me!txtField1 & """ AND """ Field2=""" & Me!txtField2 & """;" And loop through the records found (if any). Or 2. Select the table in whole. And .FindFirst "Field1=""" & Me!txtField1 & """ AND ...
Started 3 weeks ago (2008-12-18 13:33:00)
by Jason
Greetings, I am somewhat of a novice, so please bear with me. I am trying to come up with a user defined function that will allow me to find the xth percentile on a group of records within a query. Scouring the net, I found the code below. I have put this into a module in my DB and have tested it using the immediate window...
Started 3 weeks, 1 day ago (2008-12-17 13:31:00)
by Clay_LMCO
I have a library of classes that I use to manipulate MS Access UI objects (forms, subforms, controls, etc.). My code has been bullet proof for the past several months in Access 2003. Now I am migrating to 2007 and everything has broken. What I am encountering is the error message "The expression you entered refers to an ...
|
|
Hot threads for last week on microsoft.public.access.modulescoding::
Started 3 days, 16 hours ago (2009-01-05 10:10:00)
by Jack Cannon
I would like to delete an existing report in my application and import a different report as a replacement. This can be done on the menu bar by going to File/Get External Data/Import. However I need to accomplish these functions using VBA code instead of manually clicking on the menu items. Is there a means to use VBA code to delete ...
Started 1 week ago (2009-01-01 10:28:00)
by PR
I am trying to stop an excel process after working excel through access 2003... it does not seem to matter what I try to do an instace of excel stays running... canyone suggest what I maybe doing wrong here is my code: >>>code start>>>> Function transfer_aga_corps_data() On Error GoTo transfer_aga_corps_...
Started 3 days, 23 hours ago (2009-01-05 03:07:00)
by SF
Hi, I am writing a function that allow user to edit a record in a subform. It appears that the code does not work cause I got runtime error 438 Function frmEdit() 'On Error GoTo Err_Edit Dim Vfrm As Form Dim ctl As Control Set Vfrm = Screen.ActiveForm Set ctl = Screen.ActiveForm.ActiveControl...
Started 1 week, 1 day ago (2008-12-31 10:21:00)
by PR
I have some code that does the following: kills a spreadsheet if it exists, opens a template, saves it, opens the spreadseet, transfer data to it, runs a macro then I save it... I am using the following to save the spreadsheet: xlBook.SaveAs DirPath & xlsfname xlBook.Close I ...
| |
Size: 862 bytes
