| Thread | Last Post | Replies |
|
| Run time error | 15 Feb 2008 02:34 GMT | 1 |
Good day, I'm getting the -2147352567 (80020009) runtime error when I attempt to access a editable form. Along with the runtime error a message states that the recordset isn't updateable. Any information will be appreciated. Thanks.
|
| ADO find method | 15 Feb 2008 00:31 GMT | 1 |
I've coded a somewhat complex conversion program. Its creating a table based on the contents of another table. I'm creating an artificial key composed of name and phone number that must be unique. Before I add records to the target recordset I need to issue a find command
|
| Duplicating a record leaving one field blank for editing | 15 Feb 2008 00:29 GMT | 6 |
Hi - I've seen many different posts regarding duplicating a record - I am able to do this fine, however I do have a need to leave one of the fields (Position.NewLineNo) blank so that the user can fill it in. This field is not a primary key - I have a PositionID field which uses ...
|
| subform backcolor | 14 Feb 2008 22:11 GMT | 3 |
I have form and sub form I want to change backcolor of the subform (from the master form but I can't) how can I do that My code is:
|
| Query not populating form | 14 Feb 2008 22:11 GMT | 5 |
I have CustomerName query that retrieves the CustomerName, Address, City, State, and Zip Code from the CustomerName table. CustomerName is a combo box. How do I get this query to put all the corresponding fields into a form automatically after selecting a CustomerName from the ...
|
| Populating subform based on a selection from master form | 14 Feb 2008 21:53 GMT | 1 |
I have a master form that displays various Customer values (ie/name, address, specs). I am adding three subforms. I am having trouble figuring out what process I have to use to tie a CustomerName to a number that this company uses as a sort of customer number called ACM#, to ...
|
| ListBox Problem | 14 Feb 2008 20:43 GMT | 4 |
Can anyone tell me what is wrong with this event code in my form class module? Gotta be something obvious. While the form is open (so thus, I believe it must be getting to this event), I do not see the message box, nor do I see the list populated. Note that WSNames is a public ...
|
| Combo Box question.... | 14 Feb 2008 20:40 GMT | 3 |
I have a client that wants this functionality in their combo boxes. They want to be able to type in an entry into their combo box and then when the control loses focus, if it doesn't match a value they want to be able to add
|
| launch Excel failed | 14 Feb 2008 19:38 GMT | 4 |
I have a Excel spreadsheet to run function and retrieve data from Access database. My Excel is able to launch MS Access, but one machine is failed to run it automatically.
|
| LinkCriteria with AND | 14 Feb 2008 19:18 GMT | 2 |
having a syntax brain freeze.... this works fine: stLinkCriteria = "[ID]Not Like 'I*'" All IDs show on the opening report - except those that start with an I
|
| Survey Design | 14 Feb 2008 18:43 GMT | 2 |
I am creating a survey in access for children with disabilities. Not all the questions will fit on the one form, is there a way that I can have a "next" button to open the next set of questions and close the current ones being displayed?
|
| Counting totals between multiple columns for like items | 14 Feb 2008 18:41 GMT | 1 |
I have a spreadsheet that tracks weapon type and their qualification steps in two categories (primary and secondary weapon). There are 4 columns in each category: weapon type, Day, NBC, Night. I had this formula in the weapon type column:
|
| Serious Help Needed!!! | 14 Feb 2008 17:39 GMT | 11 |
My question comes in two parts: Part 1 - I have a Form with a subform (main subform) what when you double click on a field in the subform another subform puts up. On that second subform it sums the "Projected_Man_Hours" in a text box and
|
| Auto Register Contacts by contact type | 14 Feb 2008 17:19 GMT | 3 |
Take a look at this loaded question. I have frmEventRegistration which is based on tblevents. I would like to create two buttons on the form. One would automatically register all contacts from tblLeaders where LPosition is 2. The other button would automatically
|
| Check for Existing Else go to New | 14 Feb 2008 17:07 GMT | 36 |
I have a form with a subform. Main form (frmProd) takes 3 criteria via combo boxes and is bound to tblProduction. The subform (sfmProdOp) is bound to tblProdOp and contains the details for each instance in tblProduction.
|