Recent content by jj72uk

If you refer to post #1 my code shows Dim xteam As Integer xteam = InputBox(Prompt:="Team Number Please.") Which ties in with the " & xteam & " within the SQL code

Ahh!! I tried something so similar to that.... How would I then set this to a sub forms record source? I've tried: Forms![frm_NEW_consultant conversion].RecordSource = strsql And attaching it to a command button but it doesn't even give me the input box?!

Hi Bob, Thank you for the time spent looking over my question and answering it so well. I've tried the code and get a compile error. I didn't write the SQL i made the query up in access, which I know works, and then just looked at the SQL to put it into VBA to allow the user to input a...

Sorry, that just flew over my head. Can you expand a bit more?

Hi All, Been scratching my head and trawling through google for the last hour with no luck. I have a SQL query written for VBA but due to the length it covers more than one line: Sub refreshform() Dim xteam As Integer Dim sSQL As String xteam = InputBox(Prompt:="Team Number Please.")...

Hi All, Hope you can help me out here... Currently I have a VBS which when ran runs a macro in an Access database. My current VBS is : Option Explicit dim oaccess set oaccess = createobject("access.application") oaccess.opencurrentdatabase "C:\temp\qm data storage\Audit - TCF Master...

Hi, Looks like it could potentially work, its worth testing

Hi All, Just looking for some assistance.... I have an access database which has an autorun which sets off before my team gets in in the morning using autoexec and schedualed task. The database goes through to almost 60 small databases (under 3mb each) and appends to a master table in the...

Hi all, Just looking for some wisdom and help. I currently have a report which has a field that has this formula: if((({GF_CALLDETAIL.CALL_TYPE})=3 or{GF_CALLDETAIL.CALL_TYPE}= 4) and (isnull({GF_CALLDETAIL.DIAL_DIGIT}) or length({GF_CALLDETAIL.DIAL_DIGIT})<3)) then 1 else 0 This works...

What I mean is that the forms were designed on one screen resolution and when opened on a smaller res the forms do not fit the screen, so i am needing something to resize depending on screen rez. I've tried the shirnkerStrecher from peter's software, but couldn't get it to work. So I've tried...

I have done this but still the forms do not down size if the res. is decreased. The forms are still big looking and one has to use the navigation bars to scroll around the form.

Ah! That makes a lot of sense and works perfectly! On a side note. Is there an easy way to resize access forms easily. In this project particularly the calender form and the main booking form. Dependant on the systems display settings?

Doesn't the =date() control source use the system date? I tried to trick the system by changing this, would this emulate it being 2010? This didn't work. I just did what you suggested. Though it will now display the next years entitlement it pulls up a VBA error. I Made the dteCurrent...

Sorry to bring this up from the grave but I am getting a couple of issues. I have manually amended the entitlement table to include entitlement for 2010 for the managers. I then go and try and book holidays for next year for the system to tell me they have no holiday hours remaining. I'm...

Ah i thought it may have been a typo :P I;ve got a problem, but I think its my fault. I thought I'd test the DB to see if it worked for 2010. So i changed my system date to 1 jan 2010, went into the DB to book a holiday. I had to intially set the entitlement, which is to be expected, but...