Search results

Many thanks again for your reply, I can see where I am getting the problem now, In my control enabler I am referencing the tab control pages - these do not have a locked property available - only an enabled property... therefore, I would have to name each individual control separately in my...

Hello, sorry, one more quick question... I have now got rid of the sub forms and have put the fields onto the tab control on the main form (as originally designed). I am now trying the locked property out to use (to combat the 'fuzzy look') - I have changed my code, but am not sure I've done it...

Thank you so much for taking the time to explain that, I understand now why I was getting that message. I am going to change everything over today to lock property and get rid of the unnecessary sub forms - it will mean re-designing a couple of forms and changing some code but all good practice...

Thanks for taking the time to reply to my post. Maybe I am going around things backwards, I'm afraid that comes with a huge lack of experience. I was under the impression that by using the 'lock' property rather than the enabled that it stopped my query from refreshing properly - I cant remember...

Good afternoon I would be extremely grateful if anyone gets the chance to look into the following error for me... (All based on Frm_Company on the attached db). The following error occurs when leaving the top subform (SubFrm_Address) and entering the next sub form (SubFrm_Contacts). 'The...

Good afternoon I would be extremely grateful if anyone gets the chance to look into the following error for me... I have just come to demo my system so far and it pops up with this... typical :o Everything was working perfectly on the old version I had but in an attempt to 'get around' a...

Thank you for this; I am finding a different scenario now actually as I also have a 'cancel' button the main form (this is a form for entering people's company / contact details - its a sales contact management database)... I have tried putting the same code on the 'cancel' button on this main...

I seemed to have solved this with a simple me.undo on the command buttons 'on click' event... seemed to simple... I'm sure I always think things are more complicated than they are... can anyone tell me - if it OK to use this... or is there a safer / better way? My code now is: Private Sub...

I have also tried the following; Private Sub CmdCancel_Click() MsgBox "Are you sure you want to cancel this entry?", vbYesNo If vbYes Then DoCmd.RunCommand acCmdUndo End If End Sub but I get an error message saying Run-time error '2046'; 'the command or action...

Good afternoon Just a quick one today... wondered if anyone has any (nice, easy to understand) ways of stopping a record saving to a table. I have a 'cancel' command button on my form but even when pressed the record still saves in the table as I have an autonumber field (so it just saves the...

Thanks for the replies but I have managed to fix this bugglet now... I think the problem was the event on change of the combo box; I had put me.requery - this was stopping me from entering the text; I have now changed that to me.cbocontact.requery and added me.txtNotes.setfocus (although I'm...

yes, just a 'Me.Requery' The combo box itself is based on a query... Qry_SearchContact

After some experimentation I have found out the following; The text box is editable if that is the first thing I do (i.e. before picking from the list box or combo box).... The Notes section is also usable after picking a correspondence type from the list box (but NOT yet picking the combo box)...

Yes the textbox is usable if I change the record source back to the table...

Thanks for the suggestion, yes I have checked that; I have also tried deleting the text box (which is a memo field) and adding a new one but no luck again I'm afraid... it still will not allow me to type in it?? :-(

Hello This is kind of in link to my previous post 'combo box empty problem' but as the initial issue has been fixed and a new one has cropped up (ain't that always the way)... then I felt it more appropriate to post a new thread to address the new problem. I am currently designing a Sales...

hmmm, that's what is confusing me... I can edit it fine in the query, just not on the form... I am checking to see whether I have any record locks or allow edits etc that may be causing trouble? I could try and re-create this on a different machine in 2003 and send that if it helps?

Thanks for your reply and suggestions... I have now based both the Frm_CorrHistory (shown on the Contact history tab of Frm_Company) and the subfrm_Correspondence (shown at the bottom of Frm_Company) on individual queries. Everything appears to be working OK now (sorting wise) however I am now...

Apologies; it is the 'Notes' text box - the sub form is called SubFrm_Correspondence and is located at the bottom of Frm_Company. The 'add new' button should empty the contents of the form and present a blank record for the user to fill in. This code I currently have attached to the form is...

Thank you for taking the time to answer my post - I have added to it since your reply, I think I have solved the 'empty combo box error' but am now having problems with the text box (continuous form) as mentioned on above post. I have attached a copy of the database in Access 2003 - this was...