o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Simple question on sum (MS Access) -

I'm using MS Access 2002.

What I want to do is add the values of sp2, sp3, sp4, sp5. and want the sum to appear in totalsp column automatically. How do i do it?

 

Use VB to call / open forms in access -
This is a relatively simple question, but all my searching hasn't yielded the simple information. Assuming I am using a simple VB program, how do I progmatically display forms from Access? All I want to do is start VB (as a real simple front end) and use it to display forms alrea


VB.NET 2003 and MS Access -- very simple -
This question seems oh-so-simple to me, yet I'm completely confused. I'm used to VB6, and am -very- new to VB.NET. I'm also not very familiar with MS Access, I usually do work with SQL. However, since I went out of my way to get VB.NET (not specifically for this), I thought that I migh


Simple Password Question -
Hello, I have an I think simple Question. How can I use the VB 6.0 data control with an Access Database which has a password. Is there a way to access the recordsource and password without having to type set datbase = Opendatabase (......) Johan


Link Tables in Access from XML over HTTP -
Hi, Im not sure this is the place for my question. === The goal of my question ... Linking an XML Document on a webserver into MS Access. I need to do this for a small webpage. Its just a simple registration with mail response. For future features i just added all new re


Simple Report Question, I hope -
I simple want to take an access report and convert to a text file using VB6. I don't want to have to reference Access, because I am not sure that all users will have access installed on there computer. Thanks in advance Ed Farias


Two questions -
Okay, first off, I'm still getting the hang of this crazy thing called VB. So if you'll all be willing to forgive me if I'm slow to pick up... Sencond, my questions: First Question: I'm trying to import 5 text files into an Access DB. I found a VBA command for importing data in Acc


Graphics programming in VBA (howto / can you) -
simple question, hopefully a simple answer. is it possible to do a custom 'drawing' in vba? e.g. to a '.wmf' file? the reason is i need to create a custom chart to do some analysis and the standard types (including pivots) in excel & access don't work. what i need to do is


Simple Search Database -
Dear Gurus I have been developing databases in Access and know VBA fair bit but I have never developed a database in VB. I had to develope a simple database comprising of just one table Contacts and all I want is one text box to enter full and partial name and one subform displa


Simple Question on AutoNumber -
A simple Database question in MS Access: I wish to ask if it is possible that I can manually set a field of autonumber type to a particular number by code and that number is not duplicate with an existing record when inserting records into the database? Or this will generate error?


A simple question on VB5, Access, and Excel -
This should be a simple one but I have run into many walls on developing this and now I am hoping that someone has an answer. My goal is to build a program that will copy data from an Excel workbook sheet and add it to an Access database. The spreadsheet has the names of the fields


Simple Access Security Solution -
Simple Access Security Solution! I am using an Access Db (.mdb) as a backend database. The information contained is not sensitive and most of the users aren't that computer literate. I planned on setting up a password for the Db, but after reading all the forums it seems like a real


different versions of access databases... ezzzy -
Ok... this is a simple question. Can an access 2002 database be opened up by access 2000 (or whatever jet database engine comes with 2000)? I obviously need this database to be used by a visual basic 6 program, and a good portion of the people who recieve this database will either not


Simple MS Access DB Question -
I was wondering if creating a ADO or a DAO database on a computer without MS Access will work? Thanks.


Simple question on sum (MS Access) -
I'm using MS Access 2002. What I want to do is add the values of sp2, sp3, sp4, sp5. and want the sum to appear in totalsp column automatically. How do i do it?


Storing/Reading Values from Access/Excel -
Hi, I got kind of a simple question, tried searching for answers but not sure the ones i was getting pertained to what i want. I just want to store some numbers and strings (around 60 different values) to use as variables in my program. That way when a numeric value changes i can j


Same Old Problem, Can't Run A Simple Application, Now Uploaded! Plz Help -
Dear All; I uploaded A simple access Application, simple controls, and one load of code that when u resize, just DoCMD.Maximize. When i run it, it gives the same old error message "unable to connect to OLE or Active X" Given that i have win xp, and i also tested it on win


db security - simple question -
I have developed a vb front end to an mdb. How do I set licencees from opening the mdb file from access and changing the data? Can I password protect the mdb from within access, and still open in from vb? Thanks Ping


Microsoft Access.. and VB.. -
ok I have a simple Access files NAME and PHONE. is there an API or anything VB that has presets.. if not how do I setup a simple access file to store names and numbers in VB.. and this place!! rocks thanks for all your help guys/gals.


variable values to db table! -
First off I am self teaching myself this stuff! explains the silly question. Also, I just simple folk so please make the answers understandable. (5 yr old & under understandable). I have a variable holding the results of some calculations and would like to store them into a


