Search results for query: *

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

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

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

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

I have a subform in data view that displays a list of filtered records based on user criteria. I want to make a command button that emails these results to who ever they choose. I know to start with the send object to email. But I don’t know how to get the filtered results into the body of an...

I am trying to import a text based semi colon delimted file that the file name looks just like this. Acc_Export_01_26_2006_12.45.36 Is this even possible? I cant change the format of the file that I am trying to import. If I add the extention .36 to the registry it still have problems I think...

I could not find anything on this, I need to know if this is possible. I need to run code that converts a SQL string to a .dbf like: SQLstring = Select * FROM Forms!frmName!cboName Where This= cboName2 transferdatabase acExport, "dBase 5.0", name, SQLstring, blah, blah

I am trying to import many csv's files that a client has entered (so I cant change them now) I have a problem with the text qualifier, I need it to ingnore the field delimiter which is a , in this case. there are some people who have their address like this: "123 s 456...

the table I am appending to does not allow duplicates it has a composite key (manifestID,Class,Pieces) When I run the append query it give me the warning cannot insert duplicate key. I thought that if I clicked ok that it would work like a paste append and append what information it could. but...

I have a spreadsheet that gets generated every night that needs to be deleted when access is through importing it, its there a way to have this done with out user interaction. Also this spreadsheet tends to have duplicate information I have a key setup so it does not import those records but...

Trying to get a text box to display a sum but i cant get the code to work is there a better way. The text box is unbound the form only has a to date and from date boxes with this command button. I keeping gettting run time errors with this code. I copied it from another post. Dim SQLstr1 As...

I have seen this done with a program at work but i think they made it in .net here is what I want to do. I want make a datasheet or table that have like a hyperlink or button that links to a form that whould act as a child table. for example like a detials button on and order form. this is...

This is the code I am using CurrentDb.Execute "ALTER TABLE ('stDocName') ADD COLUMN Scanned YESNO" I cant get it to recognize the varible

I have been getting a lot of help from everyone here so I appreciate everyone’s help. I am so sorry for all the questions. Here is my setup I have a form that looks like this sub forms under the main. Main-Client Sub-Project Sub-Job ----> with button to print report Report looks like this...

I am full of questions today... I have a subform that is linked by the master Fieldname "project" what I want to do is use an entry form to creat new records with the "project" also linked here is the code I have. It works if the "Project" is already created. But I need it to display the ID...

I found this already but cant figure out how to use it. http://www.tek-tips.com/viewthread.cfm?qid=946099 I need a textbox to strip the first 4 chars. when text is entered. The problem is that I am scanning a barcode that its value is "ABCD1234" I need it to store only "1234" when entered into...