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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kschomer

  1. kschomer

    Appending Data

    I have some small tables (ie Jan, Feb, March etc.) I want to append all of them into one big table. From the table tab I do a copy of Jan and try to append Feb. or I do a copy of Jan and using Query tab I do an append query. Either way I am getting an error and cannot get these into one table...
  2. kschomer

    Using A Trim and Right Function together

    I ended up using the following: Address: Trim([ADR1]&[ADR2]&[ADR3]&[ADR4]&[ADR5])- this trimmed off the leading/preceeding spaces. Expr1: Len([Address]) State: Mid([Address],[Expr1]-6,2) This seemed to work when the Right function would not. Thanks for your help. Karen
  3. kschomer

    Using A Trim and Right Function together

    Trim function alone gives me, for example: 12345 South Main Street Anytown, CA98765 Right(Trim([Table Name]![Concatented field]),7) This returns 1 record without any data in any of the fields. I expect the query to return, as follows CA98765 TX23456 AL76543 etc. for example. I am not...
  4. kschomer

    Using A Trim and Right Function together

    I have a file I receive from an outside vendor monthly. The problem is the address is ADR1, ADR2, ADR3, ADR4 and ADR5. But, depending on the Address you never know what Address field the State and Zip code will be in. Therefore, I have concatenated Adr1-5 into another field. Now I need to...
  5. kschomer

    Rolling a Pending Balance over to tomorrow

    I need to take yesterdays pending balance and add it to todays avail to process-todays processed. For example: Date: 11/19 Pending= 563 Date: 11/20 Aval to Process= 78; Processed=235 Add: 563 (from yesterday) +78=641- 235 (processed 11/20)= 406 Pending. I have two linked queries that...
  6. kschomer

    Using MSGraph via MSAccess

    I have a couple of questions about using MSGraph. 1. I developed my chart through the wizard. When I am editing my line graph how do I edit MY data rather then the MSGraph "SAMPLE" data? My data includes more lines than the sample data and I can'f figure out how to manipulate the...
  7. kschomer

    Outline Format in Word

    I took those steps, and unfortunately I don't see any changes. Seems like the ONLY way to see the data is to View the master document. Any other choices show me the 6 pages, but not the data. Even when I do a Print Preview, I do not see the text only 6 blank pages. I can print the document...
  8. kschomer

    Outline Format in Word

    I created a table in MSWord that expands over about 6 pages. Somehow I got myself in an Outline format and cannot get out. I can display the master document, but I just want a regular normal document and not an outline format at all. At this point I am trying to split the table and insert...
  9. kschomer

    Working with Time

    I am exporting data from a Call Center appl. (CentreVu by Avaya communication. The report I export has time in hours:minutes. I import the data into a number field. However, I cannot convert the number value to hours:minutes and have the hours:minutes MATCH. Any ideas? I have even tried...
  10. kschomer

    Linking tables on different servers

    That sounds like I would basically need to have duplicate databases for all the programs I build since my dept. is split between the west / east and we all basically use the same data. I deleted my original link and re-established the link by selecting the network neighborhood, rather than...
  11. kschomer

    Linking tables on different servers

    Where do I find the code? I don't know how to write Visual Basic I only have tables, queries, forms, reports and macros. I am sure its looking for V: and I need to change it to generic (ie. \\servername), but I don't know where to find it and change it. Karen
  12. kschomer

    Linking tables on different servers

    Windows 98. I do believe I can use the \\servername, however I don't remember where I need to enter that. I have looks at properties etc... but not sure where it goes.
  13. kschomer

    Linking tables on different servers

    I have two separate databases. From one database I am linking to a table (personnel) in another (employee) database. Our server is local here on the west coast. However, the application is being used on the east coast, as well. The problem is the server here (west) is identified as V:\ but...
  14. kschomer

    SIMPLE security

    Thanks Pezamystik, I understand everything you explained. I went to DOS and did SET and saw set variables. But, when I tried to do SET username I received a Syntax error. I suppose that since my workstation is Windows98 it evidently works differently than NT. Anyway, I didn't have good luck...
  15. kschomer

    SIMPLE security

    Michael, Yes "Please respect my privacy" is really enough security for this particular database. My users are not sophisticated and actually would be confused to see anyone elses objectives. So in this case low expectations are fine. Not to mention that since I am not a programmed...
See more

Part and Inventory Search

Back
Top