Search results

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

jzwp22, Have come across a bit of a problem! I'm entering some historical sickness/compassionate leave and it seems to be taking off the managers entitlement so now some managers are in the negative! I've checked the checked boxes so it shouldn't count on there entitlment, i'm guessing...

Indeed....maybe I'll start looking into the tables....making tables is the easy part.

ideally what you illustrated would be spot on, but far i think its a bit much for me. I could make the tables and make a fair go at the queries. Which would feed into a list box on the calander when a specific day was clicked. What I then thought of doing was just making a button at the start...

Ahh i see now, sorry i didnt realsise it was actually in the tbl. My mistake! I guess all i need to do now is to re import the data from my current db into this one. My intial though of just creating a report for the manager to click on to see what rota is for that week won't work, as when...

lol..the requirements only change as the upper management sees it, likes it and thinks, can we add this, can we do this, how about this etc. I'm sure you have expereince this before. In its entirity these last chnages is all that would be needed. Though I cannot see a check box. If we keep...