| Thread | Last Post | Replies |
|
| creating and calling a function... | 19 Feb 2008 22:09 GMT | 9 |
I am wanting to create a function to call from an autoexec macro so it checks this upon startup.. I have 2 currency fields and 2 date fields, The code that i want to be in the function is:
|
| Application Checking for Updates on Internet - Pls help. | 19 Feb 2008 21:25 GMT | 1 |
I have put the following code (see below) into an application so a friend in a rural area can check if there is an update available for it. It works by comparing the application's version number with some text on a web page. If it detects that the version numbers are different, it ...
|
| ADODB type missing? | 19 Feb 2008 21:22 GMT | 1 |
I have been working in 2007 the entire time, just had the db set to 2003 capability mode. Now I updated my Access 2003 db to Access 2007 using Import External Data as I split the FrontEnd (program) from the BackEnd (data). Some of my modules are getting a User Defined Type ...
|
| Controlling Module Loading | 19 Feb 2008 21:05 GMT | 9 |
Do I have any control over what, or the number of modules that open when I open an Access 2003 database? Whenever I open a database that I have, which references a 6MB library mba, or when I open the library itself and a module it contains, there is quite a delay before I can do ...
|
| Linear regression - Statistic | 19 Feb 2008 20:15 GMT | 1 |
I'm looking for a library reference to do some statistics like calculate a linear regression in Access Microsoft Graph can add a trendline on a graph and show the slope value and r2, but I'm not able to read it (with VBA) from the graph.
|
| Programaticlly load/unload data | 19 Feb 2008 19:47 GMT | 4 |
I am debugging VB and need to keep my data safe. Is there a way I can export all of the data in all of the tables in the database from a program. Then, when I am done debugging, pull all the data back into the access program i am writting?
|
| format 1 digit year | 19 Feb 2008 19:21 GMT | 1 |
I have a code that names a txt file with year and julian date before export. the naming convention includes the current year. But I only need the last digit of the year i.e. instead of VHMC200850.txt i need VHMC850. Where "8" is the 1 digit year and "50" is the Julian date. ...
|
| Mail Merge - Albert D. Kallal | 19 Feb 2008 18:52 GMT | 2 |
I am using Albert D. Kallal Mail Merge and need to then send the merged document and the body of an e-mail while preserving the formatting of the text. Is there a way to modify the RidesMergeWord() to then use Word's Send To
|
| Current User Settings | 19 Feb 2008 14:53 GMT | 4 |
In my database I configure usernames and passwords for those people that need access. On my main menu I display the current user and that person security setting. My worst fear just came true; and yes, I'm obviously an Access Rookie - in a
|
| mda vs mdb | 19 Feb 2008 12:27 GMT | 1 |
Other than the file extensions, are there any functional differences between Access databases and Access Add-ins?
|
| Write to a file | 19 Feb 2008 12:26 GMT | 3 |
I searched for help in the Microsoft Visual Basic window and came up with the code below. I am hoping to adapt this simple example to meet my needs. But one big problem is that I don't want to see quote marks around my text (Hello World, in this example) in the file that is ...
|
| Before insert and check box and subform | 19 Feb 2008 04:22 GMT | 4 |
Thank You I have subform and form (Master form) The Master Form Contain Check box name checkbox1 the subform is (data sheet) and allow addition = true
|
| Prcesion bug VBA Log function | 19 Feb 2008 04:00 GMT | 3 |
Does any body know why the following code returns wrong value Int(log(128)/log(2)) returns 6 intsead of 7 ? Executing the code without the Int function returns the currect value for example log(128)/ log (2) returns correctly 7 ..
|
| Access 2007 Runtime | 19 Feb 2008 00:12 GMT | 1 |
I have installed a runtime version of a 2007 access program on another PC & all functionality works well except SendObject. When attempting to send an email from the program, I get a message " 2587 Database name can't complete the output operation". Any ideas?
|
| Updating a Hyperlink in a Table | 18 Feb 2008 20:31 GMT | 2 |
I have an Access table that has a field defined as a Hyperlink that points to a file on the server. But when I run an update query to update the field with the path to the file, the Hyperlink does not work. When I right click the field (after running the update) and select ...
|