Question about Microsoft Access 2002 for PC

1 Answer

How to create a program using ms access?

How to create a program using ms access in simple inventory?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 174 Answers

You need to study the basics of database programming. take short courses for database programming.

Posted on Dec 04, 2008

  • Florenn Baggao
    Florenn Baggao Dec 04, 2008

    you need to study the basics of database programming. take short courses for database programming.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to develop online inventory system for a iron sail shop and which programming language is good for inventory and which database ? and php, mysql can help?


Thank you for using FixYa
Hello I see that you may be leaning toward open source, and that is a good idea for your inventory. Of course MySql will work. You could use MS Office Access, or Oasis is another good one. My previous experience has been that people hear all these big names about databases and might not even need one that expensive. Are you determined to write this one yourself or do you have a programmer in the family or are you going to pay for one? It depends on how extensive your inventory is, if you are looking at less than 500 to 1000 items then these programs may really be overkill. It is surprising how many small businesses are actually running on Quickbooks. You can take a program like that and others similiar and use just the inventory module. Some people might even be able to get by with Microsoft Works or other smaller programs. Most database programs have templates that may not be exactly like your business, but allow modification to the templates to make it more like your own. I hope this was useful and please comment if this was helpful to you.

Apr 26, 2011 | Computers & Internet

1 Answer

Can you give sample source code of visual foxpro program using mySql as database flatform


Create a connection: lcStringCnxRemoto = "DRIVER={MySQL ODBC 3.51 Driver};" + ; "SERVER=200.1.1.1;" + ; "PORT=3333;" + ; "UID=booking;" + ; "PWD=booking;" + ; "DATABASE=booking;" + ; "OPTIONS=131329;" lcStringCnxLocal = "DRIVER={MySQL ODBC 3.51 Driver};" + ; "SERVER=localhost;" + ; "UID=root;" + ; "PWD=clave;" + ; "DATABASE=booking;" + ; "OPTIONS=131329;" SQLSETPROP(0,"DispLogin" , 3 ) lnHandle = SQLSTRINGCONNECT(lcStringCnxLocal)
Accesing data:
SQLSETPROP(0,"DispLogin" , 3 ) lnHandle = SQLSTRINGCONNECT(lcStringCnxLocal) IF lnHandle > 0 cmd = SQLEXEC(lnHandle,"select QuantityRooms from roomtype","cur_roomtype") IF cmd > 0 BROWSE ELSE AERROR(laErr) MESSAGEBOX("Can't connect to mySQL. Error: " + CHR(13) + laErr[2]) ENDIF USE IN cur_roomtype SQLDISCONNECT(lnHandle) ELSE AERROR(laErr) MESSAGEBOX("Can't connect to mySQL. Error: " + CHR(13) + laErr[2])
ENDIF
Creating complex sentences:
TEXT TO lcSQLcommand NOSHOW SELECT Inventory.inventoryid, Inventory.date, Inventory.roomtypeid, Inventory.sold, Roomtype.descrip, Roomtype.rooms FROM inventory Inventory INNER JOIN roomtype Roomtype ON Inventory.roomtypeid = Roomtype.roomTypeID ORDER BY Inventory.date DESC ENDTEXT cmd = SQLEXEC(lnHandle,lcSQLcommand)
Passing parameters to a query:
nValor = 12 cmd = SQLEXEC(lnHandle,"select QuantityRooms from roomtype where roomtypeid = ?nValor","cur_roomtype")
Calling a Stored Procedure:
SQLEXEC(lnHandle, "call myStoreProcedure(@param1)")
GOOD LUCK!

Mar 17, 2011 | Microsoft Visual FoxPro Professional...

2 Answers

What is ms-excel


ms excel is a program that you can make graphs and set up all sorts of things like prices at a petrol station on the front neon sign you can set it up that each time the price rises it will automatically increase that rise in dollars and cents
hope this helps

Feb 15, 2011 | Broderbund Learn MS Windows XP and Excel...

3 Answers

How to create simple batch files


Creating a batch file
MS-DOS users
Microsoft Windows and other users

MS-DOS users
To create a basic batch file in MS-DOS, follow the below steps that give you an example of how to create a basic batch file.

  1. Open an MS-DOS command window or get to MS-DOS. Additional information about doing this can be found on document CHDOS.
  2. At the MS-DOS prompt, type: edit test.bat and press enter.
  3. If typed properly, you should now be in a blue screen. Within the screen, type:

    pause
    dir c:\windows
    dir c:\windows\system

  4. Once the above three lines have been typed in, click File and choose exit; when prompted to save, click "Yes." Users who do not have a mouse cursor can accomplish this same task by pressing ALT+F to access the file menu, then pressing "X" to exit, and pressing enter to save changes.
  5. Once you are back at the MS-DOS prompt, type: test and press enter. This will execute the test.bat file and begin running the file. Because the first line is pause, you will first be prompted to press a key. Once you press a key the batch file will run line-by-line; in this case, listing the files in the windows and windows\system directories.
If you wish to add more lines to this batch file you would simply type "edit test.bat" to edit the file again.
Additional information about the MS-DOS edit command can be found on our edit command page. Some versions of MS-DOS and bootable diskettes may not have the edit command; if this is the case, you would either need to obtain the edit.com file to access this file or use the copy con command.




Microsoft Windows and other users
A Windows user can still use the above MS-DOS steps if they wish to create a batch file. If, however, you're more comfortable using Microsoft Windows or your operating system, you can use any text editor, such as Notepad or Wordpad, to create your batch files, as long as the file extension ends with .bat. In the below example we use the Windows notepad to create a batch file.
  1. Click Start
  2. Click Run
  3. Type: notepad and press enter.
  4. Once notepad is open, type the below lines in the file or copy and paste the below lines into notepad.

    @echo off
    echo Hello this is a test batch file
    pause
    dir c:\windows

  5. Click File and click Save; browse to where you want to save the file. For the file name, type "test.bat", and if your version of Windows has a "Save as type" option, choose "All files", otherwise it will save as a text file. Once all of this has been done click the Save button and exit notepad.
  6. Now, to run the batch file, simply double-click or run the file like any other program. Once the batch file has completed running it will close the window automatically.

Jan 04, 2011 | Computers & Internet

1 Answer

Choices available to create database of c++ program


Hi,

You should use the MySQL database as it is free to use and has great functionalities.

go to the belo link to get details about creating database and using in ur c++ code.

http://c-programming.suite101.com/article.cfm/using_a_mysql_databases_with_c


Thanks!

Mar 31, 2009 | Computers & Internet

1 Answer

Rating Teachers Behavior Inventory


You could assemble a simple Excel spreadsheet and then total, average, find the mean, standard deviation, trend or a host of other answers or information. You can lock the spreadsheet so no one can tamper with it or change the structure. That would be much easier than creating a special program unless there is a specific reason to do so.

Mar 21, 2009 | Microsoft Computers & Internet

2 Answers

Create an inventory prog. in visualbasic?


Do you have Microsoft Office? There are some excellent Access Templates for Inventory Databases

Jan 13, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

How to create a program using ms access?


access has a complete tutor built in id do the course press F1
and ask.

hope this helps

Dec 13, 2008 | 2001 Ducati 996 R

3 Answers

Connectivity between HTML page and Ms-Access


<HTML>
<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>

Nov 11, 2008 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Access 2002 for PC Logo

Related Topics:

3,240 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...