Search results for query: *

TRIM is not possible. You can never be sure about fieldnames from a crosstab. That is why I use SELECT * in my INSERT INTO statement. The statement has the following form: INSERT INTO DestinationTable SELECT qryDataFromCrostabAndOtherTabels.* FROM qryDataFromCrostabAndOtherTabels But the...

Finally got the solution The problem is that when adding fields for the table using DDL I choose char(25). I now changed it to text(25). That solved the problem.

Hi yoshe The trick has to be done in word. In word you can use the NEXTIF field to fill the list in your letter. I access you make a normal query including the to joined tables. Feilds from the "mother" tabel will be repeated for all its related fiels from the other table. In the merge...

I try to denormalize a Access database. Results from a crosstab query are loaded to a table by an "Insert into" statement. Other related data are loaded as well by the same statement. The fields that comes from the crosstab are all char(25). If there is data present in one of these fields, the...

I found an answer. In the Form_Load event, the locks has not been released. By tranfering the code to the timer-event everything is working just fine.

I found an answer. In the Form_Load event, the locks has not been released. By tranfering the code to the timer-event everything is working just fine.

I need to delete a field from a table via VBA. To close the table, so it can be altered, I load a form without a record source. The code for this form goes like this: Private Sub Form_Load() Dim strFelt As String strFelt = Me.OpenArgs DoCmd.Close acForm, "Adresser", acSaveYes...

I need to delete a field from a table via VBA. To close the table, so it can be altered, I load a form without a record source. The code for this form goes like this: Private Sub Form_Load() Dim strFelt As String strFelt = Me.OpenArgs DoCmd.Close acForm, "Adresser", acSaveYes...