| Thread | Last Post | Replies |
|
| Please need help w/Form Code | 23 Jan 2008 00:15 GMT | 3 |
I have a parameter form when I enter the data it puts the data in the first record it finds. How can I revise this to find the record I select and save the data to the specific records? Thank you in advance for any help you can provide.
|
| Access 2003 Runtime | 22 Jan 2008 18:21 GMT | 8 |
How can I get Access 2003 runtime? The 2000 runtime was included with the Microsoft Office Developer (MOD) product, but that doesn't seem to be the case with 2003. I read MS website and am still confused.
|
| code to fine computer name | 22 Jan 2008 13:50 GMT | 1 |
how to fine computer name? help me
|
| exit form button and BeforeUpdate form event | 22 Jan 2008 08:05 GMT | 4 |
I have an exit form button where I just want to confirm with the user if they want to save or not, if they don’t it closes the form, but if they do it saves the record before closing. Things have worked great in other forms with a simple BeforeUpdate event programmed on the form:
|
| Pass memory viarible to another sub | 22 Jan 2008 06:25 GMT | 1 |
To simplify my code, I plan to move 'DoCmd...." into another sub called CleanUp. memory viarible strPath is not working in CleanUp sub. How do I fix it?
|
| Using Memory viarable | 22 Jan 2008 05:37 GMT | 4 |
I have following: Dim mYYYY as String, mSem as String mYYYY="2007" mSem="3"
|
| DAO TableDef error | 22 Jan 2008 03:54 GMT | 3 |
I must be having a brain cramp. The following code is generating a run-time error 3420: Object invalid or no longer set. The line that is marked with the asterisk is the one generating the error. When I add error handling, it still errors when I try to print the tdf.name
|
| CopyObject | 22 Jan 2008 00:08 GMT | 1 |
I using this code to copy table to another data base ============================================== The code DoCmd.CopyObject "C:\mydb", "", acTable, "CODES"
|
| There is no "new blak record" to put the data in my form! HELP PLE | 21 Jan 2008 19:28 GMT | 1 |
Hi I have splited database to be backend and front end for 6 months and it 's working fine until today. I got 1 Form "PSR Form" that links 5 tables together; PO, Clients, Projects, Vendors, and Locations. When I want to put the new po today in PSR Form, there is no "new blak ...
|
| Excel automation from Access | 21 Jan 2008 19:02 GMT | 3 |
I have a report which I export to Excel with the following line (hidden in a button) : DoCmd.OutputTo acOutputQuery, "qryTotal", "MicrosoftExcelBiff8(*.xls)", AutoStart:=-1
|
| Code syntac Question | 21 Jan 2008 18:19 GMT | 2 |
I have a form with rows of unbound txt boxes and I want to address the boxes in increments of 1. So for examle "txtbox1" , txtbox2 and so on. I Dim an integer 'intLines" in the 'Open event of the form. Dim intLines as Integer
|
| Refresh form | 21 Jan 2008 17:13 GMT | 4 |
Hello. I have a form (Form2) with a command button at the bottom to close the form. This form opens as a pop-up over another form (Form1). Is there a way I can add to the Close Command on Form 2 a code that will set the focus back to Form 1 and then refresh that
|
| Dynamic report printing | 21 Jan 2008 17:10 GMT | 3 |
I have a report that is based on a query. The report is sorted on the field "Type". I'd like for the user to be able to print only seleted sections of the report based on which "Type" sections they need to print. I was thinking of a form where they could select which types to ...
|
| Count number of checked boxes on a form | 21 Jan 2008 16:51 GMT | 3 |
I would like to add a textbox (txtCheckedForms) that shows the number of checkbox fields are checked on a form. Is there a simple way of doing this? The only thing I've come up with so far is something like this... If chkField1 = True then varCheckedForms = varCheckedForms + 1
|
| On Open Event | 21 Jan 2008 16:29 GMT | 3 |
I get an error message On Open - Object does not support this method or property. I have it narrowed down to: Forms.frmCategories.fsubCategoryDetails.Sales.ColumnHidden = 0
|