Search results

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

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

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

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

Does anyone know how I can add a new user to my secured database with VB code? I am trying to set up an Admin form that has fields for the new user's username, PID, and group (the groups have already been set-up) and a button. When the button is clicked, the info will be verified and if...

Hi! Does anyone know if it is possible to access the unbound column in a list box? Here is what I am trying to do: I have a list box that has two columns, 1 - Name (unbound but visible) 2 - E-mail address (bound but not visible) When the user double-clicks on the name in the list...

Hi! I have a database that I am currently working on that will reside on a network server that my users will have access to. I want my users to be able to open up reports that are residing on the same server (that are in Adobe Acrobat format) from within the database. (i.e. they click on a...

Has anyone ever attempted to use a transparent gif as a background picture on a form? I have been trying but Access displays the background (transparent) color anyway. Ideas?

Can anyone tell me why a custom label that I have created with the label wizard does not appear as a label option when I try to create a new report using the same label? And if I try to recreate the label, when I go to save it, it tells me that the label already exists! And yes, the 'show...

I have a combo box on a form that displays company names (data comes from a query). The form contains a subform that has another combo box with contact names (also from the same query). I have set up the query to get the parameter for the company name from the first combo box, the afterupdate...

Hi! I have a report that I am trying to export or publish with Word. The problem is that I am losing all my dividing lines. Is there a way that I can avoid this loss? Also, does anyone know if it is possible to export a report into Acrobat Reader format? Txs.

I have a subform (on a search form) that is based on a query. What I am trying to do is when the user dbl clicks any record in the subform, another form (the edit form) opens allowing the user to edit the information for that record. I have created a macro to open the form and have filled in...

Hi! Here's the deal. I have a form whose purpose is to search one of two tables for specific information in specific fields and then display this information in a subform. The form has two check boxes (one for each table), a combo box, and a text box. What I have tried to do is when one of...