Search results for query: *

Attached are two shots of graphs created by VBA in MS Access. The one where the graph fills up the window was made in Access 2010, and is what you expect. The other is the same program running on a PC with Office 365 Professional, and the graph portion occupies only a small part of the graph...

Thank you, strongm. There is always something more to learn about Windows, and particularly about Access!

I have tried 0 right margin, one of 0.4: same problem. Tried making the text box much wider; that final italic number is still clipped. Also tried making the border solid: no effect. Currently I am working on a Lenovo P70 Windows 10 laptop. Looks like this is a problem which has existed for a...

Problem is with a simple standard text box on a form displaying a numeric field from a query. Problem occurs no matter the font size, nor whether bold or not bold is used, nor whether #,### formatting is used. I switched to "centering" instead of right-justification, and the clipping no longer...

See example where the right-most part of the zero is cut off. Using Microsoft 365 Access. Need to know how to make the entire number show up completely. Thanks.

Yes, ShowMsg is a subroutine that gives me more control over how a message looks. I have adopted the improvements you suggested, including the email idea. Thank you for the clear, well-organized info.

When a query fails in a program, the error info Access gives is not enough. I have to ask the user questions to zero in on what form or report was in use and what was being done when the failure happened, before I even know which query we are talking about. Below is my attempt to deal with this...

dhookum, it doesn't matter which file I am working with. Apparently this is not that uncommon. I found the advice to hit the Insert key during an internet search. I am content and consider the matter closed. Thank you for your input on this.

I finally found the answer. Here are the steps: 1. Select the column where you want to insert a new column. 2. Click on the "Insert Columns" on the design ribbon. 3. This is the kicker: Now hit the "Insert" key on your KEYBOARD! This works. In no other version of Access have I been required to...

dhookom, I also see "Insert Columns" on the design ribbon. It just doesn't work. strongm, I had already put the Insert Columns icon on the Quick Access toolbar. It does not work either. It is also interesting that when I click on "Insert Columns" on the design ribbon, it gets greyed out, as if...

In previous versions, if I wanted to add additional columns to the query design grid, I would highlight as many columns as I wanted to be added, then would click Insert Columns at the top of the screen. This does not work in version 2016. I don't know why Microsoft has not corrected this yet...

Thank you, StrongM. That is cool. I like elegance! I agree that it is scary, TheAceMan1. I immediately started rummaging around in several other programs I have written to see if I had depended on this in other cases. I don't often program buttons in this way, but I like it for shop-floor use...

I am using Access 2010. I have a form with two buttons, btnHigh and btnLow. If the user clicks btnHigh, the font is made bold, and the other button is set to not bold. btnHigh.FontBold = True btnLow.FontBold = False Then in my code I use this line: If btnHigh.FontBold = True Then...

Thank you JoeAtWork. This was more than just wanting to know if there were any records or not. My query actually had records but I wasn't seeing them with the ADO approach. That is what didn't make any sense. In subsequent lines of code, I wanted to do something with each record returned by the...

Thanks for the interesting reference. The table my query was built on was obtained by copying a linked ODBC table at work, and choosing the option to paste all the data into a local table so I could bring the data home. I had never made such a copy before because that option had not been...

The returning of 0 records does not produce an error. The RecordCount is simply 0. The code takes that and moves on. Here are a few more lines of the code, which I maybe should have included: 'GetShippingData: rstADO.Open "qryTexShipped", cnn, adOpenStatic, adLockOptimistic, adCmdTableDirect...

Thank you. I did not try AbsolutePosition, but I did try the rstADO.MoveLast. It gives the usual EOF/BOF error you get when there are no records. What is so frustrating is that I have used this same kind of code many times. I even re-booted my laptop in case Access had become "confused" but...

I have a query (qryTexShipped) with a Criteria (#3/16/2012#) for a date field, and a Criteria (Like "CM*") for a text field. I run the query directly and see 11 records. But in my VBA code when I try what you see listed below, the RecordCount is 0. I have done this sort of thing, successfully...

Thank you RoyVidar. I had just this moment switched to dbOpenDynaset with good success. Problem solved!

I have an Access 2003 database. Behind one form I have this code Dim D As Database Dim t As Recordset . . Set D = CurrentDb Set t = D.OpenRecordset("tblInv", dbOpenTable) Reference is: Microsoft DAO 3.6 Object Library This works fine when tblInv is actually part of the database. But when I...