Recent content by marlun

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 again, sorry I don't I understand what you mean. What is Fosters???

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

OK, I think I've tried that, perhaps the wrong way. In my table I have an Autonumber field. It doesn't append anything to the table the way I want. It didn't work with the "Get external data either. I can't understand what's wrong. Do you have any suggestions how to do it the easiest way. I...

Can I connect the marked lines to a query or to a form??? Lats say I have a deliveryform and I want to select some of the products in the list that I want to deliver, and then have an actionbutton that opens a new form with the selected lines, or something like that. How does the query know...

Great thanks for your help.

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

Hi kewo99! How do I write the If command when I have two files that needs to be checked for filepath or names. I mean something like If Dir("C:\TBLCLINETBLANK.XLS" OR "C:\TBLCLINETBLANK2.XLS" )= "" then How do i write so that it checks that both files are correct...

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