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 Rhinorhino 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: *

  • Users: svdoerga
  • Content: Threads
  • Order by date
  1. svdoerga

    Help with query

    I have a form to view data summaries. Using controls, where the user inputs 'from' and 'to' dates, a query is generated to retrieve data and display it on a subform in datasheet view. The table I'm retrieving data from looks like this: Receivement(ReceivementID(PK,autoinc nr)...
  2. svdoerga

    UK vs EU date mixup, textbox->query->subform recordsource

    On my form I have two textboxes where the user can enter a 'From' and a 'To' date. A query is then created that returns records between these dates. The result is displayed in a subform, by setting the subforms recordsource to the query like this...
  3. svdoerga

    changing subform recordsource from main form

    I am creating a form to view certain data summaries of my database. I have started out with the form having controls where the user specifies 4 values. These 4 values are then used to create a query when the user presses a button. So far the data is only retrieved from a query called...
  4. svdoerga

    prevent field emptying when escape is pressed, access 2007

    I have a datasheet form (viewing only) that has a buttons to edit or add records. When you click the add record button, a new form will open and one of the fields (a field that needs consecutive numbering) is filled in from code using DMax("[field]", "table") + 1 The textbox for this field is...
  5. svdoerga

    How to enforce field inter-dependant validation rules?

    I'm making an access database to track returned goods, Access 2007. one of the tables is like this (simplified): Item(ItemID, SerialNr, Quantity, Description) All kinds of items are returned, some have serial numbers and some don't (stuff like screws, plastic encasings, etc). When an item has...
  6. svdoerga

    calculate checkbox value by checkboxes in linked table

    Simplified, my tables are: Receivement(ReceivementID(PK, autonr), CaseClosed(checkbox)) Item(ItemID(PK, autonr), ReceivementID(FK,nr), Finished(checkbox)) So each receivement has multiple items. When the "Finished" field is checked for all the items a receivement has, the "CaseClosed" checkbox...
  7. svdoerga

    docmd.close ignores validation rules?

    Hi guys, I have a split form that only shows records, no edits, adds, or deletions. On the form I have a button "edit", to edit the selected record. It opens a popup form in dialog mode. The popped up form has a "save" and a "cancel" button. The way I need this to work is that no changes should...
  8. svdoerga

    how to link files to records without using attachments?

    I have a database where I want to add pdf files to each record. Should be 3 pdf files (scanned documents) per record on average. So far I have found 2 ways of handling attachments: - Using linked OLE objects - The access 2007 attachment feature The application will reach more than thousand...
  9. svdoerga

    conditional formatting split form datasheet not working

    I am trying to get certain rows in the datasheet view to get a green highlight, depending on a checkbox. Working with access 2007 In design view I select all the textboxes and set condition 1 of the the conditional formatting with a different font and cell color and "expression is" like this...

Part and Inventory Search

Back
Top