Search results

A beautiful young woman about to undergo a minor operation is lying on a gurney in a hospital corridor awaiting the medical staff. A man in a white coat approaches her, lifts up the sheet, and visually examines her naked body. He walks away and confers with another man in a white coat. The...

Two Scousers are riding along the M62 from Manchester to Liverpool on a motorbike. They break down and start hitching a lift. A friendly trucker stops to see if he can help and the scousers ask him for a lift. He tells them that he has no room in the wagon as he is carrying 20,000 bowling...

Sorry .. just noticed the way you are doing it ... =[Forms]![MAINFORMNAME]![SitesByVersion_subfrm].form![Count_txt] should do the trick.

=[Forms]![SitesByVersion_subfrm].form![Count_txt]

Have a look at this.

Thanks EMP that is fantastic. !!!

Hi there I have a crosstab ... but what i need it to do is to display a 0 instead of leaving the fields blank. I think that i need to use the Nz function but i am not sure as how to use it. Any help would be extremely grateful. Steve

Hi there. I have what i think is a simple question but it has stumped me. I am using the docmd.CopyObject DoCmd.CopyObject "path To DataBase", "New TableName", acTable, "Source Table Name" What i want to do is set the "path to database" to the current directory. because the databases can be...

Thaks for the uick response Mile but Sorry my mistake, I have two variations on the error. I either have the double in the combo box or i get : On that version the error If you type data into the subform after you have added to the combo box it does not assign it a value so that when you try...

Help - I have a combo box that runs a simple search and also has an add facility on the not in list event. The problem is that it seems to be adding 2 rows into the combo box instead of just once but i can't figure out why it adds the second row. It is very hard to explain what is...

Why don't use use something like Private Sub YourComboName_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.RecordsetClone rs.FindFirst "[YourFieldName] = " & Str(Me![YourComboName]) Me.Bookmark = rs.Bookmark End Sub This is a simple...

try DoCmd.FindRecord Me.txtDescription, acAnywhere, False, acSearchAll, True, acAll, True

Sorry I have just looked at it ... it is True (-1) and False (0) which is what you have tried i think so no help there Sorry about that

i seem to recall that it is Yes or No to collate copies. Default is YES Steve

Thanks fella's It works fine now Steve:D

Hi All, I know it shouldn't be that difficult but I am trying to just have a button to delete the record that the user is on at that moment in time. I am sure that it is something to with recordset.delete but i may be miles of. Any help would be greatly received. Steve

On not in list : DoCmd.OpenForm "frmAddressOfUnit", acNormal, , , acFormAdd, acDialog Me.MainUnit.Requery there is not code on the close of the other form. Steve

The error is: You must save the field before you run the requery action.

I have tried that but it is the actual combo box that says the error. That is the one with the not in list event that i am using to fire the open form. It is the same error still. I think it i will have to use an unbound cboBox to do the initial selection. Steve

OK. Here is the problem: I have a combo box that as a row source is based on a seperate table. On the not in list even to open up a form to enter (in this case) a name and address. After this i close the form but the combo box does not update. I tried using a requery as i closed the form but...