Over 1 million tech questions and answers.

Help with Shopping cart for visual basic

Q: Help with Shopping cart for visual basic

Hi I am working on a shopping cart for books in visual basic and can not figure out how to remove a selected item from the cart and adjust the price. any help would be appreciated

Thanks

RELEVANCY SCORE 200
Preferred Solution: Help with Shopping cart for visual basic

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Help with Shopping cart for visual basic

I don't use visual basic ... but only can give you some program idea....

on the cart screen it should have a "check box" hold the id of that item ( id should be the shopping cart id + which row in the cart)

when the "check box" is click ... and you press "Upadte" button to post..

you have the the shopping cart id and the item row value to remove it ... then refresh the screen again...

Read other 2 answers
RELEVANCY SCORE 79.2

Ok, so I just set up a merchant account, now I need the shopping cart thing.
I have no experience doing this sort of thing, and I could use a little help getting it going.

basically I need to know:

where do I go to get a shopping cart (free would be preferable, since I already paid for the account...), and how do I integrate it into my website?

Is there somewhere I can go to just get the code so I can "copy and paste" into an html form? what language would it use? Java, php, html, etc.
 

A:shopping cart

Abdhul said:

Ok, so I just set up a merchant account, now I need the shopping cart thing.
I have no experience doing this sort of thing, and I could use a little help getting it going.

basically I need to know:

where do I go to get a shopping cart (free would be preferable, since I already paid for the account...), and how do I integrate it into my website?

Is there somewhere I can go to just get the code so I can "copy and paste" into an html form? what language would it use? Java, php, html, etc.Click to expand...

How about this? http://www.online-store.co.uk/
 

Read other 2 answers
RELEVANCY SCORE 79.2

I downloaded CubeCart and am trying to work on it in either Dreamweaver or the File Manager on my server. Either one will work but I'm CLUELESS as to where to start.

I don't know how to put this all together and make it work and the installation instructions may has well be written in Greek. I don't know where to start...there are two header.php and two index.php and two of this and two of that and you get the drift. HELP....I need someone to walk me thru this or I may just lose my mind.

I downloaded Cube Cart cause I can *mangle* the logo easier than I can the one on osCommerce. At least I did when I was using the server I had before but that one had it laid out where I could identify which files were which...now I am on my own. This isn't a Fantasico or C-panel. Liz
 

A:Okay, I am trying to put together my shopping cart

First off, does your web server or web site meet the requirements for using CubeCart? PHP 1, MySQL on a Unix/Linux Server?
 

Read other 2 answers
RELEVANCY SCORE 78.4

I am wanting to do a shopping cart for my clothing line company. Standard buying and selling etc.. I have looked at a few options. I am not sure what my boss entirely wants but i enjoy the php/mysql options, though maybe I want ASP or something else? I have found myriads of these at vairous prices and some free? I was hoping someone here in the techsupportguy forums could give me some experience suggestions or ask me questions to determine my needs and then give a suggestion on that. If i can get away with inexpensive and highly flexable or powerful whatever software that would be great! The boss is kind of looking at cold fusion but thats not anything solid. we just want something excellent. He has had a bit of experience with it. Anyone Anyone ?

and um.. is this the right forum to ask this type of a q?
 

A:What are the best shopping cart programs available?

Check out http://www.oscommerce.com/
 

Read other 3 answers
RELEVANCY SCORE 78.4

I'd just created a website with shopping cart but it always said the "shopping cart is empty" when I go to checkout. But it's fine with IE10 or FireFox.

A:ie 11 shopping cart glitch

Hi,
Please post questions about html, css and scripting for website developers to
IE Web Developer forum
Naturally include a link to your website with your question so that someone my visit the site to investigate the issues.
or
go to http://modern.ie to find some tools and downloads to troubleshoot website compatibility issues for website developers.
to debug web pages fist
display the Developer tool (f12)
then select the Debug tab, and then refresh the page to show suppressed error messages.Rob^_^

Read other 2 answers
RELEVANCY SCORE 77.2

Hi guys, I'd like to learn more about integrating a shopping cart application with a merchant account.

I understand the mechanics of obtaining credit card information from the user via HTML forms and whatnot. What isn't clear to me is what I would then do with this information.

I've done some searching and all I can seem to find is tutorials on making the actual shopping cart software, which I can do myself, and links to other purchasable shopping cart software.

Can someone link me to a page or book that covers this topic in detail?
 

Read other answers
RELEVANCY SCORE 77.2

