Search results

I found the error. I added a "VALUE" keyword in the queries and I shouldn`t. I succeeded in saving the query, but when I want to run it, I get the following error: "The insert into statement contains the following unknown field name 'Loturi dbo_SC33XX00.SC33001'. Make sure you have typed the...

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...

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...

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...

you are a genuine :) Thanks a lot!

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!

Yes, it is. I use combo boxes for example and I cannot imagine how can I bound them to the fields of a table. More than that, my first field need an update (GotFocus) before validating/entering the data. I saw that when I bound the fields of the form to a table, I cannot set defauld values for...

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...

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 =...

Indeed, I want to create a combo box. I have a new problem (the previous one is no solved yet, anything else occured). I need to create a easy to use combo box, so the user can work with it as fast as possible. So, let`s suppose I want to create a combo box which contains the customers of an...

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?

The problem was solved...

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?

I have to do that. In fact I did, and for some records, it works, but sometimes it doesn`t and I don`t know why...

I extended the query to 2 tables with 2 fields. Even if I have identical records, the query returns some of them. Why do you think that happens? I choosed the query (it is the same query with the one that has been generated by MStef in DemoSelectQryA2002.mdb or generated by Access using...

Thank you! It works.

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...