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

    field visibility in MSAccess Form

    Thanks dhookom, Yes it is continuous forms. I display 5 fields per record which are yes/no boxes (disciplines B,E,F,M,P). I use these to change status of each field on each record. However, not all records utilize all five fields (second field not displayed is an 'active' field, one for each...
  2. gimpie1941

    field visibility in MSAccess Form

    I need to change the visibility of a field in a Form Detail section based on the value of another field in the same record. Therefore, some records will display all fields, while some will only display a few fields, based upon the value of one field. The problem I have is that if one record...
  3. gimpie1941

    getting table data

    Thank you, AceMan.. That is exactly what I was looking for. Hope I can contribute someday. Jim
  4. gimpie1941

    getting table data

    Yes, I can do a Docmd.runsql to get the data, but I then need to put the data into a public variable. If I run a Docmd.runsql "select" how do I put the result into a variable? Jim SOrry for appearing stupid, but this is vexing...
  5. gimpie1941

    getting table data

    I need to extract a selected record from a table (not source in form) and extract a field value which I want to set equal to a public variable. any help? Thanks Jim
  6. gimpie1941

    MSAccess table too large!

    I have a MSAccess97 database with over 500,000 records (yes, a half million) and it 'crawls'.! How can I convert the table to SQL table and still use the MSAccess frontend? I have 50 or so forms, 30 odd queries and over 50 reports. There are macros and visual basic code imbedded in the forms...

Part and Inventory Search

Back
Top