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

John, thanks alot, got that to work a treat. Also thank you to Maxmangion for trying to help me earlier.

I am doing it at form level. Could it be you are using a different version of access which has this replace function built in. I keep getting the message:- Compile error: Sub or Function not defined and then the word Replace is highlighted in yellow.

maxmangion, thanks for your reply, but when I run the report it does not seem to recognise the Replace function you used. Any ideas?

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

Figured it out now, I used a piece of code that was on Microsofts Knowledge base and adapted it slightly. This is what it looks like: Option Compare Database 'Use database order for string comparisons Option Explicit Global TotCount As Integer ' Call the SetCount() function from the...

directormac, The report will be included in documentation which is sent to my company's customers. The need for the blank lines is that the customer will then fill out the blank lines of this report with certain information and then send the documentation back to us. So if for example there...

I see what you mean now. Try this one, I've added a cancel button to it.

Mile-Oh-Phile, When you click the Save Record and Close Form button it then asks if you want to save it, you can then click either Yes which will save the record or you can click No to cancel it. It should work on the copy I previously attached. Cheers, Steven.

I've taken out some of the forms and reports so I can attach it now. The names I used in the original question are different as I tried to make the question as easy to understand as possible. The table which holds the data is called tblSiteAddress, the report in question is called rptSchedule...

Mark, Even when zipped the zip file is 110KB so I can't attach it. Can I send it to you via E-mail. Cheers, Steven.

O.K. Looks like I'm gonna have to resort to bribery to help me solve this one. I will buy and send the first person who can help me solve this problem a DVD (I don't mean boxed sets, my job doesn't pay that well :( ) of their choice (as long as its not some really obscure one that is...

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

Mile-o-Phile, Thanks for all your help, got it working now. Couldn't have done it without you. Cheers mate, Steven. C.

Ok, so I have created a module and left it named as Module1 for the moment. The code inside the Module looks like this: Option Compare Database Option Explicit Public strUserName As String Is this right, if so how do I then get the field on my other form to display this value.

I am letting them pick the username from a drop down. Where do I declare the public variable and then how do I display the value of that variable in a field on a form. Sorry if this sounds as though I'm being a bit dense, but I don't really know a lot about coding, only what I pick up as I go...

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