Search results

Criminy, I forgot that you could write a simple query that does nothing but call a specific function (and then, of course, call that query from another db). Yes, that'll do fine, thank you. *edit* You did forget to declare a Microsoft Access object and then Set it (I believe that's where you...

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.

Yes, thank you, that actually took care of both problems as far as the messages. However, even though my code reads like I have destroyed the Excel object, the Spreadsheet is still hanging around in the background. Anyone have any ideas why it would be doing that?

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

Welcome to the agony of continuous forms. In answer to your question, no, there's really not a way (at least that I've seen) to make an unbound control in continuous forms independent of the other instances of that control. To get around this, I would write a query and add a field in that...

Well, ADO isn't absolutely necessary, but I have found it to be a quick and handy tool for several things like counting records in a table, deleting records, etc.

Hi, after a long while, I happened to stumble across the answer to this problem while I was at a book store: If CBool(My_Connection.State and AdStateOpen) Then My_Connection.Close End If

Well, either this topic seemed too redundant for a Reply or nobody knew the answer. If it was the former, I apologize, however, if it was the latter, I finally found what I was looking for and here it is: Public Function f_Import_XL() Dim xlWB As Excel.Workbook Dim xlWS As Excel.Worksheet Dim...

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

The third option for the combo box Wizard can do this, but sometimes it doesn't work quite the way that you want it to. Either way, here's the code that you'd need: Private Sub Your_Combo_AfterUpdate() 'Finds a record on the form by clicking on the combo box. 'This combo box matches its unique...

If the two tables relate to each other, you can write a query which selects fields from each table and then base your form off of that query.

Write a query off of your Union Query and include criteria, I reckon.

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

OK, the DoEvents works like a champ. Yes, Pat, I have now determined that queries do run faster than ADO calls, but I like to sample things first before making a decision and I had never really used much ADO before this project. Another good example of this is one of my most recent projects...

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

Your code reeks of both Automation and DAO, two things that I haven't had a chance to learn because of the time demands put upon me. This is exactly what I was looking for though, thanks very much for the info and I'll begin the digestion immediately!

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

First, write a query which Outer Joins Ingredients to Clinical Studies. This will give you a result set of all ingredients whether or not they have studies "attached". I'm not sure how your formulations table factors in, but you'll probably need to write another query based off of a join...

Well, yes and no. The query data IS going into an Excel Spreadsheet, but I'd like to set it up from the Excel side using MS Query so that any users who need a copy of the workbook may have it on their workstation and only need to Refresh. Also, the worksheets are heavily formatted, so MS Query...

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