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

How do I get the list boxes to place their value in my data field though instead of being unbound. Thank you for the reply. I am making some progress.

How do I get the list boxes to place their value in my data field though instead of being unbound. Thank you for the reply. I am making some progress.

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 like what I see here in the audit db. It looks like I need to create a seperate table for the changes I wish to record as well I see 2 modules. If I were to expert the table and modules into a seperate database do you suppose that it would work. Then I could do some simple modifications to...

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

That didn't seem to work. I can tell the form to Not Allow Edits and it works for a record that has already been entered but when i add a new record, fill data in a cell, move to another cell then come back to first cell - it still allows me to change the data. Don't want that.

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

Ooops!! My Bad, I meant pbaldy.

Wow, u guys are fast. Yes baldy along those line except I am going to pass the value to a report query. I will give it a try and let you know. Many 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

That may do it. I will give it a test. Thank you

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