Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. infact

    Security settings in Access

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

    Set bound field to blank

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

    Set bound field to blank

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

    Set bound field to blank

    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?
  5. infact

    Set bound field to blank

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

    Set bound field to blank

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

    Set combo box bound to table blank

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

    Set combo box bound to table blank

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

    Search criteria in a query

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

    Populate remaining fields in column

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

    Set up accumulating total on form

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

    Clean up excel file before importing

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

    Importing Excel file to table

    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 ?
  14. infact

    Importing Excel file to table

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

    Importing an Excel data file

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

    How do you enter a new record in table

    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).
  17. infact

    How do you enter a new record in table

    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 ?
  18. infact

    Importing an Excel data file

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

    Importing an Excel data file

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

    Combo Box Set to Blank on Open

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

Part and Inventory Search

Back
Top