Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. N2Life

    Graph too small in Office 365 Access

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

    Last figure in a text box is partially cut off when conditionally formatted as italics

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

    Last figure in a text box is partially cut off when conditionally formatted as italics

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

    Last figure in a text box is partially cut off when conditionally formatted as italics

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

    Last figure in a text box is partially cut off when conditionally formatted as italics

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

    Better error info when query fails in VBA behind a form or report

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

    Better error info when query fails in VBA behind a form or report

    ...'--------------------------------------------------------------------------- strsql = "INSERT INTO tblInboundHistoryXXX SELECT tblInbound.* FROM " & _ "tblInbound WHERE LeftUSA<(Date()-2)" If Run_SQL(strsql) = False Then GoSub ERROR_MSG_SQL End If...
  8. N2Life

    Microsoft Access 2016 Insert Columns while using Query Design

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

    Microsoft Access 2016 Insert Columns while using Query Design

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

    Microsoft Access 2016 Insert Columns while using Query Design

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

    Microsoft Access 2016 Insert Columns while using Query Design

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

    FontBold not equal to TRUE

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

    FontBold not equal to TRUE

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

    rstADO.RecordCount returns wrong count

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

    rstADO.RecordCount returns wrong count

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

    rstADO.RecordCount returns wrong count

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

    rstADO.RecordCount returns wrong count

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

    rstADO.RecordCount returns wrong count

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

    Error setting a recordset in a linked table using DAO

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

    Error setting a recordset in a linked table using DAO

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

Part and Inventory Search

Back
Top