Recent content by jysharp2003

Hi, I have a customer application that needs to detect and query return records that do not have the largest value in field. Example below: field value is 1.1.1.1 where in another table there is a value of 1.1.1.1.1 that should be in it's place. I think that maybe a query that detects period...

I heard a bit that starting Access 2010 allows report for drag and drop of report to form. My app is a scheduler so having the clean report for display (being dynamic up to date too) would be valued. For now only the button and pop up allows my clean report for display and the sub form option...

Hi DBguy, Thanks for the time. Can you post the steps for your recommendation above please?

Hi all, I have a form below (Emp Scheduling tool) that would really look good if a schedule (currently in report format) could be embedded to the side. I did get a static image of the report but was hoping that it could be displaying current schedule records. Read only and users would click a...

Gasman/Ridders, Thanks for your time. dkinley has some good code and found my issue. Thought he said replace .fields with the column name but leaving .fields and adjustment the number defining the column to link to was the fix. Email works I think since my Mail program is linked to GMAIL and...

Thanks Gasman. Error form/box (displayed in .jpg) is all I get when trying to use DKinley code here. My code adjusted to my query (UNION) and column values are pasted below. Thanks for giving a shot at this. ++++++++++++++++++++ Private Sub lbl_selectGenEmail_Click() Dim MyDb As DAO.Database Dim...

Code from DKinley is found with search on ID 775884. He must be retired.

Hi, I am trying to use some code from DKin (new member and not at post count to insert link at this time but can email it to you) but coming up with error. Checked all required fields but code results in object required. Curious if this code works with a UNION query. Any help would be...

HI everyone, Can't find it and wanted to poll everyone to make sure if there is an easy way to do this. I have an Access database on my C drive that has an ever changing schedule for employees. Rather than send via email I wanted to create process in Access to save the new version of schedule...