Recent content by Lobster1071

I'm probably not thinking this through clearly, but I'm trying to have a user select a field to evaluate after importing data. The data being imported can have a different structure every time, so the user would need to type (or select) the field name on which to do the processing on. I...

If someone would be so kind, I would like to find out why this bit of code doesn't work. I'm probably just missing something simple. I've done some poking around, and can't find an answer to what I'm trying to accomplish. I simply have a field called Position, and would like to grab records...

I mean previewing the report with the command: DoCmd.OpenReport "Report1", acViewPreview The report needs to be previewed before printed.

I wonder if anyone can give me a good suggestion regarding this issue. It may be a very simple solution, but I'm just not seeing it. I'm getting by with it as it is, but was just trying to make it look a little neater. I have a sub-report linked to a report, and the sub-report needs to be in...

Thanks for the reply. Yes, the crosstab does have criteria/parameters from a form, a beginning and ending date that the user enters. I did add those 2 parameters to the query, and have the form open with info in those fields when I run the query. As I said, the query works great, and displays...

Anyone have an idea why I am unable to get certain properties of a Dynamic Crosstab query, when it works for other standard (select) queries? The Crosstab query works fine when displayed to the screen, I just can't get any properties (I am going to use the info to create a report). I'm simply...

Just the standard MsgBox command like I've always used. This is just one use of it in my code, but there is nothing different than how I've always used them: MsgBox "There is a problem with the database file selected." & vbCrLf & vbCrLf & _ "Please make sure it is the correct file." &...

OK, I'm stumped on this one... Anyone having an issue with "msgbox" commands not appearing when running on systems with Access Runtime 2010/2013 ? I create an application on my system (Access 2007), distribute it to other workstations (using everything from Win XP to Win 7), and install the...

Hmm, that's interesting. I'll have to think about SE databases, and maybe how to create and then delete them on the fly. Thank you for the good suggestion.

That's an OK idea too, but isn't what I'm doing not really writing the data into the front end? I am importing the data into a table linked to the back end. Then over time, that back end gets compacted to keep the wasted space under control. If I had a side end as you suggested, wouldn't I...

Thanks to both of you for your replies. Gemma/Dave, I still didn't see how that would help, unless I'm missing something. Yes, the structure of all the DBFs are the same. However, I'd still be creating a temporary import file in the front end, which is what I'm trying to avoid. Spike, I think...

I'm trying to find an elegant solution to an import issue using the TransferDatabase command (Access 2007). I haven't found a good solution yet, and have read a few posts, including a couple from this site related to this issue. If someone could point me to a link with a good solution, I would...

For those interested, I found a really nice solution at the link below, which is to make a Tabular layout of the fields. That way all fields grow if only one of them does. http://stackoverflow.com/questions/8099208/access-report-can-grow-property-needs-to-effect-neighboring-controls HOWEVER...

I know this is an old thread, and this resolved my problem except for one small issue. I'm wondering if anyone can point me in a direction that has a better solution. I am using these varying height vertical lines in a subreport in the details section of the main report. The problem I have is...

Thank you very much for the responses, and I like that suggestion using the filter. It should work out just fine. Thanks again.