Description:
MS Windows' relational database system, Access.
|
|
|
Common Dialog Box
|
| |
Hi I can't find the proper way to use a common dialog box (file selection) on one of my forms, though I'm sure it can not be too difficult. So I guess you guys can help me out ? Tanx in advance ! D
|
|
|
Create Desktop Shortcuts
|
| |
Has anyone used VB5STKIT.DLL ? I haven't found any documentation other than this code (below). The code seems to work and I get a return value of 0. But nothing gets added to my desktop. Any suggestions? TIA Fred Private Declare Function fCreateShellLink Lib "VB5STKIT.DLL" _ (ByVal lpstrFolderName As String, _... more »
|
|
|
copying the contents of an autonumber field to a number field
|
| |
I have a form and a subform. The main form has order id field which is an autonumber type. The subform also has order id field which is a number type. I want the subform order id to have the same value and the mainform order id. I used the following code set to subform order id on focus. Me![order id] = Forms![Enter Work Order]... more »
|
|
|
help with combobox
|
| |
Hi, In AccessXP a have a form with a combobox on it, it's recordsource is SELECT tblCandidates.LName, tblCandidates.FName, tblCandidates.ColUniNme, tblCandidates.Phone, tblCandidates.EMail, tblCdtSrcsRefrds.RRDte, tblCdtSrcsRefrds.PID AS Round, tblCdtSrcsRefrds.AppldFTInt AS Appld, tblCandidates.CID... more »
|
|
|
wrong week number in date format
|
| |
Hello, I have a problem within the form where I have date with default value 'Date()' which is formatted as week ('ww') showing week number. It was ok for the previous year but now it reads date Jan, 4th as week No 2 while I need it to be No 1. Is there a way to fix this in form / format property only or some hard... more »
|
|
|
Public variables not working...
|
| |
Good Morning All!! I have used a practice for years that is suddenly not working. If I need a parameter for a report, I use an input box to get the data and put it in a public module level variable in the report. The report's record source uses that public variable in its criteria. For example (stripped of validations,... more »
|
|
|
Link to Excel files and run an append query
|
| |
I am trying to link an excel file into access database and use an append query to add lines to the excel file. I use to do this for a longtime until the new excel 2003 service pack was loaded. After upgrading the service packs I am having a problem wherein access is unable to update into the excel file due to known/documented microsoft... more »
|
|
|
Turn report into a book
|
| |
I am trying to turn a a report printed in 2 columns on A5 paper into a booklet. The report is basically names & addresses and the report I am interested in takes 5 columns on 3 pages. So I accept the fact that I have to make the booklet 4 pages long with 8 columns. The problem is that for example, assuming the names are printed out... more »
|
|
|
Compact & Repair error
|
| |
If I compact & repair a FE AK2 database I normally get no problems. If I set the option to compact & repair it on close, I frequently get an error saying Field "Description" not found. There is no field in either the FE or BE called Description. The only reference to "Description" is in VB where I get the description property of an object (Form, Query, Report etc)... more »
|
|
|
Performance Question
|
| |
Hi, A client has a very important business critical database system, but are after greater performance. Currently they have two front end versions (one for the shop side of the business - 2 users, one for the office workers - 8 users, held on the local computers) connecting to 4 separate back-end data files, on... more »
|
|
|
|
