| Thread | Last Post | Replies |
|
| Multi User Error Message with single user in fomr | 03 Feb 2006 23:19 GMT | 5 |
I am the only user in a form, using Access 2000. The form has a master and embedded sub form with detail records. I get an error message saying,"You and another user are atempting to change data at the same time". what causes the problem, and how do I fix it?
|
| Use both values from combobox | 03 Feb 2006 22:44 GMT | 1 |
I created a combobox that displays two columns of data. The wizard gives an option to pass the selected value from one column to another control. I'd like to take the other column and pass it's data to anothe control or better yet directly to the database.
|
| Creating Expressions or code using the code builder. Please Help M | 03 Feb 2006 21:40 GMT | 5 |
Good Morning, Afternoon and Evening. I need help from you and after checking some responces i know you all can help. I am new to Access and Databases, i have taught myself in a matter of 2 weeks and have created what i believe to be a fully functional, normalised
|
| using a form with combo box to input criteria | 03 Feb 2006 20:47 GMT | 16 |
I have a query that prompts for input of criteria. I created a form (named it NAMES) and created a combo box, from a table that has the list of criteria. Eg names and SSN. so I can choose the name. I then put a button to run the query.
|
| setting default values based on another control value | 03 Feb 2006 20:23 GMT | 2 |
I have a basic invoice program where I want to populate a form with data from a 'Products' table. The form itself also saves user selections in a separate 'Orders' table. When a user selects a product, I would like to set the default UnitPrice
|
| How to show data in form based on a selected combo box value? | 03 Feb 2006 20:23 GMT | 5 |
I was trying to populate the fields in the other text boxes(only a few of the fields,not all of them) in the form based on the value selected in the combo box. But I have no idea how to proceed as this is the first time I am working on
|
| Record not found | 03 Feb 2006 18:57 GMT | 4 |
I use a data base to store items in a table called so. I want when I type an item code on a combo box and that item is already stored, to bring that record on an open subform and fill the values. To do so I have the code: Dim strFilter As String
|
| Calculating Fields On Reports and in queries | 03 Feb 2006 18:53 GMT | 2 |
Hi I am New to access so if my q sounds a bit of I apologize.. I have three fields on a form where the third field has a calculation in it to calculate the diff between the first two fields.Becuase the answer of the third [where the calculation is]field does not get updated to the ...
|
| Continuous Form - OrderBy | 03 Feb 2006 18:48 GMT | 2 |
Is it possible to type two field names in OrderBy property? e.g OrderBy: [Date];[Time] This works find, but when i exit the DB and start the application again it
|
| Combo or List Box to select data for another form | 03 Feb 2006 18:11 GMT | 3 |
I'm using Access 2000. I have my detail records for my customers on a form with many tabs and subforms. I want just the names of all of these customers (scrollable list box would be nice) to always show up to the left of my form along with some demographic information about the ...
|
| weird behavior for form ... | 03 Feb 2006 17:48 GMT | 4 |
I have been designing forms in access, but never encountered this before. I created new form for data entry in Access with Sql server backend. I created couple of records using this particular form/table. When I open this form, I don't see the already existing records even though
|
| Data entry - fields from 4 tables | 03 Feb 2006 17:12 GMT | 5 |
I'd like to be able to perform data entry for fields from 4 tables, in a single data entry interface. (I'm using Access 2002, SP3.) Is there a way for this data entry to be done from a single interface in Form view?
|
| Subform opening with no textboxes | 03 Feb 2006 17:08 GMT | 4 |
Hi there; I have a series of five subforms which are called on via command buttons on the main form. All subforms open properly except one. The bad subform, when opened, displays the labels but none of the associated text boxes for them.
|
| Static data on a data input form | 03 Feb 2006 15:59 GMT | 3 |
I have a data input form tied to a database that calculates an install price based on certain criterea. I want to be able to display some static data on the form based on data entered in box 1 So say a user inputs customer XYZ I want the name and contact info to show but still
|
| Searching | 03 Feb 2006 15:55 GMT | 1 |
What i need to do is, have a form so that a user can enter in a Name and/or month and results to be displayed in a list box!! how do i do this???
|