Recent content by iainm

My boss is trying to write a macro to export a query to a word document. He can cope with that just fine, but he wants to automatically generate the filename, based on today's date and a few other data items - I'm not entirely clear where those other data items are coming from, I think what he...

I'm trying to create a field for my tasks list which show the number of weekdays between two dates. This is what I have atm: DateDiff("d",[Start Date],[Due Date])+ 1 According to help, the appropiate interval to use is "w", but this is just counting the number of whole weeks...

I'm trying to create a very basic uder-defined field in outlook tasks to calculate the number of working days assigned to a task, given the start date and end date. I've set it up as type=formula and put in the following function: DateDiff("w",[Start Date],[Due Date]) According to VB...

I'm trying to write a formula to determine if text in one cell is contained in another cell. The romula I've built so far is =IF(SEARCH(G2,F2,1)>0,"Pass","Fail")If the text is found, Pass is returned in the box. If it's not found, #Value is returned. I've had this problem...

It's been a long time since I did any access work, and I can't remember how to do this, even though I know it should be easy. I've got two tables in concern here - one is a set of equipment records, and the other contains the history of those units. The equipment table has an EQ# (primary key)...

I just found it. it was obvious really. General;(General) -Iainm

I'm doing an accounting and finance course in which the lecturer requires us to format numbers by putting negative numbers in parentheses - I'm told this is a firaly standard acconuting practice. I've found number formats which put negative numbers in red, but not in parentheses. I tried writing...

I need to know how to say [Field]=Null or [Field]="" in a query. My problem is, I'm creating dynamic Filter strings using string concatenation of different fields to filter on (User enters Field, Operator, Data in a form and another form is filtered on this data), so if it is simply...

Guys, I've rather cleverly managed to lock myself out of my own database. I was messing wround with the startup options - trying to set it up so that when the user started the dtatabase they'd only get the main form, not the database window, the toolbars and menus etc that are available to the...

thanks

Couple of quick ones. I need a method to determine if one string is contained in another. Also, I can probably find this myself, but for the record, how do I get a simple Message/OK/Cancel-type dialog box? cheers, -IainM

thanks guys

Can anyone tell me how to tell if a given form is open in code? Was thinking there may be something like an IsOpen property, but that would give you an error if the form was closed. Is there a method that will accept a form name and return true if the form is open, like IsOpen(formname)? What I...

erm...could you give us some more detail? I've not got a good picture of what you're trying to do here

:) thanks mate. knew there had to be something like that.