| Thread | Last Post | Replies |
|
| BeforeUpdate Cancel not always working... | 20 Apr 2007 22:47 GMT | 2 |
I have a bound form with several bound controls (along with some unbound controls). I created a BeforeUpdate event proc for one of the bound fields and in some cases I set Cancel = True to cancel the change to the field. This isn't working on this particular form - I tested it in ...
|
| File Encrypting | 20 Apr 2007 21:48 GMT | 1 |
I've got an Access application that one of the functions is generate a report or string of reports and email using MS outlook. Works Jim Dandy, superb, awsome. OK, enough of that. Now that I have accomplished that my boss want's me to find a way to encrypt
|
| Link Sub Reports | 20 Apr 2007 19:12 GMT | 1 |
I have been driving myself crazy with this, but is there a way to set the links for a master and child report when opening the report? I have a master report whose unique ID is "AcctLogID". The record source is a SQL 2000 stored procedure. The sub report's record source is ...
|
| Manipulating Excel through Access | 20 Apr 2007 18:58 GMT | 4 |
Help please. I would like to open an excel file, delete the first two rows and name the file as a txt. Then import it into access. Below is my code to open the file but I need help to delete the first two rows and rename it as *.txt. Then import it into access. Help please.
|
| Run Code in parent form from subform | 20 Apr 2007 18:20 GMT | 4 |
I tried several variations rx!ForceCode = "cboCustomer_AfterUpdate" and it is a public Sub. the value of changes. Below is what I have tried. Any Suggestions? Parent.Form (rx!ForceCode)
|
| the print dialog box does not show up when i click the print icon | 20 Apr 2007 15:38 GMT | 1 |
I am trying to give the user the capability to print either the current record, a range of record or all the records in the database, but I cannot seem to find the print icon on the custom menus that will display the dialog box so that the user can make their selection,,
|
| Command Button Rollovers | 20 Apr 2007 15:00 GMT | 8 |
I am going crazy trying to figure out how to get the mouse pointer to display a pointer finger when it is over a button. Also, Is there a good way to display an alternate image on the button only when the mouse is directly on it?
|
| Comparing two one dimensional string arrays to identify difference | 20 Apr 2007 14:58 GMT | 1 |
I have two string arrays {astrBefore() & astrAfter()}. The second array (astrAfter) contains all of the elements that the first array has plus a few more. I want to identify the new elements in astrAfter().
|
| Problem with Access & Wininet | 20 Apr 2007 14:42 GMT | 2 |
I have an Access 2002 application that uses wininet.dll to access FTP. Ran like a champ for well over a year and suddenly stopped working. After a great deal of cursing and debugging, I found that the problem seemed to come from a new version of wininet, with file date of Jan. ...
|
| Dcount - Recordsource | 20 Apr 2007 14:36 GMT | 2 |
Does anyone knows whether it is possible to use the recordsource of a report as the criteria in the DCount function? Thanks.
|
| Option button | 20 Apr 2007 14:24 GMT | 7 |
when an option button is selected I want to link it to a field in a table with a yes/no value ie Table = Product Group
|
| Save As Dialog Box | 20 Apr 2007 12:58 GMT | 2 |
I need to know how to invoke the File SaveAs dialog box when generating a file in VBA in an Access 2000 database. I'm sure it is something simple but I need to save a file that I am creating in the program to the user's desired location.
|
| create a dynamic list of users from active directory? | 20 Apr 2007 11:46 GMT | 1 |
Is it possible to create a dropdown box of users dynamically from an active directory OU? I have made a call logging database, but every time a new member of staff is added to active directory i have to add them to the database as well, sometimes this doesn't get done lol
|
| Global "find and replace" | 20 Apr 2007 07:15 GMT | 1 |
I am trying to customize the Northwind sample database. Can I perform a global "find and replace" to update objects throughout then entire database?
|
| Prevent Report from being set to a printer | 20 Apr 2007 01:52 GMT | 6 |
I have a report in a collection of reports for which previewing is handy but we do not want to print it as it is 125 pages long. Does anyone know of code that will keep this report from being sent to a printer?
|