Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LaurieHamlin

  1. LaurieHamlin

    More then one day's leave

    Even though this is specifically addressed, it doesn't show a reply, so in case you haven't gotten it to work try using a response box to get the number of days off. If the user enters 1, then it's just the day clicked on, otherwise it's the number entered. Hope that helps.
  2. LaurieHamlin

    Windows Printer Dialog How to get a value from the Ok button.

    I don't quite understand what you're doing, but maybe this will help. I've created some Access DBs that others use to print letters. I've created forms to show the data in the correct format (with a print button) and identical reports to actually print (without the print button). Good luck!
  3. LaurieHamlin

    Updating values in a table based on the combination of values in the columns

    I get combining fields to another field. I don't understand why if it = 111, 112 you would update it to 110. Regardless try an update query with a switch UpDateTo: Switch(combination = "9, 10, 11, 12", "8", combination = "111, 112", "110", combination = X, updateto this, etc.) I hope that...
  4. LaurieHamlin

    VBA to change Fore Color for designated table cells

    You would have to create a recordset from tblOutput and an array from tblTargetCells and loop through them.
  5. LaurieHamlin

    Excel Formulas: Links vs References

    It probably won't make a difference, but try formatting it to text.
  6. LaurieHamlin

    Excel Formulas: Links vs References

    Did you try formatting the cells?
  7. LaurieHamlin

    Excel Formulas: Links vs References

    I'm not sure I completely understand - did you copy the worksheet? I've seen this in formulas copied from one workbook to another. I just do a replace on the old workbook name with replace with field blank. I hope that helps you.
  8. LaurieHamlin

    Crystal Reporting

    Latoya, When you say active directory, do you mean the data source is on a network? Laurie
  9. LaurieHamlin

    Creating Calendar template

    I've never tried that in Crystal. I think you would have to create a record source with the year, month, week and day. Then create a crosstab. Good luck. Let us know if you get it to work.
  10. LaurieHamlin

    Form View's

    I don't have Access 2013, but I hear that it is very similar to 2010. In 2010, click on the top left corner of the form in design view. Open the properties for the form. For Allow Form View, make sure it's set to yes. Same for Allow Datasheet View. Set the other views to no. Sorry if this...
  11. LaurieHamlin

    Vertical scroll bar not showing up in a form

    Kalyan, Which version are you using? Laurie
  12. LaurieHamlin

    Access Query is too complex to run - error message

    Tia, I haven't tried running this so it still may not work, but I simplified it a little and added () to clarify. IIf(([BegTaxBasis]=0 And [Contribution]+[Distribution]=0) or ([BegTaxBasis]=0 And [Contribution]+[Distribution]=0) Or [Distribution]=0 Or...
  13. LaurieHamlin

    Open two recordsets and populate field in one table based on criteria from another

    I'm guessing that case_code is what you want to add to the Item Table and that there are 3 fields in the Item Table? Item Number Cube Weight Code You could also use an array. To use a recordset: Private Sub GetCode() Dim db as database Dim rs, rst as recordset Dim rscntr, rstcnt, rsLoopcnt...
  14. LaurieHamlin

    Copied form seems to be linked,unable to modify recordsource without reflecting in original form

    Kalyan, I've never seen that. I would try to repair the database. Then close out of Access. Then go back in and try it. I hope that helps. Laurie
  15. LaurieHamlin

    Hide Employees with no data from subreports

    Thanks for catching that LB. It's been a while since I inserted a subreport.
See more

Part and Inventory Search

Back
Top