Search results
-
B
Has the forum been hijacked?
Not only was the forum hijacked now this thread has been as well :p Peter- bat1799
- Post #27
- Forum: Site Suggestions
-
B
dateadd not calculating properly??
Between [Start Date] And DateAdd("m",3,[Start Date]) Works for me :) peter -
B
dateadd not calculating properly??
not tested, but the way SQL handles dates you may need between #01/07/2005# and DateAdd("m",3,07/01/2005) How are you going to get the dates in to the query? linked from a form or is this a VBA sql? Peter -
B
Someone has hacked the forum :(
I may have only been here for a year but I have enjoyed my participation and will contine to try and answer question :) Peter- bat1799
- Post #25
- Forum: Site Suggestions
-
B
Delete Excel Sheet And Then Add New One
I have had some time to play with the code again :) Try this Sub DelXlSheet() Dim xlApp As Excel.Application Dim wk As Excel.Workbook Dim xlSheet As Excel.Worksheet Set xlApp = New Excel.Application Set wk = xlApp.Workbooks.Open("C:\MyFile.xls") xlApp.DisplayAlerts = False... -
B
Short cut to insert text
Try Private Sub YourControl_KeyDown(KeyCode As Integer, Shift As Integer) Dim intShiftDown As Integer, intAltDown As Integer Dim intCtrlDown As Integer ' Use bit masks to determine which key was pressed. intShiftDown = (Shift And acShiftMask) > 0 intAltDown = (Shift And...- bat1799
- Post #3
- Forum: Modules & VBA
-
B
Someone has hacked the forum :(
Bat1799 Formerly Bat17. Same/similar problem here. If I am not logged in I get in OK but if I log in with Bat17 I get an empty page returned - <body></Body> This new identity seems to be working normaly at the moment though, but I would like my old name back! Peter- bat1799
- Post #19
- Forum: Site Suggestions