Search results

  1. B

    comparing dates and other stuff...

    I have a "search form", which has a field with following row source: (SELECT DISTINCTROW Main.OrderID, Main.SFPOrderID, Companies.Fullname, Main.Date, Main.RDate, Main.SDate, Main.Finished FROM Companies INNER JOIN Main ON Companies.CustomerID = Main.CustomerID;) I'm trying to find all...
  2. B

    Data import/linking problem

    I have a folder that has database files that are named by date (evt3010.mdb) All of them contain only one table EventTable. How can i automatically import or link these to my database and rename tables preferably by date or filename (or something else). I'm stuck with this issue, any ideas?
  3. B

    problem with combo and sql

    I have a combobox that looks up 4 fields of a table. For some reason i can't make a sql-expression that looks up the value from a certain column. Like this: SELECT xxxxx FROM xxxx WHERE (((brand.pID)=Forms!main!Form!category_combo.COLUMN(1)) Access complains about undeclared function.
  4. B

    pass two values from single combo box

    Is it possible, is there any way (VBA ?) to bound a combobox to two columns in a table. Or any other way to get values from two columns (same row of course)?
  5. B

    problems with bounding

    The problem is this: i have a combo box where i choose a name. In database these names have different category ids (not unique). when i choose a name it jumps to the record with same category id, but name first in alphabets. How could i prevent this. Question 2. Is it possible to pass values of...
  6. B

    1 out of 2

    i need to compare to elements in different tables in order to create product code. For example: if the product type is toy and material is metal it would be 1, tool & plastic 2. material and product type in differnet tables. Anybody who can help me out.
  7. B

    parsing data from textfield

    I need to separate values from a single textfield -> prm1prm2prm3 will be prm1, prm2, prm3. How is it done? I'm stuck in this relatively simple question.
  8. B

    embedding a font in access

    Is it possible? I need to embed a barcode font. It is possible to use the font through macros, but it would be much easier to use embbed font in a report.
  9. B

    combo(s) to textfield

    Hi! Siple question, at least i hope so; How can i combine information from (8) combos to single textfield. Better yet if i could add a separator like / between the text. Thanks for best access forum around.
Back
Top Bottom