Search results

If I use the combos to populate the fields, I get the error message. If I manually enter the wrong dates, I get the error message. I I manually enter the correct dates, I don;t get the error message and the form works

Hmmm, thats odd. I also have a combo box on the form which also populates both txt boxes with the financial year dates, if I populate via the combo box then I get the error message about the date being incorrect, whereas if ienter the dates manually i dont get the error

Hi all, hope all is well during this Pandemic! I'm having an issue with an Unbound Form whereby there are two text fields. StartDate and EndDate which are manually filled in by the user before pressing a command button which runs a query, both fields set to short date, all standard stuff...

Thanks CJ for the information. The way you have described makes the whole process so much easier to read. I'll bear that in mind next time I'm doing something similar

Excellent. Both options seemed to work. Bloody brackets and quotes!!!!

I am trying to send an email to participants who have Confirmed Booking. A Confirmed Booking is a Booking whereby the Participant has PAID and sent in the PL Documents. The email should only go to those people who have not been emailed already. strSQL = "SELECT tblParticipants.PName...

That's perfect, many thanks for that. Thanks too fr the heads up on the code writing

Confirmed: IIf([tblbookings.amountpaid] Is Not Null And [tblbookings.plreceived]="Yes","Confirmed","Not Confirmed") Yes the field names are correct, this works in the standard query, returns what I need it to do.

Thanks... Where are you putting that, as Im still getting sytanx errors etc

Thanks for that. I now get a runtime error 3075 detailing this (((tblBookings.EventID)= " & [Forms]![frmBookingReport]![EventID] & ") AND (Nz(tblBookings.AmountPaid,0) =0) OR tblBookings.EventID= " & [Forms]![frmBookingReport]![EventID] & " AND tblBookings.AmountPaid>0 AND...

Have used this string successfully now to send emails out to participants who haven't paid. Basically, the table hold Event Bookings for each participant. In order to class a Booking Confirmed, the Participant needs to have paid AND sent in their Public Liability Insurance Certificate. What i...

Many thanks for your answer too.:D

Excellent. Many thanks for that.:D

The textbox is being populated by the combo box via a query

Hmmm thats odd. Heres a working DB then which does add the data to the table.

Hi all I have been working on a Stock / Inventory Database which is fairly simple for my requirements. I have an unbound form with a Combo Box populated via a query. The form displays the stock levels taken from the query / combo box. Also on the form are four fields that allow me to enter...

Excellent, that works However, I was using the dbopendynaset as I want to place a flag in the tbleBookings to show that an email has been sent and what date it was sent. I was using the .Edit to update the recordset with the the flags

Excellent, that works However, I was using the dbopendynaset as I want to place a flag in the tbleBookings to show that an email has been sent and what date it was sent. I was using the .Edit to update the recordset with the the flags

Hi Thanks for that I have changed the underlying queries SQL and now get a data mismatch in criteria expression EventID is an Autonumber

Hi All I have created a database that allows for the emailing of a standard message to multiple email address via a module and VBA code. This creates a recordsource from a query. All work well, however, if I add parameters to the underlying query, I get a RunTime 3061 error too few paramaters...