Search results

vbaInet FYFR, your red dots did the trick (RDDTT), YID, thank you. I guess I am a little rusty on my Excel code. That fix closed a project and lowered my blood pressure 20 points. And to CJ_London, the go advanced flipped my post from the bottom to the top but still no menu using Win7 and IE...

vbaInet, I mentioned in the post that I don't have a menu with # nor do I know any other way to put code tags in a post. There is no text modification menu on my screen when I post a question. In this example, the cells is not an object it is a method of creating a range and I had help from an...

I am exporting data from Access to Excel and following that up with formulas and formatting. The code is in Access and works on the Excel object and it works fine. The problem is it doesn't work a second time. I have to run compact and repair in Access and then the code works again. Below is...

My apologies, your link does work, but the change was not in the f string. By getting the properties of your link I was able to figure it out. Thanks for the follow up despite my rude reply. Below is what I had when I was looking up General Electric: URL...

Thanks plog, but your google site tells me to use the URL that I now know to be broken, so not much help there. Does anyone know of another site that allows free market downloads?

A number of my APIs were 32-bit and those fail in Access 2013. I used them to get the currently logged in user name and computer name. The ODBC driver should be a 64-bit one if going from 2013 to SQL

I ran into this problem with a client, the primary key was set as an integer and when they hit 32 thousand records it stopped. Make sure the primary key in both the patient (PatientID) and visitor (VisitorID) table is an autonumber and Long Integer and the Index is no duplicates. And I am...

I have an Access database that goes to http://download.finance.yahoo.com/ and gets me about a dozen numbers/dates for each stock ticker I send it. And I loop through about fifty companies. Been working for over a year, really got to rely on it. Now on Monday, the code failed. The page cannot be...

If I have this right, your home button is triggering a requery and a possible save all while the before update event is paused. My suggestion is to use before update with individual text boxes, not with an entire form. Get familiar with form.dirty. If it is true, the form has been changed...

Paul is right, you need an else top margin is six or something to reset the other rows. But I am gonna throw my two cents in as well because I rarely adjust the top margins. Are you aware that text boxes can "grow" if the length is beyond the size of the text box. By setting the Can Grow...

First of all, you're trying to do too much in one procedure. Second, anytime you have the backend on SQL you need to include dbSeeChanges when you open the recordset. Hope all this stuff helps. In one procedure check for an exiting record, you might need to use this often before you add a new...

Try this Function MaskedSSN(SSN As String) As String MaskedSSN = ("***-**-" & Right(SSN, 4)) End Function on the form load event enter Me.ssn.value = MaskedSSN(me.ssn.value) As far as your code is concerned, I think is should work. However, I would dim each variable individually, the first one...

I am posting what I learned today because hours of searching have uncovered something that no one seems to have mentioned. What really happens when you try to hide the navigation pane? I am using Access 2010. DoCmd.SelectObject acTable, , True 'select the table object in the...

My first guess, and I did not test this, is to take the length of each recordset field and subtract from the total length of the box, say 30 charactures. So if the field is ten charactures long, you have to add twenty spaces to the middle. So "Dealer: " & chr(32) & chr(32) & chr(32) ... &...

You need the CustomerID field in both the tblCustomer and tblCustomerDetail tables so you can link the one customer record to the many details. Then both have to be type Long and the one in tblCustomer should be the primary key. In the detail, index the field with duplicates. You did not give...

Thanks CJ_London. I check Allen's site all the time but I didn't see that page.

Well, you can put charts on forms and display them like any other types of data. You can also put them on reports too. You did not mention "where" the chart is, so I assumed on a form. And what I meant was you could size the chart 3 inches by 3 and the form 3 inches by 4 and you would have an...

You're welcome and I am glad you got it working.

So the default document window options is Tabbed and I designed the database to use Overlapping. So I am asking if anyone has some cool VBA code that I can run to change the client's machine when they open this database. This started when a person in the office opened the executable (accde) for...

CJ_London, Just so we're clear, this is not about trimming down the row source with a criteria string "like c*", the result being you trim the selection from fifty states down to three. This is about having "c" in the combo and it hits CA, then "cc" and it jumps to CO, and "ccc" and it jumps to...