Search results

Thanks for your help guys

Hello there you fine Access programmers. I have a problem with a list box. As you can see in my Access 97' attachment, I have a list box that updates certain boxes on a form. What I need is for the user to be able to narrow the search (by the court name field) in the list box depending on...

Does anyone know how to put a button on a form to export the data in a certain table to SAS? Thanks

Cheers - I used: DoCmd.GoToRecord , , acNewRec on the "on load" event on the form. Thanks for your help.

Almost. If I do this then I can't seem to browse through the records in the database. It only lets me add data and not adjust past records. Any way of doing that?

How do I use a form so the user can enter a record straight away? At the moment, when the user enters a form it open's at the start of the records and to add a new record they have to press "Add New Record". I want the form to open so it's ready to accept a new record straight away. Thanks...

How do I password protect certain button's on a form? I have a delete button and I only people who know the password to be able to delete records.

Thanks, that was quick! Um, another question . . . the age estimate is derived using this code in the control source of the unbound text box (estimate age): = ([date of application]) - ([date of birth]) These are date fields and to get the result of this to an age I have to set the format of...

Here's an easy one. I know what to do but I'm usure of the wording in Access: What code should I use on the click event of a button to paste a numeric value from an unbound text box to another field on the same form (the button will be on the same form). Assume that: The unbound text box you...

The direct method worked a treat! Thanks. And thank's for the speedy (3 minute) reply, must be a record!

sorry swap the 1 and 2 around, it should be: If vbokCancel = 2 Then Exit Sub Else If vbOKcancel = 1 Then DoCmd.RunMacro "Mcr_Frmmain to by MCC" Still doesn't work though!

In a vbokcancel msgbox, how do I get the cancel button to stop running a sub (i presume exitsub) and the ok button to run a macro. This is what I have so far . . . . MsgBox "This will bring back details by MCC between the dates " & Forms!Frmmain!txtDate1 & " and " & Forms!Frmmain!txtDate2 &...

I have END IF at the end, sorry, forgot to paste

I have a form with an unbound txtbox. The default for the txtbox is "01-Jan-1900". I don't want the user to see this date but if they change it then they should see it. In the before update action for the txtbox I put in this code: If Me.txtDate1 = "01-Jan-1900" Then Me.txtDate1.ForeColor =...

I have created a form but I've missed off a field in the relevant table . I went back and created the new field in the table and went back to put it in my form but its not in the field list at the top of the form design screen (next to the tool box). How do I add it to my form? Please don't...

ha ha sweet! It's now 0.5mb! Thanks

Hi, Is there anyway to decrease the size and therefore increase the speed of an access 97 database? This is my first real go at creating a database and as you can imagine I have created and deleted alot of forms & querys that I haven't needed and this (I think) has increased the size of my...

Ummmmm, still no good. I even made a new DB with a form relating to a table to test the code but it still didn't work. Should I mention that Date of conclusion is a date field, Duration of order is a text field, and Until further notice is a yes/no field (check box) . . . . . . Is there any...

Sorry, I copied the whole lot, I only typed: If IsNull([Date of conclusion]) And IsNull([Duration of order]) And IsNull([Until further notice]) Then MsgBox "Enter Date of conclusion, Duration of order, OR Until further notice", vbOKOnly Cancel = True End If ......... It still doesn't work...

I coudn't get this to work? I typed this in the Before Update field on the Form properties: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull([Date of conclusion]) And IsNull([Duration of order]) And IsNull([Until further notice]) Then MsgBox "Enter Date of conclusion, Duration of...