Search results

  1. A

    Listbox to continuous form?

    Not exactly. In a sense, its like a shopping cart list. Maybe this example similar to what I want to accomplish may help out conceptually. I query a list of jeans. I get a list of jeans color. I select which color of jeans I want from the list. The selected jeans would be brought to...
  2. A

    Listbox to continuous form?

    Gotcha. I was able to see your db work now. THanks. I see what you did. But still not exactly I was looking for. I wanted somehow to translate that to a list of selections in another area where I can add a corresponding input from the USER so I can save those records to a table.
  3. A

    Listbox to continuous form?

    Thank you for your reply. For some reason, when I click on your OPEN REPORT button on your DB example I downloaded, nothing happens. I am using Access2010 to review your example.
  4. A

    Listbox to continuous form?

    I have a listbox which contains a list of schools. I would like the user to be able to select 1 or all the records from that list box. From that list of selected records, my goal is to allow the user to use each school selected and use that as a record source for a continous form so I can...
  5. A

    Using datevalue as parameter from a form

    I have revised the control so now I dont have to use the Datevalue in my QBE for the column startDate. In the criteria field it now states: [forms]![myForm]![txtStartDate] In my table, I do have records with null values in the [startDate] or does not equal the passed value of "3/1/2012" How...
  6. A

    Using datevalue as parameter from a form

    How would you suggest I correct it in my query? In my form control textbox its just a text date "3/1/2013" Can you point to an example on how to modify this? Thanks for your reply.
  7. A

    Using datevalue as parameter from a form

    In my QBE, I have a field call [startDate] In my criteria, I am passing a parameter from a form. Currently, I am using: DateValue([forms]![myForm]![txtStartDate]) From myFORM, the value of the text box is 3/1/2013 When I run the query, it runs as expected and returns all records with the...
  8. A

    Run-time Error '94' Invalid Use Of Null - All Of Sudden Appears, Access 2007

    For some reason, this error appears: Run-time error '94' Invalid use of Null This has all of the sudden appeared and nothing has changed. Here is the following code below. Private Sub SummarizeIntrastateFilersElectionStatus() Dim db As DAO.Database Set db = CurrentDb 'Dim...
  9. A

    Append Query Vs VBA Query

    Okay. I guess the only real performance option is to keep using the DoCmd.OpenQuery option as that gives me the best performance by far.
  10. A

    Append Query Vs VBA Query

    Thanks for the followup. So wwould you think if I took the results of the query qryResultsDifferences1_Insert and appended to a temp table would be a better option? Then run an Insert on it?
  11. A

    Append Query Vs VBA Query

    I dont fully understand in regards of the stats so I will take your word for it. I did do a compact on the database per your advice, but saw no difference. Caveat is that the access DB is not split. I know that ideally I should have a split system but for testing purposes, this hasnt been done...
  12. A

    Append Query Vs VBA Query

    its a query.
  13. A

    Append Query Vs VBA Query

    I did initially set this up awhile back, but ran into performance issues. Here was the post: http://www.access-programmers.co.uk/forums/showthread.php?t=226122 So, I ended up back using DAO and such.
  14. A

    Append Query Vs VBA Query

    Thanks. I didnt think of that. I don't understand the whole bit of the underworkings why it takes longer, but if I code it the way I posted, it took 25 seconds. When I changed it to an already defined append query and executed the DoCmd.SetWarnings False DoCmd.OpenQuery("NAMEOFQUERY")...
  15. A

    Append Query Vs VBA Query

    The table I am updating is a linked Remote SQL Server table. For my code to work and from what I understood, without the dbSeeChanges, it will not update.
  16. A

    Append Query Vs VBA Query

    When I run an Append Query, it only takes 2 seconds to complete for testing. It appends 25 records to a link SQL Server table. But If I create the same type of Query in VBA using Dim str2 As String str2 = "INSERT INTO dbo_CompanyToTypeOfElectionStatus ( FK_KCN_RefID...
  17. A

    Using DAO to insert new records into remote table

    Yes, I can identify the new records local, but my problem is that I need the new record ID that I append to in the linked remote table and use it for another linked remote table from the SQL Server. Is there an example you may have that I can get a grasp? Thoughts?
  18. A

    Using DAO to insert new records into remote table

    Yes it is.
  19. A

    Using DAO to insert new records into remote table

    Thanks for your reply. But I am a bit lost on whats going on here. Can you provide a better understanding on what you are doing? Even if I dont use your example, I may need it for future use or still in my case, may still use your logic.
  20. A

    Using DAO to insert new records into remote table

    Here is my code. The User clicks on the button CmdAction. Private Sub cmdAction_Click() Dim db As DAO.Database Set db = CurrentDb Dim rstSource1 As DAO.Recordset Dim Query1 As String Query1 = "qryResultsDifferences1" ' Initialize Query Set rstSource1 =...
Back
Top Bottom