Recent content by LaurieHamlin

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.

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!

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

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

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

Did you try formatting the cells?

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.

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

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.

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

Kalyan, Which version are you using? Laurie

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

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

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

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