Search results

I will stop in the office tomorrow to verify the line. From my memory, on the Form_Load event, it would run Private Sub Form_Load() NewRequisitionNumber = LNewRequisitionNumber End Sub or something similar. This is where the error would start. I had a backup, non split database I used...

Hi All, On this lovely Friday just before leaving for the weekend, I began getting a run-time error, cannot be a zero-length. After about 30 minutes, I isolated the problem to the linked table named [Codes]. If I import codes to the front end from the back end, the vba behind the form works...

As I am still researching, I wanted opinions about a theory/idea that my company is trying to move forward with. We have a 2003 MS Access database in which they want to make into a web database. They would like to also implement SQL Server has a holding ground for other locations. The main goal...

what code are you using now? are you attempting to send a report or capture the form in a pdf?

Thanks Bob! Easy to understand and replicate. One question, in a multiuser environment, by checking the box “Do not show again” will one users action of clicking effect every user who may not have logged in to see the update form? For example Steve signs in first, checks the box to do not...

Thats fine, I will take a look. I am more of a visual learner and need to see it in action to apply it. If you get a chance, great, if not I understand.

I have been searching for a working sample of this but with no luck. Do you have something similar to this posted on your site or can direct me in the right direction. Thank you

Bob, I have a follow up question. I know this idea would need to be done prior to copying the accdb and recreating the accde file but is there a way to include an update message when the user first logs on to the new version. Say you wanted to quickly highlight the version changes such as...

Thank you. Seems to be working for me right now. Great website by the way! http://www.btabdevelopment.com

Ok. Basically I copy and replace the LRSBudget.accdb. Update the table version numbers. Then delete the LRSBudget.accde in the shared folder. Recreate the accde. And relaunch the desktop icon. If those are the right steps, it is working for me. I changed the file name because I am...

Running to a problem when i change the version number and relaunch the application. My database: LRSBudget.accde was the desktop file for the user. LRSBudget.accdb on shared drive F:\Novermeber Test LRSBudget_be.accdb on shared drive F:\Novermeber Test Code: See below, but it is located on...

In my search input, you can enter a date, name, or file number. I would not be able to enter an input mask. For my example, I was specifically focusing on the file number. Hope that helps.

Thank you for the reply but this only focuses on the first column’s information and doesn’t handle spacing. For example, in your table, if you were to change the first record to [A 100333 ],(a space after the A), and the second record to [A101999888], it wouldn’t find both records by entering...

I was wondering if anyone has worked with John Big Booty's dynamic search. The search itself is great but was wondering how can you show the results if a user misses a space. For example if I am searching for A 201 999 888 but I enter A201999888, it will not display results. Actually if I...

The code works! But still brings me back to post 7. When I search, I open my form [FRM_SearchMulti], double click the record and open to [ReviewI216]. I click the command and run the private sub MY216Email. If I cancel that action, save and close the form, double click another record from...

Email Report to Pdf Bob, I did some searching and came up with the below. The first time I ran it, it worked perfect. Now when I run it, it pulls every record instead of the current. Any suggestions? Private Sub My216Email_Click() Dim appOutLook As Object Dim MailOutLook As...

We use Outlook 2010

Thank you! I was wondering, can I take the existing code and use it somehow for a different command for an email making the file name appear correctly in an email? If so where would I edit that in my code? We have the stReportPathName, could we use something similar in the naming for the...

Thank you for the help. When I added the updated info, I generated a Compile error: Syntax error on the line. This represents ReportCapture.png. I then hit enter after the end of the line ....& ".pdf" and it generated expected: end of statement, represented in 2ReportCapture.png, any...

I was reading different links on how to save to pdf and pieced it together! Plus I enjoy your responses as you are yelling at me lol! The file name isn’t extremely important but if we can go specific! I’d like the report name to be [NFTS]_[Report]-[NFTSID]-[Short Date] = NFTS...