Recent content by itchy

Hello all, I have a little bit of a dilema. I have an Access database which I just finished converting to Access 2000 (it was 97 before). Part of the conversion was done by the wizard and part manually. I finished my conversion and ran my tests, all works great. So I created my MDE and...

Hi All, I am having a problem with a query that is created using VB. (I am using Access 2000) I have a function that runs through the fields of the created query and pulls out the field source table and field name to use in generating the ‘where’ portion of a new query. The problem I am...

I got it!!!! Finally! On a tip from another unrelated thread, I moved my mousepointer command to the On Mouse Down event instead of leaving it in the On Click event with the other functions! It works beautifully! Thank you for all your help!! Itchy

Hi Alexandre, I have removed the repaint and rearranged the functions a little in hopes that it might help. Here is where I'm at: ___________________________________ Private Sub Image83_Click() On Error GoTo ErrHandler Dim Text1, Text2, Text3 As String Dim condition1, condition2 As String...

Hi everblue, I already tried that, it doesn't work either. The problem seems to be that the hourglass process is running but only gets run aftera ll the other processes have completed (which kind of defeats the purpose!). If I remove the Screen.MousePointer = 0, the mouse pointer will...

Hello all, The following is a whole bunch of functions that get called on an 'onclick' event of a button on my form. ______________________________________________ Private Sub Image83_Click() Dim Text1, Text2, Text3 As String Dim condition1, condition2 As String Dim where1, where2, where3...

Hello All, I have a little dilemma, I have a main report with multiple subreports in it. The subreports have multiple columns and a Report Header and Footer. When opened individually, these subreports look great, the header and footer spans the width of the page and the detail section...

Hello all, I apologize for posting this in a second forum but I have had no response from the 'Reports' forum (after 4 days!) and I am getting desperate! I have a report set up with 2 columns. I have some data and a chart for each page. What I have done is placed data in the detail section and...

Hello all, I have a report set up with 2 columns. I have some data and a chart for each page. What I have done is placed data in the detail section and the chart in the group footer. The NewRowOrCol property of the Group footer is set to "Before Section" so that the data will appear in the...

Thanks for the article, but here is a question that is not addressed. It seems that the function creates a query on the fly but before doing so, deletes any existing query. My database is in a multiuser environment, so what happens if two people try to run queries at approximately the same...

Hello all, I have a little bit of a dilemma. I have an unbound form which servers as a search page for the entire database. There are a bunch of checkboxes for the user to select which area of the database to search (basically which table). Once a checkbox is selected, this triggers three...

Hello All, I have a query that has criteria which is passed to it from a report. The results of the query are then used in a sub-report which will be shown on the same page of the report where the criteria was taken from. Calculations then take place based on the contents of this sub-report...

Hi All, This is a little long winded but this problem has had me stumped for weeks! I have a problem concerning multiple criteria in a query. I have a search form that has 3 unbound text boxes. The form also has a subform that is tied to a query. Each text box on the form is tied to a...

Beautiful! Thanks!

Hi, I am trying to suppress the default error message that is generated when the user enters an item that is not on the list. I would like, instead, to have my own error message that is a little more descriptive. I have tried adding a message box to the 'On Not on List' event of the combo...