Recent content by sseawright

Nevermind, I figured it out. For anyone interested here is my code: Scanned_Image = "There Are No Scans Linked to this Record" NewLateralNumber = DMax("[Lateral_Number]", "tbl_Lateral_Location_Sheets") + 1 DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70...

I have a database with a table that uses a numeric field as a PK. If I use the built in "Duplicate" Command button on a form it creates an exact duplicate of the record, which then Access won't allow because the PK is no longer unique. Does anyone know of a way that I could make the number...

Thank you...I knew it was easy but I've just been looking at it for so long that I just couldn't come up with that answer.

Ok, this may have been asked before but I havn't been able to find it. It seems like a simple problem to me but can't seem to wrap my head around it. I have a table that is my control source in my form. In the table there is a town field and a municipality field. On the form I want to select...

Thanks for your help...I figured something out. Did a different method. I designed a new form that was formated how I wanted to print (like the report), added a few if statements to the form_load function, and created a macro to open the form in print preview mode. My Code: If Text25...

Your probably right. I'm actually using the tab control on a form but want to be able to print the form using a report.

Ok, I'm new to this forum so forgive me if I'm posting something that has been discussed before. I'm having a problem with a tab control in a report. What I have is a Control with 4 tabs. Only 1 of these tabs will have information entered in it at any given time. How can I display (on the...