Search results

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

Can anyone inform me of a way to action a subroutine AFTER the ESC key has been pressed and the Undo has been actioned? I do not mean a call from the "On Undo" event as this happens prior to the actual Undo action. I have a number of calculations that happen after a field value changes and...

I like that idea. My usage though is for a timesheet... 7 days display with 6 login/logoff times per day. Lunch break display as well as dinner break display and total daily hours. That's 63 different variable fields. ...imagine displaying a spinner control for each login/logoff with 15...

This is just a way to fix multiple users requests to have the whole field selected on mouse entry. And, as simple users (hairdressers and beauty therapists) they have no idea about keyboard behaviors and even less understanding as to what all those keys with all the F's are for. Easiest...

Dave... That's what I have proposed (see third screen from the top).

The concept... The user input is for a time entry. I simply want to be able to give a user some choices (drop down list) hence the combo box - and the ability to start typing immediately. Having the user click somewhere within a time field made up of numbers and colons and then expect them to...