Search results for query: *

I have created a database using an existing template. I would like to change the names of some tables and fields so that they reflect their true use. Is there a way to change the name of a table and or field and have all associated or "old" names automatically change to the "new" name...

I know that I can change the page properties so that I can have all v-links a certain colour ect...What I would like to do is have the v-links remain the colour that is identified in the font attributes. I have text that is red, some yellow and some blue. I do not want those colours altered...

I am creating a printable versions of existing pages. I would like to force new pages when printing, instead of having everything follow. If I create a .CSS help says it is not universal and may not work with many browsers. Is there an easy html code or something I can insert at the point...

I have created an index that prevents duplicate entries on two fields (same first and last name). Access generates an auto message when a duplicate occurs so that it can't be saved. Can I change the content of the message...or how can I have my own error message pop-up, not the system message...

I have a form that acts like a bulletin board to communicate information to other shifts. It has an auto number assigned when a new bulletin is created. There are a number of check boxes that are checked by employees to acknowlege that they have read the bulletin. There are instances where...

I have a form with a selection box control. The user selects a location and the record is displayed on fields to the left of it. The fields are the same width and height stacked on top of each other looking like a grid. The problem I have is that when the user switches his selection in the...

I have a tab control form with, 2 rows of 12 tabs. Each tab opens to reveal various on-call information for particular office locations throughout the province. Due to size limitations I have had to create 3 different tables to handle the form. tblOnCallA-N tblOnCallO-Z tblOnCallSpecial I...

I have a query that I want to use to solicit information regarding work orders. the custom diologe box I created has four controls: 1 combo box for technicians name 2 Beginning Date 3 Ending Date 4 combo box for File Number + the Cancel and Ok buttons I would like the user to input required...

I wish to use a custom diolog box to solicit parameters for a query. I created the diolog box, then I created the query. Under the criteria for "Technician" field I put: [Forms]![frmReportParameters]![cboEmployeeName] However, when I run the query, my diolog box does not open but rather an...

I have a main form called Workorders by Detachment. It has a combo field that lists all possible detachments, when a detachment is chosen all other fields (address, phone....) populate with applicable data. The form is based on a table called "Detachments" and sorted by detachment name. I do...

I have a workorders data entry form. It contains a subform where users are to enter technicians assigned to the file and man hours spent on it. It is linked via the workorder ID autonumber field. It works fine except.... when I want to enter a brand new workorder. The fields go blank and an...

Hello all: I have a select query: It contains the following fields: WorkorderID (Group by) ManHours1 (Sum) ManHours2 (Sum) ManHours3 (Sum) Currently it returns the sum of labour for three different technicians working on the same workorder. I have an additional field called Total Man hours...

I would like to post our work schedule using Quattro Pro. I would like some users to have view only permissions and others to have editing privileges. I thought that I could set the password to "editing using controls only" and then have a button on the page that when clicked will ask the user...

My database has a switchboard with 6 buttons to choose from. One of these buttons will list all records associated to a company name. Currently, when the button is clicked an "Enter Parameter Value" window comes up to have the user enter the name of the company to search for. Once the company...

I would like to have my data base automatically back-up when I log out or close. How can I do this? Please provide code, if necessary. Jeannie http://thefloyds.50megs.com/index.html

I have a form that I would like to send to interested people once it is filled out. I would like to send it in a format that will produce an almost exact replica of the form - Logo's and all. From what research I have done the best format seems to be html. Question: Can I create a template...

I have a single record form where users enter employee information. I have a field on the form that is used to mark the employees status like vacation, parental leave ect. It remains blank if the employee status is normal. I would like the field + two others to change colour if the first...

I have a database that appears to open and run fine. I am having a problem creating a back-up disk. It starts to copy and then gets stuck/freezes at 10 sec. Recently the copied DB shows the following error when trying to open. "Microsoft Jet database engine could not find the object 'MSysDb'"...

I found a utility build for Access for management of front end and back end. It is called SSW Data Pro. Has anyone ever used it, or is using it? The link to the site is http://ssw.com.au/SSW/DataPRO/ It looks very interesting, it may be something useful. Feedback is appreciated. Jeannie...

I have a compile timer form that counts down and sounds an alarm when it gets to zero. The form has been working fine for a long time and now out of the blue I am getting a compile error - User-defined type not defined. How can I fix? Here is the code: Public Sub SoundAlarm(AlarmCount As...