Search results

Thanks Pat Hartman, dkinley and Rabbie for your replies. - I've used the DLookup solution and it works a treat. - I do have referential integrity in place (Client has a one to may relationship with the Booking table) but using DLookup means I can use my own msgbox. - Regarding the query...

hi there, I want to put some code behind a 'Delete' button on my Client form that will check whether an associated Booking record exists or not. If it does then then form will return the message: "Cannot delete Client as associated Booking records exist." The two tables Client and Booking both...

My form has buttons to open a report for records with [Date of Appointment] either: 2 months ago, 1 month ago, current month, next month or next month +1. The report it opens is based on a crosstab query that contains the [Date of Appointment] field which is a Date/Time field of format Medium...

I've now read up on cross tab queries and created one for my report and it all works a treat. Very straightforward. **Thank heaps** for pointing me in the right direction - I've been scratching my head for a few days over this one. I've some filtering issues for when it loads so I'll probably...

Hi there I want to build a report (based on a query) and think that using an array is the best route except I've not done one before. The report is to list the days of a month down the first column. Each subsequent column is to hold diary details for an individual clerk (which are held in my...

Thanks Mailman & Missinglinq - that's exactly what I was looking for and my code now works great! Catherine :-)

Hi there, I'm looking for some code to get a value of format 'Month YYYY' for this month, this month +1, +2 and this month -1 etc., then put it into a caption, but will be using it for other things too. I've tried the following: Dim Month1ago As Date Dim Month2ago As Date ... Month1ago =...

Hello! I have a print button on several forms that has the following code behind it: DoCmd.OpenReport strDocName, acViewPreview, , strWhere This means that a report version of the current form opens in Print Preview and the user can right click the report to print/ email as attachment/ export...

Thanks Gemma - I've downloaded Microsoft Snapshot viewer and am using your solution for my all my reports and it works - except for one of them that has subreports. I'm starting a new thread for that. Many thanks again - I've learned (& continue to learn) so much from this forum. Catherine

I've used the defaultvalue property to achieve the same thing when moving to a new (not next) record from a current record. Assign the current value to the default value property within Form_Current and within After_Update of the fields you want auto-filled. Then within Form_Close re-set all...

hi there! I've a print button on my form that prints a report version of the same current form. This works fine. I would like now to add another button to the form that opens the email editor with the report version as an attachment. Since the email recipient is unlikely to have Access...

I need this code to be after the delete because the value I want to pick up is on the subform record previous to the one deleted.

Thanks for your help. I've made some design changes to accomodate the subform undo issues and used the Delete coding that you suggested. It almost works ok now, apart form one field that I want updated straight after the delete sql runs. The odd thing is my update code works fine if I step...

I'm struggling to get my Delete Query to work. I want to delete records from the Booking Status table where the Booking Status Date is blank. The Booking Status Date field is a Date/Time data type. Under the criteria of the QBE I've tried = " " and Year(Booking Status Date) <2006. This gives...

Ok, I understand now how the subform record becomes saved. Are you saying also that changes to a subform record therefore cannot be undone, only the record can be deleted (using your air code)? Thanks again

Bob, Its not the main form record that I have a problem with - its not being able to undo any subform changes thats my issue. What do you mean by delete query? Catherine

Hi there! My form is based on a Booking table. This form has a subform based on a Booking Status table. The booking table has a one to many relationship with the Booking Status table. I've coded a 'Close' button on my main form which asks the user whether they wish to save changes or not. If...

How do I delete a subform record from the main form using vba? Thanks in advance! Catherine

Thanks Bob and Paul, I've done as you both suggested and my issue is solved! - Catherine

Hi there! My report lists appointment records for inventory services at rented properties. Each record contains several pieces of information. When two different criteria are met simultaneously for a record, I want to change the font colour for that particular record to red. How could I do...