Recent content by bkpchs237

Hi Hokis, One of each code of two of each code is very different. However, here's one of each code based on your information above: SELECT ACCOUNT, FIRST, LAST, COMPANY, code FROM MyTable GROUP BY ACCOUNT, FIRST, LAST, COMPANY,code; where MyTable represents the name of your table. Hope...

You may be running up against Excel's display limits. Per the Excel specifications and limits, only 1,024 characters are displayed in a cell, even though up to 32,767 characters can be stored in a cell and displayed in the formula bar. Use the Len() command to find the number of characters in...

kubanvz, Try creating the chart in Excel, get it exactly the way you would like it to look, then Edit, Copy, Edit, Paste Special, Picture into PowerPoint, or Edit, Copy Picture, Edit, Paste. If you don't need to edit it after it is placed into PowerPoint this should work just fine. If you...

elsenorjose, Assuming that your dates are cells A1 thru H1 and your values in A2 thru H2 the following may help. There are a number of formulas (Forecast, Trend, Growth to name a few) in Excel that may help you with what you propose. However, to use them you will have to ask yourself some...

logisticsman, A little more help as to what is or is not working here may help us to assist you. Exactly what is happening to cause you to think that it is not updating automatically? Then the question is what are you counting? Should you be using DCount or DCountA? Hope this helps.

Kevinski, You state here that the query runs independently just fine. Then I suggest that the problem is with your report. You state that you are trying to write a report and graph the results. Am I to understand that you have placed a graph on the report? I have run into problems with...

bkast3, You may have a significant number of issues to address here that may be better served asking your question in the Access forum, but I will try to address one or two. If I read this correctly you now have 2 different front-ends and 2 different back-ends. Now you need to link the new...

tizwaz, Are your numbers actually numbers when brought in? By this I mean in the formula bar is the "number" appearing as 11111111111 (eleven 1's) or is it some sort of text entry? Also, do you want to keep them as numbers? If yes and yes, then the custom format for the cells as it appears...

Mizzness, As Lilliabeth stated the formulas work fine and seem to be proper as written. The questions are: Are you actually trying to find values that reside in columns B & C on the "Remove Access2" worksheet or are they in different columns? Otherwise, if you believe the item you are...

WaverlyITServices, An additional note, you may want to try to recreate the individual's profile. Hope this helps.

eao, I agree with anotherhiggins. Your data is setup in a fashion that is actually easier to handle than what you propose. However, to accomplish the task you describe I propose the following. Assuming your values listed start in Row 2 and continue downward, sort on the Names column, then...

dumdum2, I believe the following link may contain some useful information for your concern: http://support.microsoft.com/kb/252732/en-us Hope this helps.

WaverlyITServices, "If I save a copy of the file to his hard-drive, I experience the same problem." "Logging onto that user on a seperate machine, the problem does not occur." These two statements seem to lean towards a file-type association problem with the one machine or something really...

hofburg, I believe that the following article will have information useful to you: http://support.microsoft.com/kb/327000/en-us Hope this helps.

patme, You will need to change the subaddress property of the hyperlinks on this worksheet. You can use something similar to the following code, which changes items that have hyperlinks in cells D3 thru D12 to places on Sheet1 on the current sheet to those same cells on the current worksheet...