Search results

Hi all, I'm trying to release my objects in an error-handler, but only if they've been set to something. I'm trying If Not filesys = Nothing Then Set filesys = Nothing End If but it's not working. Anyone know?

Iterate Through Forms Collection To Get Recordsources Hi all, I've been charged with redeveloping a huge (several 100+ tables, forms, etc.) database which was brought over from another company. I'm trying to iterate through the forms to get their RecordSources, but I can't quite get it. This...

Hi all, I'm just looking to see if anyone has ever reached a definitive conclusion on dealing with Excel Automation and the age-old problem of the Excel Application hanging around in the background with the user having to eventually do a Ctl-Alt-Del or, worse, having to restart the computer in...

Is there a Method of the FileSystemObject class which will allow you to determine whether or not the file is currently in use (i.e. is open)? *edit* if not, is there another class which could make this determination?

Hi, all, I'm looking to get some general information and tips about Access reports. Up to this point, the majority of reporting/output has been via Excel as very few people within the company that I work for have MS Access but everyone has an Excel license. The upside to this is that I've been...

I have a form which accepts user-input and builds a pass-through query and its SQL based on parameters that the user inputs. If the query is successful, it pulls the results into a table. What I would like now is a subform datasheet with which to view those results (a report won't cut it as...

I see several examples on this and other sites of developers taking screenshots of their forms/reports/etc. and placing the images in HTML pages. How are you guys taking these pictures and what file format are you saving them as?

Continuous Form Independence Question Re-revisited Hi all, I have a Bound Continuous Form with 7 text boxes and one Combo Box. The effect that I'd like to have is, if the Record is New, then all of the Text Boxes will be Disabled and can only become Enabled once a Selection is made out of the...

Hi all, This one's a noodle-scratcher. I am currently developing an employee-tracking database. I have two Date variables which I have set up. The first is the Friday of the week that the employee was hired on (I just took the Hire Date and used a simple VBA function to determine the Friday...

I've been trying for the longest time to find a good source of information on Access/Notes integration, but there just doesn't seem to be a whole lot out there. We use Notes as our mail client at work and daily are sent Excel Workbooks (several dozens) which must be imported into one of my db's...

Hi, As the Subject line implies, I need to be able to: 1. Open an external database 2. Execute a function in that external database 3. Close the external database I haven't yet found the code to perform this task, so if anyone could give a hand, that'd be much appreciated.

I have the following code which opens an Excel workbook, Refreshes the Excel worksheets which query a ProTrack database, transfers the data in Access, and then closes the workbook and cleans up after itself: Public Function XL_CAD_Routine() On Error GoTo XL_Cad_Routine_Err Dim strFile As...

Hi all. My Subject Line pretty much sums up what I'm trying to do; I could've sworn that I saw this topic covered on a post a few months back, but I can't seem to find it. Anyway, I will have a workbook who's filename will be selected by a dialog box and that filename will be captured by an...

Hi, all, this is pretty much a continuation of a previous post. I having been experimenting with ADO quite a bit and, in most cases, have found Action queries called from form-level events to perform better and be easier to write. However, the really attractive thing about ADO is the support...

Hi, all, I'm attempting to accomplish a task which I assumed would be really simple, but is giving me problems. I have a function which performs several ADO actions (Update, Insert, Delete). The function takes a while to fully execute, so I decided that I'd like to have a little label on my...

Hi, I'm looking to do the following in the On-Click event of a command button: DoCmd.TransferSpreadsheet acexport, , "Some_Query", "Some_FileName", False, "Some_Range" And Then: DoCmd.TransferSpreadsheet acexport, , "Different_Query", "Same_FileName", False, "Different_Range" So...

I am trying to use MS Query to import queries from an Access database. All of the queries import fine except: -One query uses 2 functions in a module to capture the beginning and ending dates in a form. The query works in Access, but when I attempt to import using MS Query, I get the error...

Hi, all, just another day in Excel Hell. What I have is an Excel Spreadsheet which has a myriad of different data types in its numerical and date fields. The procedure that I came up with which works (to this point, anyway) is to write automated queries which, when this data is imported, looks...

Anytime I use ADO functions, whenever I'm developing forms that call these functions, I constantly get the -2147467259 error message: "Database has been placed in a state by user Admin..." when switching back and forth between Design and Run Views. In order to avoid the error, I have to save...

Hi, all. Following is partial code in the On-Click event of a command button which calls a dialog box, has the user select a .xls file, pulls a certain worksheet in from that file to a Temp Table in the db, calls a function utilizing ADO which executes several different actions on the Temp data...