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

    Soundex

    Thanks, that sounds kind of like the difference function. Sorry to sound dense but I have an access name called T_NAMES with fields first and last and a second table called T_NAMES2 with same fields. Can I use this code to compare the two?
  2. lewis33

    Soundex

    I understand there is a Soundex and also a Difference function available in SQL Server. I am not too knowledgeable with VB but here is my dilemma. I would like to compare two tables that have first names and last names and I think the Soundex function may be of help. I've read about the...
  3. lewis33

    Cross Tab Query- Unique Counts

    Thanks a ton Duane. I'll give it a whirl. Wasn't sure if there was a way to write the SQL within Access to have just one query.
  4. lewis33

    Cross Tab Query- Unique Counts

    Hi Duane, I do have a total. It's is like my data is: County,Name,Product Allegheny,joe's dialysis,HMO Allegheny,joe's dialysis,PPO Allegheny,joe's dialysis,POS Allegheny,jim's dialysis,HMO Allegheny,jim's dialysis,PPO Allegheny,jim's dialysis,POS Allegheny,tim's,dialysis,HMO Allegheny,tim's...
  5. lewis33

    Cross Tab Query- Unique Counts

    Hi, Maybe this problem has been beaten to death. However, I'm looking for a viable solution to a crosstab query problem. Basically, here's the SQL: TRANSFORM Count([ANCILLARY MASTER].NAME) AS CountOfNAME SELECT [ANCILLARY MASTER].COUNTY_NAME, [ANCILLARY MASTER].SPECIALTY FROM [ANCILLARY...
  6. lewis33

    Maximize Values in a Row

    Hi HiTech and WorkrAnt, I was (am) trying to calculate the maximum of some fields in a row (rather than in a column) and thought something might be better than: IIF([malepercent]>[femalepercent],[malepercent],[femalepercent]) and then do the same thing for the other field in the row. Doesn't...
  7. lewis33

    Maximize Values in a Row

    Hi, I have a query that has something like County, Male Percent, Female Percent, Robot Percent(kidding) grouping on the county. Can I run a query in MS Access that can MAX on the row and update a column OR give me a new calculated field? Thank you, easy to do in a spreadsheet but I'd rather...
  8. lewis33

    Datasheet Form and close buttons

    Hi, I'm struggling with an odd problem. I have a main form that with some list boxes. These have command buttons that bring up forms in the datasheet view. Only problem is that I lose the close buttons on these forms for some odd reason. I have it enabled. Wondered- to get around this, if...
  9. lewis33

    Access Datasheet Forms and Command Button

    Thank you. I'm using Access 2002. I added in the event proceduere and that works fine except that now I lose the close buttons even though I have them enabled on the properties sheet. I have to use the min/max buttons in order to see them.
  10. lewis33

    Access Datasheet Forms and Command Button

    Hi, I have a couple of, I hope, not too complex questions. 1. Everytime I close the datasheet view now, the form returns to my original main form but it does not fill the entire available window. I don't need any scroll bars or min/max buttons and I've disable them but it still does not expand...
  11. lewis33

    Having One Form Instead of Multiple Forms

    Thank you ShannonSkipper. That's most helpful.
  12. lewis33

    Having One Form Instead of Multiple Forms

    Hello, I was looking for a bit of direction on a project. I had a table that has data and it is grouped by state counties. I made a datasheet form from this. I will then put the database on a network so that people can audit the data through the form. Since there are 88 counties in the data...
  13. lewis33

    Crosstab Query- Can it add the columns

    Duane, MichaelRed, Thanks a super ton. Really- I'm trying to avoid using an outside report generator and this gives me a lot of options. Love the examples you had Duane. Professionally done to say the least.
  14. lewis33

    Crosstab Query- Can it add the columns

    Duane, Thanks very much. I'll take a look now. Sure this will do the trick.
  15. lewis33

    Crosstab Query- Can it add the columns

    Hi, apologize in advance if this has been addressed too many tabs. I couldn't see anything in the FAQ's that relate. I would like to have a crosstab query create results where the list of state counties are the columns. Then various (about 5-6 calculated fields) fields become the rows. I...
  16. lewis33

    Can't Connect to Internet

    TT4U, Wanted to say, thanks again- think I got it working. I did not go into safe mode but I made a couple of adjustments and not sure what did the trick. However, I did lose some of my disply colors when I re-booted. Basically, I deleted all the cookies and also I think I zapped a...
  17. lewis33

    Can't Connect to Internet

    Thank you again TT4U. I'll give it all of those a look see. I started having these problems when some programs started to load onto my machine when I was logged on.
  18. lewis33

    Can't Connect to Internet

    Thanks TT4U- I'll try running the rundll32.exe from the install CD. Can you tell me how to boot into safe mode and also what running msconfig does? Is that kind of a disk defrag (don't think so but thought I'd say that to show how little I know about this)
  19. lewis33

    Can't Connect to Internet

    I can establish new connections but I still can the Rundll32 error.
  20. lewis33

    Can't Connect to Internet

    Hi, I'm a DB guy so network issues are my definite weakness. Got a real issue as I cannot use my dial up Internet service nor dial into my work mainframe. I'm using Windows 98 and so far I have: 1. Reinstalled Windows 98 and reinstalled I.E. 5.5 but get the same error. I didn't remove the IE...

Part and Inventory Search

Back
Top