Search results for query: *

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...

Hi, I am using Access 2000 I have a dual multi select list box in a database which has over 30 different choices that the user can select in single or many combinations. I am having problems on figuring out how to save the selected choices to a table. This table(Table 2) is linked to a main...

Thanks PHV for your prompt reply. The code works just great. I was wondering though what kind of changes I would need to make in the code to have just a single departments highest number appear in a single unbound field on the form so that I may manipulate the number individually as well, ex...

Hi, I have a field that I use as a unique id/counter in a database. The field is numeric and the total length is 10 digits. The first 6 digits of the number are used to identify the departments in my company ex: 744445 (accounting department) 745587 (personnel department), etc. The last four...

fneily, The info. for the list isn't in a table. All the choices for the listbox was placed in the 'Row Source' properties. It might be worthwhile for me to create a table to store the info. instead of through the listbox properties. The following is the code for the command button that...

Hi fneily, That's pretty much what I wanted to do, Thanks. I inherited this database that had a paired listbox but my boss wanted me to change it to allow additions to the listbox while in the form. There is another command button on the form that saves the contents of the list to the...