| Thread | Last Post | Replies |
|
| Datasheet view record selection event? | 20 Sep 2004 13:30 GMT | 1 |
I think the answer is "No", but I thought I'd better ask before I rule it out. With a form in datasheet view, is there any way to capture programatically the selected (i.e. with shift-click or click and drag)
|
| Determine and MDB file's Access version without opening it? | 20 Sep 2004 13:26 GMT | 1 |
I have an Access application that has to import hundreds of other MDB's, some access 97 and some 2000, and merge them into several large mdb's. so far so good, but my command: Set appAccess = GetObject(TargetDBPathNAme, "Access.Application.9")
|
| Stopping #deleted appearing on my form when I delete a complete record | 20 Sep 2004 12:49 GMT | 1 |
I have a command button on one form (frmDelete) which deletes a record from the subform (frmGrant) of a main form (frmCustomer) which is open behind it. Problem is, when I go back to frmCustomer where the record was deleted, every field in the subform contains the value #deleted.
|
| Controlling bold and italic within a text box control | 20 Sep 2004 12:40 GMT | 1 |
A report requires a line containing author and title. The author is required in bold and the title in bold italic font. Only one space is required between the author and title, which are variable length when clipped.
|
| Stored procedure to fill listbox, using 'exec' | 20 Sep 2004 12:31 GMT | 2 |
Coming back to a piece of work I did a while back, which used a stored procedure to populate a list box. The SP takes a single parameter, and I think this is the reasoning for using 'exec' in the row source (I assume you need this for parameters?)
|
| Writting data into a table with VB (I think) | 20 Sep 2004 12:02 GMT | 3 |
I wish to add usage records to a table to show how many times each of the buttons on my main menu are used. I am envisaging a table which contains the following data: User: Button: Time:
|
| Declaring A Variable | 20 Sep 2004 08:50 GMT | 4 |
In the Declarations section of a form's code module, what is the difference between the following: Dim Flag As Boolean Public Flag As Boolean
|
| Posting eMail w/o MAPI? | 20 Sep 2004 08:17 GMT | 2 |
I've got a little app for managing high school reunions and I've been going through MAPI - but it's kind of a nuisance having to deal with OutLook and all that. Seems like there SB some way to just *send* that message - directly from the app to the email server.
|
| Can't figure out the cause of the problem? -- Compact and Repair !!! | 20 Sep 2004 07:34 GMT | 2 |
I just spent several hours struggling to figure out a mysterious problem with my Access 2002 database. I could not find any reason in the code or on the Forms for the problem. The date in a field on one of the Forms kept re-setting itself to random dates.
|
| size font on a text box | 20 Sep 2004 07:22 GMT | 1 |
How can i change the size of font on a text box acording the number of character (>25 characters the font size 12 )
|
| Reports, filters and crosstabs | 20 Sep 2004 02:49 GMT | 2 |
I am using VBA to determine which query sits behind a report, depending upon the preferred sort order. This has worked perfectly for ordinary select queries behind reports, but it seems to be struggling with crosstab reports. It presents a "jet engine" error.
|
| Filter one combo box based on another | 20 Sep 2004 00:20 GMT | 1 |
I have tried to filter one combo box based on a selection in another combo box, by using the following sample code: tblfield=forms![formname]![fieldname]. However, the combobox only seems to recognise the first record, not the current record in order
|
| Northwind Database | 19 Sep 2004 22:57 GMT | 8 |
Long, long ago when Access 97 first hit the streets a sample database called Northwind was shipped with it. At that time a number of articles had been posted on the correct procedure to remove all the sample data. Does anyone out there still have this information?
|
| Creating outlook message from template | 19 Sep 2004 22:14 GMT | 3 |
I am using the below code to generate an outlook message from a template from within access. I am getting the 'Object variable or With block variable not set' error on the line indicated. What am I doing wrong? Thanks
|
| Counting characters entered in a text box and ... | 19 Sep 2004 20:14 GMT | 4 |
Using VBA code on a form, does anyone know the most effective way to count characters entered into a text box AS they are being entered and displaying the number of characters remaining to the user? Thanks
|