Search results

Hmmm, just tried it and the same is still happening. :( Maybe I'll try and add a subform again with the wizard, but create a new one using an existing table rather than an existing form. I shall post back with the results.

Hi George, just wanting to say a big thank you to all the help you've given me so far. I'm incredibly appreciative of it and can't thank you enough.

I'm incredibly appreciative of the help you've been giving me. You've solved so many of my questions and I'm very grateful indeed!

Hmmmm, I wonder if it's possible to remove that option altogether... I shall try tomorrow - I'll log in remotely and give it a go. Thanks. :) Edit: AcFormEdit seems appropriate if not, me thinks.

Hmmmm, on looking, I see that they're set to "no".

Ah, I think it is. I shall go check. If it is yes, and I change it to no, When I open the form for a "New Enquiry", I take it I wouldn't be able to enter data into a subform such as frmContacts. Would I need to bring up, say, a clone form eg. "frmAddContactDetails" to input the data, then...

Sorry to appear very dumb, but how would I find that out? I can't find an obvious entry in the property fields which give me that information.

Which missing libraries? Basically, for example, I click NEW ENQUIRY on the switchboard and it opens frmEnquiry ready to enter new data: I enter data in the form controls on the general page, then the contact page, then the site page, then the quote page and then the associated documents...

I apologise, I meant to do that. Thank you for correcting me. Yes, it is Access 2007

Hi all, In my database, HERE, - as corrected by missinglinq, it is 2007 version When the main form refreshes, (or the first page) the subforms lose all the data from their controls and it's killing me! I've just been trying the db out and it must not be referencing the data properly. I...

Yep, I'll sure never forget now!

Gemma, that fixed it! thank you very much. I spent the whole working day yesterday to try and sort it, then tried some more via remote desktop last night until 1am this morning. Grrrr for SQL. Many thanks :)

Hi all, I'm getting this return value of 0 in my message box which is supposed to return the number of records matching the date entered by user: Any ideas on where I should change my code? Initially, I was trying to use RecordCount, but I couldn't get it to work. I was wondering if I'm...

Oh Pants, I'm sorry. I thought I had. :( But thank you for that <ctrl>+g suggestion. I shall remember that.

Thanks namliam, that is the answer I needed.

maybe because some of the field types are not characters or memos and a Type Mismatch is occurring...?

Hi George, This is what it does:

'ERROR HERE ACCORDING TO THE HIGHLIGHTED YELLOW BIT CurrentDb.QueryDefs("qrySearchSite").SQL = ContactSearchFinal

ok zipped it but it was 850KB which is still too large.

it's too big to upload :( took all imaging out and it's still over 3 meg when compacted