Recent content by BrettM

Now that I look closer into his statement I see I missed this little gem. I agree about the use of the array though if it is desired then the line would be... DoCmd.OpenReport "Variance_by_Producer_Detail", acViewPreview, , "[Producer_#] = " & Producer(I)

You could also do it with a For Next if you prefer... If Len(TextBox) Mod 3 <> 0 then Exit 'Not in groups of 3 StrBal= TextBox For I = 1 to Len(TextBox) step 3 LeftBit = Mid(TextBox, i ,3) 'Do something with it Next I I think I have the Mid syntax right.

Don't try to force the data into the report. Set a public variable (or a hidden textbox) and get the report to read that instead.

How about something like... If Len(TextBox) Mod 3 <> 0 then Exit 'Not in groups of 3 StrBal= TextBox Do While Len(StrBal) > 0 LeftBit = Left(StrBal, 3) 'Do something with it StrBal= Right(StrBal, len(StrBal) - 3) Loop

We are here to assist you with problems you might be having with your own code... not write the stuff for you! Try paying a consultant to do it. My rates are $120 per hour if you are interested.

Have you by any chance set a Format to the Text Box?

Try forming your question in english for a start...

Microsoft discuss this issue in depth here... http://office.microsoft.com/en-us/access/HP051877861033.aspx Look at the section about the list index. Hope it helps.

Hi, I have been using the GetSystemMetrics API successfully for some time to force the window dimensioning of an application in XP. Now a user is attempting to use the app on a Vista system and it appears that the API is not reading the metrics correctly. Consequently those rotten scroll bars...

I doubt if that is the problem. It is not enabled on mine either. Are you the author of the DB? What is the specific error message you are getting?

Have you tried just opening the form and using that forms "On Open" event to follow the hyperlink?

Where is the shared network drive located? Does the user have rights established on the shared network drive? Is the Open Mode for the BE exclusive or shared? Are you using Workgroup adminstration... is the user a member of the workgroup?

..sure have however I am doing lots of other stuff there. I actually took GalaxiomAtHome's idea and ran with it. The result is a small borderless form called "fmCancel" that pops up saying "Cancelling". It then does the stuff I require. Was a neat suggestion GalaxiomAtHome. Thanks. The scales...

Create a button on your form called eMail. In the "On Click" event enter the following... Private Sub eMail_Click() Dim olapp As Outlook.Application Dim olNewMail As Outlook.MailItem Dim eTo, eSubject, ebody As String eTo = "" eSubject = "Subject" ' set to your own stuff...

It would, however I believe it would actually make it a little more complicated for my users and possibly decrease their interest if they had to click in the time field displayed and then have to work in say a popup that had a time spinner. It would also negate the ability for the field to...