| Thread | Last Post | Replies |
|
| Report Hidden attribute | 16 Jun 2006 14:05 GMT | 2 |
How do I programatically set the Hidden Attribute of a report so that it doesnt appear in the database window?
|
| Docmd.openreport problem in Acc2003 | 16 Jun 2006 14:04 GMT | 1 |
I developed a db in Acc2000 and had been used by users for several years. Now some users moved to Acc2003 and my code Docmd.openreport doesn't work anymore. It generates error "your print action was canceled" when executed. Any help would be appreciated.
|
| List a folders contents from a widows Directory | 16 Jun 2006 13:02 GMT | 21 |
I was wondering if it is possible to have a list box populated with the contents of a folder in a directory located on a server. The files in the folder are in PDF. Then on Double Click to open the file. Is this possible? If so how do I do this.
|
| Recordset from a recordset | 16 Jun 2006 12:33 GMT | 3 |
Just a quick one ... I've never had to do anything like this before. Set rs1 = db.OpenRecordset(SQLstatement, dbOpenDynaset) rs1.Filter = strFilter Set rs2 = rs1.OpenRecordset
|
| Runtime error 429 - ActiveX component can't create object | 16 Jun 2006 12:04 GMT | 1 |
I have an Access 2002 application that was working fine on my computer but now is not. The program works just fine on other computers. I get the above error when selecting a record from a combo box. The code is below. I'm not sure if I installed another program or not - I ...
|
| Creating Reports programatically | 16 Jun 2006 03:50 GMT | 4 |
When you programatically create a report using the CreateReport function, the PageHeader and footer sections are, by default, turned on. How do you remove them? Also, how do you change the name of the report?
|
| DNS-LESS connection to MySQL | 16 Jun 2006 02:38 GMT | 1 |
In Access, is there a way to create a dns-less connection of link tables to a MySQL backend database? I have dns-less connections that connect to SQL Server, but I need it for MySQL now. Thanks.
|
| Strange Problem with MoveNext | 15 Jun 2006 23:00 GMT | 1 |
Hi, i wrote the following code(reduced to my Problem): --------------------------------------------------------------- Dim dbs As Database Set dbs = CurrentDb
|
| Too few parameters Expected 1 when setting recordset object to a q | 15 Jun 2006 22:45 GMT | 5 |
I am using Access 2003 on windows XP Professional. I have developed a time entry program to track employees' attendance and job costs. I am using a form bound to the payroll table with a subform bound to the details of the time for that day. I have a 2 saved queries. one returns ...
|
| set grouping at runtime for reports | 15 Jun 2006 22:16 GMT | 1 |
I have a form that lets users filter the report data, but I need to allow them to group by user specified levels. How can I provide users some sort of checkboxes and then group the report to those specs at runtime with VBA??
|
| FontBold Property | 15 Jun 2006 21:55 GMT | 4 |
I have an automation that send an email based on a SQL string in VBA. I want to format the type face of the email without using HTML. The example is below strBody = "Meeting Title: " & Format(Me![DateEnter], "Long Date") & vbCr I am trying to make the meeting title Bold. When ...
|
| fiter records in class module | 15 Jun 2006 21:17 GMT | 1 |
I am trying to filter an unindexed (database is too large for indexing) database that matches certain fields. At first, I want to filter it based on date, then a series of identification numbers. How do I do this filtering from inside a module? I do not want to use a query ...
|
| Docmd.GoToControl | 15 Jun 2006 20:48 GMT | 1 |
I have a data base and it is setup so that when The message box pops up it takes them to a control depending on if they answer yes or no. Once they are sent to the control I was wondering if there is anyway to open another form after they are done typing and only if they have ...
|
| Forms | 15 Jun 2006 20:43 GMT | 1 |
I have a form in Microsoft Access, that has a OK button that I would like to open in VBA programing. I get a Compile Error, Expected End Statement. Option Compare Database Private Sub CancelCmb_Click()
|
| Parsing text files | 15 Jun 2006 20:17 GMT | 4 |
Private Sub bt_Select_Click() lblCurrentFolder.Caption = BrowseFolder() End Sub Private Sub ParseFile(FileSpec As String)
|