Search results

  1. L

    combo box

    Think about what you're asking. Modification of a record or data source works on any kind of form. A recordset is a recordset, regardless of the number of records.
  2. L

    combo box

    I've never had a problem with cascading combo boxes to multiple levels. When any combo box change occurs, on the cbo_AfterUpdate event requery each of the "lower" filtered ones. Furthermore, a record source or data source is a table, query or a SQL string, either can be modified dynamically. A...
  3. L

    Table Structure

    It takes a query for each week, not one query. As I previous indicated, this normalizes you data and is very fast to execute.
  4. L

    combo box

    The parts combo box should be filtered by the stone type value and should be requeried after stone type selection.
  5. L

    Table Structure

    It's not uncommon for Excel sheets to have non-normalized data which has to be restructed once imported into Access. Isn't it obvious that Excel is not a database tool but is better than Access in displaying data. Append queries are very very fast and are easily expensed sequntially with vba...
  6. L

    Table Structure

    Do not include all employee weekly time in one row, that violates a basic rule of database normalcy. Don't worry about query time unless you're doing it with ledger sheets and a pencil, it's insignificant. I've queried millions of Access rows in a very few seconds. Your queries will be...
  7. L

    Maximise datasheet subform

    The subform size is independent of the Main form header. Change the subform detail section height property. This assumes everything fits on one page. Alternatively, post a database with with form and subform.
  8. L

    Converting Julian Date to Standard

    A date is a date is a date. It ccan be displayed in whatever Format you want, regardless of how it's displayed. Note that Format is the operative function.
  9. L

    Table Structure

    Draw a scheme of related tables for what you want. Have a row for each employees work week. Pay particular attention to the one-to-many relationship required.
  10. L

    Looking for Help

    Am I assuming correctly that you're getting paid for this and want free help? Why don't you try asking a specific question?
  11. L

    Maximise datasheet subform

    In the form/subform design form, make the subform the desired size..
  12. L

    Maximise datasheet subform

    Size the submore, it can't be maximixed.
  13. L

    last records on continuous form

    Set a bookmark and use DAO "MovePrevious" to show several additional rows.
  14. L

    Question How to Process all Records in a Table?

    Both can be used.
  15. L

    Text not displaying in a textbox

    Can you post your database, maybe just the offending form and record source. Identify the offending textbox. Is there only one control on the form to enter or select data? What is the forms Cycle property? Had the Enter key been disabled?
  16. L

    Text not displaying in a textbox

    Is there code for the AfterUpdate event? Where's focus after enter is pressed?
  17. L

    Text not displaying in a textbox

    What happens when enter is pressed? Surely focus is set on the next control having a tab stop, regardless of what type control, maybe even a new record depending on the form cycle property. I've used Access 30years and have never seen this. Check the textbox_AfterUpdate event code of that form...
  18. L

    fonts

    I did it several years ago but forget how. That program is long gone. Keep looking. Take a look at this.
  19. L

    Can I use my shared drive

    If you can see the network drive and files with Windows Explorer, you should be able to use it to store your back end.
  20. L

    Question How to Process all Records in a Table?

    Run a query that has a function which does the email when appropriate.
Back
Top Bottom