Recent content by Tezdread

ah, shutting down does seem to help...but why am I getting this error?

Hi all, I have a form with two sub forms and when I enter data into one of my subforms I get this error? A Problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control. Close the OLE server and restart it outside of Microsoft Access. Then try the original...

Hi, is there anyone that can help me with this? I got this code from another site but it gives an error and when I tried to get help I couldn't... This is the code that I was told would work Private Sub Form_Current() Dim frm As Form, sfrm1 As Form, sfrm2 As Form Set frm =...

thanks alastair69, apart from specifying the record number ('2') I think you have it. The problem with using the record number is that it will change over time as more reviews are carried out and new versions are entered. For this reason it would need to go directly to the last record

hi all, I have this database I'm working on and have a couple of issues I can't work out. The first is this, I want to have my sub forms go to the last record when moving through the main form, currently I can only get this to work when I open the form? If I move through the records in my...

cheers Ken, I wasn't sure so thought asking the question here would be the best thing...check boxes it is :)

Hi all, I was thinking/hoping of using a list box on my form to store multiple values, I haven't been able to find a way of storing any value so far so not sure how easy it will be? How can this be achieved or is it just easier to use several check boxes (approx 8) Thanks

Hi, Would you be able to take a look at my database relationships and let me know if I've got them correct based on this info? Step One All the relevant and required information for a procedure is entered into the main procedure table. Step Two Once a review is initiated, the relevant data...

Hi I've been having this same problem for a while and I've had a bit of help here but none of the suggestions have so far worked. Basically I need a way to stop people tabing through a sub form without entering data. The sub form has a check box that has to be checked (it can't be set as True...

thanks guys, I'll look into that RuralGuy Pat, not sure what you mean? When I remove the code form the form and leave the setfocus code only --------------------------------------------------- Private Sub txtContactAgentName_LostFocus() Forms.frmAllCustInfo.SetFocus...

Hi, I have a form with a couple of sub forms, one of the sub forms only has a check box and a txt field and both are required before moving on to another record. I have this following code that works partly, but it only works if one of the fields have info entered. It doesn't however stop the...

seem to have answered my own question...even when the table has info in it, it still doesn't work when it;s in the query. any ideas?

thanks guys. it appears to be a problem with the relationships and not regarding the splitting. It's probably my lack of understanding (as always) Do all tables in a query have to have 'some' info in them? Basically my query isn't returning any results but when I remove a table it does. The...

Hi, I've split a database and the backend relationships are still intact but the front end they are not and it looks like this is causing a problem. Is this usual?

that worked a treat Jay, thank you!