Search results

Sorry isladogs Function showFile() On Error GoTo ErrHand Me.CmdFile1.Visible = True Me.CmdFile2.Visible = True Me.CmdFile3.Visible = True hideNav On Error GoTo 0 ErrHand: Err_Hand ("showFile") Err.Clear End Function Function hideFile() On Error GoTo ErrHand...

So these get called from the various button such as: Private Sub CmdSearches_Click() hideFile showSearch hideActions End Sub For the navigation button: Private Sub CmdAction5_Click() On Error GoTo ErrHand showNav On Error GoTo 0 Exit Sub ErrHand: Err_Hand...

So here goes Function showFile() Me.CmdFile1.Visible = True Me.CmdFile2.Visible = True Me.CmdFile3.Visible = True End Function Function hideFile() Me.CmdFile1.Visible = False Me.CmdFile2.Visible = False Me.CmdFile3.Visible = False End Function Function showSearch()...

bugger the code toggle didn't work one second

F unction showFile() On Error GoTo ErrHand Me.CmdFile1.Visible = True Me.CmdFile2.Visible = True Me.CmdFile3.Visible = True On Error GoTo 0 ErrHand: Err_Hand ("showFile") Err.Clear End Function Function hideFile() On Error GoTo ErrHand Me.CmdFile1.Visible = False...

Hello All, So my boss has decided to give me some layout advice (poke his nose into a support database) and wants to bring things in line with the latest thinking of MSDN before roll out. To that end I've had to remove the majority of the buttons used for normal database things and add them to...

no problems

Hi Jason thanks for the offer, it has been decided to leave the idea of editable PDFs behind now. many thanks Cliff

Hi Pat Just thought I would update you on this as I know a lot has happened. Finally the boss man has agreed to put the DB on citrix and he has completely abandoned the idea of editable PDF. (mainly thanks to me ignoring the requests). You mentioned a bat file for the FE could you post it to...

Welcome Brother

Thanks Pat

good idea, thanks

@CJ_London I used the wrong button, I used the [ ] button then couldn't figure why it didn't post correctly. Once I saw the </> button I realised my mistake. I will make sure in future that I post correctly. once again many thanks

@CJ_London that has worked a treat thank you very much, I knew I was missing something but couldn't see the wood for the trees

CJ CJ Thanks for that, It mainly works however, I get a few days with 0 in it at the beginning of the year and one in November. I seem to remember it was something to do with the date format yet again..oops missed the format thing in your post

Got it

Public Sub FillTextBoxes(frm As Access.Form, theYear As Integer) Dim db As Database Dim rs As Recordset Dim ctl As Access.TextBox Dim strMonth As String Dim intMonth As Integer Dim intDay As Integer Dim FirstDayOfMonth As Date Dim intOffSet As Integer Dim IntRec As Integer Dim ActualDate As...

Sorry Gas Man the tags were there when I sent it. I'll re-do it

Hi All, I know this sounds easy to do but let me fill you in on this. So on my tech support DB I have a calendar form, gratefully taken from another (sorry can't remember who). I want to populate the small Green text boxes with the number of Tech support calls we have had in the particular...

Thanks Pat, I'll have a look see shortly. I used a package called SSE Setup to create the demo version of the database for the boss man, it installed it in a TechSpport Folder on his PC and put a short cut on the desktop for him. I've been plugging away for about 2 years now about Citrix and I...