Search results for query: *

In earlier versions of access, this code worked fine to merge and save a document. Private Sub cmdMerge_Click() Dim strFileName As String Dim strFilePath As String Dim strMergeFile As String Dim objWord As New Word.Application Dim objDoc As Word.Document objWord.Application.Visible =...

Memo fields in a union query are being truncated to 255 characters. Is this a known issue with Access 2K? Is there a fix/work around to correct this? Thanks. Larry De Laruelle

In ReportA, I have a test in the detail_format event that, when evaluated as true, will open ReportB. What I would like to do is then close ReportA. I have tried 'DoCmd.Close acReport, "ReportA"' but receive run time error 2585 "This action can't be carried out while processing a form or...

We are using an application called bmail to send help desk notices to the appropriate department. The email are sent to an external account (dept@fccin.org). The 'from' line is populated with the user's name captured as Environ("UserName"). This format is correct for internal email. Upon...

Is it possible to change a subform's recordsource from the main form? Based on user choices, I want to change the query behind the sub form or, alternatively, use and sql string in record source. I've tried: frmSubForm.recordsource = or me.formSubForm.recordsource = both produce an error...

I recently distributed a small application to about 50 users using a front end download process to put the front end on the user systems. The application is Access 2K. Some users have XP Pro, some have Windows 2K Pro and some have Windows Server 2003 (terminals); all have Access 2K installed...

We created an A2K database and used the security wizard to set up a new .mdw file and implement security. We created necessary groups, added users and assigned them to the appropriate group. We then split the db into front/back ends. I thought that the new back end would inherit the same...

Using Access 2000; SP3. Windows XP Pro OS. Application has been up and running for several weeks with no problem. Front end is downloaded to the user's system; back end resides on a server. User attempted to do data entry today and received an error when writing a new record that the...

I am trying to set up a TransferText and receive an error message: Run-time error '3027': Cannot update. Database or object is read only. Here is my code: DoCmd.TransferText acExportDelim, , "tblSvcTypeTest", "H:\Archive\SvcTypeTest", -1 I have full admin rights to the database I'm using...

Is there a programmatic way to disable the Autocorrect feature in Access? Larry De Laruelle

I have had this occur only a few times but it is driving me to drink (short trip) since I cannot replicate the problem or figure out what is causing it. Situation: Combo box used to lookup values from a table. Table contains a Primary Key, a description field, an Active (yes/no) field and...

I have set up two accumulators to count records based on the value of one of the report's fields. The two variables (integers) are declared as module level and are initialized in the Report_Open event to zero. In the Detail_Format event I have an if then statement testing for a null value; if...

I have a combo control on a form that I want to filter based on a value in another form. The main form allows the user to select a record and open an edit form for that record and also contains the value for the filter. A combo on the edit form needs to be filtered for values appropriate to...

The display value in a combo box is being deleted from the underlying lookup table. (Two column combo - PK and Description with the PK hidden.) Somehow a user is causing the description to be deleted. This has happened twice. All other fields for that record are intact. I have tried to...

I'm trying to requery a subform on a secondary/display form when a combo box on the primary form is updated. cboselect After Update (primary form) Forms!frmMedAuthMain.cboSelect = Me.cboSelect This works fine to sync the primary and secondary forms to the same client. I have tried...

Situation: Need to delete and make a report setup table in the back end of a split database from the front end. From what I have gathered this requires the use of workspaces but I'm not clear on how to do this. Would appreciate any assistance you can provide. Thanks. Larry De Laruelle...

Is it possible to set the value of an option group using VBA? I have an option group for school semesters and would like to set the selection based on semester dates. I have tried to assign the value to the bound frame using: fraSemester = intQtr (intQtr is set using a date comparison test)...

Secured using user level security. Application worked fine yesterday. Today, all users getting this message. Tried recovering a copy of the mdw from the last back up; same result. Since the backup copy produces the same result is there another glitch that is causing this problem? I have the...

I have a memo field on a tab control. When the user clicks on the 'Notes' tab, I would like the cursor to be placed at the end of the existing entry/ies so the user can begin typing the next entry. Currently, it highlights/selects the entire entry and, of course, the first key stroke deletes...

The main form contains two sub forms on a tab control. When the cursor moves to one of the subforms, the record is committed. I have an undo button on the form that tests the dirty property of the form: if true, the undo action is run, if false, the delete action is run. The undo button is...