Search results

Hello all, I have created an access database that I export a query into an Excel worksheet and do a little formating and what not. Now I would like to do two things to the workbook. I want to create a toolbar and then add two buttons, one to sort the list by last name and another to sort it...

OK I know I should be able to do this. I have a form (Software Title) with two subforms what I want to do is have Subform1 (Software Version) change Subform2 (License Information). I have an unbound filed on my main form that changes according to what the ID for Version I am working with...

Hello all, I have a Crystal Report (8.5) that uses several SQL Stored Procedures, to build a report with 8 subreports. This report is for downtime, of course I do not know when the system is going to be down so I would like to print the report to a file at the top of every hour and just write...

I am working with this code to do an Audit Trail What I want is to get the TEXT for a combo box and not the (first) column. http://articles.techrepublic.com.com/5100-10878_11-6166807.html Const cDQ As String = """"Sub AuditTrail(frm As Form, recordid As Control) 'Track changes to data...

All, I have created an audit trail form my database, which seems to work sometime and then other times I just cannot figure why I am getting errors. The error that I am geting right now is Runtime Error 9 Substring Out of Range. Another error I am getting is Runtime Error 13 Type Mismatch...

Hello all, I have writen a report that shows all our active patients and some specific data for each patient. I have multiple sub reports and have the report grouped by the Unit then Room the patient is in. Once I was done with the report I decided it would be very nice to have a summary of...

Hello all, I have been working as a contractor for a small company for about 10 years now. I was originally asked to come in and help them with an existing database that was no longer working properly. I was able to fix there issue and over the years have developed the application into a...

OK here is my situation I have an Access Database that I store demographic and financial information about a client. I then have several queries that will export the data into CSV files saved into a folder with the clients name. I then have the below code that will look in a folder for the...