Search results

Me!cmdwo_shipping_sched.FontBold = True

I'm sure there are a few ways to do this, here's one way, just add the location of the database In the On_Click event of the button put: Application.FollowHyperlink "C:\Documents and Settings\Desktop\your_database.mdb" ..change the path for each database/button

Trying to keep things relatively simple, you could build a report with all your potential fields and turn off the visibility on all the fields. Build your form with all the checkbox options and based on what the user selects turn on the visibilty of the selected fields. You may of course have...

do these help: http://support.microsoft.com/default.aspx?scid=kb;en-us;175862 http://desktop.google.com/support/bin/answer.py?answer=15000&topic=213

add a new column in the query grid like this: ColumnName:"My Text"

The wizard always makes an unsecured back-up copy of your database, have you not got that?

Condition Field Value Is ... less than ... Date() should do it.

Excellent...now I can get back to the sunshine :)

I just noticed you changed Dim Defendant As String Dim Client As Variant to.... Dim tbl_Defendant As String Dim tbl_Client As Variant there is no need to do that, you've just made up two new variables that I don't reference, you should undo those changes

Hi Gilrucht, I took a few shortcuts that's why the form was unbound. It doesn't make any difference to my example,...for the sake of 'completeness' I've now bound the form. The tables names are irrelevent to my code as I don't reference them directly, just the query 'qryClients'. Anyway, I've...

You do need to add those 2 additional fields into the defendants table. Just checking the defendants against clients is not foolproof as 2 people can have the same name. You really need to be checking clients against defendants on a 'case' basis. I did a demo for you. - Dave

Open up your table...from the main menu toolbar select...Insert > SubDataSheet

When setting focus to a control in a sub form you must first set the focus to the subform and then to the control... Me!LT2DataEntrySubform1.SetFocus Me!LT2DataEntrySubform1.Form!QRt.SetFocus

here's a sample you might find useful, not mine, can't remember where I got this.

You reference the option group frame not individual checkboxes Me!optGroup.Value = 0

Hi, the article says you need to be on a computer without the version of Vbe6.dll that is mentioned, for the solution to work. Do you have a higher version of Access on another machine?

Your problem is a well known bug in A2K, here's the relevant MS article http://support.microsoft.com/default.aspx?scid=kb;en-us;304548 You can unsecure a database, make a new mdw, set up permissons, add usernames again...but it's a lot of work. If you're really stuck I might be able to help...

According to Ken Getz in his Developer Handbook, Bangs and Dots should not be used where at all possible, as they are converted under the hood in Access so... Forms!MyForm!MyControl becomes Forms("MyForm")("MyControl") Another point, ASP doesn't recognise Bangs, another reason to use...

Will the client not let you register the OCX?, it only takes a minute, drop it into the system32 folder... go to...Start > Run > ...and type in regsvr32 myfile.ocx

Have to give a thumbs up for Wrox books as well, I've always liked their writing style. Even better, they allow you to download all the source code for free. If you want a very nice Diary or Cellphone database download here...