Search results for query: *

ThatRickGuy Thanks, exactly what I needed

ThatRickGuy Im really just wanting the store approx 10 SQL statements that the class uses. I am inquiring if its better to store them in an XML file and make the class dependent on that XML file being present. Or, is there some cleaner way. I want to have this class portable accross several...

techsmith - I dont have the option to create stored procedures. djj55 - the statements are static, I just change the parameters as needed. Thanks John

I have a best practice question. I have a class that I want to use amongst multiple applications. The class is dependent on several large SQL statements to perform its job. What is the best practice for including the SQL statements (approx 10) with the class itself? Should I use constants in...

Thanks for the datagrid idea. I had been trying to do this at the datatable level since the datagrid's columns will change based on user supplied criteria. Thanks John

Is there a way to set up a datacolumn of a datatable to only hold 2 decimal places? The value in this column is created by a datacolumn expression, and I'd like to limit the value to only 2 decimal places. Thanks

I have a form that has a text box and a progress bar. The form calls a class the performs a time consuming operation, and fires events for progress and status. All works as it should with the form update appropriatly. I tried to call this class within as a backgroundworker. When I do now, it...

I have data in a format such as; NAME SEQ POST Fred 01 Hello and Fred 02 Welcome I would like to have the output show as; NAME POST Fred Hello and Welcome So that all values in column POST are concatenated for output. Is...

I have data in a format such as; NAME SEQ POST Fred 01 Hello and Fred 02 Welcome I would like to have the output show as; NAME POST Fred Hello and Welcome So that all values in column POST are concatenated for output. Is...

Thanks so much. I really appreciate the comments, that helps me learn this quicker. Thanks again

Dave If I wasnt completely clueless, that would be very helpful. However, I am. I normaly do C and VB coding. This webform is just a front end that drops info to an email, which is read into a VB tool which transfers to a database. Here is the HTML for the listbox <DIV align=left><SELECT...

I am new to JavaScript and could use some help. I have a listbox on a webform that contains the date of all Sunday's in a given year. Users fill out this form on a Monday and must pick the appropriate Sunday from the listbox. Is there a way to have the listbox pre-select the most recent Sunday...

is it possible to have a VB form mimic the look of Apple iTunes (brushed metal type look)? I would look to spruce up my application and that always looked really sharp to me I tried setting a picture of brushed metal as the form background, however, I cant find and picture large enough. I...

I just applied to this to my computer. It works great. however, when picking back/fore colors I can no longer view the color palette. And thoughts? Thank you John

Thank you both for your replies kskid - I am getting an error 'formula must be evaluated later' lbass, I will try your method. Thank you both

dgilz Wouldnt that still return ID 1 because he is in football? I need to completely have that person off of the report.

I am in need of help limiting records coming to my report. I am using version 8.5 This is a sample recordset for illustration. There are 2 tables, Person, and Sports Person would have a numerical ID for each person. Sports has the person ID and a sport name, forming a one to many...

Are you using the CR Viewer to accomplish this? If so, can you post the code you are using. John

The forms caption would show in the task bar next to the icon John

Using Docmd I know that a report can be be opened with OpenReport, and a Where condition can be set However, Docmd.OutputTo does not appear to let me specify a Where condition. I am using VBA. Is there a work around to this? thank you John