Search results

Try this, add a parameter field and call it from and change the type to date. Do the same again but call it to. Now in your selection criteria editor, adapt the following. {Yourdatetimefield} in DateTime ({?From},time(17,00,00)) to DateTime ({?To},time(07,00,00)) This will now prompt for...

I can cetainly help you with this but based on my Crystal version 10. There are few ways of doing this. Firstly, Are the dates to report on prompted, or would you like them to be prompted? Are the dates static, Ie, always report on this date and time forever? (probably not likely) Do they have...

This is because it is a product of the displayed data. No records = No Date to display. Is the date a pre-determined point in time? (eg, yesterdays date, or last weeks date)???

Are you using the full smtp address for the distribution list within your macro?

Thanks for the feedback. It unfortunately is to be used by people who would flag this up as an issue. I could always put some text in to say press enter or click off the cell. You would be amazed how many people would not read it though, as I have done a similar thing in the past.

if you're talking page numbers, look under special fields for "Page N of M". Drag this on to your report.

Hi all, My spreadsheet has 2 activex text boxes. When a user enters information into a normal cell outside of these boxes, then clicks on a text box to input more information, it doesn't allow this. You have to click off this cell, then you can select the text box. is there any way around...

Yes, I have the exact same thing on my db. the way I did it was by using an append query, with the record ID criteria pointing to what is open on your form, and only including fields you want to keep. eg. to keep the value. field = address1 table = Yourtablename Appendto = address1 eg, to...

Here is the code I used. Probably not the best way but it works. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = False And ThisWorkbook.Sheets(1).Range("AY11") <> 2 Then Cancel = True MsgBox "You cannot save this worksheet" Else...

Fixed it. Simply added value 2 as the flag to lift the save barring. Works a treat

I'm back again. I can't quite find the solution to this issue. I am using saveasUI to disable the save option, but I do have a scenerio where I would like the user to be able to save. It is all locked down in the code, so the user basically doesn't have to do anything different. I have a...

got it. used the above as a string, then put this string in the saveas method to trigger the full save as process. Thanks for your help. Kempes

thanks. I'll give that a go. also, I've played around with another save option for when i do want the user to save a copy. For this I used Application.GetSaveAsFilename, which gives the save window and looks like it has worked, but the file has not been saved down. any ideas?

sussed it, For anyone else struggling with this issue.... I have this code in now that saves their selection to coumn P. Dim i As Long Dim v As Long v = 0 For i = 0 To Me.listbox1.ListCount - 1 ThisWorkbook.Sheets(1).Range("P" & v + 1) = Me.listbox1.Selected(i) v = v + 1 Next i Then, in...

Hi all, Is there a way to tell excel not to prompt for "Do you want to save changes, blah blah blah"). I just want to spreadsheet to be closed without prompting. Many thanks Kempes

Hi all, I have a listbox set to multiselect. When users select one or more options and saves the spreadsheet, they are no longer selected when re-opening the spreadsheet. How do I get excel to remember what options were chosen when saving and re-opening? Many thanks Kempes

aha, yes. that seems to work. Many thanks for you help. I'm still a little puzzled as to why application.volatile failed, but this is just as good for me. Thanks again

It didn't seem to like that bit of code for some reason. I tried application.calculate and worksheets(1).calculate Nothing! I'm running out of ideas

I've done a bit of searching and found that by adding application.volatile into my function, it is supposed to recaluate with any changes. However, this now breaks my function, and the cell now shows #VALUE!. Taking this line back out and selecting the cell again, it goes back to the correct...

Great, thanks for your help. Any idea what the code is for refreshing the functions? I image I need to place this in the sheetchange part of the code. There is also one called sheetcalculate. Could I use this at all?