Recent content by Delano29

Thanks Bubba. It looks like what I needed to get started. I'll try and modify it for my needs.

I have a table called “tbl_expense” and a form called “frm_expense_edit” that I use to edit the records in a table called “tbl_expense”. I am trying to set up a third form called “frm_find_all” that has fields from the “tbl_expense” table and they are the following: “office_id”, “employee_id”...

Hi Aceman, The Officecode is the primary key in the Officename table and its the foreign key in the Employee table and they are linked as a one-to-many. Should it be setup that is a parent and the other child? If so, how do I go about doing that? Thanks.

Skip, I created the form using the form wizard without using code. I thought that since the Officecode field are in both tables in a one-to-many link that if I changed the Officename of the employee it would change it to the right Officecode automatically. For instance: Office Table...

I have a form based on the Employee table listed below. The Employee table and Office table are linked as a one-to-many relationship using the Officecode field in both tables. The Employee table uses the Office table (Officename field) as a lookup. My problem is when I created the Employee...

Hi, I am creating a MS Word form that has a lot of drop-down list fields. Currently, the drop-down arrows for the list boxes only appear when a field with a drop-down list is selected. Is there a way to have the drop-down list arrows appear in all the drop-down list fields on the form at the...

Thanks. I'll try reposting it to the VBA section. The form is a word template that generates a new form. The text of the documents (located in another directory) are inserted rather than the entire document. When the user selects a command button a form comes up giving a choice of inserting...

Hi, I am using a form in MS Word. I created a macro to insert a choice of documents in one of the form fields. When the document is inserted it breaks the form in an area that is not desirable. Is there a way of inserting a page break in a specified area on the form using a macro? For...

Thanks ck1999.

Guys, those ideas never even occurred to me. Thanks. I'll try them.

Hi, Is there a way to open, save and then close Excel files using a macro or VB? I have several linked files located on the network in a single folder and the process of updating the links takes quite a long time. I would like to automate this as much as possible. While having the main...

Thanks. Will do.

Hi All, Is there a way to save and close Excel files using a macro? I have several linked files located on a network. The process of updating the links takes quite a long time and would like to automate as much as possible. I have used the 'Start' command to open the workbooks but stuck on...

Hi, I am using Access 2003 and I need to link three combo boxes on a form. I have a form ‘mform’ linked to a table called ‘mtable’ the table has four columns ‘manufacturer code’ ‘manufacturers name’, ‘make’, and ‘model’. The table contains hundreds of manufacturers and each manufacturer can...

Hi, I am using Excel 2003. Is there a way to limit the amout of characters that you could put in an excel spreadsheet column? For instance, if entering alpha numeric information in column H I don't want the user to enter more than a three character reponse for that column. I couldn't find any...