Search results

Hi, In my Word docx file is an existing table, formatted with a header row. The code below works correctly (to a point) by transferring the recordset to the already opened docx and populating the the table with the SQL from vba, starting in the 2nd row onwards. No errors are shown, but the...

Hi, just looking for ideas if anyone is interested... In Access 2013 I export certain form fields to a Word docx file which has predefined Bookmarks. This works perfectly well. Like so: 'code for Dims and Strings etc 'code for defining path, docx name etc 'then this: With myDoc...

Good day. I have the following function that does this: - Opens a MS Word Template with form fields. - Fills the Word form fields with the data from the access form. This works as expected: Function FillReport() Dim appword As Word.Application Dim doc As Word.Document Dim path As String...

Hi, I know this should be so easy, yet I have a mental block on this at the moment. Please help. tbl_myTable: Columns/Fields: - pkID (primary auto), - clientName (text), - q1 (text) - can only be "ABC" or "DEF" (from form's radio button group), - q2 (text) - can only be "ABC" or "DEF" (from...

Greetings, Forgive me for being lazy today. Lack of sleep coupled to age... One to Many tables: tbl_Doctors - Main Table : PK is doc_ID tbl_Patients - Related Table : PK is pat_ID and 'related key' is docpat_ID Dr. John has 3 Patients Dr. Sam has 7 Patients Dr. Andrew has "No Patients" IE...

Hi all, (I have searched and found many articles on this, but none of the solutions fits my needs, unless I am misunderstanding a few) Due to software licensing restrictions, my (Access 2007) development pc is NOT (may not be) connected to the network. The user pc's are all connected to the...

Hi all, I use this and it works as expected: Mid([myField],4) The data in myField will almost always start with 'ABC' followed by 'somedata'. Using Mid does this: [ABCsomedata] turns to [somedata] But if myField contains only 'somedata', then the following happens: [somedata] turns to...

Hello, It is 2am on a Sunday so please be nice. The form has a txtOriginalFile control. This is a hyperlink to a file at it's original location\folder. The record source's PK is in control txtMyPK. The following code works as expected and copies the file to the destination folder (myFolder)...

Hello, I am using the following Module and Code and it works well: http://www.access-programmers.co.uk/forums/showthread.php?t=228573 The only problem is that the backend is password protected. So everytime I call... Call CompactBE ...it prompts for the password. I can ofcourse just...

[SOLVED] VBA to simulate Acess 2007 Atachment doubleclick Hello. I would like to add a cmdButton to add attachments to the attachment field instead of the user having to doubleclick the field itself. Any ideas ? Thanks. Jamie.

[SOLVED] Windows Login User - not Database User Hello, I am successfully using the following AuditTrial, and it works well for my needs: http://www.access-programmers.co.uk/forums/showthread.php?t=140387 In the field "User" in table "tblAudit", I would like to Log the Windows UserName...

Hello, Please help me with this if you can: - On "myFormA" is a ListBox named "lstMyListbox" (column 0 is primary key same as myFormB). - Another form, "myFormB", is a SingleForm(view) which shows records from a query. - On "myFormB" the PrimaryKey field is "txt_myPK". - Also on "myFormB" I...

Hello. I am trying to simulate a mouse-click of a cmdbutton on another form, or call the Click event of a cmdbutton on another form. From Form1, I want to "click" a cmdbutton which is located on another form. Here's what I have so far: Form1 is Open. A cmdbutton on Form1 has the following...

Access2000 Hello The mainform is based on a query and also has a autonumber(prim key) field as well as several other fields. Several sub-forms on the mainform links to the mainform's autonumber field in a one-to-many relationship. When the user opens the mainform (with recordsgotonew), the...

[ACC2000] Hello, I am already using the mousehook dll which works perfectly well. In a long(vertically) Form, I have set the Scrollbars to 'Vertically Only'. I still want to use mousehook.dll to prevent scrolling records with the mouse, but I would like to be able to scroll the Window(form)...

Hello everyone, In Access2000, I have designed all my Forms with my own choice of background colour, Button colors, etc. As part of an upgrade to my database, I now want to change the background color of all the forms. Is there a way (maybe VB code ?) to change the color of ALL THE FORMS...

sorry about typo in TITLE (must read : return login name (AND DESCRIPTION) Hello, In my company we use the Employee's Employee-Number as a Windows login name. This is registered in the Domain along with the Employee's Real Name. So at the Windows(XP) login screen the user enters his/her...

Hello, In ACC2000, I am using the Module from this page... http://support.microsoft.com/default.aspx?scid=kb;en-us;197592 ... to keep an audit trail of the record. So, the table has a field named "fAuditTrail" and on my form(s), in that field's BeforeUpdate event, it calls the "AuditTrail()"...

Hi, On the form there are 15 fields and a custom "SAVE" button for which the OnClick Event checks various things before storing the record. There are 3 specific [textbox] fields which must not be duplicated in the table For example: PK=personnel_id Field1: John Field2: Doe Field3: Logistics...

Hi, (Sorry about a previous post with the same Title. There's no content for that post, don't know what happened there...) I am using Access2000. Scenario 1 - no problem, works as expected. Scenario 2 - Need your help here. Scenario 1: Mainform named [frmPatAuths] (no subforms). Based on a...