Search results

Hello O venerable people, It's a long time since I have posted in these forums, and I don't recall ever having made my way into the Excel forums before, so Hi! Having done a couple of searches (and scanned over 500 thread headers) I have to come to the conclusion either I'm not searching...

Vista Ultimate 32 with MS Office 2007, MS Office 2003 and Visual Studio Tools 2003 installed. I am trying to use the Package Wizard to create an Access 2003 distributable (with the Access run time files included) from a split database. Unfortunately everytime I try to cache the language files...

Hi, I have been unable to overcome my issue with merge-ing a document and have had to resort to splitting the document up into several reports, so that the Word template can be used as a background. I have tried several things to get the reports to print sequentially, including having four...

How do you merge to a Word template and save with new filename? 1. Users click a command button. 2. A table is created (done via a make-table query) which contains all of the data from the currently displayed record which is to be linked to a Word Template file (unfortunately, due to some...

I have a database with the following design: TableOne - Main records. TableTwo - Subsidary Records (1) TableThree - Subsidary Records (2) TableFour - Optional Subsidary Records (1) TableFive - Optional Subsidary Records (2) There is a many-to-many relationship from TableOne to TableTwo and...

I've tried searching for the solution but can't find anything that will work on my work system. One of the big problems seems to be that there are no add-ins available, so dim-ing object as DAO.Database, Database, QueryDef and other types doesn't work as the database calls them undefined...

Did a quick search and it appears that this is not unheard of but could not find any solutions to the previous queries. I've "Detect & Repair"-ed Access, I've created new forms, and new forms in new databases but to no avail, none of my ControlTips are visible. The only Knowledgebase article...

I have the following line in a bit of code: If (Me.cboName.Enabled) Then Me.cboName.SetFocus But get error message 2110, "can't move the focus to the control cboName" I have also tried If Me.cboName.Enabled = True Then Me.cboName.SetFocus and If (Me.cboName.Enabled = True) Then...

I am sure that I've seen this somewhere and possibly have even contributed to something along the same lines but I'll be danged if I can find what I'm looking for. I want to put a button on a form which opens up a pop-up form with a calendar control on it. The user can then select a date using...

Yes, it's another cross over subject, involves forms and reports but I expect the answer lies in VBA.... I have a Pop Up form that I use to open reports with; on a form where I give the operator access to a report the open report button actually opens the PreviewReport form, which then opens...

This is a problem of transferring text between two forms and getting a control to update, I've posted this here because I suspect that the answer lies in VBA and not the form... I have a "comments" text box (memo field) on a form, which is locked. Operators are allowed to add more comments...

Is it possible to force the cursor to move to the start of a text box when it gets the focus? (I suppose what I am really asking here is, is it possible to force a 'Home' key event?) There is a text entry box, which when people put the cursor into it, it sometimes sits part the way in...

I have a table in which there are four data fields; date 1 ('lowest') to date 4 ('highest'). The purpose of each field is to record when a particular state has been entered. It is possible for the states to occur in the orders as follows: 1, 2, 3, 4 1, 2, 3, 2, 1 1, 2, 3, 4, 3, 2, 1 1, 2, 1...

The record source of a form that I have is based on a user selection in a combo box in the header of the form. When the form opens there may or may not be any records to display. Currently I put up a message box when there are no records displayed but this only happens when the form is newly...

(This is about forms but I think the solution may be in VBA) I have a subform that I'd like to reuse in a new form but the subform enables and disables certain buttons in the master form. The subform also calls a pop-up which enables the user to select an option (from dates that are calculated...

I've got a form where I've used a text box and the OnCurrent event to display the current record number and recordsetcount. When I open the form from the forms dialogue everything is fine however the form is opened from the menu form I get "1 of 1" when I know that more than 1 records exist; a...

I'm using TransferSpreadsheet to export tables from my dB. Is it possible to password protect the Excel file? I've carried out a search in Modules & VBA but did not find any satisfactory answers, although the posts were all quite old and I figure that someone may have come across and answer by...

Not sure whether this really belongs in the Forms, or VBA or forum, picked Forms because I think it stems from that, despite probably involving VBA in the solution... I'm getting used to using filter by form and find it quite useful for those off-the-cuff queries, however, it is possible to...

I done a quick search and found a few useful pointers but still have some questions: 1) If you use a FE/BE split give each user their own copy of the FE. 2) Make sure that users do not open the dB Exclusively. 3) Give records their unique id just before the record is saved (using the...

I'm *really* new to this subject... I've searched for ODBC but in all the posts I've looked at everyone seems to know how what to do to get things going: I'd like to use Java to connect to an Access database and understand that I need to use ODBC, can anyone push me in the right direction...