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

The form is bound to a Query (derived from Main table). The new record is saved using a button control. When the button is clicked to save, I have a dialogue box which appears to ask the user "Do you want to save this record?" Hope this helps, Jeannie http://www.thefloyds.50megs.com

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

Great solution. I also made the field hidden so it works like magic! hehehe Thank you Jeannie http://www.thefloyds.50megs.com

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

You da man Ace! Jeannie http://www.thefloyds.50megs.com

Sorry for the delay..... [COLOR=red]1. I have a mouse hook Module heres the code:[/color red] Option Compare Database Option Explicit Private Declare Function LoadLibrary Lib "kernel32" _ Alias "LoadLibraryA" (ByVal lpLibFileName As String) As Long Private Declare Function FreeLibrary Lib...

Flushing the cashe didn't help....sigh Jeannie http://www.thefloyds.50megs.com

Hi TheAceMan1!, When I make a selection it looks like the form moves up, as indicated by the scroll bar (it moves down). I will try flushing my cache by rebooting and let ya know. Jeannie http://www.thefloyds.50megs.com

same thing...... Jeannie http://www.thefloyds.50megs.com

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

PHV - point heard loud and clear. My question to follow up is, how do I arrange it so that Access understands that each tab = a record? I now have one table with 15 fields + an autonumber field. The tab = the city or location. I have 24 tabs therefore the table should populate with 24...

The one that says you are only allowed 255 fields in a table/Query. All together I have about 360. Jean Jeannie http://thefloyds.50megs.com/index.html

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

PHV: You ARE the best! Jeannie http://thefloyds.50megs.com/index.html

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

woohoo Thanks as usual guys! Jeannie http://thefloyds.50megs.com/index.html

Yes, thanks. I attempted to test by leaving the query open in design view, opening the form and filling in the fields. However, Access will not allow me to go back to the query to click the exclamation button to test? Jeannie http://thefloyds.50megs.com/index.html