Search results

The function requires input for 4 arguments. You provide only 2 then you throw in AND ... . This makes no sense. Look at Isaac's example again.

VBA code goes in a VBA module, not in a query. Do you know how to open the VBA editor? VBA code can be behind forms and reports or in independent modules. I expect the code you reference needs to be in an independent module. An expression in query can call a VBA Function procedure (not a VBA...

Some Options: 1) pass calling form name to frmArticoliCerca with OpenArgs 2) pass other info to frmArticoliCerca with OpenArgs 3) calling forms set global variables or TempVars that are available anywhere

Hard to say. What do you already know about programming? Ever programmed in any language? The basic concepts are transferrable. Start with review of https://support.microsoft.com/en-us/office/introduction-to-access-programming-92eb616b-3204-4121-9277-70649e33be4f It's considered good etiquette...

Rearranging data from horizontal to vertical is a red flag that data is not normalized. But as long as you have it handled and solution works, call it done.

If you want to get this resolved, really need to provide file - follow instructions at bottom of my post. That way we can design and test with your schema.

I did suggest saving the discount % was an option. Would be interesting to know how retail store programs document discounts: member and sale discounts on specific products, mfr coupon, then maybe a discount off the entire purchase. I expect a record for each.

I don't see need to save SellingPrice to Products table. It can be calculated when needed. Only reason to save in OrderDetails is if the percentage can vary over time. In which case, maybe the percentage should be saved, not the calculated result. This is the same justification for saving...

Don't see how your original expressions could work. They really make no sense. Looking at one: IIf([tblEmployees].[Marital Status]=1,[tblEmployees].[Basic Salary]<[tblpayrolltaxes].[Lower],[tblpayrolltaxes].[Amount from Column A]-[Exemption credit]) What that does is if Status = 1 then the...

Transpose from horizontal to vertical in Access would be a UNION query. Looping recordset is really inefficient. Might want to explore CopyFromRecordset method. Or look at TransferSpreadsheet method again. And there is OutputTo method. Review https://accessmvp.com/KDSnell/EXCEL_MainPage.htm...

Could provide sample data and desired output as tables in post. Also, show the two working expressions.

Don't necessarily have to re-enable just to do edits. Depends on what other customization you implement. Have you employed a modified ribbon? Have you disabled right click shortcut menus? Do you hide Navigation Pane? Disable function keys? If you can still go to the VBA Editor, you can do...

Those instructions are for an ADP which hasn't been supported since Access 2003. Refer to https://learn.microsoft.com/en-us/office/troubleshoot/access/disable-database-startup-options

Subform is a form in Datasheet view. Doesn't matter, form will not reflect font setting. If a table or query is used as SourceObject, font setting will work.

Where is that code supposed to be? I don't find it in posted db. Code makes no sense anyway. Should Sigend_Form really be spelled Signed_Form?

"context"

Sorry, I deleted my earlier post. Thought I did it quick enough no one would notice. Testing again and don't know why I thought it was working. I did close and reopen form for testing code. However, seems MajP has hit the nail. I am using A2021.

Change listbox loop to Dim varItem As Variant ... For Each varItem In .ItemsSelected If Not IsNull(varItem) Then ' strFilter = strFilter & " " & i & ":" & .ItemData(i) strIN = strIN &...

Nope. Could OutputTo separate Excel workbooks then combine them with Outlook automation. Otherwise, use TransferSpreadsheet to export multiple filtered queries to same workbook. Review https://accessmvp.com/KDSnell/EXCEL_Export.htm

That does not show the dtmCreation field. If you want to provide db for analysis, follow instructions at bottom of my post.