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

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

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

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

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

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

I have an event that has an if statement. Within the "then" statement of that "if" statement I need a second "If" statement to return a value. How do I do this? I keep getting a compile error on the second if Statement. Here is what my code looks like now...

I need to use strMax to look up and compare the values in two different tables and then incriment the higher of the two tables. Basically I have a table "HardwareList" that has a field "ControlID". I also have a table "HardwareAdd" that has a field "ControlID". I need to look up the controlID...

Howdy y'all. I have an interesting need. I have a button on a form that sends a report via email when clicked. Right now the report that it sends contains all of the records of the table. What I need to do is when the button is pressed, I need a window to pop up allow the user to select which...

Okay. My task is simple. I want to export a report into a word document keeping the same graphical layout as the report. Seeing as how Access and Word are from the same company, and even the same package of software, this should be no problem, right? Big Fat WRONG and I have found plenty of...

I am using a DMax statement to add a sequential number to a record. The problem is I need the DMax statement to reference a loaded subform. All the documentation that I am finding shows the DMax statement referencing a table or query as such; DMax(FieldName, TableName) Now, does anybody know...

Okay. Now bare with me 'cause this is slightly complicated. I have a subform (HardwareComponents subform) that is based on a query that looks up ControlID's. These ControlID's are in a numeric-alphabetic form like such 142a, 142b, 142c. I need a input field (controlID) on the main...

I have a form (HardwareAdd) that opens when a value "addcomponent" is selected within a combo box on a form called "Request". This form (HardwareAdd) has a combo box(System) within it that is querying a table for system names. I need this combo box to auto select the system name that is already...

I have a simple task. I need a command button to insert text into a couple of fields when pressed. What is the on-click syntax to do so? My inclination is to use ****** Private Sub Approve_Click() Me.Status.Value = "Approved" Me.Approval.Value = "Y" ****** But for some reason it is...

On the Command25_MouseUp action I need to insert a value into a field. how can i do that?

I have a form that has a combo box in it with values that I manually inputed. One of those values is "add hardware". I need the HardwareAdd form to open up when the "add hardware " value is selected. How can I do that?

I have a form with a combo box that selects records. Each of these records has a control number like "243". There are other records that corespond to each of those with control numbers like "243a, 243b, 243c" and so on. All I need to do is have a text box show the control numbers of all of the...