Search results

How about in the form's onopen event you put: me.orderby="MyDate" me.orderbyon=true and RuralGuy is right, don't use 'Date' as the name of your date field.

I'm certainly no expert, and this is just a stab in the dark, but don't references to dates have to begin and end with an '#'? Larry

I've also seen this happen on a machine where the currently logged in account did not have delete permissions in the folder where the database resides. Larry

Keep your secured mdw file on the server. On the user's desktops, make an icon pointing to the FE on the user's machine, and include the /wrkgrp stuff pointing to the mdw on the server in the command line. I have done some quick testing in the past, and found that if you map a drive on the...

Great collection of buttons Ashfaque! Thanks for posting them. Larry

Chris - are you able to open any other database files on your computer? Larry

There's always several ways to accomplish a task - glad you found one that works for you! Larry

You said entering 'Fred Bloggs' in the 'enter parameter' prompt makes it work the way it should, so it looks like that means that frmEditUser is not getting the userID from the stlinkcriteria. Make sure that the userID name is correct (and the same) on your login form, in your stlinkcriteria...

In the onclick event of your unbound textbox launch your Medical History form with the following code: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmMedicalHistory" stLinkCriteria = "[PatientID]=" & "'" & Me![PatientID] & "'" DoCmd.OpenForm stDocName, , ...

Sounds to me like you need to open your database using the /wrkgrp switch and specify the mdw file that you must have altered when you were fiddling around with the database.

You should be able to do Me.NameofSubform.Requery Larry

I just looked at some of my code, and I was wrong in the above example. It should be ReQuery, not refresh. Larry

I'm not sure why it wouldn't be working Lisa. You need to replace 'Subform1' with the actual name of your subform, and ControlName with the actual name of your combo box that you wish to refresh. Have you tried coding the subform's OnCurrent with me.comboboxname.refresh? Larry

In the OnCurrent event of your main form try Me!Subform1.Form!ControlName.Refresh Let us know how it works. Larry

If you have a 'Login' button on your log in form, in it's onclick event code put DoCmd.OpenForm "frmMainPage" to open your first form, and Me.Visible = False to hide the login form. Then in the OnCurrent event of your main page form put Me.strUserName = Forms!frmLogIn!strUserName. Larry

I especially like using the background color change technique, then designing my forms borderless with the same color background. It looks like there is no 'form' on the screen, only controls. Larry

Make sure you are saving the record in the main form before opening the second window.

In the afterupdate event of the amount control you could do: Amt1=Amt1+(Amt1*.015) Larry

What you want is a 'Keyboard Wedge' type scanner. It inputs the numbers of the scanned barcode just as if they were typed on the keyboard. The ones with USB interface are very easy to set up on a Windows machine. Larry

Or how about: LetterGrade = "F" If Grade > 65 Then LetterGrade = "D" If Grade > 70 Then LetterGrade = "C" If Grade > 80 Then LetterGrade = "B" If Grade > 90 Then LetterGrade = "A" It's not fancy, but it will work. Larry