Search results

Hello all. I have deleted a Report but the underlying reference in the VBE editor in the CLASS OBJECTS list remains for the report and is giving me errors during run and compile. Any idea how to delete the Class Object once the object has been deleted? Any other suggestions? Version...

Hello. I currently have a data-entry form that users fill-out with data (duh!). The data comes an excel spreadsheet that is created during the work-flow process. I would like to add an "Import" button the field that, when clicked, would prompt the user to select a spreadsheet (different...

Hello all. I apologize in advance if this has been addressed elsewhere, but I have been unable to find a solution. I have been using the DefaultPRT.ZIP modules and code successfully in an Access database (2000) under a WINNT environment for a couple of years to allow the user to change...

Hello all. Depending on the logged used I would like to disable every textbox and combobox on a form using VBA. I know that I can use the following code to move through the Control Collection: Dim ctr As Control For Each ctr In Me.Controls DO SOMETHING HERE Next ctr ' Me.Refresh...

Hello. I have a form with many control and a lot of code associated with the Events of the controls. After making changes to the form the other day I noticed that most/all of the events no longer "fired" and command buttons no longer worked. When I look at the Events list for a control...

Hello all. I have a database that has a number of forms for data entry. On some of the forms I have implemented a calender control created by Stephen Lebans. Also on these forms I am trying to disable the use of the mouse wheel (I am using Access 97). Mrabrams2 posted an excellent bit of...

Hello. I am trying to install Access 97 on a machine that currently has Office 2002 (XP) installed on it. I have searched and found information about installing Access 97 on a machine with Office 2000... Has anyone successfully done this? Should I follow the same directions for installed...

I am attempting to save a report as a pdf. I have the code working that changes the default printer the Adobe Writer and then prints the report. However, I would like to bypass the Save As dialog box in Adobe Writer and have the report print (save to a specific location). I understand that...

I am using a recordset to retrieve data from a table. Because I need to retrieve data from a number of fields within in the table (depending on the contents of a number of textboxes), I have created a function that I call when these textboxes are exited. Into the function I feed the value of...

Hello. I tried to find a solution to this problem, but really couldn't even think of a way to search. Basically, I am filling a number of textboxes in a report dynamically when the report is opened. Based on the length of the text in the box, I want to fill the remainer of the textbox with...

Hello all... In an effort to increase the performance of my database, I used the decompile feature in 97 to, well, decompile the database. I have used the feature before with no problems. However, this time it created multiple problems. Namely, when I try to complile the database I get and...

Hello all. I am trying to convert the contents of a textbox from a string to a number in order to test the input values. I am using the Val Function and it works great when the contents contain no decimals. However, as soon as decimals is entered, things go wrong. Here is the code...

Hello. I am attempting to base a complicated query (which I do not create in SQL in code because of it's complexity) that has a number of parameters that are pulled from a form. The query works like a peach as long as a value is selected in combobox. The problem arises when the user does not...

Hello... I have a query that returns a number of fields from a table, i.e. Effective Date Employees Premium Increase ETC.... Sept 2002 22 $34.00 10.56% Oct 2002 24 $54.00 13.56% Now, I want to create a report using the query. The catch is...

Hello...I am not sure if there is a good way to do this... I have a textbox that I want to become disabled and locked if the user Exits the control without entering any data. The problem is that I have to set the focus to another control on the form before I can lock and disable to the...

I am looking for an example of creating Vertical Justification of the contents of a textbox within a report. I found an example on Labans website, however, it is only available in Office 2K and I am working in Office 97. Is this possible in 97? If so, any ideas would be greatly appreciated...

I am working on report that has a textbox that must be a certain size (to be seen through a hole in a overlaying piece of paper)...The text that appears within the textbox is variable, so the length will not always be the same. If the text is too long to fit in the textbox, I need the fontsize...

Hello all. I am trying to determine if a query results in any records. Depending on the situtation (no records or mutiple records) I need to do different things. The query is based on a number of parameters found on an open form. Typically I open a recordset based the query to determine if...