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 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...

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...

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...

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...

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’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...

I have looked around this forum and can't seem to find exactly what I want, but if anyone can link a thread instead of rehashing what has already been said, please do so... I have what I think is the simplest of crosstab queries set up, and would simply like the horizontal totals of the values...

This seems like a simple problem which should have a simple solution, but I cannot find the answer with the little bit of poking around I've done. I simply would like to take a fields with a number format (Single, Fixed, 2 decimal places) and export it to a DBF file. However, when they are...

I’m attempting to obtain a value from a field within a query. However, the field will vary based on selected info from a form. Yes, I know this is vague, but I’ll given an example below. This may not even be the best way to do this, so any suggestions would be appreciated. What would really...