Search results

I have a database that tracks service calls on my company's products. I need to export the problem field and the solution field veritcally to Excel instead of horizontally (how they are currently stored in the database). I thought I could use a Union Query to accomplish this, but it isn't...

That is very helpful. Thank you so much for the information. I really appreciate it.

Does anyone know, is there a way to set up an automated timeline? I set up a timeline for a unit, but going forward, I'm going to need to do a timeline for twenty plus units on a weekly basis. I have the raw data, I just need some automatic way for it to update the timeline. I am attaching...

No, the two separate sources are not going away. What I am working on is a special project to help improve our products. Once the products are improved, the database will no longer be used. When comparing the error codes (either in a separate column or in the status byte) you are comparing...

My problem is arising, because the data in the database is acutally just imported from a couple different sources. We have two programs that track our service calls and we are trying to combine them in this database. One source uses the error code and one source uses the status byte. Neither...

In my database, I have a field that contains a "Status Byte". The status byte contains various pieces of information about a service call, on of which is a four character code (any combination of either one letter and three numbers or two letters and two numbers) for what is wrong. I have all...

You're right, I decided to go with the automated comments boxes.

That works even better. I looked at the link you provided too. That was interesting. Thank you so much for your help.

That works. Thank you very much.

Here is the code I was trying to use. I am using it in Excel. 110 For X = 2 To 125 120 Range("A" & X).Select 130 Selection.ShapeRange.SetShapesDefaultProperties 140 Select Case CInt(Len(Msg) / 100) ' 100 char per line Case 1 150...

Thank you very much for the code. I really appreciate you staying late just to help me. I am having a little trouble with the code to adjust the size. Every time I try to run it, I get a message stating that "Object does not support this property or method". Is there by chance a reference...

That works great. Thank you very much. I do have one more question. Is there a way to resize the comments box so that it will show the whole comment?

Is there a way to populate the comments box on one tab to a cell on another tab? I have a tab that contains information on various service calls and I have another tab with the call texts that the technicians enter describing what they had to do on another tab. I would like to set it up, so...

I have a spreadsheet that has two tabs. One tab lists all service calls and various details about those calls. My second tab contains the call text that the technicians enter describing what they have done. I was wondering if there is a way to make it so that when you click on the call number...

Okay, I'm not sure what I did, but it's working now :D. Thank you so much for your help.

Thank you very much for the formula and the module. I'm afraid I am having some trouble with it. I can't seem to get it to return data in my live spreadsheet as you did in the sample. I've gone over it multiple times and still can't find my error. Do I need to have a certain reference for a...

Yes, this thread is tied to the other post I made today. I have updated my example. If there are two for the day, then I need both statuses to show. Can this be done?

Will this Index formula work if the value to return is text? I have another spreadsheet that I would like to use this formula for and am having trouble getting it to work. I have a sheet with raw data that has a product ID, call date, error code, and call information. I would like this...

I'm afraid, a pivot table won't do what I want it to. I'm attaching an example of what I would like to accomplish.

I didn't realize there was more than one TCL language. The TCL that I need is the Tool Control Language. Is there a resource you would recommend for this language?