Recent content by WillShakespeare

Thx - I always want to know what I'm doing wrong in first place... fits the bill perfectly! win-win! ;) Or rather 2 wins for me... :) Will [morning]

Of course... I post the question, then manage to find the answer on my own!! =VLOOKUP(A2,Sheet2!$A$2:$B$15581,2,FALSE) Will [morning]

Sorry if this has been dealt with before - my attempts at creating a suitable search phrase to fins info on this failed. Right - I have 2 worksheets. They have common values in the first column. The 2nd worksheet simply has this common code and some product codes in the 2nd column. Example...

Worked it out... Here is a link to a great article, including a comment post that shows my ported code. The article was in C#, but I ported to VB, then got it working. Code Project Will [morning]

Hi all, Was wondering if anyone has any experience using OAuth - but NOT with one of the libraries available! All I want (or rather my boss wants) is to be able to send a tweet t=from a webpage. So all I need is code to build a web request, perhaps header too (or more than one?). Then send the...

Cool,thanks. I knew how the events worked, just wasn't sure how to pass Job_ID, etc. and to handle the cancelling part in the Sub. Your reponse showed this perfectly. Will

knew it... ;)

Well, someone may well come up with a better idea, but I just tried to following to test passing the avlue between controls. 1. I created a small table called "Month_Names" which has 2 columns: Month_ID (Byte) (prime key) Month_Nme (Text - 3 chars) 2. In ID I listed 1-12 3. In Name: an, Feb...

Just had some great help, so attempting to give a little back to the community. I am not sure if your typing is a bit off or you may speak English as 2nd language, but your request is a little unclear. I am thinking you have a list of months as buttons? That someone clicks and you want to run...

I was justadding this to test, but I am not sure what to put in Before_Update. Do I simply call the Function? Will JobID and FittingDate be available to the Before_Update Sub? I had thought last night that I should use the Form, and have tried a couple of things, but this certainly seems to...

Thanks Guys, that makes sense. I needed to put JobID outside of the string, or the value doesn't work. doh! Anyway, as mentioned before I don't know how to do the reverse, or test for deleting fitting from the job. Honetly though I am just trying to make it work nicely. It's not a requirement...

Of course I just realised that fitting would be checked, but if Ftting is removed from the order later on, I would need to update again to False... but how would I do that? sigh... ;) Anyay, if any ideas, pleaselet me know. It's only a minor problem now. Will

Okay, I am having a go at inserting "updateFitting(JobID)" before Fitting value is set at 20. The function is here: Public Function updateFitting(JobID As Variant) Dim strSql As String, Db As dao.Database strSql = "UPDATE Jobs SET Jobs.Fitting=True WHERE (([Jobs].Job_ID)=JobID);"...

Awesome, thanks! By the way, does anyone have any suggestions how I could handle Fitting option on the main form? You see Fitting is one of the Products in the Job lines. What I would like to do is if the person entering the Job data selects Fitting as a product, then the "Fitting?" checkbox...

MajP, I discovered a little problem, which may be ralted to your warning about Error handling. When I run the Jobs form, if I add "Fitting" (ProdID 6) as a job line to an existing order it throws an Error 94, not able to handle Null correctly. Here is the code it highlights (the Case "sq m"...