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!

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

Recent content by JPimp

  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

    Ahh, that might be the issue, the Access DB.... This is the line where it fails: If Row5.Item("Value") Is DBNull.Value Then SWBLower.Text = String.Empty Else SWBLower.Text = Row5.Item("Value") End If Kai-What?
  4. JPimp

    Handle Null Values in DataRow

    Thanks jmeckley, yeah I am starting to conver to paramerized queries, never used before and I am just a rookie programmer, do you have a tip for a good resource on how to learn more about setting those up? It fails on the Bind grid sub routine, and then later on the row where it is calling for...
  5. 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...
  6. 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...
  7. JPimp

    Retrieve Data using Dataset and Access 2000 DB

    Thanks, I did and it worked great! Kai-What?
  8. JPimp

    Retrieve Data using Dataset and Access 2000 DB

    Thanks jmeckly for your advice, I am still a novice programmer when it comes to .NET, so I really appreciate the input. I was able to retrive a value that has data, and I populated the value in a textbox so I could see what I am working with, but when I set my case code (see below), it does not...
  9. 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...
  10. JPimp

    Conditional formatting using VBA in Access

    I did use conditional formatting on the form to begin with, but the problem is if I wanted to color code based on value and product code, and we wanted 1 stop-shop to make changes to the reference table instead of adjusting the code inside the form's conditional formatting code. Kai-What?
  11. 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...
  12. JPimp

    Excel charting - stackable bar chart

    Thanks for your help everyone, I will try to change the data structure first in the qry, and if that fails, go with the pivot table. Kai-What?
  13. JPimp

    Excel charting - stackable bar chart

    The data is coming from an Access/Oracle Query, so I am just doing a simple data import from the Query. Kai-What?
  14. 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...
  15. 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...

Part and Inventory Search

Back
Top