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...
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...
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
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
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...
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...
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")
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...
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...
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...
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...
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...
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
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.