| Thread | Last Post | Replies |
|
| change bypass key | 11 Apr 2007 21:54 GMT | 3 |
I've used Startup to disallow access keys, full menus, shortcut menus and to hide the database window. I'm wondering if there's a way to change the bypass key for this database only from holding the shift key down to holding a different key... say 'p' for example. Unfortunately ...
|
| DDL for INSERT/UPDATE with Decimal Formatting | 11 Apr 2007 21:39 GMT | 3 |
I have a need to do DDE to do a number of Insert and Update statements (via SQL) with a program that's provided to multiple countries, some of whom use different number formats than I do (english version, USA). Specifically, they would use 1.000,05 for $1,000.05...
|
| break word in reports | 11 Apr 2007 18:34 GMT | 1 |
I have a text field in table. When I print report based that table, the word in text field break apart. Example : data in text field : "This is a dangerous film" But in report : This is a danger
|
| add a linked record from a form | 11 Apr 2007 14:22 GMT | 1 |
Is there a way to link the info on two forms like a subform when opening another form with the first form open? I want to use a form to enter info then open another form and link it to the first form. I am using access 2k .adp as a front end to sql.
|
| Export to Excel 2003, 2007 | 11 Apr 2007 07:27 GMT | 3 |
I have a Access 2003 database running fine for a long time. Two new users started using the database, since they are new they get Office 2007, including Excel 2007. A routine in the Access database exports to a formatted excel file (that is, I can't just use the DoCmd ...
|
| Loading Data on a subform based on Combo Box value | 11 Apr 2007 02:56 GMT | 3 |
Hello all, I would really appreciate if someone can help me with it. I know it's simple. But I just can't get it. I tried for hours before I gave up. All I want is to display values in a subform based upon the value user chooses in a combo box. I have three fields to be displayed ...
|
| Executing make-table queries with VBA | 11 Apr 2007 00:03 GMT | 7 |
I am doing a fairly simple project for a client in which I am "translating" an existing macro into VBA in order to enable me to provide the client with a better user interface. It is a data migration system which will be run on a regular basis. It includes multiple make-table ...
|
| What about Access 2007 Runtime | 10 Apr 2007 19:26 GMT | 3 |
Hello Have somebody news about Access runtime ?? Thank's AM
|
| CreateQueryDef | 10 Apr 2007 17:21 GMT | 6 |
I've created A QueryDef and saved it using a name which I subsequently link to in another QueryDef - no problem yet. I would like use an empty string for the name in the first QueryDef, but don't know how to reference it. Is this possible, or do I need to name it?
|
| Calling a web service from access | 10 Apr 2007 16:50 GMT | 1 |
Thanks in advance for your help. We have a help desk system that exposes itself as a web service. I have a nightly process that executes on windows' scheduler and if an error is produced I log it. Going forward i'd like to also report it to the help
|
| Disable Backend | 10 Apr 2007 16:10 GMT | 1 |
Maybe this is a repeat question, but I can't find a keyword for it. I want to know if there is a way to only enable the backend (ctl + shift) when a user logs in. This is a very small database, so I have assigned the only user required to login as the admin. I simply don't ...
|
| Stripping off char from string | 10 Apr 2007 16:09 GMT | 1 |
I want to strip of the ".txt" extention from a file name. Example: MyPath = Dir(c:\*.txt) ' MyPath could eqaul something like DC123RE.txt
|
| Include variable in contol reference | 10 Apr 2007 15:19 GMT | 1 |
How can I use variables while referencing controls? I am using the following and it is not working, Access isn't recognizing my variables as control references. strCheck = Forms!myForm!Check & strVar
|
| Simply viewing a file | 10 Apr 2007 14:46 GMT | 2 |
I have an application that shells to a DOS batch file to process data from another system. It builds a .log file (simple text) that shows if the process was successful - if the other program is running something else my process fails. I just want to view the .log file to the ...
|
| Issue on calling Sybase Store procedure in MS Access VBA | 10 Apr 2007 14:12 GMT | 1 |
When a Sybase store procedure is called in Access VBA, one SP is not working properly, but complete successful with no error. If I try directly call SP in Sybase, it works fine
|