Search results

You could include your own interface for validating and refreshing the links. The attached zip archive includes two files which illustrate this, one being the front end, the other the back end. The routines in the front end in this case are designed to work with multiple Access back ends...

As others have said, doesn’t this simply require an unbound parent form in which are placed three bound subforms? The image below is of a simple example from one of my online demo files. In this case the parent from is bound, and the subforms' RecordSource properties are three different...

One caveat, which applies to any query, not just crosstabs, if the following syntax is being used to make a parameter optional: WHERE (somefield = Forms!myform!myfield OR Forms!myform!myfield IS NULL) the parameter should be declared, if anything, as a Variant data type. Otherwise it can...

The Product_tbl table should be decomposed by moving the Product_ID, Product_Name and Product_Material columns to distinct rows in a referenced table, ProductType_tbl say, in which Product_ID will be the primary key. The Product_ID column in Product_tbl should be retained as a foreign key, and...

The OP refers to a Quantity column, so if each individual physical item has a distinct serial number, then these would need to be in a column in a separate referencing table. If the serial numbers are sequential per product, it would be a simple task to generate the numbers and insert the...

The file attached to your post is a .pdf file with the error messages you've received. These don't tell us a lot I'm afraid. What we really need is a copy of your .accdb file, with any personal or otherwise sensitive data removed or disguised. We'd then be able to debug the file.

One way would be to open an unbound dialogue form containing a multi-select list box in which the products to be added to stock can be selected, with the following or similar as its RowSource property SELECT Products.ProductID, Products.Product FROM Products ORDER BY Product...

There are various ways you can control whether to use the acPrintPreview Constant for the OpenReport method's View argument, e.g. a check box or option group on the calling form, on the value of which you can conditionally execute the appropriate code. Simplest of all is to have separate Print...

If you put the controls in the page footer you can show them only on the final page with code like this in the page footer's Format event procedure: Dim blnShowControl as Boolean blnShowControl = (Page = Pages) Me.txtName.Visible = blnShowControl Me.txtSignature.Visible = blnShowControl...

Quite what unbroken serial numbering of rows achieves is hard to see, a primary key need have no semantic significance and need only be distinct, but it is a not uncommon requirement, and in my line of work it is a legal requirement in some quasi judicial contexts. The many solutions put...

The attached demo file illustrates how to print a variable number of labels starting at a selected position on the sheet. The report's query is: PARAMETERS Forms!frmlabelsDlg!optStartAt SHORT, Forms!frmlabelsDlg!txtNumberToprint SHORT; SELECT...

A distinction needs to be drawn between a record's having been updated and the values of data in the record having actually been changed. The former can occur without the latter. The following modules detect the latter in a bound form. ' module basRecordWillChange ' determines if data in a...

As it stands the query would return not only rows on the final day of the range, but also any rows on the next day where the date/time column's time of day element zero.

I'm rather concerned about the structure of your tblConcernFormSubmissions table. You have as its primary key a ConcernID column, which I'm guessing is an autonumber. That's fine as the table models the Concerns entity type. However, you also have a UserID non-key column, along with...

A set has no intrinsic order. When we talk of the next record we are usually referring to the next record in the current sort order, which we can do here because that's what we want, regardless of what that sort order might be. However in another context we might want to go to a record in a...

As far as determining which is the row to navigate to following the Requery the sort order enables you to determine this independently of the datasheet per se. The expression for the DMin function call to encompass all of the columns you've used would be tricky though. A simpler way...

If you try the expression in my demo, which I attached to post #6, you should see how it works. Hopefully you'd then be able to reproduce it in your file. To use the functions just copy and paste the entire basDateTimeStuff module into your file.

It would help greatly if there were a column or combination of columns which determines the sort order of the rows returned in the form. I can't see any obvious candidate, so let's assume therefore that the table includes a column SortColumn of Long Integer data type by which the form's query...

Shouldn't that be: >=[forms]![mainform![Fr_date] And <([forms]![mainform]![To_date]+1) i.e. on or later than the start date and on or before the end date?

I use the following module to determine whether the data in a record has or will actually change, rather than merely be updated: ' module basChangedRecord ' determines if data in a record edited ' in a form has actually been changed Option Compare Database Option Explicit ' arrays for...