a very simple question on arrays -
Hello, I'm a beginner on VB, and I have a very simple question: Does anyone here knows how to get the size (or dimentions) of an array? For example, if I define Dim y(2,3) As Integer How can I get back the dimentions of y? This should be really simple, but I can't find the right f


Noob .net to vb6 question -
A really noob question here….. I have only access to visual studio .net, and have created a very simple app that does not require any .net stuff. I find on some older pc’s I get an error when opening my program, I believe that these pc’s do not have any .net runtimes. My quest


Access Textbox -
Simple question How do i pass data from one textbox to another in the same form in access 2003 thanks james Bowtell


Access/VBA question -
Any help is appreciated. I've created 150 simple queries in Access. What I need to do is combine all the results into one table. Example, I run the first query and the results appear in the first cell (row). I run the second query and i want the results to appear in the second r


I Guarantee Nobody Here Can Answer This Question! -
I know that nobody here will answer this question, because this is the third time I've tried. But, I like to do this anyway because its such a simple question that you'd expect ANYBODY that had ANY experience at all with Javascript could answer this question without even thinking abou


Simple ADO qn involving VBA (Access->Excel Data transfer) -
ok i'm a total newbie when it comes to manipulating an ADO... i understand how to define, establish and close an ADODB connection between the 2, but I don't quite get how to manipulate and transfer the data. The various examples I've found on the net are quite confusing, so my quest


Deploying an App -
Simple Question, but I keep getting conflicting answers...I am developing an app with an access database to be distributed to different users. Do the users have to have access installed on their machine to use it and if so does it have to be the same or better version?


simple access question for simple mind -
First im new to programmming. How do I verify in my code that name "X" inputted in the table does not match any other name in the table?


[2005] a really simple question with regards to creating a field -
Hi All, i have a really simple question for anyone who is willing to help i am using ADO.net to create an access table i would like to know how to create one of those yes/no fields in an access database please. i have tried Code: ("CREATE TABLE test (test logical nul


Using access with a password.... nid help -
hi pipz, just a simple question. how do u connect vb to a access db that has a password? i created a db first without a password and using vb , it works. but wen i activated the security for my db. it gives me an error. could u show me how to connect my vb with access? Thanks


Excel - Access, Really simple for an expert !!! -
Hello, I would appreciate help on what is probably a very simple task. I am writing a simple VB6 front end to a database. (Access97). What I would like to do is to append the contents of a spreadsheet once per week to an existing table in Access. So that's one spreadsheet p


***SIMPLE Question -
Hey, Does anyone know how to use MS DataGrid of MS FlexGrids. I am just trying to get some data out of an access table using flexgrid, but due to lack of programming experience, am not able to. I have written the connection strings between VB and Access, but cant use FlexGrid. An


opening one form from another -
This may seem like a silly question I have lust started using vb6 net before I used vb access. I am having trouble finding out the command in this version they are differant in vb accesss The most imediate Question I have is this I have created a Command button to open a pop-up form w


Simple question from a simple mind -
I'm using VB6 Pro and this is my first vb project. Here is the simple question: What is the code for a command button on click, to run an setup.exe program? I'm putting shareware files that I purchased onto CD and want to create a little form that will have install buttons for each


access database and transactions -
hello everyone, this would just be simple i use microsoft access in my application. my question is, if i'm going to run this application on a machine that doesn't have microsoft access installed, would transactions still be supported??? -> [BeginTrans,CommitTrans,RollBack]


Simple Palm Application -
I have a very simple question form that I need made. Here is the scene: 1. Palm User will enter simple data onto a form. (Name, Age, Number or Children). 2. The data is stored in a database, and at the end of the day uploaded to the database for analysis. (MS Access) Is


Simple Databse Question (Noob Question) -
OK i just got VS 2003.net, so im extremely new to vb.net, How would i jsut create a Simple Database program (without using a server). How would i make one?


Simple Hflex grid question -
Hello I've got a simple question. I use ADO and a mshflexgrid. I want the first field (for example Name, to be placed in the fixed column, so when users are scrolling horizontal the name must be seen at all time. How can I do this? Best regards, Johan


BIG QUESTION - DIRECTX and .Net -
I want to be able to show a simple 3D scene in a .net program. (a solar system model to begin with, simple shading or wireframe would be fine) My question is: how do you integrate DirectX into a .net program? Does anyone have a tutorial for this or even a simple bare-bones project


stupid question (build) -
please help! I feel so stupid! I know it must be simple. I have made a simple program using .net, and it runs great on my computer, but won't run on any other computer i try. I'm guessing there are neccessary files. like maybe the .net library that they need to install. Pleas


Really Easy Network Question -
I have a simple VB6 program running with an Access DB. I never designed the program to run over a network because I don't know enough about how to do it. My question is, could this program be loaded onto a server and be run on multiple clients at the same time? My concern is multipl