Search results

Hi All, I have a form (set as Continuous) with 3 fields on it which are for example Date, Amount Paid and Name. All I am trying to do is put a total in the form footer so it will add up the amounts shown in the Amount paid field, but it doesn't seem to work. Can someone explain to me how I...

Hi all, Sorry if this sounds a bit thick but I have GHUDSONS code for disabling and enabling the Shift Key when people open a database, but I have no idea what to do with it. He says after the first lot of code to add the next lot of code to a transparent command button. Where do I create...

Hi all, This probably sounds like an easy question. I have a field which users enter Contact Names into. If a user enters for example "mr jones" I would then like the field to change to "Mr Jones" or if they wrote "mr bill smith" it would change to "Mr Bill Smith" when they tabbed or clicked...

Hi all, Does anybody know how I can automatically display the latest contents of a memo field on a form. So for example if my Memo field displays 100 characters but I have 500 characters entered in to the field how do I auotmatically display the last 100 characters. I would also need to do...

Cheers guys, that worked great. Just me being a bit thick earlier on. Thanks again. Steven.

Rich, I'm don't want to add a combo box to the form, I need to be able to search for a particular company name by selecting from a drop down list. So in theory the user presses a button on the form, this then brings up another form which displays the company names in a combo box. The user...

Hi all, I have a form (which I call frmDeveloper ) which is based on one table (all pretty standard stuff, Company Name, Company Address etc.) There are no combo boxes on the form as any particular company name and details will only be entered on to this form once so there is no need for one...

I don't think any of these will work. I am trying to do something like this:- Between [Please Enter Start Date]* And [Please Enter End Date]* I hope this makes better sense. The asterix would then allow the search to find records where there was just a date and where there was a date and...

Hi all, This may sound like a really stupid question but my brains frazzled at the moment and I can't seem to find anyway to solve this problem. In one of my queries I am performing a search on a date field, in the form of:- Between [Enter Start Date] And [Enter End Date]. All pretty simple...

Could someone please please help me with this. I have 2 tables The first one is called "tblCompany" and holds various information about companies such as "Company Name","Postcode" etc. The second is called "tblContact" and holds information such as "Contact Name" and "Company Name". The...

Hi, Does anybody know if it is possible to change the size of the text in a message box and if so how do I go about it. Cheers, Steven.

Fizzio, That worked great, thanks alot for that. As I am fairly new at using the code side of things in access what does the "Me" bit in for example "Me.NameOfCombo" mean or do. Sorry if that sounds a bit of a thick question, but like I said I'm fairly (very) new at the code side of things...

Hello all, This is my first post on these forums so please be gentle with me. I have a combo box (which for these purposes is called "CMU")which displays "Yes" and "No", now if the user selects "Yes" then a text box (which I will call "MU Comments") must be filled in, if the user selects "No"...