655 Posted Topics
 | You could always use the IIF construct for that.  |
| | Also, look at your ranges. Since you are using a "float" value to pass in, and your ranges are integers, you have gaps in range coverage. Even if you correct the values for upper and lower (good catch, Debasis!) 80.09 is greater than the upper bound for a C grade, … |
| | Congratulations. Every business is different, so your experience may not be the same as someone else's. That being said, here are some things to expect: 1. Your machine/workstation will probably not be completely configured. Expect to spend time doing some setup work. 2. Your login will probably not have all … |
| | Create a separate text box in the footer; point its record source to be the totals text boxes you have previously calculated. |
 | Re: Project Xen Sadun89, don't listen to the haters or the satirists (and you know who you are!). Go here: [URL="http://www.xen.org/"]http://www.xen.org/[/URL] Here: [URL="http://en.wikipedia.org/wiki/Xen"]http://en.wikipedia.org/wiki/Xen[/URL] and Here: [URL="http://www.cl.cam.ac.uk/research/srg/netos/xen/"]http://www.cl.cam.ac.uk/research/srg/netos/xen/[/URL]  |
| | Before I try to answer this, let me just say that in my opinion, MSAccess SQL is an abomination (and I've said it before in other posts). Okay, now that I've got that off my chest... It appears that this query is grouping one level too high. If you were … |
| | You might consider separating the concept of "Book" from the concept of "Copy". Then you can assign a non-significant identifier "CopyId" as the primary key, then have non-identifying relationships to "Book" so that you get clean relations from "Copy" to "Library", "CardHolder" etc. while "Book" retains relationships to "Author", "Publisher" … |
| | Your request is too vague. More information is needed before a meaningful answer can be framed. You can use any kind of database. You just have to design your table structure correctly. Also, what do you mean by "huge"? Are we talking terabytes or petabytes? Billions of rows? Thousands or … |
| | First some assumptions: the underlying datatype for the column in question is text, not number or date/time. If that's not the case, read no further; what you want to do can't be done. However, if it IS text, then you're just testing the wrong property. "Me.grdDataGrid.DataFormats(10).Format" should be set to … |
| | GDT is for globals. LDT is for locals, and different LDT's are loaded for different process threads. Here's a link that shows details of how the descriptors are formatted and used. [URL="http://www.acm.uiuc.edu/sigops/roll_your_own/i386/regs.html"]http://www.acm.uiuc.edu/sigops/roll_your_own/i386/regs.html[/URL] Scroll down about half way to find what you're looking for. Hope this helps! |
| | |
| | Two words that are quite similar in singular form are have very different plural forms. Example: The plural of House = Houses, but the plural of Mouse = Mice. [B]So, by applying the "wrong" form change, can you make silly plurals?[/B] Example: If the plural of Goose = Geese, would … |
| | Also, Directory.GetFiles() has an overload that allows you to specify search options. It looks like this: [CODE]string[] filePaths = Directory.GetFiles(@"c:\MyDir\", "*.bmp", SearchOption.AllDirectories); [/CODE] Here's a link with more details: [URL="http://www.csharp-examples.net/get-files-from-directory/"]http://www.csharp-examples.net/get-files-from-directory/[/URL] Hope this helps! |
| | I've been sniffing around a little to see if there was any way for me to keep track of who I've given upvotes to, or who I've given reputation points to. I haven't found a way to do that. I HAVE found lots of threads discussing/debating/arguing the merits of the …  |
| | Wow. As far as I can see, there's nothing to tie a user to a filter or a book. You'd better post your stored proc...otherwise we're going to think that your app does some kind of magic to get your result. |
| | This should to the trick: [CODE]select @@rowcount[/CODE] Just make sure you do it as the VERY NEXT statement... @@rowcount gets set after every SQL statement that returns results. You can also set a local variable equal to the results: [CODE]declare @myVar int select @myVar = @@rowcount[/CODE] Hope this helps. |
| | Not sure how you'd do it in mySQL specifically (there may be syntactical differences), but using ANSI standard SQL you could just do a UNION query isolating each pair, sort of like this: [CODE]select name, address, contact, activity1, startdate1 as 'myDate' from myTable UNION select name, address, contact, activity2, startdate2 … |
| | Not until you upgrade to Sql2008R2. However, if you want a quick-and-dirty, I have a little utility routine that works in Access2003 to pull out most of the table structure, keys, indexes and relationships. It isn't perfect, but it will get you a long way toward the structure. Paste this … |
 | Not to resurrect a really old thread, but did this ever get taken care of? I had a post today that I had to include some MS Access VBA code in a MSSQL post [URL="http://www.daniweb.com/web-development/databases/ms-sql/threads/365275"](See this thread)[/URL], and I was able to finally figure out how to code a VB6 … |
| | The syntax you're trying to use is only valid when setting the Source property on a form. You can't use it in code (see the MSAccess documentation on "Source Property"). However, you can use ADO and OLEDB to do this. It's really simple, just use this code snippet to pattern … |
| | Go to this link. It has a step-by-step tutorial on how to accomplish what you want: [URL="http://planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2"]http://planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2[/URL] The formatting on the site is a little odd, but the content is good. |
 | In cell C2, paste: [CODE]=IF(B2="YES",A2, "")[/CODE] Then highlight from C2 down to the end of your data and hit Ctrl-D. That will copy the formula and automatically change the references. |
| | A couple of things I noticed: --Member has no "status" attribute (for "current") and no way to track when dues were paid. Could be a DuesLastPaidDate attribute or even a separate entity, if you want to keep history. --Relationship between Company and Business is backwards (assuming it's "Business Type"). --Should … |
 | Your request is a little vague. What features, specifically? Generally speaking, you can't go back...you can import your objects from the old MDB into the new one, but the functionality is dependent on the msaccess.exe that you open. That goes for built-in functionality as well as the capabilities in VBA. |
 | |
| | The first thing you need to do is identify the Entities. All I see here is a list of Attributes. What are the attributes OF? So, for instance, in your third group of text above, you seem to be leaning toward a MEMBER, a LOAN (of a book, I assume), … |
 | 1. No. They are design steps. The result of each design step is a schema. 2. No. That sounds like a homework exercise. However, at the risk of violating the "homework help only to those who show effort" policy, I will say that the order you list the design steps … |
| | Usually it just means that there are no rows with all of the matching criteria. I suggest you try execute the query three times, each time including only ONE of the criteria in the "where" clause. [CODE]-- execution 1 select pname, age, gender, dscrptn from patient where curdate='05-17-2011' --docref='arshdeep' --meet='no' … |
| | Re: Full screen Answer to your first question: In the form you want maximized, put the following code in the Form_Load event procedure (a.k.a "On Load" from the Properties window): [CODE]DoCmd.Maximize[/CODE] Answer to second question: When you are looking at the database window, go to the menu bar, click on Tools, then find … |
| | Re: Dlookup() error Your answer is here: [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/364355"]http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/364355[/URL] Basically the same question, but with more code wrapped around it, made it easier to figure out what was wrong with your code. In this thread, you aren't using single-quotes to wrap around your embedded variables, plus DLookup needs a variant datatype variable to put … |
| | Your variable "vPass" should be type "variant". You may also wish to exit the sub if you have invalid entries, like so: [CODE=Visual Basic 4 / 5 / 6]Private Sub Command4_Click() Dim vPass As Variant '<------------------------ Should be variant, not string datatype If IsNull([usernametxt]) = True Then MsgBox "Username is … |
| | I smoked for 20 years, pack-a-day. I quit 3 years ago. I was sort of forced to quit smoking because the price of cigarettes went up so dramatically. My brother-in-law gave me a book by a fellow named Allen Carr called "The Easy Way to Quit Smoking". Google it (I'm …  |
| | Just out of curiosity, did you craft your "alter" statement in a SQL Query window, then copy it and adjust it in your C# dev environment? I have found that to be the most effective way to get stuff into code in the past, in many languages, especially when you're … |
| | Buy them. As you say, you don't have the skills to build it yourself. That means you would have to hire someone to build it. Costs time and money, assuming you have a good enough idea of how to build it (my impression is that your understanding of the details … |
| | Re: SQL Command [QUOTE=christine0293;1555401]...can i use count and top 6 in the same sql command ??[/QUOTE] Sure you can. [CODE=MSSql]select top 6 roomid, count(GuestId) from tblGuest a inner join tblReservation b on a.GuestId = b.GuestId group by b.RoomId [/CODE] That will give you a count of guests for a room. Obviously a simplistic … |
| | The ANSI 92 standard allows for 2 ways to join tables: the declarative form (INNER JOIN, LEFT JOIN, etc.) and the equation form. These two statements are equivalent: [CODE=MySQL] select table1.*, table2.* from table1 inner join table2 on table1.key = table2.key select table1.*, table2.* from table1, table2 where table1.key = … |
| | It's hard to know for sure what the problem is without table layouts and query results. However, you might try to use [CODE=MSAccess]SELECT DISTINCT tblStaff_Daily_Task.Daily_Task, tblStaff_Daily_Task.Role_Description,...[/CODE]If that doesn't work then post more details. |
| | Your understanding of what constitutes a repeating group is incorrect. Taking your Books example, you said "each title can come in a variety of formats, each format gets its own unique ISBN and library reference number". Therefore, it has a unique key. An actual repeating group would be more like … |
| | SSIS tends not to do well with multi-format input lines from text files. It can be done, but frankly if this is a one-time load it's not worth the effort. You should just manually change the file to incorporate the additional column and be done with it. However, if this … |
| | Okay, I'll bite. A FUNCTION is a programming construct that accomplishes something. A DESIGN is a plan of how to accomplish something. A DESCRIPTION is some text that explains or describes something. Therefore, a FUNCTION DESIGN is a plan of how a programming construct will accomplish something. A FUNCTION DESCRIPTION … |
| | Re: Tic-Tac-Toe Help For doing console-style applications, VB is probably not your best choice. Perhaps one of the legacy BASIC implementations (such as QuickBASIC) or FreeBasic would be better suited for what you are trying to do. However, if you are looking to learn VB (instead of having your heart set on a … |
| | It looks like you're mixing and matching your join syntax...always a bad idea, possibly creating a weird cross join situation. You should be using something like: [CODE]... FROM summer_scholars_semester a INNER JOIN summer_scholars_class b ON a.semester_id = b.semester_id INNER JOIN summer_scholars_registration r on b.class_id = r.class_id INNER JOIN summer_scholars_student c … |
| | Debrett's is the recognized authority on all things "British Nobility". [URL="http://www.debretts.com/people/essential-guide-to-the-peerage/the-ranks-of-the-peerage.aspx"]http://www.debretts.com/people/essential-guide-to-the-peerage/the-ranks-of-the-peerage.aspx[/URL]  |
| | A Functional Specification answers the question "What does my program do?". In the case of a GUI program, it's more like "What does my program do when the user does <action>?". Depending on how detailed you want to get, generally you will create the functional spec based on Use Cases. … |
| | Your selection criteria in your DLookups are incomplete. You should probably use something like this (Assuming that the value in [Combo0] is the user name): [CODE]If Me.PASSWORD.Value = DLookup("USERNAME", "SYS_USER", "[username]='" & me.[Combo0] & "' and [password]='" & Me.PASSWORD.Value & "'") [/CODE] That way you restrict the row checked against …  |
| | You can use the MailItem.BodyFormat to specify whether you want it to be HTML, Rich text or whatever, then (if HTML) wrap some <FONT face = "Courier New"> </FONT> tags around your text before you move it to the "MailItem.Body" variable. |
| | Go here: [URL="http://www.databaseanswers.org/data_models/"]http://www.databaseanswers.org/data_models/[/URL] A drug store would be a combination of Pharmacy, Pharmaceuticals and Retail Store. |
| | Here is a link to the Microsoft Technet search page that will get you a list of topics about using DataGrid in VB6. [URL="http://social.technet.microsoft.com/Search/en-US?query=vb6%20datagrid&ac=8"]http://social.technet.microsoft.com/Search/en-US?query=vb6%20datagrid&ac=8[/URL] I think you will be able to find what you need there. |
| | I'm a little hesitant to post on this, as I'm a database guy not a C# guy. But just looking over the code you posted, there are a couple of items that seem odd to me: 1. Line 12, where does variable "DBpath" get populated? 2. Line 16, where does … |
| | Re: VB help Not sure what help you need, other than to point out that if you're averaging, you need to divide your bftakeaway variable by the number of different variable added together (anscapp, ansespr, ansiced, anslatt = 4 variables), so [CODE]AnswerBox1.Text = bftakeaway / 4[/CODE] would be what you want. Dang...now I … |
The End.