Search results

Is there anyway to change the format for a paramater date field from yyyy-mm-dd to mm-dd-yyyy? Sure seems like this option should be able to be changed. Not really a normal format for users.

I have 2 table linked to each other. A products table and a categories table. The products table has fields. A Product ID field and a Product Name field. In the Categories Table it's the same, a Category Id and a Category Name field. My issue is this. The seperate table that stores these values...

I have a drop list box with 5 values in it, and another list box with many different values in it. I want the user to be able to make a selection from the first list box and based on that selection the second list box will have only values to select from based on the first box. Can anybody...

I have been asked if there is a way to record data changes made to the dtabase for auditing purposes. Does anyone have and ideas regarding this. Thank you in advance

Is there a way that when a user selects to add a new record that the values of the last record entered can populate the new record with the exception of corse of the primary key value?

I have some users who input data into a form. They would like to have it so that once they have entered data into a field and move to the next field that the info they already entered into the previous field cannot be altered. Is this something that can be done?

Is there a way to program a command button so that it asks for a password prior to being executed?

I have a button on a form and I want it to insert a text value into a field when pushed. Lets say I want it to insert the work "Leg" into the "body_part" field. How would I write the event code. I am not much on code but I do know how to copy and paste. Thanks

Is there any way to create an image map for selecting areas based on an image. I have an outline of a human body which is a graphic that is placed on a form and I would like to have users select parts of the body when submitting an accident report that will insert values into a field. Thanks

I have a form that already contains an email address. How am I able to turn that into a mailto: hyperlink or do I need to set up a macro. Thanks

I have a form with a combo box list of names. When I select a name that persons information populates the rest of the fiels. As well, I want to create a report and tie it to a command button on the forms page so that once a name has been selected the user can push the command button and that...

On a number field whose format is "fixed" and decimal is "Auto" how do you stop the results from automatically rounding. I need exactly what is typed into the field to stay and not round itself. Thanks

Seems anytime a user clicks into a field on my form with their mouse "say a date field" it places the curser in the middle of the field. Then a person will enter the date but it starts placing the data in the middle of the field. Is there anyway to tell the field that when someone clicks into...

How do you make a field in a table require that it has to be exactly 10 characters long when the user inputs text into the field? This is a text field

I have upsized my database to a sql server and kept the mdb file to work from. I see that there are now 2 copies of each table. 1 is a local copy and the other and odbc copy. If I want to modify or add a field in a table do I use the local copy because opening the odbc copy tells me I cannot...

I have no problem inserting the Calender control into a form but does it have to be so big! Surely there is a way to have it an icon and enlarge on click to full view for input. I am not familiar enough with it though to know how to do that. Thanks

I have a form field that can display reults in "Red" because they meet the conditional formatting criteria. However, how can I create a report showing results that meet the condition. On the "Form" I have the result just turns red if it falls within the condition but not sure how to show those...

I have a field named "value" and need it to compare itself to another field that holds its "value limit" and another field that is a "plus or minus value". I am trying to do a conditional formating that turns the "value" field to a red color if it is not withing limit guidelines. For example...

I have a field named "value" and need it to compare itself to another field that holds its "value limit" and another field that is a "plus or minus value". I am trying to do a conditional formating that turns the "value" field to a red color of it is not withing limit guidelines. For example...

I have a short date field but I would like to format a seperate text box that will only display the last 2 digits of the year. ie: 01/05/2009 = 09