Search results

I managed to work out how to solve the original issue the way i wanted to. I will attach an example of the result for reference later.

Has anybody got any thoughts, on if my idea in the above attached file is possible or not?

I have implemented your advice and it is running how it should,cheers. just as a reference I have attached an example which I will still work towards. IF you open the form it comes up with two prompts, eventually i will try and figure a way of having the date be the value for Tran_Date and the...

Thanks moke123, so this is an example of what I am trying to achieve, i should of done this earlier, my mistake.

Excellent I have caught on now, great thank you for the response

Don't be sorry arnelgp, you are being a great help. Exactly the batch number is already generated. the financials are stored in table 'trans_data' the batch number is stored in table 'batchnum' the table has the field for batch number called 'batch number' and field 'description' which...

Thanks NauticalGent The date in this case is only for reference and records, and this field will be used to filter reports. To reduce time time I have been asked to work on this. My idea is, that I have a data input form which is opened through a command button when clicked on, the user is...

Hi thanks I will test it out as soon as i get a minute. The final details of these formula's are still pickling me. I think i do need to include the filter expression because what happens at the start of the day we need to create three different unique batch numbers one for credit card, one...

Hi everyone, I have a form for input data, in this form there is a date field. For this date field I want a prompt to come up which ask for the date and then the date field is that prompt date. I can then add as many records as i want and that date field will have that number. So if my form is...

Thanks for the reply =Dmax("[Batch Number]", "Batching", "[Type]=Credit Card") For this code the credit card may not be the last batch number. Say there is currently 20 batch numbers. The last credit card batch number is 17. So i want this field to show batch 17, and then when a new credit...

Sorry for the late reply and the double post I have sorted and understand. I Have applied your code and mine looks like this Private Sub Combo174_AfterUpdate() Dim var As Variant 'change the FieldName, combobox name, Table name to what you have. var = DMax("[Batch Number]"...

Hi everyone, I need help with a project I am working on for a new job. Only been using Access for two days. I have been asked to create a database where we can input payment processing. One requirement is that when we input a transaction that the bank batch field populates. The bank batch field...