Search results for query: *

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

So, now I have the values from the subform inputing to a field on my main form. The problem is, I have multiple values in my subform and I need all of those values to show up on my main form. For example, for each record in my main form, several records show up in my subform because they are...

Thanks PHV and Remou! I used both the expression builder and the article from microsoft to derive the correct syntax listed below. Private Sub Combo42_Click() If Combo42.Value = "Relocate" Then Dim relocateMsg2 As Integer relocateMsg2 = MsgBox("Move all Components?", vbYesNoCancel + vbQuestion...

Thanks for the link on the windows support site. Unfortunately I am still having issues. I have updated to the below syntax, yet I am still unable to return the values. Private Sub Combo42_Click() If Combo42.Value = "Relocate" Then Dim relocateMsg2 As Integer relocateMsg2 = MsgBox("Move all...

I have information show up in a subform on my main form when I select a value from my combo box on my main form. I need information from the fields in the subform to input into a field on my main form when I select a value in another combo box. How can I do this? I am using the following code...

Here's a difficult one. I have a table that has controlID's with just numbers llike "325". I also have a table that has the controlID's that have the same numbers only each each of those have a letter at the end like "325a", "325b" and so on. Basically that is how the records in the two tables...