Search results

thanks for the Dirty tips that will work perfectly. Dirty.Dog =true

I have aan undo button on a form problem is that if you click the undo button without making any changes to the record displayed on the form it is throwing an erorr about how the action is not available. how can I get around this... people might click edit"calls editMode" then decide they...

thanks for the reply I found another way to accomplish what I was after.. Private Sub cboVendor_GotFocus() If IsNull(Me.cboComponent.Value) Then Me.cboVendor.RowSourceType = "Table/Query" Me.cboVendor.RowSource = "tblVendor" Me.cboVendor.ColumnCount = "3" Me.cboVendor.ColumnWidths = "0,0,1"...

why does this expression not work? it is the criteria in a query I am trying to make the query return everything in the field if nothing is selected in the combo box where the criteria comes from. IIf(IsNull([Forms]![frmVendors]![cboComponent]),"",([Vendor].[Component]) Like "*" &...

thank you

Is it possible to make the PrintOut method use a landscape format? I'm trying to print a form and it is taking two pages to print because of the width of the form.

had to re-install help files thanks! not an overly simple proccess though.

**RESOLVED**Change base of AutoNumber? My data base table uses an auto number as primary key and this number is essential for tracking records. There are several instances of the db running in parralel...all that save to a linked table via an append query. A code letter is concatenated onto...

how about this one. I feel it conveys the kind of frustration that an access developer experiences from time to time!

i found out how to see the module.....It is just the code behind my form...I did not realize that it would be referred to as a hidden module. Next question is why does it give me a compile error while making an mde. The database works fine as mdb. If there is a problem with the code why would...

yes, to no avail I have made mde copies of this db before... today I was editing the main form, went to save as mde and got the error. I guess I am going to have to start over on the changes..

I am getting athe following error message when I try to make an mde database compile error in hidden module Form_frmReferance does anyone know how to access the hidden module in order to look for the problem?

thankyou for the input. I am working with the network guy on a good solution. thanks again p.:)

How high is the resolution of the original? I find that if you reduce size from a high quality original you get better results than if if you just try to use a lower resolution original.

I have a database for service and Maintenance requests. It is a very simple db. It lives on a shared folder on the intranet. It has a hyperlink that points to it from the company intranet homepage. problem: When you click on the link the network will not allow the user to open the database...

thanks I ended up using a solution quite like your first suggestion.

How can I set the value of a text box on a form to the result of a query ? The query criteria comes from a combo box on a form , the text boxes I want to populate are on the same from. alternatively I would like to have the result of the query go directly into the table that are the txtBoxes...

is it possible to bind multiple columns in a combo box? if so how? thanks p

thanks

how do I get ti the properties of an InputBox? ans = InputBox("Enter Administrator Password", "Administrator password")