Search results

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...

Thanks for all the replies all. Very helpful!

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...

Hi Minty, Thank you for that graphical representation! It certainly helped! I see what you mean now about the listing of the product ID's twice. It makes more more sense seeing it visually. I can see how this would work and how I can then I can query for information as well. I cannot thank...

Thanks Pat, Your example has helped to make it clear. I see how it becomes complex trying to split them out which I believe is why I am hitting problems on how it should work. Essentially I need to be looking at one table called Products that would include the following: Product_ID |...

The sub products won't be a main product. With a single table do you mean all information in one table, so remove the Sub Product table and linking of products and sub products? (Apologies I'm just trying to double check I'm following correctly). Also I'm not sure I understand the requirement...

Hi Minty, Thanks for your reply! On your first point, I could use...? Products (Table Name) Product_ID (PK) Product_Name Product_Version Sub_Products (Table Name) Sub_Product_ID (PK) Sub_Product_Name Sub_Product_Version Product_And_Sub_Products (Table Name) Parent_Product_ID Product_ID (FK)...

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...

I've managed to get it working using the following... =IFS(A1="N/A","N/A",A1="Not Approved","Amber",A1="unknown","Red",A1<=TODAY()-548,"Red",A1<=TODAY()-365,"Amber",TRUE,"Green") Thank you so much for your help!

Thank you! This has worked perfectly!

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...

Minty, as always you are a true star! Not sure why I did not think of that to start with, thank you so much!!

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...

Thanks so much Minty! It works perfectly! Thank you to you both!

Apologies for the delay in replying. Thanks for your post, it's almost working. At the moment I am getting a pop up to ask me for a value. Does it need an extra set of quotes? As I hadn't previously mentioned this is for a text field not a numeric field

Thank you both, you've been so helpful. I'll look to change my design on a couple of my forms to be able to do what I'd like to do with it. Once again thank you!

Thanks CJ, I like having the split forms as the datasheet part makes it easier for filtering the data with the inbuilt filters. I think I may need to change the design of the form though to achieve what I'd like to do. Is it easy to apply filters to a continuous form? Would what I'd like to...

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?

Thanks for all your help Minty and everyone else that as contributed! Appreciate all of the help and support!