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

Borvik, Thanks for your response. The script is in a very public place now, but will not be residing there for it's intended use. I realize the security risk at this location with the execution of SQL's and possible injection problems.... Ultimately, this will be running on a intranet...

Okay, I guess I didn't do a good job of explaining what I needed here.... Here's a link to the working code. The only check mark to appear is the last one.... I'd like a check mark to appear next to each row as the information is updated in the database. I would welcome any comments or...

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

I guess I spoke to soon.... sort of.... When I put the first item into the datagridview (or an additional item if other items already exist) it does not show up.... Upon entering a second item, that one and the first one (that originally didn't show up) both appear. From that point on...

Sorwen, Great catch on the name! That fixed it! Now I just have to figure out how to stop re-listing any original items when it refreshes, but I think I remember doing that before.... RiverGuy, thanks for your valuable help as well. I really appreciate the fact that you people will take...

RiverGuy, Thanks for your help. I am not familiar with setting break points and looking at the variable values.... I've spent some time putting break points in, but can't figure out how to access the values.... Won't the code below give me access to the datagridview control on the the...

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

Andrzejek, Thanks for your reply. I'm not sure if you have to specify a table.... I thought if it didn't exist, that Access would create it automatically. I know that using a query [inside Access], a table name for the new table is not needed - it creates it.... Not sure if that translates to...

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

HarleyQuinn, Thanks for your help - that works perfectly. I've used RE in perl and VBA before, but this is my first experience with VB 2008.... I've not seen that notation before ("?<=")... Can you point me to a URL that does a good job of explaining RE's for VB2008? Thanks again and a...

HarleyQuinn, Thanks for your reply. Yes, that will always be the format of the the data. (At least from the "LotSize:" to the number. The exception could be that it is listed in Acres instead of square feet, so I can't always count on there being a "Sq.Ft." in the data. I will post the code...

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

Thanks RiverGuy - it's erring on the first iteration -- 0 I have the labels named lblCorner0, lblCorner1 ....to 7 Same with the textboxes. The can be successfully addressed by using this code: Me.lblCorner0.Visible = True I changed the code as you suggested and still no joy.

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

ZmrAbdulla - Thanks for your response. Unfortunately, that was not the solution..... However, I did find the problem and it's working now. I will post the working code below. The problem was that I had re-used some code where I was writing the data to textboxes and then clearing the...

Here's a screen shot of what's loaded during run time. The tab pages are labeled correctly, but no data in each associated datagridview.http://bil.ci.billings.mt.us/pwe/images/screenshot.bmp

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

kliot, That was the problem. I don't know why it was that way, but you nailed it on that suggestion. A star for your help! Thanks to all who contributed.

CLARIFICATION: By "SEE", I mean in the 'inteli-sense' drop down box during coding... Thanks