Search results for query: *

Thank you very much for the further guidance. Much appreciated. Will try accordingly.

Thank you - all noted. Agree with your suggestion and comment re ASP - will try in code behind although a little confused on should I use form values or hyprlink. Had previously tried <asp:LinkButton ID="LinkButton2" runat="server" PostBackUrl='<%#...

jbenson Tks for your prompt response When price = any numeric (no problem) When price= reference to the GridView control value then value always zero. Have been assuming the syntax was wrong somewhere. Have 'googled' to no avail. Have ascertained that value exists on the page behind...

Would be grateful if any help with syntax trying to pass a variable price value to a shopping cart check out where the price value is a variable based on distance. All fine when using a fixed integer, problem when trying to name the price value from the Gridview...

Resolved: To avoid formatting issues in html code, the sql database calculated field was formatted i.e cast(123.45678 as numeric(10, 2))

I have a an ASP.Net web site using vb.net code.In code behind file I am trying to populate the infowindow with content where I have to format a numeric variable to 2 decimal places.The variable is called from data in a connected sql server database. The code I am using is...

Remou Many thanks, your prompt response in correcting my sql syntax has been appreciated. All noted - am back on track with my project. Deemark

Would be grateful if I could be advised on where I have syntax issue(s) with my strSQL string variable below. Am using rs.Open strSQL ...etc but this is appears to be wrong. Looking at the various posts on this subject I have noted the 'delimeters' etc but dont seem to have it clear in my...

Update: I have figured out successful operation of the basic batch file in the OnLoad event of the Switchboard, start up to create new directories and move files. Still trying to figure out how to make this batch file activate only on the first activation of Switchboard Form OnLoad event and not...

My MSAccess2007 application was designed with a two-tier folder directory structure. I found that the MS Access2007 did not support (multi-tier folder directories in the install wizard). Searching the forums, I noted the idea to run a batch file to create the lower level folders and move the...

Changed approach to this procedure. Opted to create a non-filtered query as a Main report recordsource. Dispensed with the subreport. Created the user defined options in Group Option Frames. Created multiple 'strWhere' sql statements and applied to the DoCmd.Open Report statement. Lost most time...

DHookom Tks your prompt response,your advice is most helpful.I was almost there, so will go back and try the saved query method and apply the WHERE criteria. Noted your valued advice re the Dialog Form. Many thanks Deemark

Many tks dhookom, 1. Setting the Report RecordSource to a saved query, was one query - i.e was it supported? As I was facing SQL errors at the same time, I couldnt easily discover through debug if the setting of the saved query was causing the error and/or supported. Will try as you suggest...

Have a Report with the Parent Report's recordsource set to a table containing company header style info. This populates the Report Header text boxes and labels. A Sub Report Detail Section has been embedded into the PArent Report's Detail Section. I am trying to assign the sub report with a...

Not very sophisticated but I have used following expiration of use method on MS Access 2000/2002 / Office XP Developer application. Application quits after 183 days use. Table (tblexpiry) created with two fields (Index,firstdate). Open Form procedure initialises the start date, after 183 days...