Search results

so easy omg, this was so easy. just used a find and a bookmark. send te form to your bookmark and your done! Here is the code: Dim rs As Recordset Dim Test As Integer Dim varBookmark As Variant Set rs = Forms!minutesinvoer!InvoerenActieDetails.Form.RecordsetClone rs.FindFirst ("MinutesCode =...

sorry i dont really understand where to put it, or what it does? please advise!

Can i get the recordset of the form without cloning it ?

not posible ?

This is true!

try quicksort its better then bubble. but a littlebit more difficult to understand

please advise

Hi, I have a problem. I have a subform that is a datasheet on the left i have a subform that is a continuessubform. When the user presses the button on the left, in the continuesform, i want that the datasheet goes to that record. I do want that al other records are displayed, i just want it...

It looks like that every control that has an event, gives error. For example on exit or onclick. When i remove the event form the SF it does work.

instant update. The form has a few objects. now comes the weird part. WHen i select one, en press the button, by some controls he gives me the error, with other controls it doesnt. Always the same controls where it does or doesnt work!

Hi, Ive never been stuck this much. i dont know what else to do. The problem is, i use the DoCmd.GoToRecord , , acNewRec to add a new record. It used to work fine, but to day, i keep getting the error 2105, Cannot go to secified record. i dont know why, and i dont know what else to do...

Hi, i have a combobox with two subforms and 1 main form. the mainform is based on a query When i scroll, the records change, and the subforms corespond properly. BUT, when i use the combobox to change the records, i cant select anything. I see the list in the combox, but when i click i get...

ok a stupid question but i cant figur it out. I have 2 subforms and 1 mainform all i want is that subform1 comunicates with subform 2. subform 1 had a listbox that is filled with a query. When i click a value in the listbox the othersubform must navigate to that record.

Hi, i have a realy irritating problem i have a listbox. This listbox is on a form which has also a subform. I use the listbox to navigate trough the subform. I realized this by linking the subform to the keyvalue of the mainform/listbox using the child and master option. THe problem is that...

what i mean is that you have 2 ways to link one to many. Using a query and using a subform. Both methods give the same result.

Hi, im trieing to update some attributes in a table, but i keep getting the error that the record, im seeking does not exists (EOF) i have a list, and i want to update all attributes related to a meeting. i tried the following: rivate Sub Command22_Click() Dim cn As ADODB.Connection Dim rs...

hi, I want to put spaces in a table. With spaces i mean for example: i have the word "hallo" and i want it to be writen in the table as: "____h____a_____l_____o" the _ are spaces. I have the string perfectly in a variable. But when i add it to the updatequery i get an syntax error on the...

hi, got a weird question. Im working on a form atm (duh) I have a form that exists in more tables. Now you have 2 solutions: I can use a query and generate the form, or i can make various subforms. what is the best option? or doesnt it make much diffrence?

work perfectly, just the way i wanted it to work! Thank you!

Hi, i want to replace spaces in my query, but there are a few hard parts in it. I dont always know how many spaces. en second, the spaces that need to be replaced are after the first character. The rest needs to be removed. i have: ----1----1----2 the "-" are spaces!! and i want it to...