Search results

As I understand your question, what you want is the difference between the next to last quantity for each product and the last quantity for each product. You example assumes that there's always at least 2 rows for each product. In reality, that may not be the case for inventory, that is...

I've used Access, all versions, since Access first came out and have learned that there's a numbers of reasons to use Macros within Access. VBA coding is very simple, easy to learn, and very powerful. Complex macros are very difficult to debug and understand after they've been coded and...

Filter the form record source with the "status" combo box name. Note that the full form reference is required, not a Me reference, i.e. Forms!YourFormName!YourComboBoxName

I repeat, once the report is created it cannot be changed. Hiding or displaying something is a change.

Once a report is opened it cannot be modified. The only time a report can be modified is on the "OnFormat" event, that is, when it is being formatted (built). Buttons don't work on reports.

Thank you, I'll give you suggestion a try.

I using Access 2010 (Enterprise) on Windows 7 Enterprise PC. In the course of executing VBA code, I open an Excel workbook in Access using Dim xlAPP As Excel.Application Dim wKb As Excel.Workbook Dim sNewxlsx = {a valid path and "xlsx" file} Set xlAPP = New Excel.Application...

I have complex A13 reports each of which has multiple complex subreports whose various control properties are programmatically modified in the report's design view and then closed along with the report itself immediately prior to a report is opened in "preview" mode. Why? The various subreports...

All VBA code is not lost. Create a blank database, then import all objects from your "corrupted" database. Be careful of the options, there's one which you have to import. Off the top of my head, I forget which but it's obvious. Someone posted in this stri9ng that all code is lost. That's not...

I copied and pasted the controls manual to the header and detail, then wrote a little subroutine to adjust 22 diferent control properties to meet my requirements. T Thank you all for your various responses.

I have 10 complex A10 reports which originated from forms which now need to be converted back to forms. The new header & detail section controls, control spacing, sizing, borders, top, height, width, etc. of the various controls are needed in forms. I could save the various properties of each...

I stumbled onto it researching "securing a multi-user Access BE."

Yes, provided the path of the BE is the same. Note that an encrypted BE is significantly slower for multiple users. A non-encrypted BE utilizes row locking, while encrypted BEs utilize page locking.

A afterupdate or A notinlist A afteteupdate; Requery B; B afterupdate or B notinlist By afterupdate;

Set the "Visible" property on the datasheet columns you with to hide to False or No. Visible, or not, those controls will be saved appropriately.

<6 is a string, 1,2,3,... are numeric. I presume the combo box is a text control. What is the data type of the column being filtered? Something like this might work, using 1,2,3,4,5,6 as combo box values (assuming your column is numeric), the the filter would be iif( [properly reference combo...

Create the following column in your query: State_Date: {Query_Column_Name) + 77

What is an index going to do for you? Do you mean a unique index?

Put a combo box control on the form with its data source being all the invoice numbers (in numerical/alphabetical order) for the instant Supplier or whatever drives the main form. Pick an invoice number in that combo box then set the subform "Filter" property to "[Invoice Number] ='" &...

In a form footer.