Search results for query: *

Hi All; I am trying to use Access to to get the IP Address of multiple PC's via NSLookup. I am using the following code to output the information to a txt file; When ever I run this code from an Access module I only get the first two lines of output.dblRetVal = Shell("cmd /c nslookup.exe...

I have a query with a custom function that works fine as long as I have not opened up the VBA editor. If that is/has been opened the query loops indefinitely calling the function with new data over and over looping through all the records and starting over again. The function is a simple string...

Hi All, I have an Access front end that I use to query an Oracle 10g database. After installing Oracle XE (I've tried both 10g and 11g) the Access front end is now longer able to connect and gives me a 3151 error. Uninstalling corrects the problem. Any ideas why this might be happening?

Hi All, I have a list of phone numbers on the seventh worksheet of a workbook. These same phone numbers appear in multiple worksheets (each number appearing only once across the first six worksheets.) I'm trying to figure out a formula (tried using VLOOKUP with no success) that will lookup...

Hi All, I am running a query with a subuery in an IN clause and am getting back zero results. The query is; SELECT COUNT(*), dial_digit FROM calldetail WHERE dial_digit IN (SELECT TO_CHAR (spd_num) FROM speed) GROUP BY dial_digit ORDER BY dial_digit If I run just the subquery I get the...

Hi All, I'm new to Visio and am trying to figure out how I can mimic the expanding functionality of the Legend shape. I have multiple custom properties for a custom shape would like to be able to assign a value to any combination of the properties and have only those properties display. Any...

Hi All, I'm pretty sure what I'm looking to do is not too complicated, but can't figure out how to write the query. I'm trying to get all records from one table that does not show up in two other tables. I currently have two queries similar to the following: SELECT tableA.item1...

Hi All, I'm trying to find a way to either catch ADO errors or test an ADO connection with VBA. The standard "On Error GoTo" statements don't catch them. Thanks, Tim

Hi All, I'm trying to setup a query in Access db "A" that will pull data from a table in access db "B". I have used pass-through queries and queries on the fly with VBA in Access to query SQL server db's, but not Access db's. I believe all I need is to figure out the connection string to allow...

Hi All, I am rather new to VB.Net 05 and am a little confused about this data binding thing. I have a built in db and a form with four text boxes. I want to take the information in the text boxes and create a record, then add that record to the db. I tried the following code, but it just gets...

For some reason I no longer have the option of viewing my main form in designer (The GUI). I can only look at the code. In solution explore, the icon is no longer the form icon either, it's the same icon as a code module. Any ideas what happened and if I can fix it? Thanks.

Hi All, First off I am pretty new to VB.Net. I used to code in VB.Old (VB 6) and VBA. I am trying to learn by building a fairly simple project and like to throw a few somewhat advanced (or at least new to me) concepts in to keep it interesting. Currently I have a main form and a config form...

Hi All, I just built an almost 100% new PC. I took the old PSU (520 watt, plenty of power for this build) and DVD drive from my old pc, everything else is new. After I put everything together I tried to turn it on and got power for a fraction of a second. Just long enough to flash the lights...

Hi All, I am trying to fill a Combo Box with a list of sites from a table. The table has two columns. Friendly Name and Tech Name. The first column is a name that the end user chooses and the second column is the technical name from another file. I want to populate the combo box with all the...

Is there a way to find out who unistalled a program? I have looked at the log viewer, but with so many entries, I have no idea what to look for. Thx, Tim

Hi All, I am trying to write a query that will select all fields from a table (without puting each field in the select statement) and add an addition field that converts the the date from the database format to a date format. I have tried the following, but get a "keyword not found where...

I have five report servers and for some reason one server lets users use "View On Demand" and I can't figure out how to stop it. Any ideas? Thx.

I am trying to do something a little weird. I have been requested to build a report that gives sign on/sign off detail. When the user signs off, they are required to enter a reason code. In the report, they want a summary of each reason code next to the detail. I know I can get it summed up...

Hello All, I have a table with start times and end times. I need to find every record that has another record in the table where the start time is greater than the start time and less than the end time of the first record. For ex. Rec StartTime EndTime 01 12:55:06 12:59:52 02...

Hi All, I wrote a simple sendkeys program to alt+tab through applications on a pc. For some reason the system does not recognize the key strokes as far as resetting the screensaver timeout time. Is sendkeys supposed to work like that? If so, how else can I prevent the screensaver from coming...