Recent content by infact

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...

Aceman1 - The recordsource of the form is a query I set up made up of two tables : Table 1 Table 2 id (access set this a key) id (access set this up) machine getmach serial getser date...

Alexmidd - I just checked the query and it is not editable. Thanks.

Aceman1 - The recordsource is the query that the form is based on. I did not include the primary key when pulling records off of the database with the query. Is this whay you mean?

To Alexmidd -Thanks for replying. I am pulling information off the database for a specified date using a query. The form is based on the query. When I tried to enter a change in this field (quantity) on the form, I can't enter anything. I created a text box, then bound it to this field. When I...

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...

Thanks for the reply, Programerror. I think I made an error in not being more specific in saying what I really wanted to do. Sorry. One of the fields on the form is pulled in from a table, which will have a value in it already from the table. What I want to do is make that field on the form...

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.

Before adding the code to populate all the date fields, I realized that I forgot to add one more field for inputting a number. I created a texbox for this, tested it by entering a value, hit enter, and all 30 fields down the column became populated with the first entry value. The value in this...

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.

HELP! It's still doing it. All the columns in the Excel file had the autofilter. I clicked to remove the check next to autofilter in DATA/AUTOFILTER. Could there possibly be some vba coding behind the scenes that forces this even though it apparently gets deactivated through the menu command ?

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.

Skip, I tried it again and it worked! Maybe I used a bad copy of the excel file. Thanks very much, again. This will be a big help.