Search results

I have an existing table that has a date entered field. The outcome of this task is to add the autonumber field in the sorted table according to the date entered field. The earliest date should have #1 as the autoNumber, not 906. So far I have not been successful ... Please help. Thanks,

Thanks! :D

I added a button "previous record". Whenever I click the button to go to the previous record(s), it only advances to the first previous record but will not continue. I don't have that problem with the "next record" button. Here's the code. What went wrong? Private Sub...

No. It was so easy, I didn't think to try it. It worked! Thanks!

How do I create bookmarks on an Access form, specifically not bookmarking a record, but bookmarking a title within a certain section on a form for easy access without using the scrollbar?

How do you create 2 forms (without using tabs) that is linked to the same record? Example, instead of creating 1 long form, I would like to create 2 forms, having a button that opens the 2nd form and staying on the same record that you were in on the 1st form. i.e. if I were on record #20 on...

Thanks! That was too easy. Easy as pie! I feel silly for asking ... ;\ Have a good one! ;))

How do I update the BE with a new table that I recently added? Should I unlink the FE and BE and re-split the db?

Thanks! ;)

Thanks. I am attemping to set a bookmark. I have already created a text field and made that field invisible.

How do I advance to the top of a form from within a form. I want to program a button at the bottom of the form to go to the very top of the form. Thanks,

In this situation, how do I cancel the Update event? I am checking to ensure that the county code, which is a 3 digit number with field properties of text is not a duplicate entry.

Thanks. I will try it and reply back.

Is it because of my single and double quotes?

I have the following code to validate data to ensure it's correctly keyed in and not a duplicate. I have keyed in the county code of 014 and I get a run-time error of 3464 - Data Mismatch. Why? Here's the code place in the "Before Update event: Dim MyVar As Variant Dim County_Exists As...

How do I get the form to automatically update certain fields that is pulling data from another table? I have cascading combo box in place whereby the user will select a State. The very next field is the County correlating to the State. Both the State and County pulldowns have a control source...

I figured out how to select the first item in the combo box by using the following code. Me![combotest].RowSource = "select county_nam from county where state = '" + Forms![EPL APPLICATION]![LOCATIONNAMECOMBOBOX].Column(7) + "'" + " and county_no = '" + Forms![EPL...

O.K. I changed the textbox to a combo box and added the following code: Me![combotest].RowSource = "select county_nam from county where state = 'MS' and county_no = '24';" Me![combotest].Requery The ComboBox now shows the name of the county, but I have to click on the downarrow to see the...

How do I assign the value of the following query to a text box? Me![Text543].ControlSource = "select county_nam from county where state = 'MS' and county_no = '24';" Me![Text543].Requery I am receivineg #NAME? in the textbox when the code above is executed. When try running the following code...

Ok ... thanks.