There is a report which i am trying to debug. This is the main query which runs in the report: qry_TopTenErrorReport_Crosstab If any idea/help whats is going...

I have created a database and have been using it for over a year. My co-workers started using it recently and asked me to make a few changes. When I made...

After editing code in a form module, I can no longer open the form. When I try to open it using a command button from a menu form (code below), I get a...

The Combo box wizard which allowed you to easily create a control to look up a text field in the form, select and go to the record containing that value,...

Hallo together, I do have a severe problem with a pivot table. My query delivers 2 decimal places e.g. 2,34. When I display it in the pivot table and set the...

I am trying to use "dwgthumbnail.ocx" to show a thumbnail of an AutoCAD drawing in a MS Access form. The form has a text box (DwgFilename) with a valid...

There is a form where it ask the two dates and then run a query then report. Private Sub Command36_Click() DoCmd.OpenQuery "qryResultsReport" DoCmd.OpenReport...

I have a database project where there are exiting Brokers, FundPurchases and Investors in three tables. A Broker sells to many investors who can have many...

Hello Newbie Here Biting off more than I can chew, but anyway. Trying to create database for purchase requisitions at work. Through trial and error I have...

I have 3 text boxes on one line in my report. I would like to eliminate any spaces between the boxes due to variable length text The first box is a product...

I have a subform with combo box. User's are having difficulty selecting values from the combo box directly because so many of the values are similar (many...

Hi, When I pass a value from MyTextBox to MyComboBox using: Me.MyTextBox = Me.MyComboBox It does Not trigger the AfterUpdate Event of the ComboBox I need it...

Macro and button all works fine. It goes to other database and open the form from their. Now only problem is that there are two forms link to each other. When...

I need code to clear the clipboard after I dupe a record so that it does not fill up or give me the msgbx pertaining to whether or not I want to save the info...

Is it possible to query the RecordSet of a form (ie, the data currently displayed on it)? I have a form based on 3 queries (the AfterUpdate event of a...

Hi, I wonder if anyone can help me with a problem with an ActiveX control. I have inserted an ActiveX date picker control into a form and linked it to a date...

Hi, A 'test' is a list of questions. Each question has a grade (a number). I can display a 'test' form with questions subform and display the average grade of...

I am new to access and am teaching myself as i go along. This is what I want to do: I have a table of Entertainers. I have another table listing show dates...

I am trying to create an event on the basis of a sum field., however, it seems that when using ON Open the form is opened before the field is actually summed...