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...
...& PROJECT DETAILS
Else
'CREATE THE TABLE FROM THE EXISTING TEMPLATE TABLE (THEN FILL DATSETS AS ABOVE)
'****** CREATE TABLE FROM TEMPLATE ******
Dim objCmd As New OleDb.OleDbCommand
If conn.State = ConnectionState.Closed Then...
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...
...String)
Dim strData2 As String
Dim strURL As String
strData2 = ""
Dim dblTemp As Double
strURL = "http://***.******.*****.****.asp?Geo_code=" & strGeoCode
Dim uriWebSite As New Uri(strURL)
Dim wReq As WebRequest =...
......<strong>LotSize:</strong></font></td><td><fontsize="2">10,500Sq.Ft.</td>...
I am using this as the pattern:
strPattern = "LotSize:.{39}(\d+,*\.*\d+)"
It is returning no matches! Is there something obvious that I'm missing here? I'd really appreciate any help anyone is able to...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.