Search results for query: *

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.

So the field only has more than 1 date if the length is > 10. If the dates are always entered in that format (2 digit month, 2 digit day, 4 digit year), you can just use Left({DepositPostedDate}, 10) and Mid({DepositPostedDate}, 12, 10) and Right({DepositPostedDate}, 10). If not you'd have to...

In the main report, in the Section Expert for the section where the employee name is, open the formula editor for the suppress box. In there enter IsNull({subreport1Field}) And IsNull({subreport2Field}) And IsNull({subreport3Field}) etc. for each subreport (Enter the actual sub report names.)...

In Adobe click on File, Save As, Reduced Size PDF. In the Dialog Box select the most recent version that it must be compatible with. The farther back you go, the larger the file will be. I have complex reports that aren't that large. Without seeing the report that's all I can suggest.

This depends on the OS version (operating system) you have. Basically open control panel and search for "color". You should be able the change the colors of various objects. I can't be more specific without knowing your OS. I hope that helps.

Dim ctrl As Control Dim cntr as Long cntr = 0 For Each ctrl In Form.Controls 'this goes thru each control in the form With ctrl Select Case .ControlType Case CheckBox 'if the control is a checkbox If .value = -1 Then...