Search results

  1. D

    Same ID in a row

    Hi i have table like this : ID SIZE 1 SIZE 2 SIZE 3 SIZE 4 1 12 14 16 18 2 12 16 3 14 4 5 10 12 I need to be like this : ID SIZE 1 12 1 14 1 16 1 18 2 12 2 16 3 14 4 5 10 5 12 I know that this is very easy but im new. Can you help me.
  2. D

    Two separate words

    Hello, i have a column with a data Like: Hristo,Vankov Marty,Hristov Ivo,Petrov Hristian,Todorov So my question is how can i split two names in 2 differnt columns: [field1] [field2] Hristo Vankov Marty Hristov Ivo Petrov Hristian Todorov Thank you and sorry...
  3. D

    SUM function

    Dear Friends, im very new in MS ACCESS that why i wanna aski you a question. I have a form with 2 text boxes - currency wich is [Amount] and [SubAmount] from table Amounts. How can i create a text box in this form wich can Sum [Amount] and [SUbAmount] in a text box and display. Thanks Veselin
  4. D

    Help

    Dear Friends, im new in Access but if someone can help me please let he do it. I have a column with data as a samle "8405071214" How can i give from this digits the information like 07/05/84 Thanks
  5. D

    Query for repeating

    Dear Friends, is there someone who can tell deside my problem. I have the table with columns: ID, Date, Days, Total 251 25.01.2004 5 254.68 $ Where Days 5 is how many days i was have the same sum. How can i make an inquiry : ID, Date, Days...
  6. D

    separate

    dear friends, is there someone who can tells me how can i separate more digits. Examples: 112244554455,54 1234567897898,57 128761237836,89 So, from first digit i wanna to get 55.54, from 2nd - 898.57, from 3rd 6,89. And to make 2 colums - 1st only first 10 digits - 2nd column - the other...
  7. D

    Auto starting access

    Is there anybody who knows how can i make my MDB to starting automaticaly in every friday
  8. D

    Left, Right function

    I have a query : pol: IIf(Right(CStr(CInt(Mid([EGN_zastrahovasht];9;1))/2);1)="5";'æ';'ì') but when i try to start it access give to me "Undefined Right function" Any idea!!!
  9. D

    Help

    Is there someone why can tell me how can i convert a Digit in a Word??
  10. D

    Parent ID

    Is there someone why can tell me how can i make a Tree where every person mest have a parent? Please help me
  11. D

    Module not found.

    Today when i try to connect to my database the Access says to me .. Module not found and i cant use my reports and forms . And btw i havent any modules
  12. D

    IIF function

    is there everyone who can tell because im new in VB- how can i make iif function in Access form with 2 text boxex, where if 1st text box is >0 then 2nd text box = 1st textbox*2
  13. D

    re

    a column in the table !!
  14. D

    adding a text in table

    hello , i have a table Accounts with Id, Name, Currency - EUR, BGN, USD is there someone who can tell me how can i add a new column and where currency = EUR to write a 1.95583, where =USD to write a 1.8 and where is BGN to write 1
  15. D

    adding a serial number

    adding a auto number is there someone who can help me about that with how can i add an auto number in a report based on query?
  16. D

    help me please!!

    im new in access programmming and im wanna to askin you how can i make a macro why can write "false" in column "new" - table "customers" where column "city" is "New York"
  17. D

    Undefined function "Left"

    I have that query SELECT Polici.EGN_zastrahovasht, Left([EGN_zastrahovasht],2) AS Expr1 FROM Polici GROUP BY Polici.EGN_zastrahovasht, Left([EGN_zastrahovasht],2); but when im startin up the access says to me Undefined function "Left" in expression !!! any suggestions?
  18. D

    help

    i have as GroupHeader0 a money header , but how can i insert a money footer
  19. D

    help me!!!!

    When im trying to open my database file the Access 2000 gives to me : "The database c:\data.mdb needs to be repaired or isnt a database file" and then " Unrecognized database format c:\data.mdb" How can i decide that problem?
  20. D

    unrecognized database format

    When im trying to open my database file the Access 2000 gives to me : "The database c:\data.mdb needs to be repaired or isnt a database file" and then " Unrecognized database format c:\data.mdb" How can i decide that problem?
Top Bottom