| Thread | Last Post | Replies |
|
| ActiveX Component | 31 May 2005 19:03 GMT | 10 |
All of my Wizards in Access 2000 have quit working. The message I get is: "ActiveX Component can't create Object". I reinstalled all the Wizards from my disc but it still dosen't work. I've looked for something under Options or Tools but didn't see any place where the Wizards ...
|
| Cascading Combo Box and Subform | 31 May 2005 18:00 GMT | 1 |
I know that this question has been asked many times but for some reason i caanot seem to apply the answers to my problem. I have Three Cascading Combo Boxes that work great in there own form, once it is used as a subform i get a prompt to enter a value
|
| How to enter data into a table using a combobox | 31 May 2005 17:04 GMT | 12 |
I've tried to learn for months how to set up the properties in fields in my forms to enter data directly into a table by typing it into a combo box. I've tried changing the "limit to list" option to "no" but consistently I come up with the primary key number on all of the fields ...
|
| Export Data | 31 May 2005 16:37 GMT | 4 |
I have a query which I used to export to a Microsoft Word Mailmerge format and I'm wondering how can I do this using code so that at a click of a button, it could be exported instead of having to run the query and then manually go to File>Export...? Thanks.
|
| Updates/Inserts in Outer Join Query | 31 May 2005 15:05 GMT | 1 |
My form is based on a query. I want to display all employee hours whether Invoice has been received or not. If invoice is not there, then my form should display blank fields. When new invoices come I need to update the invoice fields and create a records in the invoice table. ...
|
| How to change the format of a displayed number in a form | 31 May 2005 14:47 GMT | 1 |
I am developing an HR database and trying to show deductions for each employee on a subform. The 2 relevant fields are "dedid" and "dedrate". "dedrate" is a number field but can mean 2 different things. If dedid = 401, then dedrate is a percentage
|
| Tab onclick not responding | 31 May 2005 14:06 GMT | 3 |
Anyone any ideas why a procedure on the OnClick event of a tab based form isn't having any effect on the controls that I want it to? I have some buttons down the right hand side of the tab form and, having been disappointed to find they persist for all tabs rather that apply only
|
| Need technique for coordinating two listboxes | 31 May 2005 13:44 GMT | 2 |
I need a technique for coordinating lists in two listboxes. The box on the left contains a list of people's names. The first column is hidden and is the record key of the name table. The box on the right will contain a list of names of those people who have been selected from the ...
|
| Validation Rule | 31 May 2005 12:45 GMT | 1 |
I have a problem i want to do some validations once a user clickes on the close button or new product button the validation works fine but if I am on a blank record that and I click on the close button it comes with a error. Basically what I want it to look is the record number ...
|
| What's wrong with the following code | 31 May 2005 11:49 GMT | 1 |
I have the following code when execute returns with an error saying "Syntax error (missing operator) in query expression '(((Orders.OrderID) = IN (465,477)) And ((Orders.Status)=1))'. Thanks. Private Sub Command28_Click()
|
| how do I pull out particular field by selecting one option from c. | 31 May 2005 10:48 GMT | 1 |
I hv created combo to select department. by selecting particular department the teachers name should display in the screen in text button. one teacter will be in one department or more. everytime I change department, the teachers name applicable to that
|
| Modifying form after modifying Source table | 31 May 2005 09:54 GMT | 2 |
Access 2K Win98 I had based a form on 2 tables : ReferalTMH and EmpTbl with the following record Source: SELECT [ReferalTMH].[IDNUMB] AS ReferalTMH_IDNUMB, [ReferalTMH].[DepID],
|
| Newrecord Always Wnt want to... | 31 May 2005 07:33 GMT | 1 |
Dear Tim Tim, You're required,, yes Mostly when to open the form from the source query, "qrydbs1" will list all records, but on the opposite something happens that I need only to list none
|
| Filtering to Cline | 31 May 2005 03:27 GMT | 1 |
I have a form which I use to invoice clients. This is actually 1 form with 2 subforms Client - Invoice# - Charge Detail I Have a combo box to choose the client on the client form.
|
| MI problem | 31 May 2005 01:30 GMT | 4 |
My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus Fax. When I tab to MI, I get a beep and an error message saying, "Control cannot be edited; it's bound to unknown field, 'MI.'" What happens is when I begin to input data in the first name field, the MI
|