Search results

An update query will do the trick

I ran into this issue a while back. The solution for me had to do with User permissions for the directory where the DB was housed. The user encountering the problem did not have write or delete access to files in the directory. So when access tried to create the locking file, the user was...

Add a reference to the Microsoft Outlook object Library and everything you need to send email will become available to you.

I would use an ADO recordset object to capture the email data that you want from the table. Then loop through the recordset to add the addresses to the email. Since you have all the addresses stored in the recordset object, you could put multiple addresses together by looping through your...

I think she may be confused with the purpose of the input mask. When you assign an input mask to a control, the control will automatically check to see if the text you are trying to store in it conforms to the mask or not. If you have already assigned the Input Mask of "000L0009" to your...

I must disagree that "anybody" can break the built in User-Level security in Access. It is definitely a large step above the average users knowledge level and can be very difficult even for the professional if implemented properly. Also, even if you lock down the shift bypass, if you are not...

Why wouldn't you just use the built in MS User Level Security for Access and use ADOX to get permission information that is used by code? Your code requires that the code runs before the security works, that can be bypassed. The built in Security for access requires a username/password before...

That is because the ADO Execute Method takes the actual SQL query text as input, not the name of a stored query. You would use it like this: cnn.Execute "INSERT INTO [LocalTempTblProjects-Report03] ( intProjectID, txtEmployeeName, StartDate, EndDate, intFiscalYear, IntProjectNo, ProjectName...

Here is a discussion I had awhile back concerning parsing xml documents....it may help ya out some.... http://www.access-programmers.co.uk/forums/showthread.php?t=116258

I haven't done much with XML in a while. Had a discussion regarding parsing/importing of XML files a ways back though. Check out this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=116258 Read through that and see if it answers any of your questions.... Also, it should...

Sending out the email is easy, you just need to add a reference to Outlook in your code (and may I recommend using Redemption as well to get rid of annoying Outlook popups). It is processing the email that is the difficult (though not impossible) task. Outlook VBA is exactly like Access VBA...

Well, it certainly seems to be a driver issue, as the Oracle 10g drivers work beautifully. Thanks for the help guys!

Banana, thank you for all your helpful suggestions. After reading through some oracle forums, I think it may be a simple driver issue. I'm waiting for the oracle 10g drivers to d/l right now and i'm going to see if that may clear all this up. seabass341, don't you have anything better to do...

Answers to Banana: 1. Microsoft ODBC for Oracle 2.575.1117.00 2. I am using a System DSN and as such I am unsure of the connection string. When I mouse over the linked table in Access I get: "ODBC;DSN=EWFM;UID=ewfmodbc;SERVER=EWFM;;TABLE=TCSDBOWNER.EMP" 3. Number-Decimal, Text on the access...

How can you say it is impossible? Apparently it is possible, 1. Because I can IMPORT the data, 2. Because two of the tables link perfectly fine. If it is impossible, please elaborate on why... Also, update. I forgot that the table i get the "...out of range..." error, I can't directly import...

I have an ODBC connection using the Microsoft ODBC for Oracle driver. I am attempting to link a set of 6 tables in my access database so that I can query the Oracle information. When I set up the links to tables, I get no errors. The problem happens when I try to open (view) or query four of...

The primary problem is that your did not Dim your array as a dynamic array to start with, the code should be: Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnn1 'You must leave the dimension blank to...

Yeah....I have run into corruption before that has caused similar strange happenings with Access, I just didn't suspect it this time because I have never used the Run Method before and thought I was perhaps just using it wrong.... Thanks for all of the help guys!

Simply.....amazing...... It works just fine when I put MessageMod into a brand new module all by it's lonesome....but it doesn't like being in the module I already have for my Global functions......what the heck......

I cannot get CallByName to work either as that only invokes methods of objects, for which my procedure is not.