Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JPimp
  • Content: Threads
  • Order by date
  1. JPimp

    Active Directory and secure access

    I have a couple of reports and I want to grant/deny access to the report form itself based on the AD group the user is in / is not in. I have searched online, but cannot find much useful info on this, can anyone point me in the direction of a good article or sample code? Thanks, Kai-What?
  2. JPimp

    Need to import CSV file into SQL Database

    I am not even sure where to begin with this, I need to set up something that will run automatically (as a scheduled task) to check for a CSV file, i.e. *.CSV, if it exists, then copy the contents of the file to a SQL table, then move the CSV file in to a different folder on the network. I have...
  3. JPimp

    Handle Null Values in DataRow

    I am retrieving a value from an access table, and I get an error each time the value is null, how can I work around this so it continues to execute the code and populates the datagrid and leaves those null values blank in the datagrid? Dim cmdSelectSWBLower = New OleDbCommand("Select * From...
  4. JPimp

    Extract value from Database and determine if exists or not.

    I am trying to extract a field value from a database table, and if the value is Null, I want to redirect the user to another webpage, but it comes up with the object not found error on the line where it checks if the value is null or not. Dim CmdSelectVerify As OleDbCommand...
  5. JPimp

    Retrieve Data using Dataset and Access 2000 DB

    I have done this multiple times with SQL and Oracle, but cannot get it to work with an Access DB. This is what I have for code: Dim cmdSelect = New OleDbCommand("Select Limit, Value From PartSpecs Where [PART No_:] = '" & strPID & "'", conMetrics) Dim myDA As OleDbDataAdapter = New...
  6. JPimp

    Conditional formatting using VBA in Access

    I set up a reference table in Access 2000 with some specs, now I want to reference this table and color code my form based on the value, for example. I want to check to see if tablename.fieldname is less than or equal to field1 or greater than or equal to field1, and then color = red, yellow or...
  7. JPimp

    Excel charting - stackable bar chart

    I am trying to make this in to a stackable bar chart, but I am at a loss here. DATE flexlate CountOfWO_BASE 0108 ontime 22 0108 overdue 10 0208 ontime 28 0208 overdue 9 0308 ontime 17 0308 overdue 21 0408 ontime 25 0408 overdue 14 0508 ontime 32 0508 overdue 11 0608 ontime 52 0608 overdue 6...
  8. JPimp

    Connecting to Access Database using VB6

    For some reason when I try to connect to this database now, used to work on my other PC, it comes back with this error when I put a "stop" on the line: Object variable not set or with block variable... This is the connection command: cmdLookupMachines.ActiveConnection = "Driver={Microsoft...
  9. JPimp

    Excel - open excel.htm file in edit mode

    I have an Excel.html file which is linked to a database, so anytime I want to refresh the data in the file, I have to right-click the file and select edit, or else it will open in a browser (since it is an html file), I am looking for some way to automate this using a macro, but I cannot seem to...
  10. JPimp

    Connection error with MS Access 97 database

    I have used this connection string many times in the past for a database/VB code, but for some reason I keep getting this error now: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified This is the connection string [Code] Dim cmdLookupMachines As New...
  11. JPimp

    VBA to conditionally format form values

    I never write VB code inside Access, and I am not sure how to start this, what I want to do is to color code values in an Access 2000 form based on hard-coded values in a table. I.e. I have a table called "limits" and for each field in my form, I have a Min and a Max value, so for example, I...
  12. JPimp

    Conditional formatting and between values

    This is a really dumb question, and I know there is an easy solution, but either I am too tired or too dumb to see it... I want to check for values and color code cells in my Datagrid based on the value, this works great for my red, but when I do yellow, it colors all cells yellow because I am...
  13. JPimp

    OnItemDatabound and Datagrid

    When I try to use the onitemdatabound function in a .NET page, nothing happens? I do a simple query to pull in all data from a small table (test mode still), and then use the itemdatabound to highlight some columns, but I get no datagrid, no error, nothing? What Am I doing wrong other than...
  14. JPimp

    Conditional Formatting of Datagrid

    I keep getting this error message when I try this code, and I have never done this before (conditional formatting), so I am not sure if that is the issue or something else? System.InvalidCastException: Unable to cast object of type 'System.EventArgs' to type...
  15. JPimp

    Query in Access vs VB 6

    I have this query, which works great when I run it in Access, then I move this over to my VB code, and it fails: Dim cmdTabwareBase As New ADODB.Command Dim rsTabwareBase As New ADODB.Recordset Dim oracleTabwareBaseData As String oracleTabwareBaseData = " SELECT...
  16. JPimp

    Secure URL(File)

    I am looking to use Windows authentication to secure access to a certain URL within my .NET project, I see where I can set it up in web.config, but that seems like it is either allowing or denying access to all pages within the project, not a specific one? I have the web.config set to Windows...
  17. JPimp

    Visual Studio 2003.NET and errors

    I have a brand new laptop, and I installed .NET framework 1.1, IIS, and then finally VS 2003.net, but I cannot get it to work, each time I start VS, it tells me that the web server is not running, I go look, it is stopped, start, and try again, same error, and in the event log there are all...
  18. JPimp

    Use calculated field in Datagrid

    I am not even sure if this is possible, I am pulling in data from a DB, populating 2 text fields, just so I can calculate the difference between the two, and then I want to display the difference in the datagrid. This is what I have so far: Dim DataReader As OleDbDataReader...
  19. JPimp

    Sum three text fields

    I want to sum the total in 3 different text fields, but all I get is the concatenated total instead of a sum total. Int32.Parse(TenMinuteSample.Text) Int32.Parse(ThirtyMinuteSample.Text) Int32.Parse(SixtyMinuteSample.Text) Dim TotalCount As Int32 TotalCount =...
  20. JPimp

    Validation and sum of fields

    I have a single field where users enter a numeric value, and then 3 additional fields that is supposed to break down the 1st value in to 3 groups, but I want to validate that the 3 breakdowns are not greater or less than the 1st numeric value. I tried a RangeValidation expression in VS.NET, but...

Part and Inventory Search

Back
Top