1,597 Topics

Member Avatar for
Member Avatar for decay

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 …

Member Avatar for HI2Japan
0
140
Member Avatar for globalizard

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 …

Member Avatar for sknake
0
202
Member Avatar for mundetas

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 …

0
58
Member Avatar for scias23

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 …

0
97
Member Avatar for rahulsaigal

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 …

Member Avatar for timothybard
0
125
Member Avatar for Dukane

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 …

Member Avatar for Dukane
0
415
Member Avatar for engg_kavi

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 …

Member Avatar for engg_kavi
0
60
Member Avatar for lkkkeith

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 …

0
57
Member Avatar for AndreRet

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 …

0
848
Member Avatar for riyaza

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?

Member Avatar for timothybard
0
59
Member Avatar for tmoney7566

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 …

Member Avatar for timothybard
0
77
Member Avatar for xilamei
0
116
Member Avatar for ZidaneXero

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 …

Member Avatar for kvprajapati
1
449
Member Avatar for happygeek

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 …

0
208
Member Avatar for slfisher

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 …

Member Avatar for DigitaLink
0
263
Member Avatar for Techwriter10

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 …

0
181
Member Avatar for Brian.oco

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 …

0
179
Member Avatar for happygeek

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 …

0
1K
Member Avatar for newscop

[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 …

Member Avatar for sloper47
0
151
Member Avatar for tgreer

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? …

0
185
Member Avatar for radline75

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 …

Member Avatar for timothybard
0
362
Member Avatar for roxys

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 …

0
71
Member Avatar for Steammike

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 = '" & …

Member Avatar for Steammike
0
277
Member Avatar for coollife
0
52
Member Avatar for greeny_1984

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.

Member Avatar for timothybard
0
93
Member Avatar for ultra vires

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 …

Member Avatar for ultra vires
0
110
Member Avatar for mevanga

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

Member Avatar for mevanga
0
130
Member Avatar for JFunk

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 …

0
68
Member Avatar for brightline

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.

0
88
Member Avatar for TBotNik

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 …

Member Avatar for TBotNik
0
110

The End.