Search results

OK, Great Thank you. This helps. I can view and retrieve the record. But when I try to edit and insert the date in this record, the new date is always placed in the first record of the table. Why can I not edit the date of the record selected?

I have done this on another form and it is working great. I don't understand what the difference is and why it does not work? I have setup a ComboBox on a form, Listed the PK of the table as the control source. Inserted the PK and many other field as the row source. When I go to select a...

Re: [SOLVED]Problems writing to a Textbox [SOLVED] After all day can't believe the forms record source was not pointing to the correct table. In fact it was not pointing to anything. I thought this automatic with the Wizard?

Thank you but starting from 0, employee.last is the 4th item. The column count for this row source is 6, which is the correct amount starting from 1 as we should. Isn't that correct?

...........................................

I am relatively new with Access 2010 so bare with me in trying to explain: The ComboBox is an unbound ComboBox called Combo0. I say it is unbound because there is no control source and the CB says "unbound". Why I dcon't know yet but it is doing "almost" what I want it to do. In any event...

Can anyone help me figure out why am having problems writing to this textbox on my form? Textbox name is: Last_Name Text Control Source is :Last_Name Line of code is : Me.Last_Name = Me.Combo0.Column(4) I get the following data in the textbox " #Name?" and the error: " You cannot assign a...

MS Rookie, Thank you. This CB is display all the data I need and limping along. I simply changed the Width to 5". All the fields are shown. When I try to select a record I get am error "The value you entered isn't valid for this field". I am not trying to enter data in this form, I simply...

Awesome, thank you now we are getting somewhere. This works but some problems? Row source updated automatically great! However, column count (for some reason by default was blank) I set it to 6 and all columns showed up, Great. Problem is columns are toooo thin. I changed the widths to...

------------------------------------------------

Thank you, are you speaking about the CB Row Source using the Query/Builder? I don't see "field list" anywhere else in the properties.

For three days I have been trying to create a specific form and all the things I know simply do not work..........Please help I have a table of records (Table A) which has two tables or PK's from foreign tables embedded in it (Table B & Table C). I want to create a form which details the...

I'll be posting. Got a lot of work to do but learning happily.....I guess. :o

I agree and am going to have to go to the query all records method but keep in mind, the exact same thing will happen if the user escapes the Assignment form because I will not have that record to query against. Truly Thank you very much for your time and code to help me get it straight.

I agree, what I have read and what you are saying here makes good sense. Queries will do the job and I guess I will have to migrate the DB to that design..... Think about this for a moment: I am creating this DB for a construction company. What we have is stuff in the 100's like: Shovels...

I hope I am not conflicting in what I say but what I am doing is updating the amount of a issued quantity of product. The Materials table has three fields pertaining to stock: Materials_Table: QTY_Stock - never changes QTY_issued - Updated each time a user checks out an item QTY_Remaining -...

Got it, and understand, the one to many relationship is Materials >>>>>>Assigned_assets Where Materials is the ONE side and Assigned_assets is the many. However, This form, which is frmAssigned_assets, via VBA, is modifying data in the Materials table directly. In the frmAssigned_assets...

Hmmm, having another problem.. Does, "DoCmd.save", only save the current form? Even though the data is correct in the foreign table (after changes are made), one of the criteria I have in an expressions is not being executed. Each time I enter a record in this form I also need to save...

No patronization intended here but you are a genius and very helpful. You are correct, I put a default date in the field "=Date()" and there are no changes most of the time. I was wondering why the Sub was intermittent? Thank you. To answer your question: Didn't think about a button. Simply...

OK, please allow me to explain what each field does: Material_ID - This field is bound to a ComboBox which calls the sub cboMaterial_ID_BeforeUpdate. I know my code is crude (still refining) but this Sub works as planned. Employee_ID _ This field is bound to a ComboBox but calls no Code...