Search results

  1. J

    Solved Unable to update field values on form (despite having properties set appropriately?)

    Hi folks, Running into a maddeningly inconsistent issue with a form. It's a Single Form, recordsource is a basic select query that prompts for the ID of the record. AllowInsertions, AllowEdits, AllowDeletions are all set to true. There are no record locks, the recordset type is "Dynaset" for...
  2. J

    Forcing sequential flow of data entry from top to bottom of a form

    Hi folks, Hoping that like always you fine folks can help me figure this out. I'm trying to set up a form (basic, bound single form used for both entering new data and updating existing records) where only the top control is enabled to begin with, and each control below this is only enabled...
  3. J

    "Inherit Value List", "Allow Value List Edits", and "List Items Edit Form" Properties

    Hi all, For a combobox set to a table/query for the rowsource, do the "Allow Value List Edits" and "List Items Edit Form" properties have any effect? I have a combobox with a table as the rowsource, and somehow, the underlying table was edited, seemingly through the combobox in some way? The...
  4. J

    Dynamically adjusting the size of a subform based on if the scrollbar is shown or not

    Hello all, I have a subform which may display anywhere from 1 to n records--when n < ~15, there is no vertical scrollbar on the right side. If I set the width of the subform control to precisely the width of the underlying form, I end up with an awkward 255 twip side-to-side horizontal...
  5. J

    Solved Combo box dropdown width

    Hi all, Is there a way to make the dropdown width on a combobox wider than the width of the control itself? I'm not referring to the column widths--it seems like if you set them wider than the control width, you end up with a scroll bar on the bottom of the dropdown. I'd like for the dropdown...
  6. J

    Preserving the ability to input data while using DLookup on a continuous form

    Hello all, I have a form used to select various employee and process training records. One half of the bottom of the form is a subform displaying the trainings that we "think" should be needed. It uses a complicated query to link employee names and job titles with what training we already have...
  7. J

    Formatting column widths and captions/column headings on a datasheet view subform

    Hello all, Trying to figure out how to configure two parts of a subform that I'm displaying in datasheet view--making the column widths persistent, and customizing the column names as they appear on the datasheet. The recordsource is a query that's an amalgam of various joins from several...
  8. J

    Solved "Multi-level GROUP BY clause is not allowed in a subquery"

    Hi all, Any idea why I get this error when I go to create a report off of the query in question, but the query otherwise runs fine (ie, I can hit "run", and look at the datasheet view of the query, no error. Base a report off of that query, go to run the report, above error. Copy the query...
  9. J

    Bizarre and Inconsistent Error in an Aggregate Query

    Hello all, Wanted to share something that I'm running into in the hopes that one of our experts has run into it before. I had seen inconsistent result sets out of a query I've been tweaking today. Sometimes 3640 results, sometimes 247520 results. Those are precise numbers, and I can't figure...
  10. J

    Nested Aggregation

    Hi all, Sorry for the lack of a descriptive title. I'm trying to associate revision levels of SOPs with historical training records (ie, someone trained on SOP-001 on 1/1/2020 was trained to Revision 3, because Revision 3 is dated 12/31/2020, and Revision 4 is dated 1/2/2020). So I need to...
  11. J

    Aligning a rectangle control with Layout gridlines

    Hello all, I've been so impressed with all the assistance you kind folks have offered me over the last couple weeks, so I'm back with another question. I have a form set up for data entry, continuous form with a header. One of the fields is a Yes/No checkbox. As I'm sure you've all seen...
  12. J

    Triggering an event after an aborted/stopped query execution

    Hello all, I have a command button that's used to trigger a macro that opens an "insert" query. However, it's possible for the user to click the button, then hit the cancel option on the default warning that appears when executing this type of query. I like the warning behavior, so I don't...
  13. J

    Solved Validation Rule to ensure that an entered value is a date

    Hello all, I am trying to make sure that the entered value in my form is a date. I've avoided using an input mask because I don't like the UI problems inherent with those--gotta enter dates with 4 OR 2 digit years, but not both, for example. Is there a way to retain that sort of flexibility...
  14. J

    Double Click a Record Selector to add that record to a table

    Hi all, Brand new to the forum but here because I was working on a highly similar situation. Interestingly, the database I'm working on uses the DblClick event to do exactly what OP is describing: shunt the selected record into another table. The overall purpose is displaying a list of staff...
Top Bottom