Search results

Hi all, I have a table with numerous records in a access table in the following format: Debtor_AC_No PIM_No Trade_Name Premessis_Type Bin ID Bin_Size_ID Emptying Cost Bin Cost CollectionNo IndivCost Rental Trade Rental S2 00177847 PIM:01154 The Bank Trade - Bins 979 T 140 £2.80 £27.50...

Hi all, I have been trying to use a query with an expression as the control source for a continuous form but all I get back is the dreaded #Name?. The query itself is, Collection Costs (individual) and im trying to use it in my Bins subform to show the total cost of a bin collection. I use...

Hi all, Simple one today, I have a form with financial information in, namely how much a service costs and how many times a year the service is required. To get the total cost I simply multiply the service cost by the service requirement using a function box. However I have found that the...

Hi all just trying to expand my knowledge of group by and other such functions so I can get useful information from my data and I would appreciate some help. The attachment shows a sample of data I'm working with, just two columns to start; Bin ID & ID. My aim, to count the Bin ID's but to...

Hi all, As the title says I am trying to open a form (as a pop up window) from inside another form. For context the main form is called 'Trade_Waste_Address' and the form im trying to open is called 'Notes'. Each has their own ID field called 'ID' & 'NoteID'. Im attempting to call up the...

Hi all, I Have a database for bin collections and I need to know the total number of collections for each bin. The code below works and return the sum of all collections for all bins with a Size ID of 1. SELECT DISTINCT SUM (Collections) AS Total120 FROM Bins WHERE (((Bins.[Bin Size...

The title says its all, how can you mere peasants call out such a work of art. It is clearly beyond all of you, future generations will remember your folly!

Just spitballing here. I have a database with records being added and removed frequently as people come and go. I was just wondering if there was a way of logging or keeping track of how many records are deleted without having to keep their associated data? Ideally I would want to have a...

Hi all, im experimenting with collecting data via email. I have used the wizard to creat a functional email that dose what I need but I was wondering if there is a way to make it look.... better is probably the best word. All it is at the moment is a long list of the fields that I have...

Hi all its me again. Before posting this I have done a good bit of reading on the issue, even looking in to some of the older posts on this site but nothing seems to work this far. (Namely these posts/sites: https://access-programmers.co.uk/forums/showthread.php?t=195350...

Hi all you Report wizards :D im trying to learn more about reports. Specifically the expression builder. *Context I have a database for Waste removal (bins and stuff) and I want a report that tells me how many bins of a particular size we have out currently. The database I have has a "Bin...

Evening All, I have ben working on this for a little while now trying a few iterations and this is what I have so far. Sub Yearly_WTN() Dim Day As Integer, Month As Integer Dim CurrentDate As String Day = Day(Date) Month = Month(Date) CurrentDate = Format(DateSerial, dd.mm.yyyy)...

Hi all, I'm new to VBA and trying to use it to make my job a bit easier while learning something new. The problem I am working at the moment is trying to get certain rows of my Excel sheet copied in to a different sheet automatically if a value in a certain range is the correct date. Here...