Search results

I'm pretty sure you won't need exit sub, as I believe once it satifies the case criteria, it won't carry on checking the remaining... However, what if your value exceeds 14500? You'll need to pop a case else and the end, which will take care of all other scenerios! Select Case test_expression...

try if isnull(me.invoiceno) then etc....

Hi, For starters you have omitted the word "else" between each IF, and I don't see an "End if", which there should be one for each if. However, rather than using multiple IF statements, try Case. Example Select Case me.test.value Case Is > 10 me.result1 = 5...

The PL/SQL statement should be something like SELECT DISTINCT dp.ekipmankod, dp.tanimi ekipman, mst.tanimi ekiptiptanim FROM tbldp_ekipman dp, tblmst_ekipmantip mst WHERE dp.ekiptipid = mst.ekiptipid or SELECT dp.ekipmankod, dp.tanimi ekipman, mst.tanimi ekiptiptanim FROM tbldp_ekipman dp...

Looks quite complicated, but will trawl through it and give it a go. I appreciate the response!

Hi, I've been playing with "activeworkbook.fullname" which gives me the file path, however, if the file is opened via a mapped network drive, a drive letter is displayed rather than the full UNC. Is there a way to force the UNC to be displayed no matter what method it was opened by? Many...

Unless I am misunderstanding the question, the only way to eliminate the blanks on a cross tab would be to pull your column header into the row header, so both attributes are rows, then the column will be purely the total by row. This should only show the relevant data then as it won't be...

is it only in the cross tab that you don't want zeros, or the whole report? If it's the whole report, you can use the select expert to filter the zeros out of the report data selection.

Yes, it is possible. I know of 2 ways depending on how you use it. 1) Add a section to your report in Page Header. Add a text label to say there is no data. Then in section expert for this section, suppress if records exist, otherwise show this message. 2) Under report/Alerts you should be...

Ah yes, Forgot to mention. Add a field for client ID. (Mine is hidden) before your code unhide it, and set focus. me.clientid.visible = true me.clientid.setfocus then your find code after this. (don't forgot to hide it again afterwards if that's what you want to do)

OK, I need help again. This works fine for me, however, the spreadsheet is in UAT now so others are running it, however, at the point it says "Something is trying to send an email on your behalf.....", this message hasn't got focus and hide behind the spreadsheet. However, it runs OK for me...

I've done this before, and if I remember right, you need to change your combo box to 2 columns, Hide the first. The first should be the record number, the second would be what you want it to display. (Client name). Now, after update, enter code docmd.findrecord yourcombo.value, which should now...

Think I've got it. Activesheet.activexcontrol.activate Seems to work OK.

Hi, I have some code that sends an email, then should display an excel message, however, once the email has been sent, the focus no longer is on excel and the taskbar application display flashes. I have to click back onto the spreadsheet to display the message and continue. Is there a way to...

There's a good chance it is taking time into account too, although displays as a date. Try using DateValue(yourdatefield)

I didn't know that! Well worth knowing. The before_close event did the trick by the way.

Thanks for the advice.

This is the jist of it. Application.DisplayAlerts = False If Range("AY11") = 1 Then Range("B2,B4,B6,B8,B10,B12,B14,B38,B40,B42,B44,B46,B48,B50,B52").Value = "" Worksheets(1).Unprotect Password:="xxxx" Range("AY11").Value = 2 Worksheets(2).Unprotect Password:="xxxx"...

I think you will need to play around with the dual axis options that you get on the graph, but I couldn't really advise as I haven't done this myself.

Hi all, I've had a quick look around but couldn't find the answer. My VB code starts with application.displayalerts = false then, further down the code application.quit finishing with application.displayalerts = true However, It still asks me if I want to save the spreadsheet, even...