Search results

  1. L

    Solved File data icon in each record on form

    Hi everybody. I was working with attachment field. Noticed that attachment field in reality consists of (lets say the field name is "Attach") - Attach.FileData - Attach.FileName - Attach.FileType In attachment field I have attached different files, with their names. In the form I had...
  2. L

    Solved Form name from a combo box as variable

    Hi to ALL. I'm "building" a form with 3 combo boxes: First is ValueList RowSourceType, RowSource = "Tables";"Queries";Forms" Depending on decision from first cbo I get the names of all tables Except left(name,4) = "MSys", all queries and all forms Depending on decision of second cbo I get names...
  3. L

    fontname,fontsize table property CHANGE(ADD)

    Hello guys. I'll ask for help on one metter which I know I maybe shouldn't ask for it. The case is that I'd like to work COMPLETE ACCESS in fontNAME "CONSOLAS" and fontSIZE 10 - so that default font would be Consolas 10. As far as I know it is not so easy to setup different fonts than...
  4. L

    set different visibility of controls in each record

    Hello to All. I've made ACCESS CONTINUOUS form like the one in attachment (which is actually Excel shape) Main wish is to have VALUES in controls Range_m;Area_m2; Volume_m3; and their VISIBILITY depending on Measure unit value ("m", "m2", "m3") On AfterUpdate event of MeasureUnit I've made...
  5. L

    Changing default font in Access 2010

    Maybe funny question, maybe already answered: I'm tired of constantly changing fonts in every new table, every new query, every new control in form, … I can't find nothing similar as settings in excell or Word. In Options I've found allowed changes (size, weight, italic …) I'm not looking for...
  6. L

    DlookUp on two tables using Double As ID

    Hello. I have 2 tables. One is [tblTimes] with two fields, first field is [IdTime], wich is actually a numeric value of, for example, 6/24 = 0,25. --> field size = Double. The second field is text and the value is 06:00. First part of table: IdTime MyTime 0,00000 00:00 0,01042 00:15 0,02083...
  7. L

    Strange Form design

    Hello, Attached I send FormProblem.docx file with my problem. From my Access database I get table (which is top page spreadsheet like) From this table (query) I'd like to make a form which would be like the bottom page spreadsheet With my knowledge I'm not able to find solution althoug...
  8. L

    Delimited fileld in table

    I've linked excel file to Access database. The excel file is automatically created by company's software and I can not change it. One column in Excel file is Delimited (Alt + 010). When I link it to Access I get (for example, field "ProductName") long, almost unreadable line of characters. Is it...
  9. L

    Passing value from Public Sub to query

    I'd like to filter query with a value from my Sub named NewName: ..... NameVePlusBuy = (Version) & " - varianta " & (Buyer) ...... where Version and Buyer are declared as strings andNameVePlusBuy is some kind of combination of both, which I would like to use it in Append query like INSERT...
  10. L

    Using variable in SQL string

    Hello. I have a PEACE of code looking like that: Dim ElKup1 As String Dim sq As String ElKup1 = (Forms!frmNotInList!Combo6.Column(1)) & " " & Forms!frmNotInList!Combo0.Column(1) sq = "Update tblElements Set ElementName = ElKup1 WHERE ElementName=null;" DoCmd.RunSQL sq When I run the...
  11. L

    How to get index of new entered sorted combo box item

    Hello. First time on any forum. I'm not exactly Access user begginer, recently I've started using SQL and some VBA coding. Here is my problem which I'm dealing with for last month. With NotInList event I'd like to add "new item" to combo box and select it programmaticaly like...
Top Bottom