Search results

Sorry I didn't respond to close out this thread..... in any case, thanks to all who responded. Your assistance was appreciated!

I got it working!! What I did was to remove the fields in my table that weren't working, and then re-entered the fields into my table, but instead of calling a field, for example, "DateReviewed", I now call it "DateReviwedA". I then changed all field names in my form to match the table field...

I've got a database of documents, some of which have pages where there is nothing but the character "*" on an occasional page. I want to write a query that will process these documents, but ignore the pages that contain nothing but that pesky character, "*". If I wrote a query like SELECT...

I have a vba module that, when run from a query, will do what you need. Works like charm. All you have to do is specify your desired length as a parameter in the query. Here's the module: Option Compare Database Option Explicit Public Function BreakNomen(Nomen As String, NomenWidth As...

I had asked this question a while ago, but got no response, so will try a different way of asking. On a report, I've got a text box with a bunch of alphanumeric data in it. However, the data appears to get split at the end of a line, with part of one piece of data on one line and then the next...

Anyone ?????

I've got a report that has several text boxes of data on it. In one particular text box, with "Can expand" set to yes, the data can be a combination of numeric and alpha, such as: 1, 2A, 3, 4A, 4B, 8, 9, 10, 11A, 11B, 20 and so on. My question, how do I prevent a piece of data from...

Your'e right....the log I'm referring to is in Computer Management, in the Event Viwer, and then in the Application and Security Logs. It looked like it was Access that was putting an entry of some type in these logs every time an .mdb was openeed. However, it turned out that another piece of...

gHudson, Thanks for your quick reply! By setting Macro security to low and tweaking the sandbox mode, will messages still get written to a log on the user's PC? We want to stop log writing for each time this user goes into an .mdb. I appreciate your repsonse, and so quickly! Think I'll name...

gHudson, Thanks!! What the heck is sandbox mode???? I thought a sandbox was something a cat used!;) I'll do as suggested and see what I can dig up. I appreciate it!

One of my users keeps getting the following message when he opens an Access file: "Security Warning: Unsafe expressions are not blocked Do you want to block unsafe expressions?" My question is, how can he turn off this warning? It is filling up a message log on his PC and since the .mdb's...

KeithG, Thanks for your reply! Could you please provide more detail? I'm just not familiar with the FileSystemObject or how to use it.

I've got a bunch of Excel files in multiple folders that I want to programatically convert to txt files. The folders are nested several layers deep, ie, \\LevelA\LevelB\LevelC\LevelD\LevelE\LevelF\uniquenameA \\LevelA\LevelB\LevelC\LevelD\LevelE\LevelF\uniquenameB...

KeithG, Still no go!! I just checked JohnnyBoy's e-mail and he had nothing, even after I used the .Send. Isn't this fun ????

KeithG, Thanks!! I'll try that and see what comes of it. I really appreciate your help.

KeithG, Good morning. Any further thoughts on my questions?

No... I put his address in as "JohnnyBoy" only. Also, when I checked my calendar, and then clicked "invite attendees", and then sent the invitation, he then recieved the appointment. Is there something I'm missing from my code that would handle all this, or should my code, the way it is, do...

I checked his e-mail, and he did not have an invitation.

KeithG, I tried what you suggested, but "JohnnyBoy" showed me his Outlook calendar, and there was nothing in his Outlook calendar. Here is the code I used: Dim outobj As Outlook.Application Dim outappt As Outlook.AppointmentItem Dim outNS As Outlook.NameSpace Dim...

KeithG, Thanks for your response..... what and how would I set it for a group of recipients?