Search results for query: *

The blow code was working fine but I must have screwed something up. All the sudden when you go to open the Excel file that I have copied, renamed, and inserted data into, the file will not open. No indications, it just does not open. If you look at the history in Excel it looks like ot was...

I have macros that will not because of trust issues. I have done everything needed in the trust center but it will not run the macros and it seems that "SetValue" is the part that will not run. I have trusted the location and also digitally signed the database but nothing changes. This...

I have discovered that it is not a problem with the code. The issue is the security code. I have done everything including creating and authorizing a security certificate on the frontend and backend database. Still when I open the macro in design view most of the items are flagged with a...

After 2003 - 2007 office upgrade I have and event proceedure that creates a new directory on a drive. WHen running the code I get an error 2950. I have alread trusted the drive and subdirectories. I am not sure if this is a problem because I am acting outside of office environment with the...

After 2003 - 2007 office upgrade I have and event proceedure that creates a new directory on a drive. WHen running the code I get an error 2950. I have alread trusted the drive and subdirectories. I am not sure if this is a problem because I am acting outside of office environment with the...

I need to copy, paste, rearrange records in subform for the purpose of creating and revising items in quotes. I am currently using ACCESS 2003 but I can upgrade if I can get this ability. Or if there is another method or tool that I can use for this purpose I could look at that. When a quote...

wstlaurent I have not had any response yet. I did find many problems with office SP3 update along these lines. It is the SP3 update that caused this problem. I was able to fix my problem by adding a Null to the end of the SQL statement and the initals are now shown in the drop down list...

Thank you for your reply GingerR To answer your questions. I dont know for sure that the updates caused this but I will try to get this information. I know it would be valuable if this was the cause. The version of office is 2003 SP3. I believe that I downloaded the Service Pack 3 update...

I have a combo box that displays the following: Project Managers initials (This is primary Key, two digits, caps) Project manager’s name The initials are set to the field when selected. I have been using this for years and all the sudden the project managers initials are blank in the drop...

I am opening an Excel worksheet and populating a cell in a named range called "MyName" with data from Access form. This works fine but when I return to Excel it is hung in the Save file mode! Excel appears to be closed but when I return to Excel I get this problem. When I return to Excel a...

PHV, (I get an error on this one) obj.Application.Range("MyName").FormulaR1C1 = Me!

PHV, Thanks for your quick response! I got the following error: Runtime error 438 Object does not support the property or method ''''' obj.Range("MyName").FormulaR1C1 = Me!

I am opening an Excel worksheet and populating a cell in a named range called "MyName" with data from Access form. This works fine but when I return to Excel it is hung in the Save file mode! Excel appears to be closed but when I return to Excel I get this problem. What am I missing here...

I have a table that is based on a query. I need this query to requery before I set a value. I have used a Requery before I set the value, but the SetValue beats the completion of the update and gives me a bogus number. Can I make a macro wait for the update of the field to SetValue?? Is there...

I would like to send an Email out of Access. I need to populate the To, From, CC, Subject, and Body fields. I want the user to type their message in Access and click a button to view the Email in Outlook before they send it. Is this possible?? Can you give me code?? Thanks, Blake

I have had problems with some of my open form buttons. <br><br>&quot;OPEN FORM&quot; - &quot;open form with specific data in it&quot;.<br>This built in function has no callout in the code for a DLL that I can see.<br><br><br>When you click the button you get an error that says: Access cannot...