Search results for query: *

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

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

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

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

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

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

Hi, I am using Access 2003. I would like to know the easiest way of moving the contents of an unbound field to a listbox? I have a text field called 'newdat1' and a listbox field called 'lstselecteddat' on the same form. I would like to use code in a command button to move the item. Is this...

Hi, I am using Access 2003 and I have a database that I inherited that I need to correct a few things on. I have a paired list boxes on one of the forms. The two fields are unbound. I can add items to the database by selecting items from the left side of the list and moving them to right side...

Hi, I am using Access 2003. The code below is attached to a command button that is suppose to attach a record to the bottom of a temporary table when pressed. The table is displayed in a subform but most of the info. to be attached in the code comes from fields in the main form. The temporary...

Hi, I am working with Access 2000 and I want to be able to delete records from a table based on the information given in a form. I have this form that the user can put in a couple of parameters to run a query. The parameters are "Userid" and "Range_Date". After the form with the user...

Hi, I am using Access 2000. I have this form that brings up selected records in a table to edit, delete, etc. I have this one particular record in the table that is linked to the form that I do not want deleted or modified by the user in any way (I am sort of using it as a place holder in...

Hello, I need to insert tne contents of an external document in a MS Word97 formfield(bookmark) using a command button. I am trying to insert the document within the field without deleting the formfield(bookmark). All the codes that I have tried so far including the following has only...

Hi, I need to insert tne contents of an external document in a MS Word97 formfield(bookmark) using a command button. I am trying to insert the document within the field without deleting the formfield(bookmark). All the codes that I have tried so far including the following has only deleted...