Search results

hmmm, i'm trying to make my form aware of any changes to the controls, and i'd rather not go and manually configure each control. Feel free to throw any ideas at me. :)

Is there a overall form procedure that is triggered if an unbound object is altered?

nope, no acSaveYes statements anywhere. The open event doesnt work either Mailman. When I open the form, it gives me an error, and then continues and works correctly. But that happens everytime I open it. Does the forms Close event run even when the code faults and the window is closed...

This is more of an annoyance than anything. My db starts with a main form (MainMenu) that contains a subform where everything happens. MainMenu is always open, with all actions occuring within the subform. The subform starts off with the form frm_Login as its source. Once login has been...

I do this using the click event. it works

When updating the table from the temp table, I will have both new and old records. Would the best method of updating be to create a recordset based on the whole temp table, then cycle through each record and do an update or insert depending whether its PK exists?

hmmmmm... At this point it would be too much drama to make the form bound.. Once I have it working I might make a copy which is modified. Before begining this project I had only breifly looked at Access, and have done mainly Java/C programming, so the bound approach works well for me since...

Ok.. I think I am begining to see the light.. Since each individual task and impact has its own unique ID I can use that to identify which record in the master table to update. Ok.. What if some records were modified and some were added. How would you handle this, since you could not...

haha.. hey adam.. your not wrong.. i think i've succeeded in confusing myself completely. At least its not recordsets that are confusing me atm... I've put my woes into words on this thread, which i think addresses my problem a bit better...

Before I began the this project, everything I read said that unbound forms were more stable and useful than bounded forms. The system I am building will be for multiple users, and it seemed more logical to design it to be unbounded.

Ok, my head is spinning from trying to figure this out. I dont think its that difficult, its just that there is that much going on that i've lost track and need a bit of help.. :confused: ____________________________ My form is made up of a header, the detail, and two subforms. This main...

As the title suggests, im wondering if there are editors available for use with VBA script apart from the default built-in one. Im really starting to get sick of the limitations of this editor as my code gets more and more complicated.

My form has a header, the main form, and then two subforms.. how could you use the dirty check in this case? Hmm, i just read that the Dirty option is only available for bound forms.. mine is unbounded.. any ideas?

you could put it in the forms load code

You need to have the employee id stored in tblCustomer. and then set the cboSelect source to Select tblCustomer.CustomerID FROM tblCustomerID WHERE EmployeeID = 6 thats one way of doing it

more information is needed.. can you post up the code your using

Ok, i've worked out a way of doing it. If I create a recordset based on the table, I can do a loops through and check the value of the control to the corresponding value in the table. For each fld in rst.fields fieldname = fldAbrv & fld.name if (frm_Change.Controls.Item(fieldname)...

I just did a test with that and it returned the modified value... Basically what happens is, a form will load. If the person has rights to approve the form it is unlocked. The approver inspects the contents of the form and either approves or rejects it. The special case is if the approver...

Ok, I have a form that after viewing can be approved or rejected. It is possible to have one of the approvers to make a change and then submit the approval. In order to check for a change, is it possible to create a recordset on the form Load, and then another one after the approval button...

ahh... that would help wouldn't it... :rolleyes: cheers bob