Search results for query: *

Using Access 2007 SP2 I have a report that I'm trying to get to work with data from a couple of different tables.... BACKGROUND: The database manages Work Orders for construction projects. It keeps track of property owners and the work that is being assessed to them. Both individually and...

Hi, I have a page that displays (in a table) information to the user reflecting what is IN the database and they may change the data by editing it as shown and then SAVE the data back to the database by clicking on a button. As each field is updated (via AJAX calls), I would like a little...

Hi, I'm having problems refreshing a dynamically created datagridview. It's not a problem to load the control and populate it with the correct information. When I add a record, it's inserted into the database (Access via oledb) correctly. If I add the record, close the tabpage, move a record...

Hi, I've got kind of a weird situation... I have an Access backend that I'm using to store all project data. When the user opens the data connection, he can choose from several active projects.... Upon selection of a project, the program checks to see if a "master" or "global" table exists in...

This should be very easy and straight-forward, but I can't get this figured out.... I need to grab a number out of a text file that I have captured off the web. I've stripped out the newlines, returns, form feeds, and spaces. A sample of the data I'm sorting through: (need the red number)...

I have a snippet of code that is not working... It was outside of a for loop and worked when I addressed the labels and textboxes individually. Now (inside the for loop) it can't seem to "find" the labels or textboxes.... Error Message: Object reference not set to an instance of an object...

I have some code that creates a tabcontrol, adds as many tabpages as will be needed and places a datagridview on each tabpage. The datasource does actually hold data, but nothing is being displayed in the datagridview.... Can you tell me what I'm missing or doing wrong? strDBLocation =...

I have a form that has several combo boxes and text boxes. Based on the value of one of the combo boxes, I'd like to enable/disable some of the text boxes AND change the corresponding label of the text box. The Problem: When I try to write the code for that, VB [2008] will not recognize the...

I have a combo box that is filled from a database. The connection seems to work all right and what I "SEE" when the form loads is correct..... However, the value member is not what I expect it to be. Here's the code: Private Sub SetUpWorkItemsComboBox() Dim strDBLocation As String...

This is driving me crazy... I can comment out the sql statement and everything is fine (minus the sql statement never occuring), but when I try to run normally I get an error statement. Here's the statement: strSql = "INSERT INTO tblContractors (Contractor, Owner, Address, City, State, Zip...

Hi... This is my [newbie] first attempt at creating a class to handle all my database connections, creating datasets and - eventully - inserts, updates and deletes. I created this to avoid code duplication and needless call to and from the database, but I'm not sure that I've done anything...

This is a newbie question so beware and forgive my ignorance... I have a form that has severl labels, comboBoxes and DateTimePickers on it -- (it's an In/Out board for our office). I had it working with VB6 and am now trying to create the same thing in VB.Net 2003 (the latest edition we...

A newbie question... just getting my feet wet.... I know there is an elegant way to do this, but I'm not seeing it right now. I have a form with several labels (N1...N27) and I would like to programatically fill the text of each label with names out of a database. I can do one or several...

I'm not sure if this is possible..... but here's what I'm trying to do... I have declared several variables (see code below) and then am trying to assign values to them in a loop. The values are being pulled from the database successfully, but then the code is not working when I try to assign...

This thread (thread701-957119) came very close to answering my question, however, when I alter my query as directed, it only returns one record.... I need to return the earliest maintenance record from the database for each "section" ( a street section - if it matters...) Each street section...

I've been coding for some time using the following style: Dim conn As Object Dim rs As Object Dim strSql As String Set conn = Application.CurrentProject.Connection Set rs = CreateObject("ADODB.Recordset") strSql = "SELECT Project, ProjectDescription FROM tblGlobalVars;"...

I am trying to get the file modified time on all files in a directory and it keeps getting December 31 1969 as the last modification time... Here's the code: if (is_dir($dir)) { if ($dh = opendir($dir)) { while (($pictname = readdir($dh)) !== false)...

I have a form (frmControlPanel) that has a tab control on it with 7 tabs. I'm trying to access the controls on the seventh tab from a module and can't seem to get the syntax right. Any help would be greatly appreciated. When I request the properties after clicking on my tab control, it has...

I am using Win XP and MS Access 2000. I have been developing Access databases for several years on this machine with no problems. The latest db that I'm working on is growing large, (5,376 KB Empty), it's probably the biggest database that I've been involved with to date. Everything has gone...

How do I change an Expression to VB Code? What I would like to do is change the following expression into something similar with VB... Expression: =IIf([CurrentRecord]>(Count(*)),'New Record',('Record ' & [CurrentRecord] & ' of ' & Count(*))) Actually, all I really care about is the first...