Search results

Also the .OldValue is useful if you want to create an undo procedure

Hi there Why not create a form that asks for the criteria. Then in your query you pass the values to the criteria by using the following syntax [Forms]![frmMyForm]![cboPotSize] [Forms]![frmMyForm]![cboPotDesign] etc.. This way you can design your form to whatever you want and can have an...

Presumably you haven't yet rolled this out to your users? When you have the database open it creates a record locking file in the background and is denoted by the file extension .ldb. With the database closed have a look in the folder where your back end tables are located and see if there is...

Hi there, Just thinking about it you would also need to check this combo box is completed when your user closes the form. If you want your user to follow a logical procedure i.e. only allow them on to the next control when the previous one is completed then use the code in the On GotFocus...

Try this code in your combo box's On Lost Focus event If IsNull([Givenby]) = True Then MsgBox "Please select a name from the list", vbCritical, "No Name" Me.Givenby.SetFocus End If

Go to Tools Menu ---> Database Utilities ----> Convert Database ---> To Access 97 File Format This is where it is in Access 2002 and I'm sure it's the same for A2K HTH Rob

You cannot save as a 97 version. You can convert down to 97 but may loose features that are only available in 2000.

Hi there What you will have now is a BE containing the tables and a FE containing your queries, forms, reports, macros, modules and pages. The FE you will copy to each of your users machines and you will have a master copy. Every time you make changes to your master copy i.e. new forms or...

You need to use the Database Splitter. In A2k its under Tools---->Database Utilities. The wizard will take you through the process Tip Once you have split your database you could use the Linked Table Manager to re-link to the back end using UNC naming technique. Where it ask for the file...

I'm just guessing but am I right in thinking you have just the one database being shared by your users and that contains your tables and your forms, queries, reports etc? If so why not split the database. This will create a back end containing the tables (resides on the server) and front end...

Hi there, Just a couple of thoughts... 1. Are all your users running the same version of Access? 2. Has any of your users experienced any other problems with the network? It could be a faulty connection somewhere

Mile, Great stuff :D It's nice to have something to refer to. Rob

Hi there, I have an example of simple password authentication. It's not quite what you want but what it does is to make use of the DLookup function to return the password, permission level and login name to public variables. Unfortunately it's too large to post here (116K) so if you want I...

You can use the On No Data event of your report Private Sub Report_NoData(Cancel as Integer) MsgBox "No Data To Print", vbCritical, "No Data" Cancel = True End Sub

Hi there, Try ghudson's suggestion as that code tests for Null and a zero length string. Also what is the error message you are getting? It could be that Access 97 doesn't recognise the vbCritical part. In Access 2K it does. However I think the constant for that is 16 so you may want to try...

Ian, Try this: Private Sub logcall_Click() On Error GoTo Err_logcall_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmcall" stLinkCriteria = "[ID]=" & Me![ID] If IsNull([Second Name]) = True Then MsgBox("This option cannot be run without data",vbCritical,"No...

Try using this code: If IsNull(youControlNameInHere) = True then msgbox("This option cannot be run without data",vbCritical,"No Data") Exit Sub Else ...code to run your report End if Bear in mind that this only tests for a Null and not a zero. HTH Rob

Hi Chris Glad I could help :) If your still having problems or need anymore help then keep on posting! Good luck Rob

Chris, You mentioned the following: In the first instance, rather than have a combination of free text and selecting from the list box concatenating themselves into 1 text box, could you have 2 text boxes, one for the free text typing and the other for the list of preset findings? If yes...

Steve, I'm not sure but you may need to run an update query, unfortunately I can't help you much on this one but hopefully someone else will. I have attached an example which shows the relationships and I've created a simple crosstab query as well to show you how you can display the data. HTH...