Search results

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 think we're on the right track but I am not sure what the "me" part means. Thanks

I get the conditional formatting part but how do you write an expression that uses plus or minus 0.2?

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

I have a combo box that pulls up values from a products table which has a product number field as well as a product description field. I can get the product number value to store in another field but I would also like to be able to store the cooresponding products description into a different...

I have a main record form with a subform to record events built into it. If I am in the subform and want to add a new record I either have to click the New Record button or tab through thte fields to the end then a blank record appears. Seems there should be a way to have the subform insert...

Little confused. Subform only shows me the records that are linked to it's main record. I think you are on the right track though but not sure what you mean about a query that only shows linked records

I have 2 tables and they are linked. Main table holds lets say a "Main" log record which is input from a form. The linked second table holds multiple records associated with it's Main record. They are input from a sub-form that has been inserted into the Main form. If i am in the subform of a...

Yes, with each main log record there should be 100 sample results records associated with it. Just trying to find a time saver for the user so they won't have to manually insert 100 records each time. Thanks

First let me start by saying--<So far the support I have been given on this forum has been great. Started new job 3 wks ago and have to database labratory results from testings of milk samples.>-- To my question. I have a main form from the main table that acts as a login for main test samples...

I have code that I built into a control in FORM view that changes the background color of the box based on a certain selected value and it works fine but when viewing the same form in DATASHEET view it does not work. Is this the way it's going to be or is there a workaround. Thanks

I hope this is something simple but I need to define a field data type in a table so that it is a number but allows the user to enter example: -3.5 and have the field hold that exact value. I can do with a text field but calculations may need to be done on this field later on. Thanks in advance:D

Say I have a control that only accepts 2 values, one would be "Positive" the other "Negative" text values. Then say I have another table called "Positives". Is it possible to set the control up so that any time a value of "Positive" is selected then a new record is created in the "Positives"...

I have a field in my table called "testcalc" and I want it to be calculated but when I put the calculation in it's control source it's data does not stay because it's lost it's contol source. How do I keep the control source "testcalc" yet build the calculation into it

How do you invoke a save action. You mean simply click the save icon?