Search results

This seemed to do the trick for me. If Eval(strInspType & " " & vYellow) Then I took out the second eval.

I am trying to make a "dynamic" If...then statement in VBA to evaluate something like: "If -1 >= 0 Then" I have a table that contains a field that contains a string like: ">14" So I do a Dlookup to get that value (vYellow varient) and I want to use it in an If...then like this: If...

I am createing a query in VBA, saving it, then running it, and it does not work. But if I go into SQL mode, copy and past it into a new query it runs. I have comparied the one that does not work and the one that does and they are identical. What's up?!! Here is my code to create it: Dim...

I am using SQL 2000 and have two tables that I want to create a relations ship, so that when I add data to one it gets added to the other. Table_Main QuoteID int PartNumber nvarchar (both make up key field) Table_Secondary QuoteID int Item nvarchar (both make up key field) When I use the...

I am trying to import some data from an Excell spreadsheet into Access, but not every row contains the same data. Basically I have one row that contains the Parent information and then rows directly underneith it that contain the child data, and the child data can be in various number of rows...

I have a form with two subforms on it, and up till now I have made it unbound. After the user selects the record he wants to view from a combobox I then set the main and sub forms to stored procedures and set the imput paramters accordingly. That works great for viewing, but now I need to add a...

Not sure what you mean by "reference them", but here is what I had to do to get it to work: I had to make a new parameter and then pass it a question mark in my code: resynccommand="EXEC test67 ?" CREATE PROCEDURE "test67" ( @QuestionMark nvarchar ) */ AS SELECT <stuff removed> FROM <stuff...

I need to use a resync command on a form, but the SQL is too long to use. Is there a way to use a stored procedure instead? When I tried making a stored procedure using the needed "?" in plce of the parameters I get this error: ADO error: No value given for one or more required parmameters...

Thanks, Any idea how to get the emebed files out of the database, using code that is, I don't want to go thorugh all of them by hand.

I have a Access 97 MDB that has a form and continuous subform on it. When I tried to convert it over to an ADP and MSSQL 2000 I can select an item for the first row of the subform but when I enter one for the second row I get an error. I thought that I had this solved at one time by getting my...

I have a one table database that contains just embedded MS Word files. It has about 1200 records and the files are about 20K each. The MDB (Access 97) is about 900 Meg after compacting. I know that when it reaches 1 Gig Access will complain (I had to break it out of another MDB into its own...

I have a query in which I am trying to multiply a group of records in one specific field, just like you would do when you do a Sum. So, instead of having a query take a column of data and adding them together, I want to mulitply them: SUM: 2+5+4=11 Mult: 2*5*4=40 Is there another way to do...

Then I guess I can't do it in a parent/child relationship since I really need a parent/child/grand child relationship to get me 3 levels deep. Which means I need a 3 column table. Sound about right? Mitch

Thanks, but I guess I did not specify enough that I am not trying to set a form's recordsource. All I want to do is open the the sp in datasheet view, like running an MDB query by double clicking it and entering the parameters in the prompts that pop up. Using code that is, instead of...

Is there a way to run a sp after passing it parameters and having it display the results. I am using an .ADP and MS SQL2000 I can do this to run a sp with parmeters but not display the results: CurrentProject.Connection.Execute ("spDataValidation_Scrap_GoodVsScrapPerHr @BeginDate="...

I am trying to make a form/table that will allow me to enter where I put a tool in our tool cribs. I thought this would be a simple BOM type thing with parent and child fields. So my table would look like this: T_Cribs Parent Child LocationDescription This works until I need to edit...

I have a form that has a combobox on it and I want the user to select from it then have the form go to that record. I am converting an MDB to an .ADP so I can't use DAO and must use ADO. This "old" form used this DAO code: Me.RecordsetClone.FindFirst "[CustID] = '" & Me![cbx-lookupcustid]...

I can set my recordset to a stored procedures in my .ADP using this code: Set rstHeaderStatusChange = CurrentProject.Connection.Execute("spSSHCDStatusHeirarchyLink") But how do I code to make the recordset updatable? I tried: CurrentProject.Connection.Open but then Access wants some function...

I'm not sure I understand what your point is, but I think you are saying not to have any data on any form "pre-loaded" execept for whatever the user is currently looking at. Is that correct?

They all are in continuous mode Pop up would work, I'd have to change ALL of my forms for the most part and add the code to pop them up and remove ALL the tabs from ALL of my forms. That would not be pleasant. :eek: