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

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.

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

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

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

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

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

Was browsing this forum this morning and came across thread68-1302164, which is now closed. I had also been looking for a way to automatically shrink-to-fit PrintScreen shots that I put into Powerpoint. Could not locate any built-in feature to do that, so wrote VBA code to take care of it: Sub...

I ordered a copy of Office Pro Edition 2003. Have not taken wrapper off yet, but am suspicious. There are 2 misspellings on the back of the box: 1. Exchange daga with other systems... (daga instead of data) 2. Helps keep your e-mail in box less cluttered and you PC safer... (you instead of...

Does anybody have any experience with linking to data in TimeForce (timecards software from Qqest), either for Excel or for Access? Thanks.

I have an Access program that displays some data and a graph on a form. On an ordinary monitor, the graph displays perfectly. But when I use one of these new-fangled wide-screen monitors, only the left portion of the graph appears. The rest of the form is completely normal. Have played around...

Why does the second line of the code shown below produce an error in Excel 2007 and not in Excel 2003? The error is: Run Time Error ‘1004’, Unable to set the Text Property of the Characters class ActiveSheet.Shapes("btnJobSummary").Select Selection.Characters.Text = "Prepare Job Summary" &...

My form stores multiple records of payment against an invoice. TablePayment should always have at least 1 record for each invoice. This record has a field containing the InvoiceNumber, and other fields to be filled in at the time of a payment. User is able to delete payments in case of error...

From Windows XP Professional, I opened an Access 2000 database today that opened yesterday with no problem. Today I get this message: Run-time error '2455': You entered an expression that has an invalid reference to the property CommitOnNavigation I have never heard of CommitOnNavigation. I...

Database A contains a link to a table in Database B. This link is, of course, valid even if Database B is closed. Is there a way in VBA code within Database A to check if Database B is indeed open? I am using Windows XP, Access 2000. Something like: Function...

I needed this function to determine a date that was a certain number of work days in the past. It also handles future dates. This may save a fellow Access user some time. Public Function WorkDate(StartingDate As Date, DaysDiff As Integer) As Date ' This function is concerned only with work...

Reference thread181-821399. A similar question was posted in Nov of 2004, with no responses. I am using Windows XP, Access 2000. I have a graph (chart) on a form. There is a combo-box in which you select what series to graph. Doing so should cause the title of the graph to change, as well...

Imagine a form with a combobox at the top which displays some names and has ID numbers that are not displayed. Clicking on a name displays information about that person. If the user wants to advance to the next name, he/she has to click on the dropdown, then click on the next name. It would be...

Am experiencing some odd behavior with an Access 2002 form. I added a textbox to the form. The Control Source is: ="Hello World" (Just an example; doesn't matter what I put there.) When the form loads, this textbox is nowhere in sight. But if I click with the mouse where the textbox is located...

I have run into this problem enough times now, that I want to bring it to this forum. I have an Access database (Access 2000, running under Windows xp). I add queries, revise forms or reports, etc. Then I close the database and click on Compact and Repair. Everything proceeds normally. I rename...