Search results

Ok, I'm very much stumped as to why this has happened and completly lost on how to fix it! I have a report in Access 2007 that displays groups of data based on a sorting and grouping option of four report fields (they are all text data types). It was originally working just fine and everything...

Well, in checking the references, both the old and new computers have the same things listed so I don't think that is it. I did install the Compatability Pack on one unit and try again but did not have any luck. I guess I'm back to the begining wondering what is missing...

I encountered a strange issue this morning and I'm wondering if others have seen the same and what they have done about it. The short version is that I am using VBA to re-format an Excel file from Access. We recently replaced some computers in the office and the new units are failing when they...

Ok, so I'm wondering of anyone ever found the answer to this one? I have the same problem!

Interestingly, this is exactally the thing I came here looking for today... I, too, will be monitoring this question for a response!

I'm just wondering if anyone has figured a good way to send an Access report to Excel and hold all the formatting? I know that feature was nerfed by Microsoft in Access 2007 but I'm trying find some way to take all the lovely formatting I do for my reports in Access and send them out to a file...

Yes, that is what I am trying to do. The nature of the data is that it will remain static until the next update. There is only one set of records (from multiple queries) that will be displayed on this form at any given time. My intent is to send the image to a file then e-mail that file for...

Okay, so there I was... No really, I'm trying to send the content of a form to an external file using VBA. I'm pretty sure that the OutPutTo method is the proper way to do it but I can't seem to get it right. The code below will execute and the file is properly formatted. The only problem...

Hey gang! Ok, so I'm using a DLookUp on a form (several, actually) to compute the percentage of a certain portion of my dataset. The DLookUp method works and seems to return the correct values but it takes a horribly long time populate the calculated fields. This is what I have in the control...

Oh wow! That worked perfectly! That's what I did wrong! Thanks DK!

Well, the good news is that it is doing something now. The bad news is that it isn't working... I'm getting an error (Compile Error: Method or Data Member Not Found) on the .Compile reference. I am guessing this is because I need to first call the proper library (um... that's what it is in...

Well, here I am again being dense... I have tried a number of variations of calling Me.OpenArgs into my form and I can't get any of them to actually display the value. I'm reasonably sure that they are setting the value, I just can't place that value on the actual form. The latest attempt...

DK - I think I may not have been clear... I don't want to use the MsgBox code (I provided it so you could see what I am doing now). MsgBox opens a popup that I can't format with the same colors and fonts used in the rest of my program so I am using a popup form with the same information. What...

Ok, so I think I understand how to use OpenArgs as part of my call to the message form. I believe the code below will place the value of strPath onto the global variable Me.OpenArgs. I have also read several threads on using this method and they seem to indicate I should call this value in the...

Hi Gang! Ok, so I know that you can't manipulate the appearance of a standard message box and that you need to create a popup form that has what you want and looks all cool. I'm okay with doing this and I have set up a form for my code to call and use. What I don't know how to do is place a...

Okay! Thanks for the suggestions guys but I actually found a solution by proxy! As it happens, the queries I was having trouble with were taking too long to run (lots of data to sort out) so I decided to append to a temp table for processing. Now the queries run with the prompts and the VBA...

Oops... I guess I knew that Bob, but I clearly overlooked it... I will look into changing it when I can... THNX!

Well, for the love of God.... all it had to do was give me a little error message and let me fix it! Thanks a million Vassago... Works great now!

Bump - Please don't hate me for this!

Ok, so I'm trying to use nested IIf statements to determine the value of one column in a query. For some reason, I can't get the query to accept the third statement. Naturally, I'm using Access 2007 which, rather than actually tell me what the error is, it simply reverts back to the previously...