Search results

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.

I think you try to update query which isnt updatable. Maybe your query is summarized or crosstab query.

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

You cant linked label to a field, but you can put this code On Current event of form YouLabel.Caption = [YourCalculatedField]

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

I have the same problem. Any help?

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

check this link http://www.mvps.org/access/forms/frm0045.htm

Is controls on your forms bound or not? Did you try to add several records and navigate through the records?

Try to add records on that query. If want post database tossoltic@gmail.com I can check whats wrong.

Its not nessesery for subforms to be linked.

Check data type of your Row and Control sources in comboboxes. Combobox show one data but proces another data. I mean if Control source is some_ID and Row source is "someName" based on query or value list, combobox display "someName" but carrying value is some_ID. hope this help.

I dont now for Access 2000, but in Access 2002 and 2003 this option is avaible. Maybe You search on wrong place. When you are in Design view, click on properties (not Format on Menu bar), You have a 5 tabs: Format, Data, Event; Other and All. On Format go to the bottom there you must have a...

Select Design view, select Properties click on Event tab, here you can find On Close event.

Did you try with: If strZipLookup = Null Then...