Search results

Kevin - I spent the morning going through the database checking for the leads you gave me. The code was compiled and the error handling is in place (I had performed all this because of the various programming information from this forum already) :) I am using stored queries, there aren't any...

Hmmm - no change. Any ideas on other references that I should increase priority on or make sure are checked? I suspect that is where my problem is, as the code runs, it just runs slowly. TIA

Without VB, i.e. if you used the Developer solution just for the Access FrontEnd MDE file, would it remain tied to the backend MDB file on the network? Can you use Access runtime to distribute the front end if it is dependent on the network shared backend? TIA - Pat

Do you think increasing the priority and version of DAO would help? Just wondering if that code would run faster through DAO. Thanks again :) I'll try it on Monday.

How would one convert a traditionally split database solution, i.e. MDE front end and MDB backend for network sharing, into a runtime Access solution. Does Developer have support for this? I would be very interested if I could deploy our database to systems without Access via Developer, but...

I could have sworn I tried that, but upon trying it again it worked! Thanks Wayne :) That extra set of "eyes" sure helped!

Okay - I've attached the file post importation where the error is appearing. If you open the Table Query form and click to select tables, you immediately get a runtime error. Help?

Hmmm - I went and matched code references in the sample to my database, but now I am getting a "Type Mismatched" error, without any debugging assistance. Any ideas? Always frustrating to find the perfect code and then not be able to get it to import :)

I did that and it works so long as I'm in the example I downloaded. Once I import it into my current database, I'm having problems with the program, specifically I'm having problems with the After_Update event in the form. I'm trying to sort through these - thanks again guys for all the...

DJN - That is PERFECT. It is exactly what I was looking for. However, I am having difficulty with two items. One, it's not marrying to my system very well and Two, there is a limit of 6 fields to select. Is there a way to increase that? The marriage to my system is having problems with the...

So let's say I have ListBox1, ListBox2 and ListBox3. I want ListBox1 to have the list of Tables of the database. ListBox2 would then list the fields of the Table selected, and ListBox3 would show the data for the field selected. I've tried implementing an After_Update( Me.Listbox#.Requery )...

Okay - I didn't know whether to post this in queries or forms, so here goes. My users need to be able to have more control over extracting data from the tables in a dynamic fashion. I envision them being able to go to a form, click on a pull down box which is populated with the table names -...

Okay - I didn't know whether to post this in queries or forms, so I'll try here first. My users need to be able to have more control over extracting data from the tables in a dynamic fashion. I envision them being able to go to a form, click on a pull down box which is populated with the table...

I did read about the debugging issue - I'm going to use the Show workaround for that in case of errors. I'll try the Word report method, sounds better anyway because then the users can manipulate the data directly, instead of having to export it (eliminate a step). One question - once Pop Up...

Kevin - Works for everything like a charm. Should I put different code to launch the reports? I set the reports to popup and modal "Yes", but they won't launch and minimize the program when I try. Thanks again :)

Unbelievable. You are the MAN! It worked like a charm - thank you _very_ much for that !

I can't post the database, as it seems to large to attach to the BB. The problem I'm having is the same as most people I've read on the forum trying to implement the "hide access" trick, as outlined in the attached files in this thread. I want the database to boot up without the large Access...

Kevin - Can you help me too - I am trying to accomplish the same, but having varied results. Thanks :) Pat

:) I wish it were that simple. What I want is a result like the following thread. I am having problems implementing the code as described in the link (and above), was wondering if anyone familiar with it could help me out...

Actually I'm referring to hiding the database window, so that the form looks like a program without the Access GUI behind it. The form should pop up and minimize the surrounding MS Access "components". Sorry about the code formatting. Thanks for your help :) Pat