Search results

  1. Eugene-LS

    Windows 11 Compatibility

    Not BIOS, but CPU ... (younger than 2015) - as i know.
  2. Eugene-LS

    Windows 11 Compatibility

    Ну = кремень! Сударь, с вами сложно спорить! ... На сём и закончим, пожалуй. :)
  3. Eugene-LS

    Select bound Combobox value using VBA based on variable?

    may be ... but I tried to show one of the solutions
  4. Eugene-LS

    Windows 11 Compatibility

    Fine! :) А я и не сомневался, что "наших" тут есть немало!
  5. Eugene-LS

    Windows 11 Compatibility

    Try Google Translate to read that: Да конечно , это один из вариантов решения. Но вы будите использовать систему уже на "Свой Страх и Риск"- не зная кто её модифицировал и как. Стрёмно всё это! (Written in Russian) Sorry - my english is not good enough to write that thing ...
  6. Eugene-LS

    Select bound Combobox value using VBA based on variable?

    Try that way: Me.Assigned_To.RowSource = "SELECT Nama FROM Employees " & _ "WHERE EmployeeID= " & Dlookup("EmployeeID","Employee","[Nama]= " & strUser)
  7. Eugene-LS

    Windows 11 Compatibility

    I got all the same for my ASUS H97-PLUS Mother Bord, but it has TRM expansion slot (check out that in yours) - already made order for TRM-2 module (20-1 pin) - I will receive it in beginning of November .. ... Just 1280 RUR = Аpрrox. 16.25 Pounds ...
  8. Eugene-LS

    Solved Export report to Excel with VBA

    In I did - as I can see - ansver is : YES!
  9. Eugene-LS

    Solved Export report to Excel with VBA

    Hm-m-m .... How should I know abaute application that i have never seen? Need to take a look at the app specifics!
  10. Eugene-LS

    Solved Export report to Excel with VBA

    I use this method a lot when outputting reports to Excel (filling down a template) - it works just fine
  11. Eugene-LS

    Access: Need to display a list of tables in a drop down window

    Private Sub Command2_Click() Dim sVal$ If Me.Combo0.ListIndex = -1 Then MsgBox "Wro-o-o-o-ng!!!", vbExclamation Me.Combo0.SetFocus Exit Sub End If sVal = Me.Combo0 sVal = "INSERT INTO Total " & _ "( MODEL, SERIAL, [MONTH], OPERATIONAL, PLANNED, " &...
  12. Eugene-LS

    Access: Need to display a list of tables in a drop down window

    Ok! I didn't understand right away. Just change my code as shown below: Private Sub Form_Load() Dim sVal$ sVal = "SELECT [Name] FROM MSysObjects " & _ "WHERE ([Name] Like 'Data_*') ORDER BY [Name];" Me.Combo0.RowSource = sVal End Sub
  13. Eugene-LS

    Access: Need to display a list of tables in a drop down window

    Private Sub Form_Load() Dim sVal$ sVal = "SELECT [Name] FROM MSysObjects " & _ "WHERE (Flags=0) AND ([Type]=1) ORDER BY [Name];" Me.Combo0.RowSource = sVal End Sub
  14. Eugene-LS

    Solved Export report to Excel with VBA

    Wrong string left in my code - sorry ... Delete it please I usualy use "Late Binding"
  15. Eugene-LS

    Solved Export report to Excel with VBA

    That's not enough ... Add to project references "Microsoft Excel XX.X Object Library", or use "Late Binding"
  16. Eugene-LS

    Solved Export report to Excel with VBA

    That should fire! :) Private Sub ExportToExcel_Click() 'Dim xlApp As Object 'Dim xlWorkbook As Object 'Dim xlSheet As Object Dim xlApp As Excel.Application Dim xlWorkbook As Excel.Workbook Dim xlSheet As Excel.Worksheet ' ' Variables for data retrieval Dim SQL1 As String...
  17. Eugene-LS

    Solved Export report to Excel with VBA

    Add to project references "Microsoft Excel XX.X Object Library", or return everything as it was
  18. Eugene-LS

    Date Validation Problems.

    I checked your condition for myself, it works as expected.
  19. Eugene-LS

    how to separate 12 digits to many fields in access

    - "...how to separate 12 digits to many fields in access?" There are many ways ... How "separate"? - by what rules ?
Top Bottom