Search results

Thanks! Changed to this tempweigh = rst.Fields("MaterialWeight") and it works now. Television

Greetings again! I have a following problem: I have a form in continuous mode. Users are supposed to filter data in it to their liking using inbuild filters in Access. After that there is a button that should calculate total weights in filtered records (at this point, I add more calculations...

Works now! Though I am curious why this code works but above one doesn't. Whats the difference between those two? Thanks again! Television

Unfortunately this code returns also a syntax error :(. Any ideas for correct syntax? Television

Greetings again! One quick question: Can in function Docmd.OpenForm its wherecondition be a boolean value (true/false)? I try to make button to open a new form on a click and show only records that are True in certain yes/no field. I have tried several solutions but nothing works then I...

You are probably right about normalization. Total pottery weights are located in their find unit table and finds are on their own table. Both table contains additional info. I probably should have put pottery weights to separate table in a manner you suggested and linked it to either unit table...

Unfortunately, that is not possible due to structure of out data :( (too long to explain). Fortunately our data amount is not overly large, so this DLookup function doesn't slow down query, where I use it. Thanks for concern thought. Television

That did it! Thanks again Eugin! Television

Greetings! I made a custom function to look certain value from table based on couple of criterias that it gets from query where I want to use it. Function's code is below: Public Function PotteryWeights(strLocusID As Long, nrPotSubID As Long) As Variant Dim priSubID As Long Dim...

This is getting stranger all the time. First I work couple hours with this problem creating new version of said form, trying different things and nothing works. Then I leave this problem alone and do other stuff and now my form is working as it should be. I really don't get it, but I guess this...

By using "Filter" option in toolbar. Yes, they are defined. Thanks! Television

Greetings! Strange problem again: I have a pretty simple form that includes subform. Subform's table is linked to main form's table with parent/child relation. Connecting fields are main table's ID field and corresponding field in child table. Subform is in datasheet view. This is pretty basic...

Thanks Eugin. My query indeed runs on parameter that it gets from a form. I didn't know that it would be a problem. I will adjust my code, modify Browne's code to accept more parameters and post results here. I will also edit my previous post to be more standard (after a meeting of course...

Greetings! I have a following problem: I need to concatenate fields in one of my tables depending of several conditions based on different fields in same table. Here is sample row from the table. NonDiagnosticsFindsMainTable ID: 7 LocusID: 2 LocusNr: 2.2 MaterialID: 1...

Thanks! Have to try this tomorrow at work. Television Edit: Worked as it should! Thank you again!

It looks that autonumber could be used to find additions, but CompositeFeature might be better since I am not 100% sure that autonumbers are same. It seems that CompositeFeature is actually unique (must have thinking other table). Find duplicate-query I just ran confirmed that.

I think that EntryDate would be best candidate to identify new records. Anything added since beginning of July 2013 are new ones. There are still some duplicates in CompositeFeature-field (these are old tables that several users have modified in different point of time and some of them were...

Both started identical and to both were made changes and records added.

Both tables are structuraly identical (fields have same names, datatypes, lengths etc...). Originaly both contained same information. My users have modified some of the original records (but not the same ones thankfully) and added new different records in their own version of database. Now I...

Greetings. I suppose I was not clear enough. Sorry about that. Its a one-off job and auto-numbers are not a problem. Data in both tables are based on same mastertable's data and both contain different modifications and additional records (different versions so to speak), so simple append doesn't...