Search results

  1. A

    Insert into

    Thanks, but I was hoping to learn about VBA solution. I know how to use subforms, but really this is not an option here. I guess i just look someplace else than..
  2. A

    Insert into

    No, it's not complicated. It's very easy in use and administratation. Is there a solution for my question?
  3. A

    Insert into

    It's complicated. Table tbClients stores data of client's family members, so I need to put for example five rows with client ID, so users could fill other fields in this rows via form. Something like this.
  4. A

    Insert into

    I don't want to extend this code by multiply "ElseIF" Statesments up to LpW=10 or more, so is there a way to do this? please help:)
  5. A

    Insert into

    Hej, I wrote this code: Dim ID, strSQL As String ID = "'" & Me![ID_Client] & "'" LpW = InputBox("Insert number of clients", "Lp") If LpW = 1 Then strSQL1 = "INSERT INTO tbClients (ID_Client) values (" & ID & ")" DoCmd.RunSQL (strSQL1) ElseIf LpW = 2 Then strSQL2 = "INSERT INTO...
  6. A

    DoCmd.TransferSpreadsheet

    It's working now. Thanks man!:)
  7. A

    DoCmd.TransferSpreadsheet

    Hello, I wanted to import data from excel to access table via form button. And I did it using DoCmd.TransferSpreadsheet. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbclients", strFileName, True Now I want to import data from two different workbook sheets "costumer1"...
  8. A

    advanced form filter

    Thanks for solution, but I wonder how to do it via VBA. Any chance You could help my out with this one?
  9. A

    advanced form filter

    Hello, In my form i'd like to create a command button with assign vba. I want to filter form with this button with following criteria: 1. me.account_nr is like "000*" - text 2. me.clients_nr > 0 - numeric 3. me.open_date is null - date Please help me with code structure.
  10. A

    filter form

    Thanks, but that's not a solution i've been looking for...
  11. A

    filter form

    Hi, I've been looking for the answer for a long time now, so please help. I have a form with over 50000 clients. Each client has a unique personal ID like 000154225, 002254653 ect. I often have a list of 20 or more personal IDs and I want to filter my form to display only whose 20 clients...
  12. A

    RecordCount in listbox

    Thank You. ...so I did something like this: Private Sub Form_Current() Dim db As DAO.Database Dim rs As DAO.Recordset Dim i%, SQLstr$ Dim u As String u = Me.id SQLstr = "SELECT [PaidDate] FROM payments WHERE id Like '" & u & "*' ORDER BY [PaidDate] desc;" Set db...
  13. A

    RecordCount in listbox

    hello, I have the listbox named "payment_date", which shows recordset specified by following code: Private sub Form_Current() Dim que As String que = "SELECT [date] FROM payments WHERE id Like '" & Me!myid & "*' ORDER BY [date] desc;" Me.payment_date.RowSource = que End SubI need my...
  14. A

    variable as string

    thank you very much! it's working now:)
  15. A

    variable as string

    Hello, I have a problem inserting data into a table "ID_list" via VBA I want my users to insert value "ID" to InputBox. Everything works just fine until they insert value like this: 001256. Access inserts this value to the table as 1256. I want it to insert exactly what users enter This is my...
Back
Top Bottom