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

    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...
  16. 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...
  17. 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...
  18. 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...
  19. JPimp

    Conditional formatting and between values

    Genius! I cannot thank you enough ca8msm! Kai-What?
  20. 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...

Part and Inventory Search

Back
Top