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 Wanet Telecoms Ltd 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: *

  1. bboggessswcg

    Help with Group Policy

    I am trying to stop internet access for a client. I have used group policy and not allowed iexplore.exe to run at all. This works great, but then the users open up my computer or network places and type their web address in the address bar right there. Then they go to the web page. How can I...
  2. bboggessswcg

    Tape Backup Challenge

    Hello all, I would like to find out how to write to a tape drive in a windows machine with vb.net. I want to be able to write a file to the tape regardless of what tape is in the drive. It would also be nice to be able to do some administrative stuff like format the tape. I would like to add...
  3. bboggessswcg

    Link Tables with Access

    Hello all, I have an AS400 that I would like to link into an Access database. I am not an AS400 guy, but I am an Access guy. I set up a DSN to the AS400, but the problem is when I go to link in the tables I get an error with the table name. It looks like the table name is QS36F.C.ACTFIL...
  4. bboggessswcg

    Help with Domain Resolution

    Hello, Not really sure if this is the right forum, but here goes. I have a domain www.whatever.com. This works great. What I want is if I type in whatever.com that this will point to www.whatever.com. Instead it currently goes straight to the server hosting the DNS server. I am running my...
  5. bboggessswcg

    Variables in Stored Procedure

    Here is what I am trying to do: I want to run a SELECT statement like below that will return only 1 record and that is the CYATTY field: SELECT CASATY.CYATTY FROM ATTYMF INNER JOIN CASATY ON ATTYMF.ATCODE = CASATY.CYATTY WHERE (CASATY.CMID=@CMID) AND (CASATY.CYPLDF='P') AND...
  6. bboggessswcg

    LIKE in stored procedure

    Can anyone tell me how to use the LIKE command in a stored procedure? Below is my current stored procedure. I keep getting a syntax error. I need to use the like and %. Thanks in advance. CREATE PROCEDURE myGetAllAttorneysSearch (@strCounty char(2), @strSearch char(20)) AS SELECT...
  7. bboggessswcg

    dbase easy question

    I am converting a dbase file. I am reading a dbase file and then running an SQL statment that Selects everything in the file and then puts it into a new file. My problem is that if I add a field to this new file in my SQL statement then I need to be able to set the field width. Can anyone...
  8. bboggessswcg

    INSERT INTO statement

    I am building an SQL statement on the fly in my program from a recordset. My problem is that there are comma's in the data that is messing up my SQL string. Could you please help me find an answer to this as soon as possible. The only thing I have tried is putting in the Chr code for comma...
  9. bboggessswcg

    Command line parameters

    Can anyone give me a little help with a command line launch? I would like to get an example of how to grab the switch or parameter passed from the command line. Like if I launch the VB program from the command line "get.exe wsdisp", I want to be able to read in teh wsdisp into a...
  10. bboggessswcg

    Shell Command Help

    I need to be able to launch a batch file at the first load of my program and then wait for it to finish before continuing. I can launch the batch file just fine, but how do I make it wait? The batch could run up to 2 hours. Thanks in advance for your help.
  11. bboggessswcg

    Database writing problem

    I am now reading a .DBF file into a recordset with about 1.2 million records in it. I am then writing the entire file back out into another .DBF file. This process is taking forever, and I need to speed it up. I am just using a SELECT statement to get the information, and a UPDATE statement on...
  12. bboggessswcg

    Autonumber field

    Is there a way to reset the autonumber field? I would like to wipe my table clean and start the autonumber field as 1 again.
  13. bboggessswcg

    Lock a form

    Is there a way to lock a form in a database? I have a database application .mdb file that my predeccessor created. My problem is that when I go to the forms or reports page, I can not create a new one or get to the design of the existing one. How do I turn this off??? Please help!!!
  14. bboggessswcg

    Access Runtime

    Has anyone used Access runtime files successfully? What capabilities do I have if I install runtime on a computer without Access installed? Can I open or run a macro or report? Thanks, in advance.
  15. bboggessswcg

    Printer Object

    How do I use the printer object to change the papersize to legal instead of letter?
  16. bboggessswcg

    Foxuser File

    Is there a way that I can tell Foxpro to store the Foxuser file it creates in a specific place? It currently stores it in the C: drive root. I want to change that path. Is this possible?

Part and Inventory Search

Back
Top