Search results for query: *

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

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

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

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

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

Hey all. I'm working on a wire labeling project and was wondering if there was a good way to capture what IP Address, and MAC address was plugged into a device. I know "show mac address-table" will pull in the MAC Address, but I'm looking for something now that will pull in the IP Address...

Hey all. I just got Office 07 installed and I'm running a database that ran fine in 03. When I run it, I'm getting an error saying "The Microsoft Office Access Database Engine does not recognize 'Format' as a valid field name or expression" It shows it as Error 2950 I view the report that it...

Can anyone offer code that would run and check if the user is running Access 2007 or Access 2003? I basically have a form that I want certain OCX controls to populate if it is not 2007 since 2007 has some pre-built now depending on the field type. (like a date field) Thanks for the time once again.

Could I get some help on getting some if statements kicked off with the data below? Here is what I am looking to do. Example: if the service period covers May through July we will want the spreadsheet to show NULL values for Feb through April AND August through January. We will want to show...

Hello to all again, I have an sql statement that is not interpreting a variable correctly. Here is the code; 'these two (txt*)are referencing fields in a form and not defined in the code, just wanted to show the values. txtExcludeStatus = 82,91,95,96 txtExcludeBays = 457,557,996...

Hello everyone. I received this database that uses multiple queries to drill down to a single result. Basically there are 4 input boxes on the form (stored on a table) to enter in status codes for exluding labels. Each query pass compared an individual field of the table to finally sort...

I have a make table query that is pulling information from multiple tables. The one field is pulling up to be a text field, but I need it to be a number field. I've looked in the properties of that field but I can't seem to find anything that changes it from a text field to a number field...

Hey all. I got an interesting question today and was wondering if anyone could help me out. The older digital cameras, when attached to a PC would automatically connect to a drive letter. So to use a database to pull these photos off was pretty simple. Now, with the new cameras, they open up...

Hey guys. I'm having trouble with a report. It's a report with a query as a control source and when I open the report, the 1st 3 records out of 150 show up, but after the 1st 3, every field gives me a #Error. The strange thing is, this report has been working for years, and all of the sudden...

Hello experts, I am trying to find a way to access active directory thur access 2003. I have added the ActiveDs type lib and tried to use the object browser to figure out how to write the code but I am at my wits end. Does anyone happen to have a snippet of code I could use to query which...

Ok, i have just spent the last couple hours scouring the forum trying to find a resolution to my delima. I am certain that after I post this that someone will probably refer me to a previous post. If so please forgive me as I have searched on many diff sequences to find what I needed. Now that...

I have some code that is setup on a form to determine if required fields have been populated. They are required in the table but I wanted to specify the field they missed and set the focus to that field. It works great except when they choose "Next" and it goes to a new record. Then when you...

I have a form that has multiple subforms that are populated based off of a multi select control. All sub forms have the same fields, it is just filtered based off of what is selected in its associated list box. What i would like to do is have a single report that displays the filtered selection...