Search results

Im running an update query but in the criterial field i would like to include something that instructs the query to be executed only on the value selected in my listbox. i need some help with the syntax cause i dont know how to bound the query's execution to the selected/highlighted value in...

My query is executing on everything in the listbox. I only want it to be executed on the value that i select. What codes can i use? I really need some help on this one.

How do i apply a query that i want to execute only on a highlighted record in a listbox. If there is a link, sample database or lines of code could you please assist. Currently everything is being executed on all of the records in the query. Also Does Access 2000 support codes for drag and...

How can i apply the following code to the immediate record in my subform. I would like when the assigned check box value = true, then the fields for that record become locked. Ive written the following code to an onclick event for a check box labeled "assigned" on my form, the problem is it...

Back to square one. It seems as though it would be best if i made the first combo box unbound but how do i prevent all the others in the form from changing when i change the value in only one of them?

I have a table that keeps putting a zero value in the new recordl. It was previously an autonumber field. I changed that and deleted the zero from the default value property. How do i get rid of this???

I keep getting this messgae that says "tyhe current field must match the join key in the table that serves as the one side of the one-to-many relationship" Im working on a subform that im using a query on, Can someone advise as to what i should do, THANKS IN ADVANCE >> i found a waya around...

I seem to be having some listbox troubles. I would like to know how to use the highlighted record that i have selected in my listbox to update another field on my form. I had used a macro with the event on dblclick, the problem is the event seems to be carrying out the update on all the...

I have three subforms that i want to open optionally by using one open button after selecting the form that i want to open from a combo box. or open the subform when the value in the combo box changes. Please help

I know that it isnt advised to store the concatenated value but in this case, I have a memo field which is the description of a particular system component. i have Unbound Combo Boxes for descriptive elements such as COLOUR, SIZE, CONNECTIVITY, MAKE. ALL of these i would to store in a field...

In one table i Have component group Id and the description as fields then another table has the sub groupings for each Component Group Id Example Component Group ID = 1 which is the primary key Description = Keyboards Component Sub datasheet has Group ID = 1 foreign key Descriptive Options...

In one table i Have component group Id and the description as fields then another table has the sub groupings for each Component Group Id Example Component Group ID = 1 which is the primary key Description = Keyboards Component Sub datasheet has Group ID = 1 foreign key Descriptive Options...

Okay this i definately need help with. I want my form to behave in the same manner as a datasheet in that it just displays rows of data. I want to create this how do i do that.

im creating a form in design view but the icon to show the fields from the table that i want the fields to come from isnt being displayed; how do i get it to show?

Im creating a db to keep records of computers that have been assigned to persons in their various departments and also unassigned computers and spare parts. problem: For the machine specifications table should i put in the following fields as columns Hard Drive 1 Hard Drive 2 Hard Drive 3...

I want to put a search form (text box and listbox) on a form that has the records displayed.Can i please get some help with codes. Ive been searching your forums but the problem is that most of the search forms are linked to pop-ups. Can someone PLEASE help me.

Private Sub quicksearch_AfterUpdate() Dim db As DAO.Database Dim rs As DAO.Recordset Set rs = Me.Recordset.Clone rs.FindFirst "[ID number] = " & Str(Me![quicksearch]) Me.Bookmark = rs.Bookmark End Sub this is the code that im using to help me with a...

I have a field called "Bad Pc Part" which is a listbox. THe problem is I want it to display the contents of 3 other fields from another table. I created a query for the Bad Pc Part field but the problem is it only displays the information in the first field of the table. It doesnt show the...

Listbox My main form that displays the records also has on it a listbox for easier navigation to records. What i would like is when i delete the records, they automatically become removed from the listbox. Currently what happens is that i have to close the form and reopen it in order for the...

My subform when i click the New record button on the subform i want it to disable a text box that is on the main form. Me.Pensioners.Form!quicksearch.Enabled = False where Pensioners is the name of the Parent Form. Thhis isnt working for one reason or another. Please advise.