Search results

  1. E

    Connect a listbox to a table/query?

    I have a table of customers and have table of stuff they can buy. Those two tables I use in the next table where their ordes get registred. I have and order form where I have a listbox. When I create a new order I want to have the customersname in a listbox but I want the customersID(primary...
  2. E

    Using access query in visual basic?

    Stangest thing is that DLookup worked fine... I will try Dmax also
  3. E

    Using access query in visual basic?

    Well I just was wondering :D If I did the VBA way.. How would it look?
  4. E

    Using access query in visual basic?

    Thanks for the answer but is this the only way to do it or is there other ways? :cool: :rolleyes:
  5. E

    Using access query in visual basic?

    I have an access Query(named newSerial) : SELECT TOP 1 (Productbase.Serialnumber+1) AS Expr1 FROM ProductBase ORDER BY (Productbase.Serialnumber+1) DESC; I want to access this new value. Its not a key since an autonumber may be any number. When I create a new product. How do I get this value...
  6. E

    Using query in form?

    I have a table with a lot of columns. I have two columns i want to prepair to be used in a tablesheet form. One with sizenumber and another with productnumber. I have a datasheet form where I want to use the data from sizenumber and productnumber writen as one ex. "3-345767" (first number is...
  7. E

    How do I use a query in a tablesheet form?

    I have a query "Sort String: Drawing.Size & "-" & [Drawnr]" that I want to use in a form. I havent succeded to get it to connect succesfully. If I use ="A" & [Size ] & "-" & [Drawnr] as control source you cant right click and choose descend or ascend. How should I solve this?
View older results
Back
Top Bottom