Search results

Make sure your table or query in the row source includes the two columns then change the bound column to 2. It’s a visual thing really.

It is better practice not to use variant where possible use control or textbox instead.

Here is the complete paper size constants: 'Paper Sizes Private Const DMPAPER_LETTER = 1 ' Letter 8 1/2 x 11 in Private Const DMPAPER_LETTERSMALL = 2 ' Letter Small 8 1/2 x 11 in Private Const DMPAPER_TABLOID = 3 ' Tabloid 11 x 17 in Private Const...

I have knocked some code together which may work in the runtime version. I have modified the code from A Code A day for the basic structure and added a default printer function from Albert D.Kallal. Note this just a basic function to show you how you could go about it not a complete code to...

Recreate the textbox and combo as stated (Don't just copy and paste). Also try: Me.[txtNumber1].value = Me.[cboSurname1].Column(1)

I'm telling :p

I agree it might be a refrences issue. Note this applies under the add-ins restrictions. You might want to change the priority of some or the references. Also sometimes I find you need to write a refrenced properties in full i.e. VBA.DateTime.Date rather than just Date.

Note: This begins the close process it does not destroy the window immediately. Bare this in mind if you want to open Access shortly after.

:confused: That exactly what I think she wants.

Well if you had bothered then you would realise this is not simply about hidding the access window (that is easy) it about showing the forms ontop (so they look like standalone interfaces) at the same time. That is the whole issue with reports they can't be popups. You need to think before you...

"Important Some restrictions may prevent you from saving your database as an MDE file: · If your database is secured with user-level security, you must meet certain criteria. · If your database is replicated, you must first remove replication system tables and properties. · If your database...

Repair the database before compiling. It might be a system object that is corrupted.

Labels don't have a source that's why they are labels. Use the on current event to update the label txt.

To unhide db objects go to Tools -> Options -> View. In the show options chech hidden objects.

If it ain't broke don't fix it. The company I last worked at the larger holding company suddenly decided that all the businesses had to have office 2000 for no good reason. This caused a lot of havoc, and many people were left with something they either couldn't use or was inadequate. I know...

You don't have to use selectobject to do this anyway. If you hadread the code properly you would use this method: Call fSetAccessWindow(1) 'show or Call fSetAccessWindow(2) 'maximize He didn't ask for this however he asked whether you can display reports without having the access window open.

Well this is not how you search databases for one, like you say it is very process intensive. What are you trying to do compare each record field with the search string or compare one record field with the search string?

If you have used the code to hide the access window then you would know selecting the report is not the problem, it is making it display topmost of the mdi parent window. The only mdi child windows which display topmost to a mdi application window are popup and dialogue this is fact. Mdi stands...

I don't understand why you don't want to use the security. You can leave the passwords blank. You can create four user groups: dogs, cats, fish and admin.

If it is just the names you want, then go into datasheet view. Select the first row. File -> Print -> Selected Record(s). Then you can choose your own orientation fit to page, etc.