Recent content by jmbcreative

Good afternoon fellahs, I am just cracking the seal on my batch scripting knowledge and I could use a little help on this one. I am trying to write a batch file that will search for a string within another txt file and return all six rows of information under the string I am searching for and...

Just as a side note to the advice already posted, you may want to look into the company's computing policy. If you signed a computing policy when you gained access to the companies computing resources, chances are there is a clause that states that the data contained and produced on the...

Thank you, George!

I am working on createinga UDF and I am stumped. At this point my basic question is this; in a UDF, if I want to use a field that I created within it as part of an equation, do I have to declare the field as a variable? For example say if I have something like the following; CREATE FUNCTION...

Awesome! It worked out. I suppose it make sense perfect sense now that i llok at the solution, just needed someone to point it out. Many Thanks amigo!

Howdy Folks, I have a bit of a complication with the DMAX sequence that I am running. To give you the rundown, basically I have a table that maintains equipment inventory "HardwareList copy". This table identifies a main system and all of it's components. The are identified with controlID's...

Scratch that! I use the DateDiff function to get the results that I needed. For those who are intersted, ResponseTimebyHours: DateDiff("h",[requestDate],[rogerDate]) Gave me the response time in hours. Joe

I have a need to create a chart showing the type of request and the average response time by roger. the data that I have collected in my query looks like below; requestDate rogerDate type 3/08/2006 8:48:41 AM 3/08/2006 11:48:41 AM relocate 3/10/2006 8:20:41 AM...

That Auto Filter tool Rocks! And all this time, I never knew it existed. man, what time that saves me. Most of the manipulation that I need can be done through this tool. Thanks Mate!

Thanks Skip! That worked out. How do I perform this operation for the entire column?

Thanks for the tips, Skip. I used the formula and it worked out. One Question that i can't seem to find an answer to; Is there a way to check if a cell contains a value within it and then delete or copy it? What I want to do is check if a cell contains "SN:" and if true, copy that value to...

No code as of yet. Here is what my spreadsheet looks like System Dell Serial# Memory Type Model MemSize As you can see the data for each system is on seperate rows. In order to import it properly into my database I need all the data to be on the same...

I have a HUGE spreadsheet that I want to import to a database. The problem is the spreadsheet is not linear. What I need to do is move the values of any cell that has the word "model" in it over to the right one and up one to make it linear. I'm pretty sure this is easy to do, yet I have...

BADA-FREAKIN BING!! Thanks mate! That did tha trick.

My database is being used to maintain a hardware list. The Main form that I am discussing here is used to submit changes for review. My main Hardware list table has every piece of hardware on inventory. Some of pieces are systems (CPU's) and some of these are components (hard drive, monitors)...