Search results

I completely understand. Wasn't trying to start a war, I only wanted to give the reason behind my previous statement. Just to prove there was one, not to prove it was right. Peace

The above quote is the reason for my statement about slowing the code down. Not, that I think everyone should believe everything they read... but it seems logical enough to me to follow it as a rule. Peace

I'm curious if the above solution fixed your problem? It seems to me the original way was correct. Since the code is actually filling in the property Field of the textbox (which in this case only excepts a string) you would need to put quotes around the Date(). Another way of thinking about it...

I've tested your code on A2002 and it seems to be working fine. Of course I didn't create your openfiledb(), just changed the line to: sourcedb = "c:\My Documents\Testing Database.mdb" It created a linked table to my "Test" table in the aforementioned database. Not sure why it wouldn't be...

Is Openfiledb() a user defined function? And either way, what is it?

Simply put when you move to the current data in your form (i.e. Clicking the Next Record Arrow) It looks to see if there is any information in [RecordingID] which is either a control on the form or a Field in the form's Query (which doesn't necessarily have to be on the form itself). If it has...

I think you pretty much have to use an If statement for this particular case. And I can't see how it would slow you down enough to matter. The Following works nicely: Dim olApp As Outlook.Application Dim nsNameSpace As Outlook.NameSpace Dim fldFolder As Outlook.MAPIFolder Dim objMessages As...

I don't know all aspects of e-mail setup but there is an EntryID but it's a very long string of numbers and using it would be a waste of memory. If it were me I'd use ReceivedOn to get (what should be) a unique Time stamp for the message. If you really wanted to make sure you could use both...

Can you tell what Message it's having problems with? You could try changing the .To to .Subject and seeing if it errors out there. I'm thinking it's having a problem with the Object it's pulling, like perhaps its not an actual email message and thus doesn't have a .To item to read, which...

Put a break on the line that is giving you the error, I'm assuming its the: strData = strData & "'" & objMessage.To & "'," Hold the mouse over the objMessage.To (or whatever you have on that line) and see what the value is when it errors out. It could be trying to pass a Null value... I've...

In your declaration section change to: Dim objMessages As Outlook.Items And add: Dim objMessage As Outlook.MailItem Then when you type in "objMessage." it will give you a list of all available properties. In this particular case I believe you want "objMessage.To". You may also want to...

See... they SAY it's by design. But they don't explain why... "Oh My God! They Killed Kenny!" (insert next quote here to refer to Microsoft)

I don't really think there's a way to do it. But I can't figure out Why Microsoft wouldn't want to give you the ability to turn this off... What I am doing is an extremely randomized copy and paste job that can't be easily automated without losing the data's integrity. But I appreciate your...

When copying information from Access and pasting into Excel does anyone know how to NOT paste the Field names with the information? It's very annoying to have to paste the information next to my excel list and then have to copy and paste the cells into position without the field names. Thanks...

One way to unhighlight text inside a control is to set the SelLength to Zero. txtBox1.SetFocus txtBox1.SelLength = 0 If you don't know which control you're going to be in then you can use: Screen.ActiveControl.SelLength = 0 Peace

What type is glblDirCode? Have you checked to see exactly what is passed to glblDirCode when you believe it should be 0 (i.e. Toggle a breakpoint and hold your cursor over the word glblDirCode)? It's hard to pinpoint anything difinitive from your description so far. I would suggest commenting...

Also be careful when writing your code [Part_#] is not the same as [Part #] and in your original post you had it as Part#. Use what VBA pops up for you when you type "Me.P" (vba should give you the option to pick the control name). Then after its been filled in add the brackets. But I concur...

*is psychic* Thanks Pat. Of course I've just killed my credibility. ;) Though, I've never actually tried to use brackets around control names, so I guess I didn't think that was an option. Though it makes sense.

The fastest fix is to just make sure all the tables and queries are hidden and that your users don't have the Tools->Options->View->Show->Hidden Objects checkbox checked. I'm thinking there might be a way to set this option via VBA but couldn't tell you what it is off the top of my head (and...

Well, actually you can use Part# when referring to a table field, because of the fact that you can put it in braces to let VBA know it's a field name. [MyTable]![Part#] should be fine to use. I'm saying that it's not necessarily the best choice. As in this situation, you really aren't...