Access Receipt Generator

[smithj14]

I am working on an access app that will generate receipts for clients who pay our company. I am stuck on two things.

First: I want to increment a receipt number automatically without using AutoNumber. I have a seperate table "RECEIPT_NUMBER " with a field "RCPT_NUM" to hold the receipt number value. I have my main form and table "RECEIPT" with a field "Receipt_Number " that needs to pull the last used receipt number and add 1 to it for the new receipt.

Second: I am trying to print a report based on a date range. I tried a few of the examples online but none worked.

If anyone could lend a brain I would be greatly appreciative.

[missinglinq]

Here's a general example:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then
 If RecordsetClone.RecordCount = 0 Then
  Me.RCPT_NUM = 1
 Else
  Me.RCPT_NUM = DMax("[RCPT_NUM]", "RECEIPT_NUMBER") + 1
  End If
End If
End Sub

This assumes that your receipt numbers are Numerical datatype. If they're actually Text post back and I'll show you the slightly different syntax. I've also placed this code in the Form_BeforeUpda te event. Because of this the number will only show up after the record is saved, but it's neccessary to place it here for a multi-user database, so that two users starting a record don't generate the same number. If this is a single user database, you can place the identical code in the Form_Current event and the number will show as soon as a new record is started.

Welcome to Bytes!

Linq ;0)>

[NeoPa]

For the Date Range issue, check out Literal DateTimes and Their Delimiters (#).

This also depends on exactly what you're intending to achieve with this. Again, post back if you need more help.

PS. It's generally a good idea (and we prefer it so) that separate questions are posted in separate threads. It just makes it so much more straightforward to deal with them.

[smithj14]

Date Range issue:

I need to print a report that shows all the receipts created for a certain date range. It could be for one day, two days or for the whole month. I can get the prompts to ask for a date range if I use a query but would rather have two txtBoxes to enter the dates I need to filter by. When I try it now I am getting the report to open but no data displays.

[NeoPa]

...When I try it now I am getting the report to open but no data displays.

WHAT are you trying?

How can we possibly help if you keep the question so secret?