Forms

Question about finding specific record on a Form linked to a table
I have a Form that is linked to a table. It has been used for a while for both viewing records and for updating data. I have added a combo box to the form, and set it RowSource to a query that finds a smaller set of records from table that the Form is based on. When the Form opens, it always goes to the 1 rec... 11 Dec 2009 16:57

DoCmd.ApplyFilter generates Parameter prompt
What would cause the following: I execute DoCmd.ApplyFilter , "[TicketNo] = " & Me!GetTicket and get an error: Enter Parameter Value TicketNo Error looks like I'm executing a query and it is prompting for a parameter Me!GetTicket should have a valid value in it I appear to be positioned on the 'Autonum' row. -... 10 Dec 2009 20:07

DoCmd.RunSQL combobox column
I am not sure what is wrong with the statement: DoCmd.RunSQL "INSERT INTO CaseAddresses ( [Address] ) VALUES (Forms![AddressManager].Form![cmbAddress]![Column(2)])", -1 I have a combo box and I am trying to take the value from column 2 of the combobox and have it enter as a new record in the CaseAddresses ta... 10 Dec 2009 17:55

Drag a file(path) from an Access Form into another app?
I've read all about dragging files INTO Access forms, and dragging and dropping data between controls on Access forms. I need to do something different: MyApp has a subform with a list of files in a folder on the local HD. Currently I have buttons that opens the file using a Shell() command. The Users wa... 7 Jan 2010 05:47

RQuestion on Form Record Selector Bar
Is ther a programmatic way to set focus to a record's Record Selector Bar on a form, so that the user can scroll a continuous form up and down with the up and down arrow keys and not to have to first click the bar? Thanks. ... 10 Dec 2009 20:07

Move Files after import
Hi Everyone, I want to move all the imported files to another path instead of deleting. here is the code i am using. Private Sub Befehl457_Click() On Error GoTo Err_Befehl457_Click Dim strPathFile As String, strFile As String, strPath As String Dim strTable As String Dim blnHasFieldNames As Bool... 10 Dec 2009 03:36

open and close form with one OnClick
Jeannete Thank you very much. This code is what I been looking "Jeanette Cunningham" wrote: Jeff, On the close button of form1st put this code DoCmd.OpenForm "form2nd",,,,,,"value of variable" DoCmd.Close acForm, Me.Name Jeanette Cunningham "Jeff @ CI" <JeffCI(a)discussions.micros... 9 Dec 2009 13:19

How To: Ribbons
Hi, I want to create a custom ribbon menu but load it from code when the database starts (Autoexec), e.g. the ribbon menu is temporary in that I DON'T/CAN'T use the 'USysRibbons' table (ADP and all that, tables are stored in Oracle), so after I've connected to the Oracle server and created a recordset to the me... 9 Dec 2009 12:11

images with word automation
Access 2003 (2000 format) I've done quite a bit of Word automation from Access to build forms for clients but I'm stumped. I'm trying to dynamically build a table of signatures at the bottom of a document. The signatures are stored in a table in Access in an OLE Object type field. I created a single row table ... 8 Dec 2009 23:04

Open a NotePad
I'd like to open a specific NotePad file (c:\help.txt) from a command button using VBA. What code should I use? Thanks. ... 8 Dec 2009 20:53