Search results

I have a text box that takes the date of service and adds a "!" before and after the date. (control source ="!" & [dtmDateOfService] & "!") That works but I need to take the slashes out so my bar code reader will read it as a date. What do I do to get rid of these slashes? Thanks

First, I thank all of you for taking time to help! I have a form that has a tab control sub form, in tab # one I have name/address demographic, in the other tab sub forms I want to use the name field from tab # one sub form (helps to keep them focused) I use unbound field in some cases to...

I have a form that has the following fields: Location, Address, City, State, Zip If the location is one of our frequent locations, I have a sub form that they can pops up and click on a button to enter all the address info it in the database, if it is a new location t they will enter it from...

I have a form that has four or five fields in it and a few option groups. What I want to do is to use the same form by pressing a button for a new form (I've done this) but it does not clear (reset) the option buttons. How do get clear and reset these buttons. Thanks.

I have a form with four or five fields, one of them being a time. I also have some option groups that are to be checked. What I would like to do is use the same form, have them complete the form and when they are ready, enter new data by pressing a button for a new record and reset all the...

Combining text I have two text fields that I would like to combine. One of them is a combo box. However when I use =[tblOne]![strText1] & " " & [strText2] I get "John 1" with 1 being the column in the combo box instead of "John Doe" that shows up in my table. Please help! Thanks

I have a form that for simplicity has four boxes, left upper, right upper, left lower, right lower. Each box has a check box in it. I don't want to use the option group because I need to be able to check none, one two... or all boxes. If the boxes are checked it will send "text" to a field...

I have a query, that dependent on a value from an expression I need to change the forecolor, my expression is: Expr1: Format(IIf([DispatchedTime]>[EnRouteTime],DateAdd("d",1,[EnRouteTime])-[DispatchedTime],[EnRouteTime]-[DispatchedTime]),"hh:nn:ss") What I need is if the Expr1 is greater than...

Is there a way to use check box to enter data. I have set up a yes/no format and change the format to "" (for not checked)and "Red" (for the checked). Is there an easier way to do this? What I would like, is to check boxes and have it enter the label as its value [ ] Red [ ] Blue [ ] Green...

I have a set of times I need to calculate the laps time: Notification Time En Route Time On Scene Time I need to subtract En Route time from Notification Time and On Scene Time from Notification Time. I also run into a problem when calls start at 23:15 and end in 00:15. Can someone help me...

I have a querie that they have to enter their password to get to their specific data. I use [Enter Password] in the command line to limit them to their data. However when the box opens "Enter Password" you can see their password. Is there anyway your can make this popup box a "Password"...

How do I do an auto entry like the following example: ID Number Mail Name Mail Address City State Zip [] if same press button ID Number Ship (ID would be entered) Ship Address City State Zip what they would do is enter the mail address info and then press the button to have the same info...

How do I combine fields from one recored to make a sentence. Owner|Color|Sex |Animal|Pet's Name| ------------------------------------- Jane |Black|Female|Cat |FiFi | John |Red |Male |Dog |Spot | In a report to come out as Jane's Black Female Cat name is FiFi (or) John's Red...

I have a form, when it is complete the person completing the form must sign the form. Can I add a box/field that a input device (graphic tablet) can input their signature and then be printed on a report. Also how do I keep that box/field private so it cann't be used again. Thanks.

Is there a way to have a memo field spell checked automatically once you leave the memo field. Thanks

We use a form to enter our data (forms, multi sub forms), once that data is entered I need a button (command) to press, from this form, to print another form (different format) with all the data we just entered. Presently they have to get out of this form, go to the other form search for the ID...

I have two tables with the same information (Name, address, phone)as well as other information. In most cases it has alot of the same information, but can be different hence two tables two primary keys. We presently key information in one table (subform) and the other information(separate...

I need to calculate a person's age at the time the field is entered. We enter the person's date of birth when we enter data. Please help. Thanks