Search results for query: *

I am using powershell to check a folder and when a file gets added to the folder, it queries a sql table and if there hasn't been a file added in the last 6 hours then it will send an email to several people letting them know that the file was copied/uploaded to that folder. I can send the...

I have about 1,000 pdf files and each file has about 50 pages. I want to split/extract the pages out of each file onto it’s own file (should be 1-3 pages). The pdf file contains Contract Name. I want the file to print every time it finds a new contract name. It is usually 1 contract per page...

I have about 1,000 pdf files and each file has about 50 pages. I want to split/extract the pages out of each file onto it’s own file (should be 1-3 pages). The pdf file contains Contract Name. I want the file to print every time it finds a new contract name. It is usually 1 contract per page...

I have a form that has a Tab Control with 10 tabs. Each tab has a subform. I am dynamically creating these forms from template forms I have. I make a copy of the main form and 10 subforms that are in each tab. I want to be able to rename the sourceobject of each subform in each tab. I tried...

I have a subform on a main form that I want to change the recordsource. I have some code that loops and does this for several subforms on the main form. I need it to by dynamically, so I want to use variables. Below is how I would do it hard coded...

I having been using passthru queries with no issues. I am having with a passthru query. The string I am trying to pass is 3,064 in length. It is an insert that has about 150 fields. Is there a maximum length that a string odbc will take? INSERT INTO Tab06 ( GroupID, AssignedAuditors, MoveToWS...

I want to put a tab control inside another Tab Control. I have 10 tabs on the parent tab control. When I try placing a tab control in the 6th tab of the parent tab control, it works but when I move to another tab on the parent tab, the child tab control shows up on every tab of the parent tab...

How can I search for something in a textbox and when found, highlight the word or phrase searched. I don't want the whole textbox highlighted. thanks, alex

I have a SQL view linked into a ms access application. That view is used in a subform and in datasheet view. I want to select multiple records and click on a button that will delete those selected rows. I need the button because the view has 1 table and a subquery joined in the view and will...

I want my report to be pivoted. my data product - amt - month - Year abc - 9.99 - 7 - 2013 abc - 39.99 - 7 - 2013 abc - 19.99 - 7 - 2013 abc - 5.99 - 8 - 2013 abc - 9.99 - 8 - 2013 abc - 29.99 - 8 - 2013 zzz - 7.99 - 7 - 2013 zzz - 19.99 - 7 - 2013 zzz - 9.99 - 7 - 2013 zzz - 13.99 - 8 - 2013...

I have this code that I got from "igor krupitsky which he posted on another site. It merges (appends) 2 pdf files. I need to edit the code so that it does this: I have 8,000 files in a folder and I want to merge the files that have the same prefix name in the filename. i.e. 122TX4939.pdf...

I have a form which has a tab control (10 tabs). I have a subform in each tab and each subform has a table or query associated with it. I want to open the form with no tables opening with them because the tables are big and take long to open. The tables are sql linked tables. This is an...

I am trying to run a passthru query and get a runtime error 3146: ODBC-- Call Failed This is my code: conn = "ODBC;DRIVER={SQL Server Native Client 10.0};SERVER=UKHOST04;DATABASE=COOPTRADEDISCOUNTS;TRUSTED_CONNECTION=Yes;" sql = "Update TblGroupID Set AuditorID = 'abenit01', UpdatedDate =...

I am trying to call a stored procedure with a passthru query but it is not working for me. I get Run-time error '3146': ODBC --call failed. strconn = "ODBC;DRIVER={SQL Server Native Client 10.0};SERVER=UKHOST04;DATABASE=CoOpClaimConceptReferenceTables;TRUSTED_CONNECTION=Yes;" mysproc = "exec...

How can I set the date to dd/mm/yyyy for the entire app? I know you can set the server/desktop to the format date you want but in this case I cannot. I want to set the application to the format date of dd/mm/yyyy. Can this be done? There is a query that is taking a date from a text box and...

I have a dropdown that once I select a value, it runs an event on the After Update Event. Once the code finishes it resets the drop down to the first value, even though I selected the second value. Here is the code and the data for the dropdown. So if I select ID = 5, when the after update...

I always close my recordset and set them to nothing. I do the same with database. Is it necessary to close the recordset if I put set rs = nothing after on the next line?

I have a form with a subform. I've had to make a copy of both and use all 4 because I have 2 different tables that get's used on the subform depending on the type of data we use and there are some fields that are in 1 table that are not in the other. Is there a way to make both tables work...

I have this code that loops thru the querydef's and deletes the passthru queries, but it always leaves out a few. When I tried to trap an error, it does not give me the error description. It also does not finishing looping thru all the querydefs. Why does it not catch all of them...

I have a form with a subform ("frmReturnsInvoice"). The form and subform uses 2 separate sql tables which I linked to my ms access application using dsnless linking. I have another form ("FrmHdrDatasheet") which my users initially go into which is in datasheet view. The users scroll thru the...