Search results

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.

I believe this answer is obvious, but just wanted to see if there was a better/easier way that I was missing. I have a main table called "Assignments" (Date, Time, EmployeeID, Notes, etc). The EmployeeID field is a Lookup field (combo box) which of course is linked to a simple "Employee" table...

This is probably a dumb question, but I'm going to ask it anyway...:D After I install and run my created package on another workstation, I don't see the name of the program on the taskbar. I mean I see the application running, but it is a "blank" application on the taskbar with no title. Even...

I would think it would have to be a new table every time. I have no idea how many fields, or what their names are for each Excel file. The only thing I can keep consistant is the table name that I am importing the random Excel file into by using the TransferSpreadsheet command. I of course...

I’m trying to write a program to do the simplest task, but of course I am stuck on how to accomplish this. The program is going to do this… 1) Import an Excel file 2) Remove trailing blanks from all fields 3) Export it as a DBF file Sounds unbelievably easy, right? I can do...

That's amazing. It looks so easy, but yet I never would have figured that out. It was exactly what I needed, and works perfectly. Thank you so much!:)