1. In combobox property in Bound Column you must enter 1, this number cant be 0
2. In tblHourlyRate you didn't enter any value, table is showing only default value. You must enter some value to table add "hourlyRateID" number.
hope this help.
Do You have allready calculated field?
If Your Label is called "lblDisplay", and calculated field is "txtfullname" than code is:
Private Sub Form_Current()
lblDisplay.Caption = txtfullname
End Sub
I dont understand what isnt working with Sendkey. I dont like this command but in your case this working perfectly. I dont have experiance with pagescrolling but when I create macros with Sendkeys command everything working ok. You need two macros, one for scroll down, one for scroll up.
hope...
try with this:
Private Sub Form_Current()
' If the number of records in the form
' is greater than 10, display the
' UpDownButtons
If Me.RecordsetClone.RecordCount > 10 Then
UpdownButtons.Visible = True
Else
UpdownButtons.Visible = False
End If
End Sub
This formula is working for me:
IIf(TABLE1!something Is Not Null;"T";IIf(TABLE1!something1 Is Not Null;"X";"XT"))
If you use a Form for criteria You must refresh forms data.
I working on Access about three years, also I create few complete projects (for friends and for sell) in Access. I like Access. But all time I thinking is it need and is it worth to move to VB.Net or similar enviroment. In near future I want to create more projects for sell.
I need Your...
You can put rectangle on a form with white backcolor, place it behin of all controls and on properties you can choose Display when: Print only
Hope this help
This code must be on Click event of button
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
I do something for you. If you want to filtering form, create these forms based on querys. There you can put criteria for filtering...
First you must learn naming conventions. Lots of name confusing on your prog.
Hope this help