Recent content by mrrayj60

thanks - I used a hyper link and that opens the exhibits for them, they see what they need and print it or email it - cool Ray

I need to print a pdf doc from this form - Whats the best way to show it to the user so I can tell them to click the button? The document is in a set location on our server so I can embed a exact path if needed Thanks Ray

Will access 2003 work on windows 10 pro without the jet 4.0 and I cannot get the jet downloads to install? I have not been able to get mine working Thanks - Ray

Thanks, method 2 worked for us and they are back up and running-Ray

Is there a way to tell the autonumber field to use a specific number next. Somehow my numbering jumped from 5259, 5260 etc to 16314512, 16314513 sequence. Because these numbers are so high even deleting the records does not let me go back - I fear the only option is to export and re-import the...

New method installed but still leaves a blank record. Here are 4 snips from my form and table - as the last photo shows its a new record automatically numbered. Thanks for all the help - Ray

I get the confirmation request, Do you want to delete 1 record? click yes and the record is deleted but it always leaves a totally empty blank record that I have to delete...its always done this so I am finally tired of it looking for the answer - Thanks Ray

The delete button in my form was installed using the command button wizard. When I delete a record it deletes the record but leaves a blank record and then I have to go and delete the blank record too. Is there a way to delete a record and not leave a blank? Thanks in advance - Ray :banghead...

Awesome reply, that did the job perfectly, thanks again - Ray Dear Brookridge Homeowner, We have received your consent to online voting and you may now go to www.ballot.com and register to vote on the 2017 Budget. You will need to enter your First Name, Last Name, Street Address Account...

This form button will send an email to this persons email address, its under onclick event-I would like skip a line or two and then add txtfirstname, txtlastname,txtaddress,txtaccount to the last part of the email, they are part of the form...any suggestions? DoCmd.SendObject acSendNoObject, ...

My form has this after update code. Well my users are adding spaces in the tag number and makes it difficult to sort. They appear as ABC 123 instead of ABC123. Any suggestions? Thanks, Ray Me.License_Tag_Number = Trim(UCase(Me.License_Tag_Number)) Thanks, pbaldy Private Sub...

Isskint, Well how about that a report in a report, great idea. Thanks for all your help. Looks great, works great. Thanks for all your help. Ray from Brookridge a homeowners association. :)

Thank you Isskint, I created the reports for each shift using the # to get my shifts, thanks. I have never made a report that has other reports in them. I will browse the forum to locate that but if you get this can you point me in the direction, Thanks Again. Ray

My report gives me the total records created by date. Manager wants to broken down by shift entries. My table has a field createtime. Ive tried toying with this grouping in the report but no luck. =DatePart("h",[createtime]) Using it in a query gives me zero records. Should I be looking into...

I have a button that opens outlook and puts the forms email address in, click send and everything is good. If I close the email without sending it gives me a runtime error 2501 The SendObject was cancelled. It's only a problem if I do not send an email. Any thoughts? Thanks, Ray Private Sub...