Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: AllanBertelsen
- Content: Threads
- Order by date
-
INSERT INTO from crosstab adds spaces
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...- AllanBertelsen
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Runtime 3211 - Locking problem
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...- AllanBertelsen
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Runtime 3211 - Locking problem
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...- AllanBertelsen
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
