Search results for query: *

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?

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

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?

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

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

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

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

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

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

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?

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

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?

The data is coming from an Access/Oracle Query, so I am just doing a simple data import from the Query. Kai-What?

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

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

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

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

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

Genius! I cannot thank you enough ca8msm! Kai-What?

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