Search results

I'd say that your query is not build according to your requirements ;) RV

Seems to me that you're turning company issues into yours. You will be better of to leave them for what they are (as it's not your problem), start seeking backup or get yourself another your. And yeah, IT projects tend to take some time ;) RV

Not sure which environment you're using (Access or SQL Server or whatever). Anyway, you're using non-existing data types. For instance, Access doesn't have a varchar datatype. SWL Server doesn't have a datatype memo. Rv

How did you try? Post your query including the Nz function. RV

He's still an unknown quantity though :D RV

Glad to help ;) RV

How 'bout PARAMETERS [spSubSystemHours] Text ( 255 ), [UserEntry] Text ( 255 ); UPDATE tblSubSystem SET tblSubSystem.SubSystemHours = [spSubSystemDetails]&UserEntry WHERE tblSubSystem.SubSystemDetails=[spSubSystemDetails]; RV

Paul, any data you put on a tab page relates back to the record source of your form. In other words, what you're trying to achieve is not possible. Your request doesn't make sense, as your tab pages should only show related data. RV

Open your form in design view. Open the Properties window. Select the Format tab page. Set the property Is Hyperlink of your text box to Yes. Add a Double Click Event to your text box, add code which is: Application.FollowHyperlink Me.nameoftextbox RV

Use this as an expression in a query column: IIF(Day(JoinDate)>15, DateSerial(Year(JoinDate)+1, Month(JoinDate)+1, 1), DateSerial(Year(JoinDate)+1, Month(JoinDate),1)) Could be that you need to replace the comma's by semi colons. RV

The answer is LEFT JOINS. Here's what your query basically should look like in SQL. You'll need to use the Nz function on each SUM plus some sort of formatting to reflect your calculated amounts in the appropiate format. I'll leave that up to you ;) SELECT tblSalesinfo.SaleRefID...

Actually, your English is quite good, as is quite common for Dutchies ;) BTW, there is an excellent forum in Dutch that deals with Access, Excel, Word, to mention a few. Check it out : http://office.webforums.nl/forum/index.php RV (also proud to be Dutch :D )

You'll need to write a function in VBA. Have a look at the Randomize statement to generate randomized numbers. Or search the forum. RV

You need the # signs in VBA to identify your variable as a date string. RV

Search the forum, questions on time and date calculations have been asked before 'bout a zillion times ;) RV

Use the After Update event. RV

Put this code in the On Open event of your form: Me.[Invoice Date].DefaultValue = "=#" & Format(Date, "dd-mm-yyyy") & "#" And put this code in the Before Update event of your Invoice Date field: Me.[Invoice Date].DefaultValue = "=#" & Format(Me.[Invoice Date], "dd-mm-yyyy") & "#" RV

Seems like a bit of overkill to me ;) This will do fine: SELECT T1.* FROM MyTable AS T1 WHERE EXISTS ( SELECT * FROM MyTable AS T2 WHERE T2.mfr_num=T1.mfr_num AND T2.catalog_code=T1.catalog_code ) This statement will also run a bit faster ;) RV

Have you checked upon the control box name? And oh, next time post your thread in the appropiate forum ;) RV