Search results for query: *

Hello, I have a table that has up to 5 entries of the same Application number, with the Status changing on each one. What I'd like to do is get the highest number (last in the sequence) for each application number. Here's what the table looks like: App Num Sequence Status EntryDate...

I'm not sure what I'm doing wrong here, but I keep getting different error's. I added a primary key that is just your basic Access key, named ID. I didn't have a primary key before besides the Zip codes. ID is a number. Here is what I am passing it: strSQL = "SELECT State, Affiliate, County...

I have looked all over, and there is a ton of info on this, but I can't seem to get anything to work. I am trying to use this FAQ: http://www.tek-tips.com/faqs.cfm?fid=4233 I have one table named Zip_Vert: State Affiliate County Zip PA PA-3 Allegheny 15227 PA...

I still couldn't get them to run using the same onClick event, so I ended up using the second one and it worked. OnClick="btnRun_Click" OnClientClick="turnOn()" Thanks for your help!!

Thanks for your help, but I am still doing something wrong. The problem that I'm having is calling that function. I need it to fire off two onclick events, and I can't get the syntax working. I followed this thread and also googled it with no luck...

I am trying to change the arrow cursor to an hourglass. - The user clicks a button - The onClick event (in C#) hits the server and takes about 8-10 seconds to query and populate the gridview. I would like the hourglass to show during this time. All code is written in VS.NET 2005 with ASP.NET...

Hello, I am trying to get the "Find and Replace" control (ctrl + f) to pop up when the user clicks on a command button. The button is embedded into an Excel workbook. I also would like the control to be opened with the options shown and the "Within" field to be selecting workbook. I have...

Hello, I am trying to get the "Find and Replace" control (ctrl + f) to pop up when the user clicks on a command button. The button is embedded into an Excel workbook. I also would like the control to be opened with the options shown and the "Within" field to be selecting workbook. I have...

Thank you!! It works perfect now.

I am trying to import a pipe delimited text file into MS Access. The code that I am messing with is: strPath = "C:\cooper.txt" strTable = "PIPE" DoCmd.RunSQL "DROP TABLE " & strTable DoCmd.TransferText acImportDelim, , strTable, strPath I'm not sure what to put for the first parameter of...

I tried that and it worked. It is highlighting the word 'TRUE' and 'FALSE' in the ConActive row now, but how would I get that entire row to be highlighted with the particular color?

I added {sp_rpt_Car5000Q;1.ConActive} as a row in the crosstab. I then tried the same formula that I have above and it did not work. I tried to use the gridrowcolumnvalue as you suggested, but it keeps saying that it wants a string, and ConActive is a boolean. Maybe my syntax is wrong: If...

{sp_rpt_Car5000Q;1.ConActive} is a report field. It is not a column or a row. I had it as a column and it still did not work. The row names are: {sp_rpt_Car5000Q;1.CarAName}, {sp_rpt_Car5000Q;1.CovDesc}, and @ConNameANDLocation - which is a formula concatenating CarAName and CarAddress. The...

I am trying to change the color of certain rows using this formula in Basic Syntax (Crystal 10): If {sp_rpt_Car5000Q;1.ConActive} = FALSE Then formula = crRed Else formula = crBlack End If I have used this formula in other reports to change row colors and it has worked fine...