1,597 Topics
| |
I have a products table containing the following fields amongst others: Product ID Product Name Product Type Trade Price RRP In my order table & form I have fields that I setup with "look up" data type (this puts a dropdown box on the table & form) that finds data … | |
This is not a homework problem & my first post in 2+ years. I just got asked to do this in C# based on my asp & DB experience & I am tearing my hair out as they want in done in one day & 2 MS videos say to … | |
Could someone please help me with my access database. I have chart I added in a report. I wanted to group the month names instead instead of ordering it by the year month like 31 august 2009 for example. march value in 2007 was 2, and in march 2008 it … | |
how do i create a login dialog box in my database that does this, 1. there are two blank textboxes. one for username, and one for password. 2. when the user clicks the submit button, it will look for a match of the username in the table, then checks if … | |
hello , i have the following accessdatabase access database name = surya table name = collection field 1=id field 2=date field 3=customer field 4= amount i want an asp code were i will input from date to date to search the table collection and to display all records in between … | |
| Hi, I am new to Access 2007. I have two columns in my table, Make and Model. The Make column is a lookup from a Makes table which has different makes of computer (Dell, Toshiba, etc...) in it. I also have a Model column adjacent to it which is set … |
hi friends, i have created a table in ms-access. it contain 7 fields. in it 1st field is customer_id which is set as autonumber type. now i have a doubt of how to provide the value to this table. i dont want to overwrite the autonumber field as well as … | |
I am working an assignment which is a Sports Day Enrollment system for secondary school. I have simply 3 tables: Student(Sid,class,clsNon,Sname,dob,House) Event(Eid,Ename,Grade) Enrollment(Enid,Sid,Eid) Grade(by calculating the age) A>=16 B=14-15 C<=13 But my assumption is that each student can only apply for 3 events. How can I display the corresponding events … | |
A reply on so many data and SQL questions, this attachment has 20 forms with all different connection samples and data related queries. This will put any beginner on the right track to successful coding in vb6. I have put together this sample from numerous others over the past few … | |
I Have a access data base, and have a field "Card No" if we think starting no is 1 and ending no will be 20. some times some numbers are missing and some are not in this range, ex. 21 How can I make a missing no report? | |
I am new to databases, this is my first attempt at one. I coach a girls softball team and I am trying to put together some useful stats from the tables that I have made. I have several tables of data, 4 or 5 quries, 3 or 4 reports and … | |
please guys... help me to connect a textfield on my mobile app to be connected in ms access... thanks alot :) | |
Hello everyone Im new at this thing of programming and im having trouble in saving a new record to the database, I've searched online for this problem and ive tried all the possible ways that i find in internet but i cant manage to make it work correctly This is … | |
With the [URL="http://www.daniweb.com/blogs/entry3625.html"]success[/URL] of the iPhone App Store and Microsoft wanting a [URL="http://www.itwire.com/content/view/20349/53/"]piece of the action[/URL] it was only a matter of time before RIM got into the [URL="http://www.itwire.com/content/view/21310/53/"]online application storefront[/URL] game. With the BlackBerry App World online store launching later this month, [URL="http://na.blackberry.com/eng/developers/application_storefront"]submissions are now being accepted[/URL] from developers … | |
Is the time that it takes to boot up and power down a computer at the beginning and the end of the day work? [URL="http://www.law.com/jsp/nlj/PubArticleNLJ.jsp?id=1202426038668"]A number of lawyers[/URL] are trying to settle that question. On the one hand, users start rebooting the computer and then spend up to 15-20 minutes … | |
This morning EMC, Microsoft and IBM announced they had worked together over a two-year period to create a [URL="http://www.fiercecontentmanagement.com/story/ring-bells-major-ecm-vendors-send-content-sharing-standard-oasis-today/2008-09-10"]content interchange standard[/URL] for enterprise content management systems. It may not sound like much, but it's meaningful on several levels. For content management customers, it means it will greatly simplify moving content … | |
A good friend of mine thinks that data technology access kingpin Qualcomm can be to the wireless market in the 2010’s what Microsoft was to software in the 1980’s and 1990’s. Granted, Qualcomm is smack in the sweet spot – the premier provider of high-speed data access products and services … | |
Here at DaniWeb I have always been rather proud of the fact that not only is member feedback encouraged, but the powers that be read what is being said, participate in the debate and sometimes their minds, and system policy, are changed by it. For any real community this feedback … | |
[B]Find out which are the essential design issues when developing applications for handheld devices.[/B] Mobile devices' inherent Web capabilities open a whole new platform for delivering content. Before you dive into developing mobile Web applications, read about some issues that you need to consider. When targeting handheld devices such as … | |
McAfee, Inc., a leader in intrusion prevention, announced that its security services group, Foundstone Professional Services, will release a whitepaper on Microsoft ASP.NET Forms Authentication and "cookie replay" attacks. The whitepaper will be located at [url]http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subcontent=/resources/whitepapers.htm[/url]. In response, Microsoft authored an MSDN article: [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;900111[/url]. What is a "cookie replay" attack? … | |
I am trying to figure out how to set up a form in Access to automatically fill in 2 fields (Region # and Store Name) based on the Store number which is entered in another field. So whenever a user types in a store number, the store name and region … | |
Hello, I want to let access fill in a checkbox automatically based on the value of another field in the same table. I have a student course registration system in access, and I have a table of Marks that have a mark field, diploma field and the student_id, that I … | |
Hi expert, I'm facing a problem when i try to update the database, below is my code: Dim conn As New OleDb.OleDbConnection Dim strSQL As OleDb.OleDbCommand Dim ra As Integer Dim num conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=C:\employee.mdb" conn.Open() strSQL = New OleDb.OleDbCommand("Update [emp] Set e_name = '" & … | |
Hi i have to store a song in MS access database . I want the code in c sharp or vb.net | |
Hi everone, i have a table containing employees in and out dates of a project containing sat and sun.i want to remove sat and sun and display results.how to achieve this. | |
Hey guys need your help here. I will go ahead and describe my problem and what i intend and what i am getting. Platform for SQL Queries : MS Access There are 2 identical table in terms of table structure, they contain information ( RAW Data) about month, money i … | |
Hi, everyone... I'm using ms access 2003 and i wanna know how to write a code in vba that will take initial days x add y days every end of month and store them as accumulated days. Pleases I don't know wre to start. Thanx in advance | |
Hi, I've created a query that inner joins 4 tables. The tables have a common field CPname and CoverType. The query works and results are correct. However, when I use this query as my record source for a report, I came up with this error: "The specified field 'TblCover.CoverType' could … | |
I has a problem with MS Access queries: In SQL, if I want to include arabic word in the query where part, Simply I add '[COLOR="Red"]N[/COLOR]' before the arabic word. The question is what represents this character in MS Access query. Thanks in advance. | |
All, Have a frustrating report problem. Have code of:[code]Function RAmount() HrsAmt = DLookup("trp_ham", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) MilAmt = DLookup("trp_mam", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) RAmount = HrsAmt + MilAmt End Function Function RCount() RCount = DCount("trp_id", "qryTIMshtS") End Function Function RTotal() HrsTot = DSum("trp_ham", "qryTIMshtS") MilTot = DSum("trp_mam", "qryTIMshtS") RTotal … |
The End.