Search results

Not really sure if this is what you are after but you could trap a keypress for the form F9 or whatever. A key that isn't used in every day life. When the key is pressed make your field visible....Maybe!

If you have set the type s currency, then it may have a default value of 0. therefore you're criteria could be =0. If this is not the case try Is Null or =""

Put this in the on click event: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "MyTable", "c:\MyExcelFileName.xls", True True refers to whether the spreadsheet has field names. The field names need to match the field names in the table. Hope this helps

If you mean a Rich TextBox click 'more controls' on the toolbox, then select Rich text box....

Thanks for the answer but I need the individual item to be bold, when clicked, and remain bold within the combo box until the item is clicked again. Therefore when the user selects the combo box the second time, whatever item they clicked in the list the first time is still there but...

Does anyone know if it is possible to make the item(s) clicked in a combo box bold or italic or red or whatever. Then when it is clicked again 'unbold' it.

Try this: ftp://ftp.ruhr-uni-bochum.de/pub/Info-ZIP/info-zip.html

In the On Click event of the label put in: Docmd.openform "MyFormNameInHere" And your form will open.

Try: Between val([Enter first ID:]) And val([Enter Last ID:]) If it doesn't work, look up 'Between' in the help file. This function will give you a range.

I was actually looking for 2 entries the same rather than a sequence but it works in the say way. I accomplished it by looking at the 1st the 2nd & comparing them, 2nd & 3rd and so on. With only 1000 records I think you'll be surprised at it's speed, then again maybe I'm easily pleased!

Dim Axs As Access.Application Set Axs = New Access.Application Axs.OpenCurrentDatabase YourDatabasePath, False Axs.DoCmd.OpenReport "YourReportName" Axs.Quit Set Axs = Nothing

In your criteria you could put: Between [Enter first ID:] And [Enter Last ID:] This will then give you a range...

I have done something similar recently and I think you're going to struggle to do this in a query, although I may be wrong. There were many more than 1000 records in my table and it worked very quickly and was doing a lot more than you seem to require.

Private Sub Combo2_Click() If Combo2 = "No" Then Text0.Visible = True Text0.Enabled = True Else Text0.Visible = False Text0.Enabled = False End If End Sub

Pre draw the comments box and set it's visible & enabled properties to false. When the use selects no, enable the visible & enabled properties. txtComments.Enabled = True txtComments.Visble = True

Form properties - Data entry is possibly set to True.

I'm not sure I fully understand but why not do the sum in a query and use dlookup to show the value in the footer of your first report and also in the detail of the 2nd report.

Could be many things. Try entering data directly into your table. Then go to the next record. If that doesn't error then it is something to do with your form...

One way would be to put this in the kepress event of your text box: If KeyAscii = 45 Then If InStr(1, Text0.Text, Chr(45)) Then KeyAscii = 0 Else KeyAscii = 0 Text0.Text = Mid(Chr(45), 1) & ext0.Text End If End If

Before the 'Unable to save'... message, do you not get another error message?