Search results for query: *

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

Answer I needed is here: thread702-1606331

Okay, I managed to get a good answer to my other thread, wthout having to update a table. So thanks, but don't worry about this one. I appreciate you guys looking though. Will

Yes!!! I till can't "see" how the Sum works here but not with the IIf, but it does and that's all I need. Thanks so very much. I jut need to do one for Discount now and I should be good to go. Thx, Maj! Will

Hi, And thanks. In short there is an A-Level project (an old one, not current) that I am working on as a project for my Post Graduate Teacher Trainig qualification. Everyone on the course is having trouble with this DB task, but I took it upon myself to work it out (which is what I love to do...

Wow, thanks MajP. This all looks straight forward. My plan with using the IIFs was just to get a quick solution. I am guessing you had a quick look at the work in progress, and the reason there are a few tex boxes on the subform was because I was experimenting with different ways until I could...