I am running XP home SP1 and IE 6. When I try to add something to a shopping cart I get this error "We're sorry, more information is needed to order this item. Please complete Step 2, then continue your order" on one site (llbean.com). On another site (victoriassecret.com) it acts like it adds it to the shopping bag, but when I view the bag it is empty.

I had SP2 installed and uninstalled it, and have the same results. I also have done the registry tweak to fool the system into thinking that IE6 is not installed and reinstalled it. I was able to add something to my LLBean shopping cart after doing that. The item was backordered, and when I went back to change my choice, it gave me the "We're sorry, more information is needed to order this item. Please complete Step 2, then continue your order" error again. I have run the latest Spybot S&D, and Adaware versions and deleted some spy/adware. Still having the problems. Hijackthis 1.99 log below:

Logfile of HijackThis v1.99.0
Scan saved at 8:13:46 PM, on 1/3/2005
Platform: Windows XP SP1 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\LEXBCES.EXE
C:\WINDOWS\system32\LEXPPS.EXE
C:\WINDOWS\system32\spoolsv.exe
C:\PROGRA~1\COMMON~1\AOL\ACS\acsd.exe
c:\... Read more

A:IE 6 wont let me add items to shopping cart

got this working by deleting all of Dell's mcaffee security center which for some reason was not allowing me to shop online after installing XP SP2
 

Read other 1 answers
RELEVANCY SCORE 77.2

When shopping on line nothing will go into the shopping cart! Someone walk me thru on how to allow me to do this. I have windows xp with ca suite security supplied by road runner internet with what ever e machines put in the computer when you buy it.

A:security & cookies & shopping cart

What internet browser are you using?

Read other 1 answers
RELEVANCY SCORE 77.2

The webhost for this shopping cart site creates the codes needed to make it work on a separate page for each item. I copied the codes for each individual product and pasted them onto one page.
Each item contains a form with hidden fields that consists of the product's id # so that the shopping cart processor should know which item is being purchased when the buy button is being clicked.
However, the different products are not being recognized on the page, but rather, every buy button interprets as if the first item on the page is being purchased again and again.
Being that I'm not familiar with javascripts, I don't know how to format this page so that the buy buttons for each individual item sends the right info. One thing that I did learn is that 2 forms one 1 page cannot have the same form name so I altered the name of the 2nd form to celectvar as opposed to selectvar (the default name given by the webhost).

Following is a clipping of the scripts and forms for the 2 first products on the page.
PHP:

