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!

Register Log in
  • Congratulations Rhinorhino 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: prover
  • Content: Threads
  • Order by date
  1. prover

    Get the path to a file on a users machine

    This may be simple but it eascapes me... What i'm doing is reading data from Excel to a datareader. I don't have a problem with doing that. My problem is trying to point to the Excel file on a user local machine. If i hard code the path i'm fine. I was playing around with the fileupload...
  2. prover

    dropdownlist values start at 6am and end at 9pm...

    I need to create a dropdownlist that has time values from 6am to 9pm (on the hour and half hour) as values. EX: 6:00AM 6:30AM 7:00AM 7:30AM etc... I've hard coded this but there has to be a way to do this via code. Maybe not? Ultimately i'd like to be able to reuse the code say for instance...
  3. prover

    Update a record based on checked/unchecked value in a checkboxlist

    I have a form with preselected items in a checkboxlist control. What i'd like to do is either add a record if a checkbox was checked. Delete a record if the checkbox was unchecked. A user checked the following items and recorded them to a DB. Checkboxlist Items: car truck (checked) boat...
  4. prover

    Stored procedure Help Insert with a one to many relationship...

    I need some advise. I have a person table and a language table with a one to many relationship. I want to be able to add a new person and if they speak ohter languages then add then to the lang. table. The data is comming from an asp.net page. I'd rather not insert the person , return the...
  5. prover

    Import MS Outlook Appointments Using a Date Criteria

    I can import all appointments from Outlook but what I'd like to do is only import appointments between a certain date period. The following code imports all appointments.. is there a way to refine my criteria? Dim ol As New Outlook.Application Dim olns As Outlook.NameSpace Dim cf As...
  6. prover

    Return list of people with multiple languages spoken

    My brain is mush. I know this has got to be simple but right now simple things escape me... I have "Person" table" and a "Language" table with a one to many relationship. I want to return a list of persons and any language spoken (if any) similar to below: Name Address...
  7. prover

    Show multiple languages spoken for each person in a GridView

    This may be simple but it escapes me. I have a gridview with the following columns: Name, address and position. I need to add another column listing all langaues spoken for each person (if any). My question is how to get the gridview to display each person and any language they speak...
  8. prover

    Extract multiple values from one DB field and populate a checkbox list

    Ok here goes... I have a checkboxlist which stores its data in one field. how do i return that data back to the checkboxlist fro display. there are five options m - manager c - clerk a - assistant n - monitor and the values saved in the db: "mca" (if you checked manager...
  9. prover

    Where to put code when access to the <HEAD> tag isn't available!

    Hello, Our company has split our web pages into two include files. A header and footer include files. Because of this I no longer have "access" to the <HEAD> tags to place my javascript code. I was wondering if my js code should go above the ssi or below it? Or does it really matter...
  10. prover

    Adding a sequential number between a fiscal year help

    Hi all, I need a way to assign the next sequential (permit) number to an approved application. The trick is that every fiscal year the numbers restart at zero and the fiscal year is between 7/1/xx and 6/30/xx. for example if an application was approved on 8/4/03 i would need to get the next...
  11. prover

    Stored Proceedure or SQL in a component

    Hi All, In a component, is it better to use a stored procedure to add, update and delete records or to just type the sql statement (ex: delete from table where ...)? Am I assuming (rightly?) that because a .dll is compiled it'll run a sql statement just as fast as a stored procedure? Is the...
  12. prover

    How to open a image(*.tif) located on the server...

    We have applications that get scanned and the information from that application populates a database. What I'd like to do is be able to recall the .tif image for a particular application. I have no problem finding the file (using FSO): <% 'test code myfile = &quot;ZCK9JE0001.tif&quot; Set FSO...
  13. prover

    compare records from two tables to see if ther y match...

    I have an address table that periodically needs to be updated with new addresses from a table that is given to me once a month. What I need is a way to compare the addresses in the new table to what is existing in the &quot;Master&quot; table. If there is no match then flag that new record to...
  14. prover

    Check that a email address exists when submitting a form...

    Is there a way to test that an email (that was submitted) actually exists not just if the syntax is correct. I have a form that a user submits and i send back a confirmation email with a tracking number. I find a lot of emails are bouncing back as undeliverable (grrrr). I was wondering if...
  15. prover

    Stored Procedure that add a record for ech checkbox checked...

    I have a dropdown list of managers and a series of checkboxes with divisions. I need a SP that will add a new record to the tblDivMgrs table for each checkbox that is checked. the table id designed as follows: tblDivMgrs DMID (PK) MgrName Division Page EX: John Smith (Dropdownbox)...
  16. prover

    Calculate a Date based on another field...

    I have a table tblCase: CaseID int LocID int CaseDate datetime Allotted varchar I need to add the CaseDate + Allotted and if the date equals today then return all the cases that are due. here is the stored procedure (SQL) I'm working on: SELECT * FROM tblCase WHERE...
  17. prover

    Need help with a little database logic...

    I just had a db droppped in my lap and I need to make modifications to it. This db basically tracks addresses that had a certificate issued. This certificate is only good for a year but unfortunately there was no thought put in for records that were to be renewed! The address table has a 1 to...
  18. prover

    Turn off the &quot;Read-only&quot; attribute of a file...

    I've been working on a project that writes data to files in a particular folder. I recently added new files from a CD and of course I forgot to turn off the &quot;read-only&quot; attribute. The folder contains hundreds of files. Is there a way to turn off/on the read-only attruibute of a...
  19. prover

    Programmatically move a file from one folder to another

    Is it possible for Access to Programmatically move a file from one folder to another? In my case it wold be a .tif image. Basically I have a folder with .tif images in it (approx 50 a day). What I need to do is automate placing each .tif image in its own folder. Each .tif image name is a...
  20. prover

    Time a query without opening it...

    Anyone know how to get the elasped time it took for a query to run without opening it? I have code that does this but the query needs to be opened.

Part and Inventory Search

Back
Top