Search results

  1. O

    insert into ... select error

    I`m trying to insert some rows of the table [Produse finite dbo_SC03XX00] into the table [Loturi dbo_SC33XX00]. So, I tryed to run the following queries: A) INSERT INTO [Loturi dbo_SC33XX00] ( [Loturi dbo_SC33XX00].SC33001, [Loturi dbo_SC33XX00].SC33002, [Loturi dbo_SC33XX00].SC33003, [Loturi...
  2. O

    form refresh problem

    I have a form with linked fields. If I keep this form open and I input the data in the linked table using another method, but not the form, the form is not refreshed. I would like to add a button to the form that refresh the form with the new data, but I dont` know any functions or VBA code that...
  3. O

    INSERT INTO problem

    I have a table SL with some fields, the first of them are: CODNOU and CODADR. I have a query test with some fields, the first of them are COD_NOU and COD_ADR. I made the following query: INSERT INTO SL ( CODNOU, CODADR ) SELECT COD_NOU, COD_ADR FROM test; which intends to insert the data from...
  4. O

    form with tabs problem

    I made a form with 2 tabs. I created controls on it and I saw that some controls belong to both of the tabs. How can I set the controls to belong only to one tab? Thank you in advance!
  5. O

    Run-time error '2115'

    I have a form with a subform(I suppose it doesn`t matter too much). I set an AfterUpdate method for the last component (combo box) of the form. That method should retrieve the values of all the fields of the form and send them into a database. For that I need to set the focus on the each...
  6. O

    Strange "Variable not defined" error

    Hello, I made a form with a field and I set a GotFocus function for it: Private Sub NRCDA_GotFocus() Dim SQL As String ' i build the qry SQL = "SELECT * FROM NRCRT" ' recordset variable Dim r As Recordset ' open the recordset Set r =...
  7. O

    how can I link a drop list to a query?

    I want to create a drop list, so I can do that: I select an item from the drop list. I detect the ID of the item and, depending of this ID, I select some records from a table. Can somebody help me?
  8. O

    format problem

    I want to format a cell (using Properties Dialog Box), I want to set a field 2 decimals, but the number displayed by the report in that field have more than 2 decimals. What could be wrong?
  9. O

    select [...] (not) exists

    I have 2 identic tables: T1 and T2 which contain only one field NR. T1 contains the data: 1 2 3 4 5 6 7 8 9 10 11 12 T2 contains the data: 5 6 7 8 A B C D I want to select all the records found in T1, but not found in T2. So, I wrote the following SQL query: SELECT T1.NR FROM T1 WHERE NOT...
Back
Top Bottom