Search results

I used the sample file you posted. Try changing your default printer and see if the new printer also cuts your print size. It is set for no scaling.

I tried opening two workbooks side by side and I dragged the test worksheet to the new workbook using Excel 2021 and 2016, still, print size was preserved. To discard the printer being the culprit, switch your default printer and see if that produces the same behavior on your end.

I am unable to reproduce the behavior in either Excel 2016 or Excel 2021. Maybe it's a 365 thing, but any copy I make preserves the print size. When I copy a worksheet I use only these methods: If the copy must remain in the same workbook, I either Ctrl+Drag or use the Move or Copy option of...

No idea why Access doesn't like the link, but you can try a different approach to open it Change FollowHyperlink "https://www8.tax.ny.gov/PRIS/prisStart" with this Shell "explorer " & "https://www8.tax.ny.gov/PRIS/prisStart" or maybe this Shell "cmd /c start " &...

I'm a human being and even I have problems understanding the intent of this. Is this some sort of puzzle? This is confusing as heck, you have the result of each student in the class, but is it per subject? or just the total? is it a number? is it a letter? do you have the number of questions...

If the textbox serves no other purpose but to let the user click it, I'd remove the textbox and just make a button with a "View Customer" caption, on the on click event of this button, I'd include the URL and concatenate customer Id there like FollowHyperlink...

I'm going to be perceived as pedantic but table fields don't have on click events. Sorry about this minor detail, I know you're referring to a control, not a field. Anyway, what type of control are you referring to? Are you using a hyperlink label, a textbox, a textbox with a button or...

Do you have a sample database you can upload where Me! makes a combobox dropdown but Me. does not?

Very well, I just checked a bunch of variations and the result of my testing indicates that You can avoid bangs in queries too. This is the syntax: Forms.MyFormName.Form.MyControlName If ControlName is in a subform, same applies: Forms.MyFormName.Form.MySubFormControlName.Form.MyControlName...

@MajP Allow me to clarify. In post #4, @cheekybuddha mentioned this: Which I interpreted as "bangs must be used in expressions". So I replied with a test database that uses dots, instead of bangs in expressions. I do not have all versions of Access, so I can not know if what I'm saying is...

I am sorry that I wasn't clear enough that I want to demonstrate that dot notation can be used to avoid the bangs. The added point I am now investigating is why some properties can be accessed and others not. For instance: this works Application.CurrentObjectType this works Application.Name...

Yes, I absolutely want you to write any dot notation there and validate that the bang is not mandatory there. And this is not dot notation.

Dot notation can be used in expressions. It would be nice to know if your version does not allow it, but in 2016 it does let me access all form properties that I tested using dot notation. To all readers: Please download the attached database file and check if it works in your Access version...

Hi, John. Thanks for the tip. However, the dropdown method requires you to set focus to the combo box before calling it. Using dot notation and bang notation should not be important for this. However, you should not forget that when a field in your table has the same name as a control in your...

I think I'm missing the filters key, try any of these: https://api.procore.com/rest/v1.0/projects/999111/rfis/filters[created_at]="2023-05-15T12:00:00Z...2023-05-29T12:00:00Z" https://api.procore.com/rest/v1.0/projects/999111/rfis/filters[created_at]=2023-05-15T12:00:00Z...2023-05-29T12:00:00Z...

I modified your date range, from may 15 - may 15 to may 15 - may 29

I didn't know you could do that, thanks for letting me know. My setup for this kind of work would include the VBA-JSON module found on github, using dictionaries to first create the object then convert it to JSON, that way my code looks better and I don't have to deal with so much string...

Tried in Access 2016 and 2021, no PDF option for that. Maybe that's a 365 thing or some plugin you installed.

I can't/won't list all of the methods to break into an Access database. Just know that anything you try will be hackable with relative ease.

To be fair, if that database is sent to users who don't know anything about Access, implementing a validation of this kind will have some effect, a very small one, but it's OK to try. It will be bypassed easily with the simple holding of the shift key as the file opens, among so many other ways...