Recent content by skoolz

The IIFs and Counts are in the report only.... the query runs ok and has no calculations in it. It's the report that has these extra calculating fields I created and these are the problem...

Thanks fro the response Minty, The count is not in the query, it's only in the report

Hi All, I need help with the following error I'm getting when I try run a report linked to a query. The query loads and works fine, however on the report I get the above titled error with the following calculated fields in the report. if I delete these fields, the report loads fine...

Hi Minty but I'm new to access and don't know how to create a recordset as you suggested. And exemplary code would be appreciated. Meanwhile i have tried my revised code below however when I try search now I'm getting the no records fine but even for valid search details i know records exist...

Hi all, i need you help with a record search code of mine which was and works on an earlier version of my database but not on this latest version I have had to redevelop and re-assign tables etc because I had made 2 initial fundamental design errors of saving text data to tables instead of...

spikepl, It is true that I'm a novice in Access hence why I was seeking expert advice and guidance on my flawed design. Thanks Gemma, I did initially post on UA due to low response I posted here and wasn't aware the two separate forums sites are one. arnelgp thanks for your advice, much...

spikepl, I used unbound forms to create a user friendly and intuitive UI and use cascading combo box selections and validation.... any suggestions or steer on how to create such a locking mechanisms?

Thanks ChrisTheIntern for you assistance which is more in line with the type of solutions I was after.... I have tried your last suggestions and get a runtime type mismatch error pointing at the line below intCount = DCount("dateAssessed", rs) Hope you can help.

Hi all, I have designed a database which I intend to split for multi-users to access from one front end icon on a shared folder at work. I have designed a form bound to cmr record table and on it a subform to another table where cmrs activities will be saved. The form has buttons to and blank...

Hi All, I want to do a unique count of dates when an activity was done in my table. The table may have multiple entries of the activity performed possibly on the same date by an individual e.g. table entries . approvalNoSys dateAssessed Activity 100 01/08/2015 Audit 100...

Hi Experts... Another help call and I must admit that I am impressed that 7 out of my 8 help posts have been solved by the contributors and Mods here so Kudos!! I have this code that has outbugged me... 1 full day messing with it so if I can't solve this then my project ends! Issue - I have 2...

I hear you loud and clear MarkK, luckily I was still at the brainstorming and creation stage of the tables hence why I thought I would test my approach thinking first and I got a informative response. I will set my tables according to your advice in which case I will be able to retrieve the...

Hi jdraw, thanks for the response... I know the Last() function or expression and that does not the context I mean. By last I mean the End (Latest) eg. Yr1 Yr2 Yr3 Yr4 Yr5 Rec1 Y Y Y Rec2 Y Rec3 Y Y Y Rec4 Y Y Rec5...

Hi All, Is there a way to write a code or query to find the last value in the last Field (column) of a record in a table? Or find the last field name that contains data, in a record? Thanks in advance.

1. what is the name of the control (not field) in your cmrOverview form which you want to compare with the approvalNosys field in your R_P_Data_P table? = approvalNosys (bound control name) or txtappNoSys (the textbox name) using either works. 2. what field type is the approvalNosys field in...