Search results

Thanks June7. I know there is no relationship- the subform is there to find a respective filtered record from a 'reference' table to apply to the record as circumstances warrant. The database will be used by myself to cost items- so I'm not looking for something awesome, but rather something...

Sure thing. I put together a quick example database which shows a sample of one of the subforms. If you load the frmMainTable, you will see a subform which requires parameters to filter and get the respective cost. For example, if you select, Box type = Non Standard, Box Size = Small and...

Yes I understand that. But some of the subforms are like calculators, which don't store a value for each record.

Hi all, I have a form with a couple of subforms on it. These subforms have a summed total amount which I want to populate an entry in the main forms table. For example, let's say each subform on the main form contained a summed total for Widget A amount (on subform 1), Widget B amount (subform...

Thank you arnelgp. I understand the reason, but never heard of Tempvars! Really appreciate it. Will look up Tempvars to try and learn more about it.

This is definitely worth a look- thank you for taking the time to share the link. I know it was a long shot but for some reason I suspected something to do with Windows/Access- hence reinstalling. This is worth looking into too. You never know.

Thanks The_Doc_Man. I did import items- so I think I did it right according to what you just said.

This is awesome bastanu- as a rookie I've never seen or heard of this. I tried doing a google search but clearly I wasn't searching for the right thing. Thanks a lot for posting the link.

Awesome Pat. Thank you for your generosity is making that available to try. I will give that a go in combination with George's approach.

Thanks GPGeorge. That sounds like a smart and methodical approach to try and isolate the issue/s. Thank you for your input.

That's a great idea. I didn't try that with a new database to isolate whether it's this database or something with Access or my computer. No worries, I have so many backups of the database in various folders now, after days of trying to isolate the problem at various points. Importing the...

That's a good idea Mike- thank you. I haven't tried that yet and if honest, was trying to avoid it! But it does sound like one of the next steps.

Hi arnelgp, For some reason when I applied this to my actual database, I keep getting: "The expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the...

Hi all, I seem to have multiple problems with my new local Access database (Access 2010) with behavior's I can't explain. My main problem right now is that for the strangest reason, I can't even copy and paste a copy of an existing form (I've tried to do to use for testing purposes to find...

Understood. Thank you for explaining this to me. (y)

Awesome- Thank you arnelgp. I didn't think of trying to use a query for it instead. Just curious (for learning purposes), in your query, the criteria of "IIf(Len([Forms]![frmInvestigationSample]![cboCategory] & "")=0,[ID],[Forms]![frmInvestigationSample]![cboCategory])", what was your logic...

Hi all, I've got a combo box on a form and after the user selects something, I want the corresponding details on the subform, but I'm getting a reference error in the After Event Code. I've been trying to follow this example...

Thanks so much for that. I've never used the Nz function.

If the syntax looks correct to you guys, then it seems like there's something I'm missing with the data types that's possibly the problem- so I'll attach a small sample of the database as I see without it, it would be difficult to answer. @theDBguy: The fields are currency/numerical based...

Hello all, I've been working on an IIF statement on one of the controls on my form and for over 4 days I can't seem to figure it out- so I thought it's time to reach out for some fresh minds and ideas. :) Happy to provide more information if required, but I didn't want to bored people with...