|
Hi All!
My windows application uses 3 Access databases, any one of which I update by editing data directly in the DB.
daCgy.Fill(dsCgy, "Accounts")
With 2 databases I have no problem updating single or multiple columns. One DB will update the first 2 columns but no more.
Columns are added to ONLY this DB on the fly, using a number for the header. (1, 2,3, , , ,) The columns are populated with Zeros. The zeros are changed programaticaly to 1.
The Code I use for adding columns is:-
C = "ALTER TABLE Category ADD COLUMN " & t1 & " Short "
After the columns have been created their format shows up in Access as follows:-
Field Size -Long Integer
Decimal Places -Auto
Default Value -0
Required -No
Indexed -No
Can someone please suggest a remedy? (apart from suicide!)
|
|
|
|
|
Hi all
I am new to this and found it by accident but was hoping that someone might be able to help me.
I am currently putting together a web page for a driving school that I am setting up. I want to include a page that has a calendar function very similar to that of microsoft outlook in the sence that the NEW customer would be able to click on a date and then a time and a new page opens allowing them to put in their details, credit card, address, name etc, thus booking the lesson.
In order to achieve all this I need the basic code which people keep telling me is simple but doesn't know where to get it from.
Is there a calendar that is available that I can customise, my skills are very basic so it would have to be very close. I have been told that I can get the source for MS outlook calendar but I cant find it anywhere.
Hope someone can help
Paul
Good Instructors Lead You To Where You Are Too Afraid To Go Alone
|
|
|
|
|
ASP.NET has a calendar control, all it does is create a table with links for days, etc.
Paul Ferris wrote: I have been told that I can get the source for MS outlook calendar
Definately not true.
Is your site already data driven ( that is, are you already using a database ) ? A database is obviously required to store and retrieve calendar details. I'm not sure you want a full calendar, you probably want just to show the dates/times that are available for booking ? You don't want new customers to see who else is getting lessons at what time.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi Christian,
Yes I obviously will need database capabilities which a mate of mine is dealing with.
You are absolutely right...all I need is for customers to see what is available and then book online. I definately dont want them to see other details for other bookings, however, there must be a process in place for me to view all details of all booking.
Any ideas?
Paul
A Good Instructor Will Lead You Where You Are Too Afraid To Go Alone
|
|
|
|
|
You'll use a data bound control like a datagrid, and you'll tie it to the results of a database call. So, without a data layer, there's not much you can do.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi.
I have an application developed using VB. The application is installed on the server and until recently I was updating it when needed without problems.
Yesterday I had to make new updated to the app. After I completed my updated and release both application and the set up project I removed previous version from the server and ran my new set up. When the set up was complete in the installed projects (Control Panel) I saw my application being installed (takes about 32 mg) but folder in the wwwroot was empty and of course the application didn't work because default and all other files (dlls too) are missing.
Did anyone have such a problem? I think there's something wrong with the permission (IIS) when I install the application. The installer works on my machine and all other machines as well.
There was something installed on the server recently and I think it did something that causes this to happen.
Thanks Alex.
|
|
|
|
|
Hello
Can someone direct me to a resource where I can find the codes for the greek alphabet?
I know from experience that the alphabet for greeks comes in more than one flavor. I only have one set of codes in a macro I have written for Word but I know that 2 more exist. The database I am working with will not accept greek characters so I must convert them to the english spelling before I import them. Currently, my macro will not catch greek characters from certain sources because I do not have an exhaustive list of greek codes. Below I have a find and replace for finding betas----ChrW(61538). That code won't find all symbols that look like the beta symbol since some sources have it encoded differently. I have searched in more references than I care to admit. Can anyone help. I just need a reference. Thanks 
Selection.HomeKey Unit:=wdStory
With Selection.Find
.Text = ChrW(61538)
.Replacement.Text = ".beta."
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
Selection.WholeStory
Selection.Font.Name = "Times New Roman"
-- modified at 16:08 Wednesday 9th August, 2006
|
|
|
|
|
Can someone please help me.
If I right click on a web page I can view source.
Is there a way to do this via code?
Example: FileOpen(1, WebPage, OpenMode.Input)
So basically it opens the web page as a text file. That way I can simply search through the text and pull out the information (using code).
Any help at all would be greatly appreciated. If it's not clear what I'm asking, please please tell me so I can make it a clearer
Thankyou
Grags_1977
Graham Maddocks
-- modified at 16:11 Wednesday 9th August, 2006
|
|
|
|
|
Hello,
Does anyone out there know how to update the text value of a subitem of a listview and refresh the list to show the changes?
the code I have is:
<br />
Me.listview.SelectedItems(0).SubItems.Item(1).Text = "Something"<br />
Me.listview.Invalidate()<br />
Me.listview.Refresh()<br />
Me.listview.Update()<br />
The setting of the text works, but the invalidate, refresh and update don't seem to update the text displayed to the user. THank you
eatwork
|
|
|
|
|
How do I code an emailing function in VB whereby the email is sent from a chosen/custom home address?
-- modified at 14:25 Wednesday 9th August, 2006
Nothing lasts but nothing is lost
|
|
|
|
|
|
Christian Graus wrote:
Funny enough, the first two hits are on codeproject.
That's no moon, it's a space station. - Obi-wan Kenobi
|
|
|
|
|
How do I add a select all button to a OpenFileDialog control?
Thanks,
Glen
|
|
|
|
|
Hello again,
i'm using a parametric command like this:
odbAdapter.UpdateCommand = New OleDbCommand( _
"UPDATE Operators SET description=@description, today=@today, name=@name, role=@role WHERE id=@id")
How can i see, while debugging, the actual sql statement passed to Access by DataAdapter.Update method?
It looks like there's a mismatch between the column of the table in the database and the columns of the dataset. I can say this because values are saved into db table, but in the wrong columns (precisely, it's a shift).
I need to see the actual statement to point out what's wrong.
Is there anyone who faced this yet?
|
|
|
|
|
There's n way to see that statement.
But, since OleDb doesn't support named parameters (i.e: "@description"), you have to make sure that they get created in the same order that they would appear in the SQL statement.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks Dave,
so is it my approach wrong?
The fact is that parameters order in SelectCommand, InsertCommand and UpdateCommand is not the same, due to the UPDATE's "WHERE" clause...
For i'm just trying to synchronize an Access table with an user editable Datagrid, can you suggest what the standard ADO.NET way is supposed to be?
|
|
|
|
|
If this is all you're doing, why are you supplying the SQL commands yourself??
Just give the SELECT command to get the data, then use an OleDbCommandBuilder[^] to create the rest of the commands for you.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: If this is all you're doing, why are you supplying the SQL commands yourself??
Well, let's say it's an ADO.NET newb mistake...
Anyway, using OleDbCommandBuilder it works flawlessly.
Thanks a lot
|
|
|
|
|
how to insert a flash movie in vb.net?(it is possible in old VB(vb6))how it possible in vb dot net 2005?
fff
|
|
|
|
|
how to create dockable menu(dock menu) in vb.net?i want to create a menu like the Menu tool box in vb.net.(side menu).for this i create a left menu with pull down property. but i can't dock it(need to hide it till the mouse pointer comes out and appears when mouse comes in )................ please reply
fff
|
|
|
|
|
Hi All,
I have two files IDX and FIM file. I scan images in put their information Location and size in IDX file and FIM while contains actual data about images.
I am displaying image using ImageMan. Which needs two things address of image memory block and image size.
In dataGridView I am displaying infromation about all image records it has.
On Click on each row in DataGridView I wanted to display image in ImageMan AciveX. I wrote below code but some time it works some time it gives error bad memory handle.
Please let me know ASAP what should I do to fix it.
Regards,
Vivek
Private Sub dgvImageData_RowEnter(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvImageData.RowEnter
Dim iFimLoc As Integer = 0
Dim iFimSize As Integer = 0
iFimLoc = Convert.ToInt32(dgvImageData.Rows(e.RowIndex).Cells("FimLoc").Value)
iFimSize = Convert.ToInt32(dgvImageData.Rows(e.RowIndex).Cells("FimSize").Value)
Dim fsFimFile As New FileStream(vFimFileName, FileMode.Open, FileAccess.Read)
Dim brFimReader As New BinaryReader(fsFimFile)
Dim fimBufferRead As Byte()
Dim gh As GCHandle
Dim AddrOfImageData As IntPtr
Me.mtxtErrorMessage.Text = ""
Me.mtxtErrorMessage.Update()
Try
fimBufferRead = Nothing
brFimReader.BaseStream.Seek(iFimLoc, SeekOrigin.Begin)
'Dim soundHandle As IntPtr = fsFimFile.Read(fimBufferRead, iFimLoc, iFimSize)
fimBufferRead = brFimReader.ReadBytes(iFimSize)
gh = GCHandle.Alloc(fimBufferRead, GCHandleType.Pinned)
AddrOfImageData = gh.AddrOfPinnedObject()
gh.Free()
Me.AxImageManOcx.Picture = ""
Me.AxImageManOcx.AutoScale = ImvbLib.enumAutoScale.Stretch
Me.AxImageManOcx.ScaleMethod = ImvbLib.enumScaleMethod.AntiAlias
Me.AxImageManOcx.ImageDataSize = iFimSize
Me.AxImageManOcx.hImageData = AddrOfImageData
Me.AxImageManOcx.Refresh()
Me.mtxtErrorMessage.Text = AddrOfImageData.ToString()
Catch ex As Exception
Me.mtxtErrorMessage.Text = ex.ToString()
Finally
brFimReader.Close()
fsFimFile.Close()
fimBufferRead = Nothing
End Try
Me.mtxtErrorMessage.Update()
End Sub
Vivek Gupta
|
|
|
|
|
I have Starting position and Image size. Based on these two value I wanted to know what is the memory address of Starting position in memory file.
This information is required to display image with ImageMan OCX. Above code sometime display image correctly and sometime it return bad handle error.
so I am wondering what is wrong with it?
|
|
|
|
|
I want to ensure tht only 3 or less strings are entered in a masked textbox.
How would I go about doing this?
Thank you
Nothing lasts but nothing is lost
|
|
|
|
|
Do you mean three or less characters?
You can control the number of characters using your mask. For instance select the mask as provided format "numeric (5 digits)" and delte two 's from the mask will limit the control to accepting 3 numbers.
|
|
|
|
|
No i mean 3 strings, its a textbox allowing for the entry of a store's name, here stores have a maximum number of 3 strings in their names.
Im generating a unique ID for each store and i need to ensure that only 3 or less strings are entered(this also requires that a space is not entered after the last string).
Thank you
Nothing lasts but nothing is lost
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
