Search results

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...

Hi Pat the fillable PDF was the Boss's idea not mine, he has changed his mind since he got a small demo DB. I'm leaning more towards Citrix. So the process goes... 1. We are contacted about a camera issue/problem 2. I log the details on my db 3. if it can be resolved it is closed on the db. If...

Hi Pat Sorry I didn't tell the whole story. I packaged up a sample database that installed a small backend, Runtime Access and the front end for my boss and the Operations director, who now have changed their collective minds and want the database rolled out. I'm looking into the best way to do...

Hi Pat Potentially everyone who has access to the DB will create a PDF. I think the boss is coming round to just using the database. I'm in the process of getting the information about Azure vs Citrix server together for him

Hi Pat thank you for the response, I will look into the full version and if the boss wants me to have it or not. Thanks for the advice Cliff

Hi Gasman I have normally completed them but I thought it was to do with the way they were saved and distributed

DBGuy I'll have a look at your site today, many thanks

Hi Pat Thanks for that titbit of info. I thought if it was editable you could enter data into the fields. I don't think my boss wants to pay for everyone to have the full version

Hi DBGuy thank you for your quick reply. I do indeed have a standard form which was based on a paper form the technician filled in by hand. The CEO wants to have an editable pdf created. I have pointed out that with the database the technician can have restricted access (already built in) and...

Hello all I have a database that looks after our repairs and technical support logging. My CEO wants one of the reports to be exported to PDF but it needs to be editable. My question is: does anyone or has any one done similar? created an editable pdf file from a report or the query under the...

an Ex Girlfriend of mine asked me the very same question, my reply: "No bigger than usual"... now you know why she is my ex ;)

Hello Martin Welcome to the forum

Hello and welcome to the forum.

Thank you arnelgp for your help. That is a lot better than I had the user had to press Ctrl +P to print it off

Ah, bugger yes you do indeed