Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fordtran
  • Content: Threads
  • Order by date
  1. fordtran

    Syntax error in query

    I have a syntax error in this query, but cannot find it. Can somebody help ? S$ = "INSERT INTO comments (comment, date) VALUES (" & Chr(39) & txtComment.Text & Chr(39) & ", #" & Today & "# )" Thanks fordtran
  2. fordtran

    Loading multiple photos from a directory

    I have a web page (ASP.NET) with a drop down list control (ddlSelect) and about 20 image controls. If an item is selected on the ddl I wish to load all the images in a certain directory into the image controls. The number of images in a certain directory may vary. I also wish to load the name of...
  3. fordtran

    Startup programs

    I have a problem to remove programs from my computer - possibly bcause they startup when I startup windows. How can I establish which programs are loaded automatically when windows starts up. Thanks fordtran
  4. fordtran

    Streamreader

    I am conversant with reading a textfile and writing that to a label control on my web page. Is it possible to read that directly onto the page in stead of into a control. Thanks fordtran
  5. fordtran

    Web server not running

    My webserver was running and I could load and debug my ASP.NET projects. However, all of a sudden now, when I wish to open a project it says : Specified web server not running ASP/NET 1.1 When I go to IIS, Websites, Default website it has a red error icon. The right click menu gives me the start...
  6. fordtran

    Union sum()

    I am sorry, the search facility is down, but I need help now. I have two tables named HOURS and OLDHOURS. Each table has fields HOURSWORKED and HOURSOVERTIME I need to summarise the hoursworked and the hoursovertime such as in : Sum(HOURSWORKED)as TOTALHOURSWORKED and sum(HOURSOVERTIME) as...
  7. fordtran

    Inherits

    I have an error on asp.net saying : Could not load type : mywebsitename.mywebpagename What does the Inherits in the first line of the htm of a webform refer to ? Thanks fordtran
  8. fordtran

    Help with Query please

    I have an Access 2000 database and wish to set up a query which will do the following : I have an ITEMS table which contains the following fields : ID, ITEMNAME, STARTINGSTOCK, MINIMUMSTOCK A second table contains my purchases of this item. The table would be : ITEMSPURCHASED with fields ...
  9. fordtran

    Passing array variable to sub

    When I use CALL MySub A,B() in which B is an array, I get an error. How do I pass an array variable of a variable quantity of entries in the array to a sub. I cannot use B(10) or B(1 to 10) as it may be 20 and it does not take the foregoing syntax. Thanks fordtran
  10. fordtran

    Union in inner join

    I am joining two tables (ORDEREDITEMS having a list of ordered items and an ID reference to items in another table named ITEMS which have the names of these ordered items. I then do an inner join like in .. Inner join ITEMS on ORDEREDITEMS.ID=ITEMS.ID This only sends me records of ordered items...
  11. fordtran

    Two sets of rows from query

    I have a setup similar to Google. I have a table with clients. In my flexgrid I have to divide these clients into two categories. First I have to list all clients who have paid their subscription - say a field called paid - and I have to sort them alphabetically. Then I have to add all the...
  12. fordtran

    Color object

    I have to set the datagrid.forecolor to #Be9268, but it does not want to accept it as it says it cannot convert a long value to a system.drawing.color. How should I go about setting it in terms of #.... or even RGB. Thanks fordtran
  13. fordtran

    Unsolicited website browsing

    When I run asp.net and debug the solution, it is shown in the browser MIE6, but just after that a website named : http://www.winantispyware.com/download/2006/?ax=1&ex=1&mpt=1163947914381&aid=mgcog4_asr comes up in the browser automatically. I have restricted www.winantispyware.com in my...
  14. fordtran

    Debugging user group

    When I run asp.net I get the error - check that you are a member of the debugging user group. This is not the real error as I am a member of the debugging user group. There is a report that this is a bug in asp.net. see http://support.microsoft.com/kb/319842/en-us I have found however that by...
  15. fordtran

    Help me with Query please

    I have a table 'projecttasks' which has a field 'projectno' referring to a project in the projects table with a 'projectname' field. The 'projecttasks' table also has a field 'subbieno' referring to a subbie number in the subbie table with a 'subbiename' field. I want to extract a record for a...
  16. fordtran

    Viewport and Userdocument

    I wish to make three viewports on a form to preview a model in the three views (plan and two elevations) I can do each one alone on a whole form, but need to show all three views simultaneously. For this I need to set up viewports, but I can't use the setviewport method as a form does not...
  17. fordtran

    Localhost forbidden

    When I type in http://localhost/ I get the error 403 Forbidden. When I ping localhost I do get a reply. I think it is a security problem, but have checked everything. The IIs6.log file does not show anything. I have set the aspnet user authentication and made a virtual directory. I use XP prof...
  18. fordtran

    Password corrupted database

    I am using an Access2000 database which I protected with a password. When working on the database with VB6 one of the user's power went off and it now says (after I type in my password) that the database must be repaired as someone has quit Access while the database was open. When I ask it to...
  19. fordtran

    Top records by sum query

    I have about 1000 items in the Items table each with an ItemNo and ItemName. For each of these items I have placed many orders and have those ordered items in the OrderedItems table in which I have placed the ItemNo referring to the ID in the Items table and the quantity of that item ordered. I...
  20. fordtran

    Subdivide screen

    I wish to run a very narrow reminders program on the right hand side of my screen in such a way that other programs (or windows) that are opened subsequently must not show over (cover)my reminders window. Even if my reminders window is not active or does not have the focus it should show fully...

Part and Inventory Search

Back
Top