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

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

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

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

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

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

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

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

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

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

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

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

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