Search results for 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)...

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

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

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

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

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

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

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

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