Search results for query: *

thank you for the feedback strongm. We ran it and it works great on databases that have the activex in place but on the ones that have it as a missing reference (MSCAL.OCX is not present in office folder) we receive an error, "can't find project or library". Is there way to test for the...

Hello All, Need some extra brains on this issue. Been cruising the forum and searching for scenarios but can't seem to find any that would match what i need to do. I'm running Office 2010 all machines in all locations and as some of you may know Microsoft removed the ActiveX calendar control...

Hello all. I'm very new to scripting and I need some help figuring out what I'm doing wrong with my array. Basically my goal is to find out if Remote Desktop is enabled on all of the machines at our site. The script works for my machine, but I've tried to add the array and the list of "echo's"...

Got it to work, I had to set the Unique Records to Yes because of another error I received. Thank you guys for your help.

Forgot to enter my SQL statement DELETE tblrcvqtymismatch.ID, tblrcvqtymismatch.[Vendor Name], tblrcvqtymismatch.Date, tblrcvqtymismatch.[Order Qty], tblrcvqtymismatch.[Receive Qty], tblrcvqtymismatch.[Item Number], tblrcvqtymismatch.PO, tblrcvqtymismatch.RR, * FROM tblrcvqtymismatch INNER JOIN...

I appreciate the reply. The select query seems to work fine, but when I change to a delete query I get an error "Specify the table containing the records you want to delete".

I have a table with Purchase Orders plus some other information. Some of the purchase orders are in the table multiple times because of different item numbers attached. This table is called tblmismatch I also have a query that pulls out PO's from a different table. After I run this query, I...

The "CloseCurrentDatabase" still takes a very long time to run.

Hi all, I have a module that imports a lot of .txt file information into several different databases. However, we have recently moved to Windows 7 (Office 07) and it seems that the part of my code that closes each database is taking a very long time to run. Here is my code... Function...

Hi everyone. I have lines of text that I'm trying to pull information out of. Here is what the lines look like... ap1.0077.lowes.com [10.1.52.51] ap10.0077.lowes.com [10.1.52.60] ap11.0077.lowes.com [10.1.52.61] ap12.0077.lowes.com [10.1.52.62] ap13.0077.lowes.com [10.1.52.63]...

Arrgghh, calling off the knowledge hounds due to personal stupidity. Code was working as intended.... I forgot to reset the run date so it knew not to run... Once I moved the date beyond the interval specified all took off. Stupidity is tough to deal with however when it is self inflicted...

Well, I am still having issues here, changed the flag to come from the access executable however it will not kick off my sub? This does not work from the /x flag or running in the macro but I can step through it and it works? Public Function CheckIt() Call DoISend End Function This works...

PHV, That got it, sorry about missing the detail of qualifying it on the executable and not the database. Thanks for the time and help.

PHV, thank you for the quick response. I did not think of that and so I setup it up in a short cut but it is not triggering the macro?? I can run the macro from access and it works as expected but just not firing from the shortcut (used for testing right now). Does it matter that there is...

I have a database that is actively used everyday and I have added code to send me a report from it that will be based on a day interval and a windows scheduler task to open the database, send me the report and then close. Everything for the reporting works as intended when the sub is called and...

I got it last night. Thanks for your help dhookom

I do have a problem though now. The top two items in my query are "Crossdock", the bottom two are "Warehouse" I don't see a way that I can separate these out at all to distinguish between the two. If I put the labelbox in the detail part of the report, each label box will show up 4 times. I'm...

I got it taken care of. I was doing something really stupid. Long day. Thanks for the response.

Hey all. I've got two queries that are virtually the same. They both show the exact same information, but their criteria is just a little different. (One was needed to show certain picks in the building, and the other one a different set of picks). Anyway, I'm trying to find a way to get both...

Thanks for your response. I knew about the show arp command, but I did not know about the show ip arp command. I did run the show ip arp command on our gateway and it returned the IP and MAC, so thank you for that. I do have a question regarding this command though. Are the MAC Addresses...