Search results for query: *

I have tried all the helpful suggestions to try to be able to update data in a form that I created from a query, but still get "Recordset not updateable". After poking around in the Security settings of Access, I noticed that under User and Group permissions, Database, table, query boxes are...

Hi. One of the fields that I am pulling into a form from a table has a value that changes daily. I need to be able to enter a new value each day for that field. How do I set up that field on the form to be able to enter a different value each time. I created a text box and bound it to the table...

Can a combo box bound to a table be set to blank to allow data entry in that field to update the table with the information entered into that combo box ? Thanks.

I set up a query using two tables (table1, table2). Since these are joined, can I get records off of table 1 by setting up a search criteria referencing a field in table 2 ? (Ex. if date in table1 equals getdate in table2). Thanks.

Is there a way to set up a text box with an accumulating total for a field ? Each time a value is entered into a field, that value is added to this total field ? (Like running total for Access reports) ? Thanks.

How do you clean up an excel file before importing it to avoid drop down boxes from autofilter from appearing in form. I don't seem to be able to clear this up. Thanks.

I imported an Excel file into table, ran query, ran form from query and the first field has a drop down box format. This must have been set up in the Excel file like this but doesn't show up in the table, only when I run the form. How can I remove this ? Thanks.

When I enter a new record through a form, it just updates the last record that has the same id#. I thought if you tabbed through the fields on form, and at end hit new record tab (*>) on bottom of form, that a new record (line) is entered into the table ?

I am new to Access. How do I add Me.ComboBoxName = "" to on Open event for a form ? This is to set a combo box to blank when form opens. Thanks.

While trying to import an Excel file with 20,000+ records into Access, I am getting an "unable to translate field" error message which references some of the values in the first field. This field supposedly was formatted as text, and can be either a one or two digit number or a combination of...

I have a combo box with a list of two values to select from. When I open the form the previous value that was selected is displayed in that field. How do you make this field be blank when opening the form ? Thanks.

On a form (tabular) that will list 30 records I have a date field with a drop down list to select a date to populate the field. The date will be the same for all 30 records, so is there a way to autofill or populate the rest of the fields with the selected date instead of having to do this 30...

We have a program at work to get daily meter counts, which is written in Excel. It is set up with 30 lines (30 machines) with fields to enter the meter count for each machine and this will update a data file with the info. I want to set up an Access application to do this as it will be easier to...