Search results

On my main form which lists scheme details, I have a button which opens a search form. This has cascading combos on it. Once the user has selected what they want, they press a button and then return at the record they chose on the main form. However, I realised that the search form could be used...

Maybe try going to the menu bar, choose 'View' then 'Code'. Or choose the 'Code' option from your toolbar. HTH

Hmmm. It's always the simple things that catch you out..... After trying both suggestions, I was getting nowhere. I added msgboxes to each to check the code was firing, and it was. But no changes were happening. So I added a new record to my db rather than trying it out on an existing record...

I've got to leave the office now, but I've printed off your suggestion, and will try it out over the weekend at home. Thanks to both of you for your help, and have a great weekend. ;)

Two more things..... I have put a message box in after the code, and when I update the relevant field, the message box appears, so the code is firing, but not doing anything. Secondly, I have just made a new field in the db where the code worked, and tried to get it to work on the new field...

So are you saying that you want that field to grow, but your problem is that the rest of the fields on there in that line don't grow at the same time and it looks bad? If so, I found the following code on these forum which automatically resizes the rest of the fields if one grows. It really...

Thanks for continuing to help me. I tried your latest suggestion, but I'm still getting nothing. It also seem that it's not a subform problem. When I said "If I try the same thing on a main form, there is no problem", this wasn't actually quite correct. As I was having trouble with this, I...

Thanks for the reply, however I just can't seem to get anything to work. If I try the same thing on a main form, there is no problem. So it's obviously a problem with the fact that it's on a subform. I just don't know how to resolve this. :(

I followed what you said, but when I altered dates in txtRevisedStartDate, nothing happened. I'm intrigued. However, I wasn't quite sure what you meant by this "Now include revInc on your form that allows users to change the Date. " I have added this field to my subform, it is linked to the...

If you want a form to appear as the first thing you see when you open your database, you need to do the following. Go to Tools on the menu bar and choose Startup. Then a dialog box will appear. On the right hand side, you will see a combo box with all of your form names in it. Choose the form...

I have a field (txtRevisedStartDate) which holds the revised start date for works. Currently, this is overtyped if a new revised start date is given. I don't need to hold information about all of the revised dates, but I would like to know how many times this field has been altered. I tried...

That's ok - glad I didn't upset you and that you've sorted the problem.;)

I am being dense today. Why the 'OUCH'? I wasn't trying to be sarcastic or anything, I just wasn't sure if you were talking about linking (child and master fields etc) or something else. I didn't mean to offend you or anything!:eek: :)

Maybe I'm being dense, but what do you mean by 'syncing'? Do you mean linking?

Absolutely perfect, many thanks.;)

For information... For some time I have been hunting for info about code that automatically resizes your forms depending upon the screen resolution your machine is set to. I have searched posts on these forums, and like many others, have found that some very useful code (courtesy of the Access...

Dear all I have a main form 'frmSchemeDetails'. Within this, I have a subform 'sfrmDetailsa'. The subform consists of a tab control, and on each of the six pages of this tab control, I have individual forms as subforms. Each tab page name is the same as the subform that that page contains...

Well said, Hayley, and I hope that others will look at your postings and choose not to waste any of their time helping you. In the words of Green Day, "kiss yourself goodbye".

Me!TextBox.ForeColor = RGB(255,0,0) should do it. HTH

Does it have to be Word? Snapshot will keep the lines etc, but email recipients will need this to be installed.