Recent content by kschomer

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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