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 derfloh 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. GooGoocluster

    force user validation for windows app not web

    Does anyone know the code to vaidate user credentails even?
  2. GooGoocluster

    force user validation for windows app not web

    I want to make an application that forces users to login using windows credentials when they use the application on public computers. In our network we have personal and public computers. I would like when ever some one were to use this public computer with a public login to force them to use...
  3. GooGoocluster

    Clipboard Paste Question

    sorry I did not clarify very well. me <-- not very good at explaining things. Right now I am using the copy selection button on the terminal window to copy it into the clipboard then put it into excel. what I was invisioning I could to is take what is in the clipboard and dump it into a...
  4. GooGoocluster

    Clipboard Paste Question

    we capture the data from a AS400 Screen (like DOS) I would just like to that but I dont know the table names so I can make a connection string. How can I do what you said kjv1611? "You might can paste using a recordset to loop through a table's fields
  5. GooGoocluster

    Clipboard Paste Question

    Is there a way to paste data into a table using VBA or macros. the data has column headers and currently I am pasteing it into excel, saving it then importing it into a table. I hope you guys can help thanks
  6. GooGoocluster

    Looking for code to extract Pages from PDF

    Is it possible to search with in a PDF Find Text and then extract the whole page that contains this text? Here is an example of What I want to do. Search for this text string "AB 0003 0103" AB is the job 0003 is the SEQ# and 0103 is page 1 of 3 I whould like to find this and then extract this...
  7. GooGoocluster

    Working with PDF Files

    Does anyone know where I might find out more info regarding this?
  8. GooGoocluster

    Working with PDF Files

    Is it possible to search with in a PDF Find Text and then extract the whole page that contains this text? Here is an example of What I want to do. Search for this text string "AB 0003 0103" AB is the job 0003 is the SEQ# and 0103 is page 1 of 3 I whould like to find this and then extract this...
  9. GooGoocluster

    Help!! Overiding ByPass Key

    Does any one know how to do this for an adp project? I tried to use this code and it says it does not recognize the format on this line. Set Bdd = DBEngine.Workspaces(0).OpenDatabase("\path\to\yourdb.mdb")
  10. GooGoocluster

    Is this even possible? Reports!strVar.Recordsource

    Can you use Varribles when using Reports! ? dim strVar As String strVar = "Full Sheet Labels" Reports!strVar.Recordsource This is the Error message " Cannot Find Report named 'strVar' " I have also tried Reports!(strVar).Recordsource and Reports!"["&(strVar)&"]".Recordsource Thanks in...
  11. GooGoocluster

    CreateQueryDef In ADP

    Does outputto create dbase 5.0 files? I thought I looked to see if it could i will look again.
  12. GooGoocluster

    CreateQueryDef In ADP

    I have created the view and now it is just in my adp database. but I cant export it to dbase file. here is what I tried DoCmd.TransferDatabase acExport, "dBase 5.0", "L:\DC\JTM\Master Form\JTM.adp", acQuery, "qryTmpExport", StrJob, False This code says the path is not correct. but it is the...
  13. GooGoocluster

    CreateQueryDef In ADP

    I should have admin rights. they made me the owner of the database. Earlier I made this same view non programatically and was trying to use the transferdatabase command to export it into a .dbf and it said it was having trouble finding the view could this be one of the incompatibilty issuses...
  14. GooGoocluster

    CreateQueryDef In ADP

    I was able to use the following code in a regular mdb file but I took same code unchanged into my .adp file and I get runtime error 91 "object or with block not found" from what I recall. Does any one know the code that will work for adp? Thanks strSQL = "SELECT ImportTable.* FROM...
  15. GooGoocluster

    Text Wizard Does Not show up in ADP

    I am trying to make a schema file for a query that I have but I cant get the Export text wizard to a appear. this was working before but now it does not Instead a Encode as Dialog shows up instead. I can use this wizard in Mdb files that I have but not this current adp that I am working on. Is...
  16. GooGoocluster

    ADP Disable Shift Problem

    Thanks just had to remove all the other garbage and it worked fine. Anyone looking to Enable the shift key again here is the code CurrentProject.Properties.Add "AllowByPassKey", True
  17. GooGoocluster

    ADP Disable Shift Problem

    Refered from this thread: thread705-403154 My CODE: Function DisableShiftKey() Dim dbs As Object Dim prp As Object Const PROPERTY_NOT_FOUND As Integer = 3270 On Error GoTo ErrorHandler Set dbs = Application.CurrentDb ' Try to set the property. If it fails, the...
  18. GooGoocluster

    Saving contents of a filtered datasheet

    Thanks for clearing that up. After rereading your post I put it in a module. But I still was not putting them in the declarations section. Sorry I did not know what that was at the time thanks again for your help guys works like a charm
  19. GooGoocluster

    Saving contents of a filtered datasheet

    it stoped on Public strAccount As String returned the error: Invalid attribute in Sub or Function
  20. GooGoocluster

    Saving contents of a filtered datasheet

    Its the command button to a find button here is my entire code. Public Sub Command48_Click() 'strAccount, strFrmDate, strToDate, strZIP, strPKID, strCarrier, strSQL, strSQL2, strAnd1, strAnd2, strAnd3 As String) Public strAccount As String Public strFrmDate As String Public strToDate As...

Part and Inventory Search

Back
Top