Question about 2001 Ducati 996 R

1 Answer

How to create a program using ms access?

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

Posted by on

  • Rob Selvy
    Rob Selvy May 11, 2010

    Ok I see you have a Ducati yet you are asking a question regarding the use of MS Access? Can you please elaborate on what it is you're trying to accomplish?

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Champion:

    An expert who has answered 200 questions.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 254 Answers

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

hope this helps

Posted on Jan 04, 2009

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...

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?


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

Dec 04, 2008 | Microsoft Access 2002 for PC

1 Answer

How to create database in m.s.office


you can create static data base in Excel works heet and link each cell to another sheet.
or you can create a dynamic data base in access. you need a MS access book. there are lots link you need to understand in order to have a working data base.

Nov 28, 2008 | Microsoft Computers & Internet

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

1 Answer

MS ACCESS


How to Evaluate the rows in MS Access

Sep 18, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
2001 Ducati 996 R Logo

Related Topics:

99 people viewed this question

Ask a Question

Usually answered in minutes!

Top Ducati Experts

Arnie Burke
Arnie Burke

Level 3 Expert

4514 Answers

Gino Cussen
Gino Cussen

Level 2 Expert

216 Answers

yadayada
yadayada

Level 3 Expert

71338 Answers

Are you a Ducati Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...