| Thread | Last Post | Replies |
|
| open a calender with vbscript | 22 Mar 2007 04:18 GMT | 1 |
On Access 2003, I need to open the calender control 11.0 for four different dates. I do not have the room to leave the calender on the page, so I need to find a method to open the calender by clicking in the cell or by clicking an hyperlink. How can I do that?
|
| Combining Data | 22 Mar 2007 03:55 GMT | 1 |
I don't know if what I am going to ask is possible, but I though I'd ask the experts. I have a table listing items in a charity auction. If I wanted to combine 2 items into 1 new item, such as theater tickets and a restaurant certificate
|
| Validation Rules and Validation Expressions | 22 Mar 2007 02:59 GMT | 2 |
I'm working on a program using vb in Visual Studios 2005 where I need to validate a couple of text boxes. One is for a credit card. Most credit cards have 16 digits and that's what I'd like to set the validation to. If the user enters less than 16 or more than 16 numbers, they ...
|
| Toggling a List Box | 22 Mar 2007 01:18 GMT | 3 |
I have a list box containing employee names; I want to toggle it back and forth between showing all employees and showing just current employees. Employees are stored in an Employees Table with FName, LName, Init (a shortened max 8-character version of their name) and a yes/no ...
|
| Explorer window - find xls - path etc becomes part of programme | 22 Mar 2007 00:56 GMT | 5 |
From access an XLS template is opened and saved under a new name. If it is possible, how do I do it question follows. How do I get an explorer window or equal to open so that the user can find and select the file - get its path. The file then becomes part of the
|
| Recordset / Query Problem | 21 Mar 2007 23:33 GMT | 1 |
I'm having an issue that's driving me nutz... everytime I try to run a function that uses a stored query as the source of the recordset, I get an error of "Run-tim error '3061': Too few parameters. Expected 1."
|
| Word connectivity (continued) again | 21 Mar 2007 18:44 GMT | 3 |
I have discovered that this does not happen if you leave the word document open the routine works ok over mulitple occurances, but if you close it without saving, as you inevitabley have to then you cannot write another letter, the occurance of word is started but does
|
| access default database folder for all users | 21 Mar 2007 16:57 GMT | 3 |
I have an access 2002 database and many users are working on it. Database is on server so every user is logging onto server trough citrix metaframe. Now the question, how do I set the Default Database Folder for all users so they don't have to, on first login to go to ...
|
| Parse XML VBA | 21 Mar 2007 16:55 GMT | 3 |
I am looking for instructions on how to parse a XML response received from a web service into variable components for storage in an access table. I have tried the application.importxml method and it is not providing the results I need. Is there a way to pull elements from a XML ...
|
| How to tell whether FindRecord has found anything | 21 Mar 2007 16:44 GMT | 4 |
I have a form (with records of CDs) with a subform (showing contents of each CD). I have an text box on the main form to enter text to be found, and a Go button. The code for the button uses DoCmd.FindRecord to highlight the found text in the subform. This works fine - each click ...
|
| Run a Winzip self extracting file | 21 Mar 2007 15:14 GMT | 5 |
I used Winzip to zip up files that we need to send to many users in different locations. The file created is an .exe file. These users do not have Winzip installed on their computers. Is there a way to run this executable winzip file on the users machine with VBA code?
|
| FileSystemObject drive error | 21 Mar 2007 12:15 GMT | 4 |
I am trying to create a routine to gather information about files. I found the following code provided by the MS Scripting Guy: Set objConnection = CreateObject("ADODB.Connection") Set objRecordset = CreateObject("ADODB.Recordset")
|
| Error sending emails from Access through Outlook... | 21 Mar 2007 05:43 GMT | 1 |
I am having the typical problem when sending an email from Access. I get that error saying that another application is trying to send an email on my behalf or whatever. I heard that it can be bypassed by using sendObject, is this true? If so, how would i modify my code to use ...
|
| Attached a DLL | 21 Mar 2007 04:04 GMT | 1 |
I created a dll in VB.net 2005 and I am trying to use the dll in Access 2000 and Access 2003, when I try to attached it under references I get an error.... anyone have any ideas on how to resolve?
|
| everyone,Converting Numbers into Words | 21 Mar 2007 00:07 GMT | 1 |
|