Search results

Pat, thanks for your help! Big jim

Hey, Big Jim here: Let's say for example I have a setup where I am using this string strTest = "Doug's" as a recordset parameter. This will of course cause an error if the SQL was written as: Select * From Table Where Name = '" & strTest & "';" What oh what do I do about that apostrophe in...

Hello, Big Jim here, I was wondering if there is an easy way to find the 2nd most MAX value of a column. I could figure this out using some VB, but I was hoping there is an easier less stressful "function" to accomplish this task. Thanks in advance... Big Jim

Hello, Big Jim here, Is it possible to set up an array such as: intTotal(strGender,strLocation) = intTotal(strGender,strLocation) + some value where of course strGender and strLocation are both non-numeric values? The thought here being that I would have 2 strGenders and many strLocations...

Hi, Big Jim here: I created a query using a querydef in VB. Is there anyway for me to adjust the properties on one of the columns using VB? Specifically, I want to adjust the number of decimal places allowed. Thanks in advance, Big Jim

Thanks, Kaspi! Big Jim is greatful that you could help him out. You're the best! Big Jim

Hey, Big Jim here, Is there anyway to use a string in an array? Say I had: Dim intTest(strWords, 1 to 5) as Integer Something along those lines. Is it possible? Thanks in advance....Big Jim

Thanks, Mic, that is a very good point. Big Jim just lets his boss look at the table, but I'll look into that Form idea as well. I use the table as a report. The table is not referenced by anything, and it doesn't look like it would fit in a report nicely. I'll email you a piece of it if you...

Hello, Big Jim here: I created an Access table using code (tableDef, field, etc.). I am trying to adjust the field width of a table's column from code. Any suggestions? Thanks in advance! Big Jim

Keith, Thanks for your help. Worked great! Big Jim

Hello, Big Jim here, Ok, say I have a number from 1-365 (I had to build an array to group data by each day of the year. I need to convert that number 1-365 back to the month and day of month. How would I do this? Thanks in advance, Big Jim

Thank you to both of you. You have been a great help. Big Jim

Hello, Big Jim here, Say I had the number 45. Is there anyway for me to have VB set that as a date on a 1-365 day scale? In other words, 45 would be February 14th. Thanks in advance, Big Jim

Thanks, Jack! That really helped. I must remind anyone trying to do this that you have to have the multi-select property for the list box set to yes or it will not work.

Hey, Big Jim here... I was wondering if there was a way to select multiple items from a list box from VB. For example, say I have "A", "B", "C", and "D" in a listbox. (I have MultiSelect already turned on.) Now, I want my VB code to highlight both "A" and "B" in the listbox. How would I do...

Pat, As usual, your guidance has shown me the way. Thanks for your help.... Big Jim

Hi, Big Jim here.... I am using a function in the Where clause when creating a graph: WHERE column IN (Function) The function is set = to a list of values contained in a string, generated on my form. My question is how to set up the Function so that it will properly populate my graph...

Hey, Big Jim Here, How would you create lines and circles on a Form from code (Event Procedure)? I am getting the impression that this can only be done on a report. Thanks in advance, Big Jim

Thanks MHM! Your advice wokred great. If I might ask, why is the difference between using "." and "!" in VB? For example, object properties are referenced using ".", but the recordset is referenced using "!". Thanks again! Big Jim

Hello, Big Jim here: I was hoping to use VB to run an sql statement and then place the single value returned by the sql statement in a label on a form. Here is the code I was using: ****** Dim rsta As Recordset Dim strSQL As String Dim strHold As String strSQL = "Select [1] From [00Fleet]...