Search results for query: *

Hi, I have a problem with my sql query. It contains three tables. TestPlanNodes, ManualSteps and ManualTestStepResults. This db saves data from diffrent test rounds. ManualSteps contains all different test steps that can be made and ManualTestStepResults contains the results from all the...

Hi! I have a form where i do a search in a table. I want to do the selection from the table depending on what i write in the textfield with vb. Something like strSQL = "SELECT (*) FROM table WHERE id = SEARCHFIELD ON THE FORM" And then I want to able to see the result in a listbox. As you can...

Hi! I read thread faq702-4246 (http://www.tek-tips.com/faqs.cfm?spid=702&sfid=4246) There they use a value list for the list boxes, What i need is to use a query i have. But the problem is that I don't know how to implement that in the code on that page. happy for any help

Hi! I have a problem with a search form. I'm using a macro to find data from records in two different tables. First i use goToControl: Control name: search (which is a subform) Then i use i FindRecord: Match: Any part of field Match case: No...

Hi! I have a query that selects everything from a table. In the table I have a serialnumber(SN). Looks like: 4-715-1025000901 Right now I have serialnumbers from 4-715-1025000901 to 4-715-1025001001. And my result looks like: SN Amount Price 4-715-1025000901 1...

Hi! I want to get a value in a textfield on a form using DSum. When the form open I have an event procedure that sums up the value in a storage for each market. INow I have this line: Forms!Ekonomi!Saldo = DSum("Antal*Lagervärde_avg", "tblLager",[ ]) The problem is that...

Hi! I have a problem with importing from excel. I have a table with deliveries where I have to save every delivery made. Thats why I need an Autonumber field so that there will be a new unique row for each delivery. But when I make a delivery of products from an excel-file it doesn't work. I can...

Hi. I have a form where I insert records from an excel-file into a table. I have an Autonumber field in that table. And I have a macro that jumps to a new record in a that table, but how do I write? DoCmd.GoToRecord ( ), , acNewRec What do I write between the ()??? My tablename is...

I have a query that selects products and shows them in listbox. I would like to if there is a way to select specific lines or all lines from the listbox that I want to use for other purposes e.g. deliveries or spmething like that. Does anyone know. I would really like to know. Thanks

Hi. I have a table that needs to be updated with an updatequery, but when I run it I get something like "Must use updateable query". My updatequery gets its value from an select query that calculates a Sum. How do I do to prevent that from happening or is there any other way to update...

Hi! I have a query thats selects objects, with long serielnumbers. I want the query to select the objects with similar first 8 characters. How do write that? Now I have the following command in the criteriabox: Left([Forms]![frmSök]![Text14],8) Does anyone know how to solve this Thanks

Hi!!! I have a problem with a query. I have three select-queries which gives me three different values I want to add (using a fourth query). That works fine but when one of the three select-queries doesn't "select" a value The fourth query doesn't select anything. How can I prevent...

Hi!! I have two different excel dokuments. I want to link fields between the docs. In document A i fill in a number of columns (text, numbers, currency), and i want some of the columns to be copied into document B. How do I do that please help /marlun

Hi! I have several select-queries that colloects a value that i want to update a field in a table with. I'm now trying with an update-query, but I get following error-message. "Must use an updatable query!" I don't know what to do or what is wrong??? thanks /marlun

Hi! I wonder if there is a possibility to use a form to import data from an excel-file into an existing table. If it's possible I would like to use a browse field/button, or is the only way throug the FILE in the MENU, and then get external data??? Would appreciate any help... /marlun

Hi! I wonder how I do when I want to add data from an excel-file to my DB, so it puts the data in correct tables. Does the excel-file have to be setup in a certain way or does it work automaticly, never done this before. thanks

Hello! I've an update query that gives me following error message Operation must use an updatable query. (Error 3073) Is it because I have an updatequery that depends on several select queries that collects the values i want. ????? please help

Hi! I have an If-criteria below, when it's true I want it to run this update query where I have a field (Amount1) in a table "tblLager", I want that amount to be updated with an "Amount2" that comes from a form (Which i fill in). If DCount("ProdSN&quot...

Hi there! I have vb-code that searches for duplicate records: If DCount("ProdSN", "Lager", "ProdSN = '" & Me!ProdSN & "'") > 0 And _ DCount("ProjIn", "Lager", "ProjIn = '" & Me!ProjIn & "'") > 0 Then The problem I...

Hello! I have a problem with a update query. I have a form that adds records to my DB. I fill in an amount in the form "AmountIn". I want it to add the "AmountIn" with the Amount in the table. Seems to me it's pretty easy, but it doesn't work. The query's criteria is a S/N...