Recent content by CupKat

Hello Access World Forum! I have two queries I’m trying to combine into one, but I’m having some trouble. q1 summarises days worked per contractor per billing month as per the information provided by the client. q2 summarises days worked per contractor per billing month as per the information...

Thank you both for taking the time to help! It's really interesting to see different ways of approaching the problem and the thinking behind it! I am going to have to play around with it a bit to see what's going to work best for my setup.

Access noob here :) I have a form for worker timesheet information, with a continuous subform for entering days worked in a specific period. The subform has a period start date and a period end date, both currently manually entered. Most, but not all of the time, the period start will be a...

That provided a bonus learning opportunity - I now know that I can copy just the structure of the database without any of the records - I was worried I was going to have to go through and delete all sensitive information in order to share it! Very useful in case I need to ask for help another...

That did it! Thank you ever so much for taking the time to help! :D

I have attempted to do a copy attached below, hopefully it has what is needed!

Forms!FrmClientINVOICES_MAIN_4!FrmClientINVOICES_SUB_4.Form!Contracts_Combo4.Requery

Will a series of screenshots do? Adding first invoice, all good: Second invoice, still all good: Going back to view first invoice, contract dropdown now blank: Clicking first invoice subform dropdown now gives options based on most recently entered main form client: If I go back and...

SELECT Tbl02_Clients.ID_Clients, Tbl02_Clients.Trading_Name, Tbl01_CONTRACTS.ID_CONTRACTS, Tbl01_CONTRACTS.ContractsKey, Tbl01_CONTRACTS.Client_Rate FROM Tbl02_Clients INNER JOIN Tbl01_CONTRACTS ON Tbl02_Clients.ID_Clients = Tbl01_CONTRACTS.Client_Trading_Name WHERE...

The row source for the main form combo box is: SELECT Tbl02_Clients.ID_Clients, Tbl02_Clients.Trading_Name FROM Tbl02_Clients ORDER BY Tbl02_Clients.Trading_Name; and the subform combo box: SELECT [qry04_ClientINVICES_SUB4_Contracts].[ID_Clients]...

Hi, access newbie and first time poster here! I have a form for entering invoice information. In the main form you choose a client from a combo box, and this filters options in a combo box in the subform to only show contractors currently placed with that client. After trying various ways of...

Hello, and thank you for allowing me to join your forum! I live in the UK, and I work for a small business that has used an Excel spreadsheet for years to run all the checks and balances. I have taken on the task of trying to make an Access database to replace this spreadsheet. I'm new to this...