Search results for query: *

Cheers for that! :)

Hello, I've been doing a lot of Crystal development recently and I'm rather curious why depending on how I order an "Or" statement depends on the results produced. I have a Running Total Field doing a count that evaluates on a formula that does some date comparisons. If I use...

Actually ignore me. I see the previous thread has some example code that's pointed me in the right direction!

Hi all, I've been creating an Access VBA db where I work purely for myself. I now need to let others use this database. My problem is that I need some users to only have read only access to the db, others to have read only access to some tables but read/write to others and finally some to...

I need to include the working days but =NETWORKDAYS(cellpos1,cellpos2) does the trick! I knew it'd be something simple! :) Thanks for the help!

Probably mind bogglingly simple for some here but I'm struggling to work out the number of days between two dates. Surely there's a very simple neat way of doing this?

A quick check on the online MSDN shows the problem and solution: http://support.microsoft.com/default.aspx?scid=kb;en-us;178510

Hmmm... I now get a new error when I run the project for a second time! :) "Run-time error '9': Subscript out of range" And it debugs to your Windows("oletest.xls").Activate code. Now I understand this error in a "normal" coding sense but with regard to OLE I'm...

Splendid! I found the thread and it works a treat! Cheers!

I'm pretty new to OLE Automation so bear with me! I'm intending to create a complex Excel spreadsheet that I want to pump values from Access into on a cell by cell basis. I've created a quick Access VBA test project that opens my .xls file "oletest", changes focus in Excel to...

As I suspected then. Thanks to all for the advice!

The list is actually an Access Form listbox. Apologies for not be clearer. You cannot use Conditional Formatting on the listbox.

It's as I suspected then. "but another approach that could solve your problem would be to incorporate a subform with each member of the list as a different object. These fields would respond to conditional formatting and you could use code to insert the selected item as appropriate.&quot...

No I never knew that existed. However, whenever I select the list "Conditional formatting" is always greyed out. If I select any other objects (Combo Boxes etc) "Conditional formatting" is available. I suspect I cannot conditionally format a list box.

I'm currently displaying about 100 items in a list that is populated via a SQL statement. These are the condition of certain items. I now want to be able to colour the items in the list depending on their condition. I.e. Green = good, Red = bad. I'm beginning to suspect this can't actually be...

I'm currently displaying about 100 items in a list that is populated via a SQL statement. These are the condition of certain items. I now want to be able to colour the items in the list depending on their condition. I.e. Green = good, Red = bad. I'm beginning to suspect this can't actually be...

I've just solved it! But you pointed me in the right direction. I need to say: Form_ReplaceObsoleteColumns.List19.Selected(0) = True and then examine the contents of the column and row. Thanks for your help!

Again on trying: sTemp = Form_ViewObsoleteColumns.List1.Column(1,1) I get the same result. Everybody here who's seen the code have all uttered the immortal phrase "But that should always work!" so my code's probably doomed! :)

Hmmm... now it gets even more interesting. I've cut the code and form down to the bare minimum. I.e. two buttons and a listbox. Button one performs the SQL lookup that populates the listbox correctly. Button two does the: sTemp = Form_ViewObsoleteColumns.List1.Column(1) I get the same results...

I posted this on the Microsoft Access "Other" messageboard and it didn't generate much of a response to something that is really confusing me! Anybody here able to give me some help? :) Using Access 2000 I have the following code on a button click event: sSQLString = "SELECT *...