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

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.

Thanks AlexMidd - I was tring to add a new record but the entry point was not being positioned to the bottom of the file (new entry).

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 ?

Hi Skipvought - Thanks for the code. I ran this but it made the machine names that were alphanumeric (DP1234)blank, and left the names that were numbers as is.

Thanks for your reply, pseale. The first field in record is a machine name. First we used a number for the name (1,35, etc.) Then we set up other names such as "p76b", "t33001", etc. (alphanumeric). In Excel this caused problems, so all these fields were reformatted text. Then when I attempted...

Thanks for replying, Aceman 1 -- The combo box is set up as a value list with two values, Day,Eve. Upon opening a form I thought a combo box was blank by default, but one of these values appears in the text box, and as above, when I tried to apply code to set it to blank or set the default to...