Search results

Hi all, I don't really have a problem for anyone to solve but I do have a question as to a difference I found between Access 97 and 2000. I am in the process of converting some 97 databases to 2000. I am doing this by simply using the convert option within Access 2000. I thought things would...

Hi all, I am trying to change the wallpaper on the desktop through Access, I have the attached code which half works but I'm going to need somebodys help to get it working correctly. Option Compare Database Option Explicit Private Const SPIF_UPDATEINIFILE = &H1 Private Const...

Hi all, Been a long time since I posted anything on here so hope you don't mind helping me out. I have an address field on a report which looks something like this 1 Example Street~Example Village~Example Town~Example County etc. What I need to do is everytime the ~ symbol appears I need to...

Hi all, I've hit a bit of a problem while finishing off a report for a database I've been doing. I have a table which for example hold Addresses and Units (this field is just a number which shows how much of any product that address has ordered). What I am trying to achieve in my report is...

Hi all, I have a main form called "frmMain" which is based on a table called tblCompanyName, this table only has on field in it which is "CompanyName", so my main form only has this field on it. Also on my main form there is a subform called "frmSubform" which is based on a table called...

Hi all, I have the following code attached to one of my controls on a form on the Lost Focus Event. If IsNull(Me.Compliance) = True Then Me.ComplianceScore = "" Else If Me.Compliance >= 78.4 Then Me.ComplianceScore = 4 Else If Me.Compliance >= 77.2 Then Me.ComplianceScore = 3 Else If...

Hi all, I have a basic table called tblUserTable which holds the following fields "UserName" and "Password". I then have a Login form called "frmLogin" which has the fields "UserName and "Password". On this form there is a button which has the following code in the On Click property. Private...

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...

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...

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.

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"...