Search results

Very good points... I'll start looking into it soon.

Okay, I've solved this now, thankyou for your replies :) It looks like it was struggling while it was trying to recognise what I wanted it to do, so I clarified it by adding in even more parenthesis. Calc %w/w: IIf(Nz([%w/w],0)<>0,[%w/w],IIf(IsNumeric([Assay (mg/ml)]),(round(([Assay...

I'll have to look into that, though those field names are exactly what they should be description-wise: the access database I'm creating is for a big medical / healthcare organisation and this is where they will be storing all of their data once it has been migrated. My point is that they might...

Hi Neil: Do you mean special characters as in the "%" and "/" signs? Isn't the punctation a necessary part of the IIF() and round() functions? I'm sure this was working for me at one point too... maybe something else is interfering with it... looks like I'm going to have to try debugging it...

My query seems to be playing up, and I'm not entirely sure why at the moment. Can anyone shed any light on this matter? I have a query which is constructed from a table containing the following fields: %w/w Assay (mg/ml) Calc %w/w The third item (Calc %w/w) is the following: Calc %w/w...

I've implemented the two-subform in a test for now, but the three-second time lag while it's switching and updating still annoys me a little (perfectionist? me?) I'm switching it in code using the subform's sourceObject.

Hi Pat, thanx for the reply, but that's not quite what we meant. Basically we have a form and subform. The subform is in datasheet view. We have 2 columns in the datasheet that we want to be hidden and inaccessible until a particular button is clicked on the main form. It looks fine doing this...

Okay, I think I've finally got it sorted, though it is a bit of a messy-looking solution (but only because I know what the code looks like). It does seem to be working perfectly, after a lot of debugging.

Has anyone ever had any luck synchronizing multiple combo-boxes? I've played around with the two-combo-box functionality, but it isn't suitable to my needs. I'm attempting to use 4 combo-boxes and it's really starting to mess with my head now. I'm not sure if I'm complicating it more than it...

I have a main form, attached to which is a subform. When a new record is created in the subform that record has it's [Data checked by] column blank. The [Data checked by] field is locked intentionally. I want to be able to update it in code which is easy enough to do, but only when the "Checked"...

Thankyou for replying :) That wasn't entirely what I was looking for, as in form view I'm fairly certain you can just use the record-selectors to select all of the data. The idea of changing between views didn't really fit my needs, but after a lot of searching and some work I've managed to...

In a subform I'm attempting to highlight an entire row with formatting if a particular field is left blank. I've looked at most of the similar posts about this sort of problem and the general consensus seems to be that you can't do it in datasheet view, but you can do something similar in...

Unfortunately what Stephen Lebans has done can't be applied to the record-scrolling idea because: I've been looking at this problem recently too, and so far I can't find much that can be done. Oh well...:(

Having a lot more success now. Just in the nick of time too!

I'm attempting to automate a rather large report that my database needs to be able to produce. I'm also attempting to adapt the "Table of Contents" functions from the Microsoft Knowledge Base, but can't work on it more until I get my current problem out of the way. The report will be...

I've been working on this problem for quite a while now, so any insight that anyone can offer will be gladly received. I've looked through at most of the posts with a similar vein in them, but none seem to really address what I'm looking for. I have a main report. In the first section is the...