Search results
-
C
Form is Larger in Form View than in Design View
Made some minor mods... See what you think... Hope anything i Did helps... CJ- CJames
- Post #7
- Forum: Modules & VBA
-
C
Form is Larger in Form View than in Design View
Could you try something that works for me on sizing and positioning the form... Private Sub Form_Open(Cancel As Integer) DoCmd.MoveSize 9500, 5000, 4125, 2350 and then change these numbers yourself to size and position how you wish.. 1st arg is how far right to position...- CJames
- Post #4
- Forum: Modules & VBA
-
C
Access VBA Insert Into syntax check ? Okay - Not Okay ?
Excellent... Okay... So my assumption was wrong about using the SQL Server DB Query editor syntax... I was over complicating it... If I use the regular access vba insert into syntax it will GO INTO SQL SERVER LINK TABLE JUST FINE... (and which also would show the correct values in the IM...- CJames
- Post #5
- Forum: SQL Server
-
C
Access VBA Insert Into syntax check ? Okay - Not Okay ?
Hi PBaldy... thanks for your info... I forgot the dbfailonerror part of the execute statement... thank you for catching that gem. :o) Yes, i have used the IM Window to debug access vba query strings in the past and it works great but this is SQL Server Insert Into syntax and the immediate...- CJames
- Post #3
- Forum: SQL Server
-
C
Access VBA Insert Into syntax check ? Okay - Not Okay ?
I am rusty on Insert Into VBA code syntax to append records into a SQL Server DB TABLE from MS Access VBA code with a linked to SQL Server table for doing the inserts. I only get a little time on the Server Cloud desktop later in the week to test this... so I am trying to pre CHECK my code for...- CJames
- Thread
- Replies: 7
- Forum: SQL Server