Search results

  1. R

    Access VBA Code to create a toolbar in Excel

    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...
  2. R

    Make a form run off of a query?

    Ross, I would make the table with all the months a many table. Add a field for month and year and remove your totals. Then on the sub form have a header with all the titles of the fields with the field under it. The fields that total we can put a formula in to add or preform what ever...
  3. R

    Make a form run off of a query?

    OK in that case you could have the record source for the form look at cell phone and in the criteria section make is is not null. However I would still take the billing or amounts in a seperate table. In the new table you do not need to have a field for totals or any fields that calculate totals.
  4. R

    Make a form run off of a query?

    Bowks14, Well, there are a few things I can see. Are you wanting to use a drop down to move to a record? Using a query can lead to the form not being editable, so you really only want to use a query for display reasons. To so this you would have an unbound combo box in the header or top...
  5. R

    Form with 2 Subforms

    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...
  6. R

    Access FE with SQL 2005 BE!

    Are all the machines the same? Are they all connected to the network the same way? Does you form have any queries on it? Is it one form or a for with lots of sub forms on it?
  7. R

    Access FE with SQL 2005 BE!

    So when you open the table is is fine, but when you open the form with that recordsource it is slow?
  8. R

    Access FE with SQL 2005 BE!

    Is this when you open a table or query?
  9. R

    Access FE with SQL 2005 BE!

    As Bob stated above when not connect to the tables via an ODBC connection? Are you trying to open a form and at that time create the record source? So in your tables you have nothing?
  10. R

    Scheduled Printing

    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...
  11. R

    Audit Trail

    I am WANTING to put in ComboBox in the code above I can get value but that would only give me the ID and not the text. I guess I can try .value.Column(1) and .oldValue.Column(1)
  12. R

    Audit Trail

    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...
  13. R

    Access FE with SQL 2005 BE!

    Are you having issues? I have not done this but I do work with SQL 2005 and Access? I might be able to help.
  14. R

    Subscript out of Range, TypeMismatch, what am I doing wrong!!

    I checked and I do have D dimed as a control. It is the first line in myHistory. I was hoping it was going to be that.
  15. R

    Subscript out of Range, TypeMismatch, what am I doing wrong!!

    OK I added the two additional controls, I cannot believe I missed them. Here is the coed I have now Case acTextBox, acComboBox, acListBox, acOptionGroup, acCheckBox, acOptionButton ' Skip Updates field. myValue = D.Value Now I am getting a...
  16. R

    Subscript out of Range, TypeMismatch, what am I doing wrong!!

    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...
  17. R

    Supress Footer

    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...
  18. R

    Creating user login with access

    It is working great now!! Thank you!
  19. R

    Creating user login with access

    I did try that, but it did not seem to work. Let metry it again. I am now working on updating the form to know what group the user is in and then i will check if the tag is read only depending on what group they are in. I will let you know how it works. Thanks again for you help!!! The tag...
  20. R

    Creating user login with access

    Bob, So if I place "lock" in the tag property of all the fileds I want to lock and then I add your code it will turn the property for each field to Locked=Yes? Wouldn't I need to have an If Statement? To check if the controls tag property has "lock" and then set the Locked Property to Yes...
Back
Top Bottom