Search results

Set AllowAdditions back to False after NOT entering a new record - but on what event? I have a continueous subform which has allowadditions set to False. Then I have an "add new record" which changes the allowadditions to True and sends user to the empty new record. Now, let's say the user...

I have multiple instances of the form open. Whenever an instance gets focus I gather its window handle. I wish to store this window handle "somewhere" so then I can refer to it as the last instance that had focus. My question: where should I store it? In a global variable or a table? It will be...

how did you tackle the problem of referring to a particular instance in the end?

solution to the quote: http://www.access-programmers.co.uk/forums/showthread.php?t=112969

I have multiple instances of the same form open so I can't refer to the particular instance by using the name of the form. I did bunch of searching and reading about it and I'm using a solution which uses window handles to keep multiple instances open. However, I can't find anywhere how to use...

In your tableData go to Design view and then to lookup for the ProductID field. There choose Row source type as Table/Query and under Row source specify your query name. Then go to the form delete the previous ProductID field and insert it again from the list. It should be a combo box with...

I'm in no way an expert in vba but can't you use: for i=0 to 19 ... and then use the i (or i+1) in your if condition and also in creating the name of the subform

doesn't your query have a StudentID as well? If so create the combobox (with wizard as I wrote above) but based on the query not the table. Then when it asks you to add fields add all three: ID, fname, lname and then click next. then it will ask you if you wish to hide the id field - say yes and...

How can I use the window handle to open a form, or better to set a focus to it or requery it? Getting the handle is quite easy : handle = form.hwnd but how can I use it after I have it?

Thanks so much; that's exactly the explanation I was hoping for.

How can I find out the form's index number? I found this function (see below) on google after a second day of searching, but I'm not sure how to make it work with multiple instances of the same form. Because if I pass the forms name then I always keep getting the same index. (Please don't refer...

still in a dead corner That's the link that got in me in "trouble". It shows how to open new instances, etc.. but not how to refer to them later from different forms. So I thought of using the Form index number, but can't find the proper syntax anywhere for: 1. getting the Form index number 2...

How can I refer to a form by using its index number? Also how can I retrieve an index number of a form? (I'm opening multiple instances of the same form and read that the only way to refer to those instances is by using their index number. I found some solutions that use hWnd as well but I...

I don't need to have this number after the DB is closed. I guess I ould use a table with one field. I thought using collections would be more proper thing to do, but I'm not to familiar with them. How can I open a form when I have its window handle? Or to be more exact requery a subform on the...

How can I save a number with vba so that I can later reference it (collections?). I wish to pass a HWND value of an instance of a form and later set focus back to that form using that value. My other question is how do I refer to a form using the HWND (and form's control)?

Did you try creating the combo box students with the wizard? The wizard gives you an option to: Find a record on my form base on the value I selected in my combo box; if you use that then when you select a record from the combobox the form will go to the specified student. This may not be a...

I think your subform is a continues form. If so then you're running into the same issues I had but you have a little different goal. Maybe this thread will help (see the post called "new ideas"): http://www.access-programmers.co.uk/forums/showthread.php?t=100412 To find more posts on this you...

form instances - lost and desperate for any help Gotfocus doesn't do the work in the end and I'm not sure what else I can do. I'm really lost here because I don't understand the code I used for creating instances and I reached a dead end. Here is the code that creates a new instance of my main...

I have a following lines of code: Dim rs As Recordset Me.Requery Set rs = Me.Recordset However it causes an error "Type Mismatch" When i change Dim rs As Recordset to: Dim rs As DAO.Recordset everything works fine. However, I'm not sure why; could somone be so kind as to explain in few...

I ran a code to hide all toolbars through an AutoExec module. (I also created a module to unhide all). Now, even though I disabled the autoexec Access opens without the Menu Bar. I did run the unhide code which did work and showed all the menu including the Menu Bar, but after I close the...