Search results

For future reference Pat, if you don't want people to send you messages directly, then you should probably disable private messaging, just food for thought.

Yes, your function worked like a charm Pat, thanks for your help.

Sorry, I didn't see the previous reply.... :)

Try using the "find unmatched query wizard" when creating a new query, Access will guide you through the steps, it is quite simple.

I know the property exists in Excel, but can I shrink the font of a control depending on the size of the text, while keeping the control the same size?? TIA, Sparx

Thanks Pat, hopefully this will solve my issue.

I need a function that will convert a julian date into a regular date (ie 2003-03-06). Anyone have any ideas. TIA Sparx

Jon, that's the type of answer I was looking for, thanks a lot

Your reply doesn't help too much

I am creating a query where fields are all fixed width. When the field is numeric I fill the field with zeros, when the field is text, I fill it with empty spaces. The problem here is that the empty spaces get added before the text, but I want the empty spaces to get added after the text...

Thanks, works like a charm, but I feel like an idiot asking questions with such simple answers, when I deal with issues I am a little rusty on, I like to post it here and continue with my work, rather than spend time searching for it, I guess that I'm lazy!! Tks again

I am writing to a file, and VB automatically put a carriage return after the final line of the written file. I cannot allow this. How do I get rid of the blank line? TIA, ERIK

It's funny how things can be just too simple, thanx for your help.

I am running code in vba that is using the Write command, and I am creating a text file that is delimited by * and is also fixed width. After every line, there is a separate delimiter which is the semi-colon. But the problem I have is that by default, quotations get added at the beginning and...

What would you like to do with the number once validated?? ie If the number is not really a number but something else, what do you want to happen?

I have .htm files that I want to automatically load into Access, make the necessary changes and then save them. You can do this by using the wizard for "Pages", but I want to code this. Anyone have any ideas, TIA, Erik

Thanks for your help, I'll let you know what the outcome is.

I included the attachment of the Microsoft dialog box. It requires the user to click yes in order for the e-mail to be sent

Here is the code you have been asking for: Dim mail Dim TestInput As Variant Me.TestInput.SetFocus TestInput = Me.TestInput.Text Me.MailTo.SetFocus MailTo = Me.MailTo.Text Me.MailFrom.SetFocus MailFrom = Me.MailFrom.Text Me.MailSubject.SetFocus MailSubject = Me.MailSubject.Text Set mail =...

That code works, but it's not really what I'm looking for. The user still needs to click yes in order for the e-mail to be sent, I don't want this, I want the e-mail to be sent without any intervention by the user. Any other ideas?? Thanks, Erik