|
function reference Is there any way to pass in the name of a function programmatically? I have similar parameters for a couple of functions and would like to pass in the function name to a statement such as: UpdateAppointment=FunctionName("Appointment",lngAppointmentID) Can this be done? Thanks, Sam ... 6 Jul 2008 18:06
Case statement Excellent Idea Excellent Idea. I love it. I will change it to that. Thanks Marsh !!! "Marshall Barton" <marshbarton(a)wowway.com> wrote in message news:f3vu641h812jdmkt651d8tb7lv07jan6c3(a)4ax.com... tony Jacobs wrote: I am having trouble with this code can anyone help. I have the follwing case statement that ... 6 Jul 2008 12:59
Not Updating I have one record that I would like to divide into any number of records that the client chooses as long as it's not a negative number. Everything works fine except the check total part. Lets say a check is $8.39 and you want to end up with 4 checks or records in the end, each records total should be 2.09, 2.... 6 Jul 2008 18:06
stellenangebote stellenanzeigen stellenangebot muenchen stellenangebote immobilien job stellenangebote karriere deutschland stellenangebote stellenanzeigen stellenangebot muenchen stellenangebote immobilien job stellenangebote karriere deutschland + + + ARBEITSANGEBOTE IN DEUTSCHLAND http://WWW.ARBEITSANGEBOT-DEUTSCHLAND.DE http://WWW.ARBEITSANGEBOT-DEUTSCHLAND.DE + + + STELLENANGEBOTE IN DEUTSCHLAND http://WWW.STELLEN... 6 Jul 2008 11:57
Form Goes Into Break mode A97 I have a form that is the start-up form for my app. It has always operated correctly and is used to set some security then open a Splash screen. The app is designed to block the By-Pass key etc and then configure toolbars and title bar etc making itselft ready for the user. It's been working fine until now bu... 6 Jul 2008 09:55
Detect failed ODBC connection when vpn is not up? Some users might not have the vpn connected when they start my app...the odbc timeouts for the passthrough queries on the main form take a long time (20-30 secs each) to return a failed odbc connection error. Does anyone know of a quick way to test for an ok odbc connection? So far I've not seen any difference ... 6 Jul 2008 03:48
ListBox Question Hello all, Is there a way to make the background of a ListBox transparent? It only seems to work on the border. -S ... 6 Jul 2008 17:04
Finding first Null Record... I need help opening a form that is automaticall parked on the first null value of a select group of fields. I have tried: DoCmd.OpenForm "frmActMapUpDte", acNormal, , "IsNull(JVID)", acFormEdit, acWindowNormal This works, but it FILTERS the record set to just JVID is null. I would like to just Find the fir... 6 Jul 2008 00:45
dlookup I have following data MyCode MyValue A 1 B 2 C 3 D 4 E 0 I just wonder if I use Dlookup("[MyCode]","MyTable", "[MyValue] <= " 3) which record will return A, B or C or unknonw? Because A, B and C are less or equal 3, does Dlookup return the most cl... 5 Jul 2008 21:42
Case statement Problem not resolved Still Doug; The Value of the Me.Combo28.Column(1) is Like 'B*' , and any other variations.(Like 'C*', etc.....). You helped me with this earlier on. The lstbox gets poulated with items that start with a B when I select a combo box value of Like 'B*', and so on. No all I want to do is print the items in the lstbox , ... 5 Jul 2008 10:28
Conditional Formatting - Embedded Subreport I cannot get the conditional formatting in an embedded report to work. There is no VBA involved. The conditional formatting value (through the Access tool) is "condition" - the value is "[dts]>= Date() - 7. If the recorded date is new then seven days old then we want the text bold. I can get the to work in ... 5 Jul 2008 09:27
Case statement Problem not resolved Damon; I tried your code and I added 3 message boxes at the end of the code to see the value of the stDocName and it is always the report name in the Case else statement. It seems that we are close, but the conditional reports are not being picked up . "Damon Heron" <damon_327(a)hotmail.com> wrote in message ... 5 Jul 2008 06:24
Case statement Problem few more tries I tried the code without the left function, and my debugging message box returns what is actually in the combobox column(1) which is any of the below criteria. here is the code: ............................................................................. ............................................................... 5 Jul 2008 10:28 |