Search results

missing reference The missing reference is Microsoft Office XP Web Components... I just deselected it and it seeems to work fine!! Thank you everyone for your help! Much appreciated! Krys

ok... I can get to references... and from the list of available references... what do I choose? Thanks!

cannot find Project/Library Sorry everyone, thank you so much for your help. I'm very new at VB so i'm not entirely sure what to do... I've tried using the Format function but it highlights 'format' and says 'cannot find Project/Library'.. when I look at the help menu, it says to look at the...

Thank you... I was thinking that could be the case... what a punish!

Hello! A quick question about dates... In a rate_date field, I store the value '1/8/2004' as in 1st August 2004 (well... at least that's what I thought it was storing). When I write a simple select query like... select pay_rate, rate_date from PayRates where pay_rate = 'marking' and rate_date...

day/month swap Thank you for that! I think I may have found the real problem. In the rate_date field, I store the values '1/8/2004' as in 1st August. When I write a simple select query like... select pay_rate, rate_date from PayRates where pay_rate = 'marking' and rate_date = #1/8/04#; ->...

still problem :( Thank you both for your replies! The problem is that it is finding BOF and EOF when it shouldn't . So - if I select a pay rate of 'marking' with a date '9/09/2004', it seems to work and find the correct amount of pay... if I ever select a pay rate of 'marking' with a date of...

just one more problem with that Thank you very much for your help... It seems to work for the first one.. then I get a: 'Run-time error '3021': Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.' Below is the code...

Hi! I'm having a 'type mismatch' error in the following SQL statement in my VB code... stSQL = "Select [AmountPerHour] from PayRates where [Pay_Rate_ID] = 'marking' And [Rate_Date] = Me![Rate_Date] " After debugging I can see that Rate_Date holds the value 9/09/2004 as does Me![Rate_Date]...

Thank you!! That did work! :D

Hello...help!! I have a table 'PayRate' which has three columns - payrate, date_changed and amount - payrate and date_changed are both primary keys.. In another table which keeps a record of pay called 'paydetails'.. I also have the keys payrate and date_changed... payrate here is a lookup on...