Search results

I doubt the base set can be modified. Why is this needed? Do you want to limit user's color choices to a defined set? How many colors? After a certain point, can't avoid getting colors that look close in hue. If users want unlimited choices then they should be willing to learn the tool. If...

By "access runtime" you mean clients do not have full Access program, just Runtime? Are they running an accdb frontend? You say it "works perfectly in access" - so you mean on your PC with full Access program? Are you actually changing password in this case?

Cross-post https://stackoverflow.com/questions/79634165/how-do-i-use-vba-to-save-the-layout-of-a-subform-query-on-an-access-form

Not quite sure what you are asking for here. A combobox would be bound to field so a selection would automatically populate field of record. If a user needs to enter an item that does not yet exist in tblPropertyTypeAttributes, would require code to allow them to input "on the fly" during data...

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