Search results

Need a form/subform arrangement. Main form bound to tblProperty Subform bound to tblPropertyAttributes with a combobox using tblPropertyTypeAttributes as its RowSource This is essentially a many-to-many relationship where tblPropertyAttributes is a "junction" table that associates properties...

As I said, I did change the extension and it won't open, says file is corrupted. Attach the file in a Zip folder. Use Windows Compression. Could have included all those files in one Zip folder.

Build an aggregate query. This is basic Access functionality. Have you studied an introductory tutorial? File in post2 won't open, not even if I change extension.

Consider using a Toggle button instead. In either case, consider code to change button Caption property as well.

Use True and False instead of Yes and No. True is an intrinsic constant with value of -1 (False is 0). The reason it sets only to not visible is because ANYTHING that is not True (-1) is treated as False and that includes "Yes". I know, the property in design shows Yes or No but code expects...

Do you want to count how many distinct tickets or how many records for each ticket? For the first, consider a nested query like: SELECT Count(*) AS CntTick FROM (SELECT DISTINCT IDTicket FROM tablename WHERE Status = 1) AS Q1; For the latter, don't include ID. Post your actual SQL statement.

You said this is a field, are you viewing a table or a form? Need to use a form so you can control this. Is form in Single or Continuous or Datasheet view? Pat's solution may be simplest but if you really don't want to always show the archived values in list, here is another approach...

I don't see an icon in upper left. All I see, very briefly, is an "in progress" popup with Cancel button. But output is so quick there is no opportunity to even click Cancel if I wanted to.

Review https://www.accessforums.net/showthread.php?t=65686 and https://www.accessforums.net/showthread.php?t=73766

Can force Excel to recognize Nz() by setting a VBA Editor reference to Microsoft Access x.x Object Library. Your expression using IIf: Sum(IIf([Amount] Is Null, 0, [Amount]))

Why would multiple fields hold same data? Want to provide sample data and desired result? Attach file or build tables in post. Why were you concatenating field references in original code? Boolean constants should never be within text delimiters as they are numeric and field actually contains...

Doc, I tested a form with an UNBOUND textbox named same as a field in RecordSource. Following code both returned value from textbox: Debug.Print Me.Test1 Debug.Print Me!Test1 When there was no control by that name, same code returned value from field.

Yes, the entire suite of apps installed. Best purchase deal I ever made.

With my Office 2021 Pro Plus, I wasn't given option to not install. After install, when I opened Outlook the New version opened and there was a clickable prompt in upper right corner to "Switch to Classic". Both apps are still listed but now Classic is default.

That video is showing MS Office Professional Plus 2021. As I said, I already installed 2021 for one PC and it is fine, Outlook Classic works. It was a cheap 3rd-party purchase and can't install on a second PC. My second PC still has Office 2010 and that Outlook is basically dead. My attempt to...

Every time I click Install, it fails and advises "We couldn't install this product. Wait a bit and try again". So I just installed O365 and Outlook Classic app shows along with Outlook New. Opening Classic tells me this is a trial and I have to buy O365 subscription to continue. For my other PC...

Yes, that is the download/install I attempted. The MS Store download doesn't work. The other download is for Office 365 I don't want.

When I installed Office 2021 I had option for Outlook to switch to Classic. New and Classic both show in list of apps. Classic is my default mail app. Even if it isn't, Classic should be there for the CDO code to work with. I have read recent discussions that MS no longer includes Classic with...

On the PC I just checked, upgrade wiped away everything, like an original install. This was my first go at upgrade. Still no sign of Bitlocker after restart. The other PC I chose option to not wipe apps or user settings. I will now have to go check out these settings on that one.

No sign of CoPilot on this PC. gpedit.msc errors "can't find". As for all the other Settings, either I don't find or they are Off. Tried the Bitlocker procedure but it does not show in System and Security. Maybe I need to restart computer.