<script> function validateSelect() {    

 var 
els Read more

A:javascript used in a shopping cart site

So what is your question exactly?? They have bad coding on their site and are only going to be selling black & white cookies. They should have tested the pages before they put them on the internet.....poor business decision.
 

Read other 3 answers
RELEVANCY SCORE 77.2

I have IE7. I connect through road runner. I have not made any changes to my computer. everything was fine. Did a virus scan. talked to road runner.. etc. I cannot get to the site that hosts my shopping cart. www.ecartsoft.com from my computer. also I cannot log on to access my shopping cart account. I talked extensively to my shopping cart tech. all is fine there. we did a tracert and traced my steps to their server.. seems like somehow their server is not allowing my computer in. I also cannot use the shopping cart on my own site to test it.. It times out, can't find site..etc.
I deleted all temp files, history, cookies, turned off firewall.. etc. etc. checked internet options. we went over it all! this is sudden. I have had this cart site for almost a year with no problems. can anyone shed some light. I can access all other sites.. My bank, aol, ebay, etc.. etc. no problems. seems like it is my computer??

A:can't access my shopping cart or their site

Please do this

Click Start => Run and copy and paste the following line into the run box: regsvr32 urlmon.dll, press OK. Once it is copmpleted you will get this message DllRegisterServer in urlmon.dll succeeded, repeat the above steps, but replace regsvr32 urlmon.dll with:

regsvr32 actxprxy.dll
regsvr32 shdocvw.dll
regsvr32 mshtml.dll
regsvr32 browseui.dll
regsvr32 jscript.dll
regsvr32 vbscript.dll
regsvr32 oleaut32.dll

Read other 3 answers
RELEVANCY SCORE 77.2

When adding items to our Paypal shopping cart we can continue shopping to add more items by clicking on the continue shopping button. However, a POPUp appears notifying you that "The webpage you are viewing is trying to close the window-Do you want to close the window-yes or no"
This is confusing and is there a way to deactivate that POPUP from showing up. It only appears on internet Explorer and not Google Chrome or Firefox.
Any help would be appreciated

Thanks
Al

A:[SOLVED] Paypal Shopping Cart Pop Up

Hello and welcome to the forum.

You should be able to click on the pop up and click Allow.
Click Start = >Internet Explorer => Tools => Internet Options => Click on the tab Privacy => Under Pop up blocker click Settings => Enter Paypal and click Add

Read other 3 answers
RELEVANCY SCORE 76.4

Yesturday the Shopping Cart on Newegg stopped working. I did have it working earlier in the day as I had compiled a list of items but when I went back later the cart was empty. I logged back in thinking it would be there but still it was empty. Now whenever I click on "Add To Cart" it takes me to the next screen saying it has added it to the cart but the $ counter in the top right corner stays at $0.00 and when clicking on the cart itself or proceeding to checkout it tells me the cart is empty. It does this whether I am logged in or not.

I tried adjusting the Cookie settings like their site advises but it didn't seem to change anything. They did suggest going into Tools, Internet Options, Security, Custom Level then scrolling down looking for Cookie options (there is no option for cookie listed there). But under privacy I found cookie options and changed it to accept all but still the problem was the same.

The weird thing is that yesturday sometime before the problem started the browser history was somehow erased. Nobody actually went through the steps and cleared the history though. The only actions that were performed between the cart working and not working were photo's being uploaded from a camera and the MyDocuments folder being accessed by another computer on the same network. The other computer on the network has no problems with Newegg's cart but this one - a laptop on a wireless network using XP and IE version 6.0 still does.

There no wer... Read more

A:Solved: Newegg Shopping Cart not working

I guess I should've researched this a little more thorough. My clock was a set to feb' instead of jan' - changed that back and all is well. Doh!
 

Read other 1 answers
RELEVANCY SCORE 76.4

Some business web pages don't display the shopping cart box on the web page on one Dell computer with WinXP using either IE or Firefox. These same pages work correctly on all our other computers. When looking at properties on a laptop alongside the Dell and comparing, all seems the same. Have tried restore back several months, have shut off pop-ups and turned back on. have updated Java, same problesm.
 

A:some web pages don't display shopping cart icon

Read other 16 answers
RELEVANCY SCORE 75.6

I am (a novice and) trying to make a shopping cart for a bookstore (using visual studio and visual basic). The shopping cart page shows a gridview where all the items the customer wants to purchase is listed (the gridveiw has columns for isbn, title, price and amount). The amount column is a text box, where the user can change the amount. Under the grid view I have a button <update amount>. A click on this button is supposed to go through the gridview to see if the user has changed the amount of any of the books. If so, the price of this item(book) is to be changed (prise * amount of the item). If the amount of one book is set to 0 the row is to be deleted from the gridview. Can some one help me with the code needed to accomplish this???

At the end of each row in the gridview I have put a button <remove item>, and a click on this button is supposed to delete the selected row from the gridview. The gridview is listed on the shopping cart page with this code:

GridView1.DataSource = Session("kurv")
GridView1.DataBind()

What code do I need to accomplish this removal of the selected item?
 

Read other answers
RELEVANCY SCORE 73.2

I have a (currently) simple Access database with Search form, to which I've added a multi-field filter, based on a nice bit of code I found online.

The next stage is to reproduce this form with added functionality, for issuing and receiving goods into stock.
I'd like for the user to be able to select multiple stock items, see them added to something in a "shopping cart"-style and then click a button to issue the selected items (subtract from stock) or receipt them (add to stock) and, print the details.

The way I'm imagining it, I'd add Issue Qty and Receipt Qty fields to the existing Stock search form. Anything that had been given an Issue Qty or Receipt Qty would populate a query. The query would simultaneously feed a subform, displaying the slected items & quantities for the user to see, and then buttons for Issue and Receive (or a single button, maybe) would allow the user to confirm their changes, updating the stock quantity accordingly, printing a report showing what they'd issued or receipted and emptying the query for next use.

I'm not sure if this is the best way to go about it. Perhaps rather than populating a query, it could or should be done with a sort of temporary recordset.
There might be difficulties in undoing, too. I'd need to have something in place to allow the user to either delete items from the "cart" subform or set the Issue / Receipt Qty on the main form to zero. In either case, it'd b... Read more

A:MS Access 2007 - select items shopping cart-style, then update table?

Read other 16 answers
RELEVANCY SCORE 66.8

Hello,

I guess my question can be asked in two ways, the short way and the long way.

Here's the short one:

Can you do everything that you can do with VBA with VB?
The long one is:

I need to be able to write programs that conceivably invovle web forms/web services (VB right?), Microsoft SQL Server 2002 (VB again right?) but also Microsft Office applications like Excel and Access (VBA??). Does that mean I need to learn both Visual Basic and Visual Basic for Applications? In my initial research into Visual Basic I've learned that Visual Basic for Applications is a subset of Visual Basic, so shouldn't that mean that Visual Basic, being the parent and more powerful than Visual Basic for Applications, is capable of performing all of the functions that Visual Basic for Applications does?

Thanks for your help,
Bsdslayer
([email protected])
 

A:Solved: Visual Basic vs. Visual Basic for Applications

I do not know VB at all, only some VBA. The main difference is that VBA has words specifically for the applications, a classic exanple would be the
Range("a65536").End(xlUp)
both range and .End(xlUp) are for use in Excel.
 

Read other 3 answers
RELEVANCY SCORE 62.4

Hello everyone. Right now im doing a proyect in Visual FoxPro v. 6.5 where i am using a control names MAPX.OCX, this is used to display maps and its cordinates. I have already started to use this control, but im a bit stuck. I read in the manual of the control, but it is made for Visual Basic and C++ and I have very little experience using Visual FoxPro.

The instructions of the VB as the following:

Private sub Globessymbol_click()
Dim top20cities as mapxlib.layer
set top20cities = map1.layers("ciudades")
top20cities.style.symbolbitmapname = "x.bmp"
end sub

The Map1 is the name of an OLE object that identifies the MAPX.OCX and this also has some layers to put the name, icons, lines, etc. This layers are the ones i am having trouble codificating it in Visual FoxPro.

does someone here have any knowledge of how to do this? i'll thank very much the help.
 

Read other answers
RELEVANCY SCORE 61.2

Hi there
I'm just messing around a bit with Visual Basic - I just want to use EXCEL (mainly) and a couple of really simple Windows stuff. I can't be bothered with C# or .NET -- I'm not (nor intend to be) a professional programmer -- but would like to have a go with some small applications and get to grips with the Basic in EXCEL.

I've got the old Ms Visual Basic 6 disks -- is it worth while messing about with these on W8 (Ms believe it or not is going to support the platform through W8 releases !!!) or should I just bite the bullet and download Visual Studio express which seems a bit overkill also for what I'm really trying to do.

As I'm running a 32 bit version of Office it would seem that most of the VB6 stuff could run quite simply in EXCEL 2010 (32 bit) even though my OS is x-64 --or I could even run it in an XP VM.

Any suggestions as to which is the better way to go -- I just want this for casual use -- not as a professional.

Cheers
jimbo

A:Visual Basic 6 or Visual Studio for EXCEL use

Doesn't Office 2010 still support VBA (Visual Basic for Applications)? I think that is what you mean by Basic in Excel?

As far as supporting VB6 in Win 8, VB6 apps do run in Windows (32 bit), though we've had issues at work with some 3rd party components. I'm pretty sure 64 bit is out for VB6! I couldn't get any VB6 executables to run on my Windows 7-64 box, though they will run just fine in an XP VM.

I think your options are VBA in Excel if you want to stick with classic VB...

Read other 3 answers
RELEVANCY SCORE 58.8

Hi everyone,

I've been trying to get my feet wet in creating a .vbs file from notepad to do a basic function. I wanted to be able to run .reg files remotely but also interactively. This led me down the path of simply finding an example of a .vbs that would open anything remotely at all. Notepad is what came up with the most results and the Win32_ScheduledJob object appeared to be what was needed.

I researched many different places but this is a decent walkthrough. http://msdn.microsoft.com/en-us/library/windows/desktop/aa394601(v=vs.85).aspx

I grabbed the code below out of the website and changed the date parameters to run in a couple minutes from my current time. I could see the task in scheduled tasks but when the time had come and gone nothing would happen and this is just trying to get it to run locally so far.

strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\cimv2")
JobID = "Test"
Set objNewJob = objWMIService.Get("Win32_ScheduledJob")
errJobCreate = objNewJob.Create _
("Notepad.exe", "********143000.000000-420", _
True , 1 OR 4 OR 16, ,True, JobId)
If errJobCreate = 0 Then
WScript.Echo "Job created successfully: " & VBNewLine _
& "Notepad.exe scheduled to run repeately at 14.30 (2:30 P.M.) PST" & VBNewLine _
& "on Mon, Wed, and Fri."
Else
WScript.... Read more

Read other answers
RELEVANCY SCORE 54.4

Hi everybody,
When I try to open a Visual Basic file (from a network drive) by double-clicking the file, it won't open. The error message says that path is not found (then gives the path of the file I just tried to open). However, if I leave the Visual Basic window open and try to open that same exact file from the same exact location, it opens. Also, If I copy the folder that the file and the forms are in from the network drive to the desktop, I can open it. And if I open the file within Visual Basic and do a Save As and save it to the desktop and close the window and open the file from the desktop, it works. Any ideas what would be causing this?

Read other answers
RELEVANCY SCORE 54.4

How would you convert a and b from a While loop to a Do While loop, and a Do Until loop.

a. While J <> hugeJ
largeJ = largeJ + J
J = J Mod bigJ
End While

b. While N <= display
Print “Visual Basic 6 How To Program!”
N = N * 7
End While
 

A:Visual Basic Help!

Do your own homework!
 

Read other 1 answers
RELEVANCY SCORE 54.4

Hello.

im developing an application under visual basic, Now im stoped because I dont know how to setup the parameter about that my application can print automaticly the "PDF file loaded into my application" inmediatly after after a print job is send from another application what ever Word, excell or POS software.

Its possible to make my application can print automaticly after other print job is send to the default printer ?....
 

A:Visual basic

Welcome to TSG Jeismair,
I worked with this issue in 2012.(I did a TSG thread on it). Seems we were not able to autoprint a pdf. The best I could come up with was to open the PDF so the user could then manually print. He was only wanting to print 1 page. So your request may be different.
 

Read other 1 answers
RELEVANCY SCORE 54.4

I need to pass an array of values to a select statement in VB6 but need help with the syntax

cmnFileGet.CancelError = True
cmnFileGet.FileName = txtFilePath.Text
cmnFileGet.Filter = "*.txtDate"

cmnFileGet.FileName = txtFilePath.Text

is the line of code that is currently passing a single file to the select statement. I want all files that qualify for the filter "*.txtDate"

txtDate is a text box the end user fills in. For example I want all files that qualify for "*.7/30" if the end user has entered 7/30 into the text box.

The syntax in the case statement must somehow cause the program to go back for the next value in the array once all the other code in the case statement is executed.

Any help will be greatfully appreciated.
 

A:Visual Basic Fun

If I understand your question, you would want to do something like this:

cmnFileGet.Filter = "*." & txtDate.Text

That would limit the dialog box to files with an extention "7/09" in your example. Again, I'm not sure I understand the question. I appologize if I'm way off here, but let me know if I am...

As far as the array part of the question goes, if your array was called Dates() where each member of Dates() was a date entered by the user:

for x = 1 to UBound(Dates)
Select Case Dates(x)
case "7/09"
...
case "7/10"
...
case else
...
End Select
Next x
 

Read other 1 answers
RELEVANCY SCORE 54.4

I've got some time on my hands and thought to teach myself VB. Can someone give me a quick differentiation between VB6 and VB.NET? Is the latter just the more recent version, or does it include internet controls?

Thanks
Pradhan
 

A:Visual Basic.NET vs Visual Basic

Read other 6 answers
RELEVANCY SCORE 54.4

Hey Guys, It's me again... I am a Computer Engineering Student and working on our thesis now... I wonder if you could help me in my problem.

I Want to print a receipt from the form in visual basic 6.0... If it clicked a button, it will print automatically... I want to know what is the code for that.. thank you!

Hoping for your immediate replies.. Thank you so much!

A:Help! Visual Basic 6.0

PrintForm

Printing a form In Visual Basic | Visual Basic 6 (VB6)

Print VB Form Using cmdialog Control in vb6 - Toolbox for IT Groups

Read other 1 answers
RELEVANCY SCORE 54.4

I need some help with my Visual Basic class. I am a student, but have done all of the coding, so no coding is needed. I just need some troubleshooting with the coding itself. I cannot get the correct alignment I need in my listboxes. Once you see the coding, you will understand what it is that I need, especially if you are decent in VB. In the first and second listboxes, the content is not properly aligned. I need the text to be perfectly aligned from top to bottom.

I have included the zipped file for those who wish to help to view. You will need Visual Basic 2008 Express Edition or Higher, I think.
 

Read other answers
RELEVANCY SCORE 54.4

**EDIT** Apologies, it's C++, not C#
Hi there.

I'm currently working on a coursework project and I've come across some trouble.
I'm making an animation and in one scene I want to have a string of text scrolling to the right, and another string of text scrolling to the left.
I am able to get one string of text scrolling, but if I try to add another one, it just screws it all up.
I've also tried adding another view port on the same scene but it still doesn't seem to do the trick. Ideally, I need to have two view ports in the scene.

Here's the code I have:
This is declared at the beginning of the code:

Code:
float fTranslate = 0.0;
Translating code:

Code:
//TRANSLATION STARTS
glPushMatrix();
//glTranslatef(0.0f,fTranslate,0.0);
glTranslatef(fTranslate,0.0f,0.0); //Determine whether the text translates side-ways (x) or upwards (y)
glTranslatef(75,200,0.0); //Starting point of text
glTranslatef(-50,-200,0.0);
glColor3f (1.0, 1.0, 1.0);
renderSpacedBitmapString(20,600,5,GLUT_BITMAP_HELVETICA_18,"We've got great deals at");

fTranslate += 2.0; //Translation speed - ALSO, + makes text go right, - makes text go left
glPopMatrix();
//TRANSLATION ENDS

glViewport(0,0,300,400);

glPushMatrix();
glTranslatef(fTranslate,0.0f,0.0); //Determine whether the text translates side-ways (x) or u... Read more

Read other answers
RELEVANCY SCORE 54.4

Here is my code...The only error I am getting is a identifier expected after the "b" on Private Sub at the very top. Can anyone help me out??

Private Sub
btnFactorial_Click( _
ByVal eventSender As System.Object, _
ByVal eventArgs As System.EventArgs) _
Handles btnFactorial.Click
Dim x As Double
Dim Fact As Double

lblOutput.Text = "To determine the Factorial of a number. " _
& "Please enter a number less than 10."
& "Then, click on the Factorial Button to view the results."

x = Val(txtInput.Text)

Fact = Factorial(x)
lblOutput.Text = ("")
lblOutput.Text = (" " & x & "! is " & Fact)
End Sub

Private Function Factorial(ByRef x As Double) As Double
If x <= 1 Then
Factorial = 1
Else
Factorial = x * Factorial(x - 1)
End If

End Function

End Class
 

Read other answers
RELEVANCY SCORE 54.4

I'm trying to run an SQL INSERT INTO statement in a macro in Microsoft Access. This is the general line I'm trying to run:

Code:

INSERT INTO [2004Q27] (TrainingID, Count) SELECT 1, Sum(IIf([Q27_1]=1,1,0)) FROM 2004Data

It basically tallies up the count in the Q27_1 field. Note that this is just one instance of this line. I'm running it in nested For loop to run it for every year and for questions Q27_1, Q27_2...Q27_i. This is the actual code, with the variables for the year and the Q27_<counter>.
Code:

adoRS.Open "INSERT INTO [" & Trim(sYear) & "Q27] (TrainingID, Count) SELECT " & j & ", Sum(IIf([Q27" & Chr(95) & j & "]=1,1,0)) FROM " & Trim(sYear) & "Data", adoConn

I'm getting a "Syntax Error in INSERT INTO statement", and the only problem is the underscore. I have this statement for other questions, such as Q1, Q2...Qi and it works perfectly, but question 27 contains multiple answers, and so the field names are Q27_1, Q27_2, etc. Any suggestions on what to do?
 

A:Visual Basic / SQL help!

Nevermind, I got it to work.

Apparantly "count" isn't a good word to use for a field name. Once I changed it to "tally", it worked like a charm. And the underscore wasn't a problem at all.
 

Read other 1 answers
RELEVANCY SCORE 54.4

Does anyknow here know of any good websites with beginner and intermediate visual basic tutorials along with a forum with lots of helpful people?
If so, click on reply thread and post me the link!

Thanks
 

A:Visual Basic .net

Here's a good website. People post their projects that they've worked on. It's a great learning tool to download them and review their code etc.

www.planetsourcecode.com
 

Read other 1 answers
RELEVANCY SCORE 54.4

Hi everyone,

I have a relatively simple question. I have a ms access database app written in vb6. I have a function in the app that allows the user to edit a record. The way i'm currently working this is by using the adodata.recordset.addnew method which writes an new record to the database and then i'm going through using SQL and deleting the old record. I was wondering if there is, and i'm sure there is, a way to bring up a record and edit it and save it as opposed to writing a whole new record and deleting the old one.

Thanks to all who read!
 

A:visual basic 6.0 ADO

G-Man:

As you are using ADO then you have the ability to Update a record:
Code:

With ADOData.Recordset
.Fields("MyField1").Value = "My New Value"
.Fields("MyField2").Value = 400
.Update
End With

This updates the current record with the new field values. Now this appears very simple (and it can be) however you do generally need to consider a few things. Firstly you need to ensure that the recordset (table) that you are updating has a primary key. If you don't then you will either get spurious results or you will get an error message that may say something like "insufficient base information for updating".

I would strongly recommend that you avoid using the ADO Data control and create your recordset(s) in code as this gives you much more flexibility in terms of setting the cursortype/locktype of the recordset which governs whether it is updatable etc.

Another method that you can employ is to use a standard SQL statement to perform the update (though here again a primary key is strongly recommended to avoid odd results) and do something like this:
Code:

ADOData.ActiveConnection.Execute "Update MyTable Set MyField1 = 'My New Value', MyField2 = 400 Where MyKeyField = 123456"
 

Read other 2 answers
RELEVANCY SCORE 54.4

Hello,

Please need help urgently, I am trying to send(FTP) a file via visual basic 6.0 to a server, also the user name and password need to be included in the application too.

Thanks,
 

A:Visual basic and FTP

Use the Microsoft Internet Transfer Control. You can find examples of its usage at http://www.pscode.com. Search for FTP and you should get a ton of results.
 

Read other 1 answers
RELEVANCY SCORE 54.4

Is there a freeware (opensource) version of Visual Basic? There are a boatload of good powerpoint templates and games that require VB but my school does not have it. My administrator is hesitant to buy something that she doesn't understand, so I am trying to find a freeware version of it to show her and the rest of the teachers how useful it can be.

A:Visual Basic and Win 7

Delphi Open Source

Read other 1 answers
RELEVANCY SCORE 54.4

I have this assignment where i have use case blocks and if statements and I'm so confused on how to do it. I have to make it where button 2 will calculate the total charge that also tells that there is a $30.00 deposit. and my label control i have to enter 1,2,3 for the item and "F" or "H" for day rental. I have to make it to where i can put either upper or lower case.
Someone please help me. I dont know where to start. This is what i have so far
 

Read other answers
RELEVANCY SCORE 54.4

Hello,

I was interested in programming and I was wondering if Visual Basic would be a good language to learn.

Thanks,

Mike
 

A:Visual Basic 6

Read other 13 answers
RELEVANCY SCORE 54.4

first post so please go easy on me -

I have written a macro in VB within Excel to send a saved copy of the wokbook as an attachment in an email to predetermined addresses, this part is so far fine and working okay, however i now want to set the importance of the email to high when a certain priority is selected in the spreadsheet anyu help would be great, this is what i have so far...

Sub email()
On Error GoTo NotSent
ActiveWorkbook.SendMail Recipients:=Array("[email protected]"), Subject:="New RSPR Request"

MsgBox "Do Not Save Any Changes To This Document. Any problems contact EATF x54512."
Exit Sub

NotSent:
MsgBox Prompt:="This RSPR Request has not been sent. To send the request select Yes when the file has loaded."
MsgBox "Do Not Save Any Changes To This Document. Any problems contact EATF x54512."
End Sub

Thanks
 

Read other answers
RELEVANCY SCORE 54.4

Hello,

I have a couple of questions about visual basic,

I have used vb before long time ago, now i look around and i see stuff like visual basic.net, visual studio, etc...
I looked at a software store on the internet to see the price of visual basic, and i thought there would be like visual basic version 7, 8 9... like it used to be
But there isn't any, could someone explain to me the difference between these different visual ___ softwares? especially .net and studio

Also, how old is visual basic 5 now? How outdated is this program? Like would i be able to still use this to make a powerful program?
 

A:Visual basic, which one!?!?

Read other 13 answers
RELEVANCY SCORE 54.4

Greetings all,

I am constructing a macro that will allow me to have my summary sheet open, hit a button to browse for a .xls file then import the values from it and add them to any existing values. File location and the amount of files are a variable so adding the one at a time is fine.

So far I have been able to get Excel to open the browse window, allow me to select the desired file and import the values from the specified cells but I’m having trouble with getting it to place the values into the same cell co-ordinates and add them to any existing values that may be present.

My coding experience in Visual Basic is limited to what I have learnt in the past few days trying to get this working. What I have constructed up until now has been done so primarily through salvaging bits of code from other macros modifying them and basically putting them together through trial and error, so it’s entirely possible I have made simple mistakes.

Here is what I have so far…

Sub Compile ()

Dim x As Long, z As Variant
Dim bk As Workbook, sh As Worksheet
Dim sh1 As Worksheet

Set sh = Workbooks("DTS09.xls").Worksheets("DTS Totals")

z = Application.GetOpenFilename(FileFilter:= _
"Excel files (*.xls), *.xls", MultiSelect:=False)
If Not IsArray(z) Then
MsgBox "Exit?"
Exit Sub
End If

For x = 1 To UBound(z)

Set bk = Workbooks.Open(z(x))
On Error Resume Next
Set sh1 = bk.Worksheets("Trigger Info")
On Error GoTo 0
If Not sh1 Is Nothing Th... Read more

A:Visual basic help please.

Read other 7 answers
RELEVANCY SCORE 54.4

I just installed Visual Basic C++ 2010 Express and I was wondering if I could uninstall older versions. It's about the following applications:
Microsoft C++ 2005 Redistributable
Microsoft C++ 2008 Redistributable x86 9.0.30729.4148
Both have one security update as well. So is it safe to remove them or will this cause problems?

A:Visual Basic C++

Try the uninstall and see.

Create system restore point first -
START | type create | "create a restore point"

Uninstall the older C++ versions. If problems occur, restore the system using the restore point created -
START | type rstrui

Regards. . .

jcgriff2

`

Read other 2 answers
RELEVANCY SCORE 54.4

I am having a go at Visual Basic Express 2008 and looking for books or websites for training.
One thing has me confused what is the difference between Visual Basic Express 2008 and Visual Studio 2008?
I would also like to know of any good websites for training.

Thanks
jack

A:Visual Basic

This guy has done a really good Youtube series about VB 2010.

Read other 2 answers
RELEVANCY SCORE 54.4

Hello I am thinking of getting into visual basic but it's too expensive for me (yes I'm a tight little ****) but does anyone know of a freeware clone of it at all. thanks.
 

A:Visual basic

Excel had it's own version of VB, as far as the coding goes it's all the same, you can even run class modules etc from it. A good starting point to learn VB coding. Obviously you can't make executables with it though.
 

Read other 14 answers
RELEVANCY SCORE 54.4

I use VB 2008 Express Edition, and I cannot get my multiple form application to work correctly. I am trying to get frmNext to show up after frmInput is done. So, in frmInput's button click event, I type in strName = TextBox1.Text, frmNext.Show(), and Unload frmInput. Unload does not work in vb 2008 anymore I guess, because it gave me an error. So, I typed in Me.Close(), which closes the application altogether. So, I decided to go into frmNext's form load event and type in Me.Text = strName and frmInput.Close(), which causes the entire program to close. I need help getting frmNext to show up and frmInput to close down.
 

A:Visual Basic Help

Read other 6 answers
RELEVANCY SCORE 54.4

Hi, can anyone show me code that i can apply to a button in Visual Basic to open up a program, i am having trouble... Thanks in advance (Y)
 

A:Visual Basic

http://msdn2.microsoft.com/en-us/library/sxz296wz(VS.80).aspx
 

Read other 2 answers
RELEVANCY SCORE 54.4

I'm trying to learn VB. I have a picBox and some optButtons along with chkBoxes.
I can't figure out how to name font styles and apply them to the text in the picBox.
IE. I want Comic Sans as my default font with Arial and Courier as optButtons. What is the syntax to do that? my picbox is called picDisplayBill
Do I need to create a sub procedure to do this?
Thanks!
John
 

A:Visual Basic

Why can't you just change the FontStyle property in the Properties box? I'm not quite sure I understand the question.
 

Read other 1 answers
RELEVANCY SCORE 54.4

hey everyone.... im going to take some programming classes this semester and i can take c# and visual basic. my question is would it be a bad idea to take the classes together in the same semester? I ask because one of my previous teachers recommended not to take java and C# at the same time cause they have very similar commands. i looked at some visual basic.net and C# and they seemed really different but still would like to get a better opinion.
 

A:C# vs. Visual Basic .Net

ZaUcY said:





hey everyone.... im going to take some programming classes this semester and i can take c# and visual basic. my question is would it be a bad idea to take the classes together in the same semester? I ask because one of my previous teachers recommended not to take java and C# at the same time cause they have very similar commands. i looked at some visual basic.net and C# and they seemed really different but still would like to get a better opinion.Click to expand...

Well C# and Java is in high demand so you should take both of these classes. You can also take VB also. VB is easy to learn so you might want too add this course also.
 

Read other 4 answers
RELEVANCY SCORE 54.4

Ok, I'm writting my first real program in Visual Basic.

I have questions.

This program is going to generate a CSS, and I need to know if it's possible for me to get a quick color picker implented in the app. So, when they pick the color, it will automatically input the hex code for that color in the box.

Help is really appricated.
 

A:Visual Basic

there is this activeX component called Microsoft Common Dialogs Control (mscomdlg.ocx) and can be used to popup a color picker. learn more at www.msdn.com
 

Read other 3 answers