Search results

This is perfect thank you! It works! :)

I have a query that pulls a list of vulnerabilities. In that there is a column called "TicketState". The value is either, Open, Resolved or it's empty. I've got a where clause in the query to not show anything that is resolved as the list on the form is for open tickets. However I've noticed...

Thanks! Although I didn't think it was possible to have a SQL statement assign to a text box?

Hi, I'd like to be able to count the number of records between two sets of dynamic dates using an expression as I want to display this information in an unbound textbox on a form. I have a column on a continuous form that shows "FirstDetected" as a date. I'd like to count the number of...

Got this working with putting the text part at the front and the following with the numeric. =DCount("*","qryUnionVulnAssets","[TicketState] <>'Resolved' AND [Severity] = 5 AND [AssetID] = " & [txtAssetID])

'#Error' which flashes on the form, as though it was on a loop. I've checked the data type for 'Severity' and it is correctly set as a number.

How many criteria can you have with DCount? I'm now trying to do the following but not having much luck. In summary I'd like to count a row if the severity is 5 and the ticket status is not equal to resolved whilst matching it to the AssetID. I've tried the following but it throws back an...

Thanks Plog! Got it working with that link used the following as the control source on the form - thanks so much for bearing with me. =DCount("*","qryUnTestSev","[AssetID] = " & [txtAssetID])

Forgive me, I thought DLookup was to look up a value? The union query doesn't pull a total number of rows. It lists all rows where the Severity matches '5' for example: An asset can have many vulnerabilities each scored either a 4 or 5. So the union query is pulling back 2 rows for two...

Hi Plog, Yeah the query pulls the correct results, 2 rows as I have put one row of Sev 5 into two of the tables. The problem is trying to get these row as a count into a textbox on a bound form (the form is not bound to this query but another one) but matching the count to the asset ID on the...

Hi plog, 1. The tables don't have the same columns, hence why they are separate. They have between 10-20 columns different, I didn't want to list them all without it become to long. I apologise I should have been clearer on that. 2. Again the column name in the Vuln tables is just called...

I'm trying to count rows that equal a value from 3 tables linked to another table and I'm having trouble. I have the following: tblAssets AssetID | IP Address | Asset Name tblVuln_A (Relationship 1-M from IP in Assets Table) VulnID | IP Address | VulnTitle | Severity (Number 4 or 5)...

Hi CJ_London, 'FullSupportUntil' is a field on a bound continuous form. The form itself is based on a union query which is joining 4 other queries. I've had to use padding of the FullSupportUntil field on queries 2,3 & 4 as the data isn't available in those tables only query 1 relating to...

I have a date field on a pop up form "frmOSRecords". This displays the listed OS's against an Asset. I've added a conditional format to change the textbox that displays when the OS is in full support until to fill red if the date is in the past. However it seems it will only full the textbox...

I've fully understood the union part of the query and in addition the padding out of the cells now after some time playing around with it. I've also go around having a different form with the different columns by using the padding and then adding an expression to state which source table it is...

Hi Ranman256, Thank you so much for your reply and input on this. I've read your reply a few times and I feel it makes sense. Query each list and use a union query to bring those together, that way it will look up the search value across all of the tables. When you say to pad out the...

Hello all, Is it possible to to use a query to search for a value in a text box on a form and look it up in 3 different tables and return the results from the one table it was found in? I currently have a database to hold information on assets. I have an assets table and each area of the...

Thanks for your reply minty. It seems the issue was relating to an if statement I had wrapped around it. I fixed the issue in this code and all worked correctly. Thanks so much for your help!

Hello, I'm currently having an issue in getting a list box to requery once and edit/update has been made to a record. I'm using a subform 3 levels deep - I currently have a main form called frmMain (which is a Navigation form) frmMaintainLists (NavigationSubForm) then finally an unbound...