Search results

Hello, I'm trying to make a query to look for value in my column called 'Category'. The text I want to look for is as follows, *Logical Application*. The asterisks are within the text it needs to find. However every time I try to put "*Logical Application*" in the criteria access changes the...

Hello, Is it possible to output the results of the DateAdd function as a string in a query? I'm currently using the DateAdd function to work out a date 6 months (Field Name: DueDate) from a date specified from another field (Field Name: ValidatedDate). I'm then wanting this to output a status...

Hello, I'm trying to get the last date of the previous month based on a current month. So for example if the current end month is 30/06/2018, I'd like it to return 31/05/2018. I have a text box called txtCurrentDate (Value: 30/06/2018) I then have a second text box called txtPreviousDate...

Hello all, I have a single table to which I'd like to update certain records. I'd like to update certain fields for these certain records. For example I'd like to update the 'DataClassification' for Record ID 001 to "Public" but then I'd like to update the DataClassification for Record ID 002...

Hi all, I have a table called tblAppInventory to which I upload data from Excel spreadsheets at the end of each month. The columns in my table and sample data are as follows: ID | AppID | AppName | AppDeveloper | CodeTestingStatus | NumbOfVuln | DataDate 1 1004 AppOne Internal Passed 0...

I have a crosstab query which I am using my forms record source. The query itself looks like this: Month | Low | Medium | High | Very High | February 2018 0 5 1 2 January 2018 0 4 2 6 I've used the statuses as column headers as that is what I wanted my text boses to be populated...

Hello all, I’d like to open a query from a form, and with that query filter the data from a series of combo boxes and text boxes. Either through an existing query or a new query. Is this possible to do? I’ve been googling it but I’m struggling to find something.

Counting records in query but returning a defined score rather than count value I'm in need of some guidance.. I'm currently constructing a query. At the moment I'm pulling AppID and App Name from the 'tbl_App_Inventory' table - I'm wanting to link pull a field [MissedSLA] which is a text...

Hello, I'm trying to use a Dlookup in a query. There is a reason for this (despite me knowing this is not the right way of doing it), but due to the data being premature and working through issues I'm currently basing my queries on imported data from excel. I currently do not have relationships...

I'm currently using a Crosstab query to be able to output statistics on a month by month basis. This is providing me with a count of statuses based on an inventory month by month. I'm going to be uploading my data from Excel on a monthly basis. I've added a field to populate the date at which...

I'm currently looking to build a new database for a new project I'm working on. At the minute I am in a planning phase for the tables. I'm ideally looking for some help/guidance so I can be planning correctly. My source data will be a series of flat file Excel documents that I will import into...

I've successfully linked tables from another access database into the database I'm building to utilise data already there. What I'm seeing is if I open one of those linked tables in my database, is the locked file icon/file (.laccdb) on the (external) database where I've linked the tables from...

Needing some help with the best practice with an approach to setting up some tables for a Product/Sub Product and Product Versions. I believe I’ve set it up wrong and trying to work out the best way to move forward. Some background information.. A Product can have many Sub Products but also...

What's the best method for exporting query results to excel? Through a search on the forums, it seems it can be done via VBA or via a Macro. I'd prefer the option to be able to export without having the save the file, so that the end user gets the choice to save the file or not. There is a...

Hello, I'm trying to use a query to pull a list of records where the date field ("NextDue") is within the next 90 days from today's date I've been using this as the criteria in my query: <=Date()+90 Results (Example): 01/06/2017 18/08/2017 This works but also pulls up dates that are in the...

Is it possible to change the font for one field on a split form? I'm trying to introduce a Status indicator (green or red circle). I had planned to use 'Webdings' front. The letter 'n' gives me the icon I'd like to use, then was planning to use conditional formatting to change the colour to...

I currently have two continuous forms. On form_A I'd like to link values in one column so that it will open form_B when the end users clicks on the link and filters the continuous form_B with value of which the end user clicked on from form_A is this at all possible?

Hi all, I'm having some problems with enabling/disabling a comboxbox control based on the result of a checkbox on the same form. I currently have a checkbox control (chkStatus) which is locked so that the end user cannot change it, I then also have a combobox (cmboDASStatus). I'm trying to...

In need of some help and guidance. I'm looking to create a dashboard form, I did anticipate to use the built in graph functionality to create this based on queries I had made. I'm currently having a problem with the graph functionality where I get the following "Automation Error Library Not...

Hello, I currently have the following IF statement =IFS(AF12>=TODAY()-365,"Green",AF12<TODAY()-365,"Red") This gives me... 1. If cell is less than 12 months old = Green 2. If cell date is more than 12 months old = Red I would like to amend it to: 1. If cell is less than 12 months old =...