Search results

  1. K

    Date conversion comparison not working

    Hey everyone, thanks for all your help in the past, I really appreciate it. It's helped me to grow and get better at understanding how DB's operate. Unfortunately, I recently (temporarily)took over a position that uses an Access database that does not work properly, and I'm stumpped on how to...
  2. K

    Sum a value based off multiple fields

    I don’t really like having an id field on two of my tables (tblStatValue and tblAttributeValue) are they necessary? Also, I can understand why it would be beneficial to load all the attributes into a single column, rather than create a separate column for each one, but it seems strange to me...
  3. K

    Sum a value based off multiple fields

    Cool thanks for the info, I'll look into applying your suggestion. I appreciate your taking the time to help me out. ~Kit
  4. K

    Sum a value based off multiple fields

    So in other words the two examples should be as follows: Char_Name, hp Hypshi, 19 Bowser Jr,30 (since I didn't provide a red color modifier) Edit: I figured it out - by removing the relational link I was able to get it to work perfectly. Here's how the SQL looks: SELECT...
  5. K

    Sum a value based off multiple fields

    My apologies, thanks for your patience. Using the tables above I'm trying to have the query (to start with) show the Character's name, and a sum of the hp values based on what race, species, class, color1, and color2 was selected. I'm starting with hp but of course I have more, once we...
  6. K

    Sum a value based off multiple fields

    I've learned that if I try each value individually it will pull them but when I try to pull multiple at once it won't do it....
  7. K

    Sum a value based off multiple fields

    I updated my previous post to show comma delimited text as requested. Pat I'll give your suggestion a try. It can't hurt at this point, it's 11pm here so I don't even know what I'm doing at the moment! lol Also, I've realized since I first posted that I was using Type_Modifier when I should...
  8. K

    Sum a value based off multiple fields

    I suppose I can do that. I was trying not to show too much because I was slightly embarrassed that I was using Super Mario references, but I guess I can use the disclaimer that I'm just using things I'm familiar with to help me learn this stuff! Here's a piece of the tables and I'm hoping they...
  9. K

    Sum a value based off multiple fields

    I'm trying to build a query that uses the information pulled from controls on a form called "CharacterCreation" - 2 of the controls are "Race" and "Class", and the form stores this data in a "Characters" table. The query needs to refer to the Characters table, and another table called...
  10. K

    Select Record from List Box

    Sorry, I didn't mention it. The list box is an unbound object that uses the same table that the form is using. I want to use a list rather than a combo box for aesthetic reasons, while also reducing the number of needed clicks by one. Once the name is clicked, the rest of the form should fill...
  11. K

    Select Record from List Box

    Hello, I have a form that allows me to change the information for a list of personnel. On this form I have a list box that displays all the personnel in the list. There should never be more than 12-15 people in this list so it's an effective way of selecting records, however I can't figure out...
  12. K

    Create shapes

    I have seen that website before in my searches...Your linked post makes it easier to understand how it works though. To use it I assume I will first have to install it. But it is late. I'll look into that tomorrow. Thanks a lot ChrisO I'm off to bed. ~Kit
  13. K

    Create shapes

    An easy way to illustrate an example of what could be possible is to imagine a smiley face. You could have three circles – two for eyes which overlay a larger one for the head. My plan was to allow the user to save character traits, like eye color, to a table. I wanted to have VBA refer to...
  14. K

    Create shapes

    I’m working on a home project right now, and I have a desire to add some shapes (that would be recolored based on the user’s preference) to a form. I’ve searched this forum, and google, and found that drawing in Access is very limited. Each time it was mentioned people asked “What do you want...
  15. K

    FileSystemObject

    You’re right. I modified the code to return the value in a message box. The value is exactly what I need it to be. Also, the database resides in the parent folder. I guess I'm going to have to keep playing around with it for a while. The end result is to be able to use this location to archive...
  16. K

    FileSystemObject

    I have run into trouble with an Access database. I didn't build this database I am merely trying to get it running for our office because we really think it could benefit us. I created a shorter version of the VBA code that is giving me trouble so I can troubleshoot it. What it is trying to...
  17. K

    Rst Query -doing it wrong?

    Help! I need to refer to a query called "UserID Query" to create a record set!!! I thought this would work but it seems to be locking out my database... SQL = "[UserID Query]" Set rst = DBEngine(0)(0).OpenRecordset(SQL) It's possible that this is good and the error is elsewhere but at...
  18. K

    Multiple COUNTs in a single Query

    I played with the crosstab query wizard as you suggested but I don't think that's going to work. I'm not trying to take current fields and have them used as headers, I'm trying to create new fields that count the total based off of one field. For every instance Joe has a record that shows "A1"...
  19. K

    Multiple COUNTs in a single Query

    I think that would give me a total of all errors. I want to create new fields called "A1" and "B1" (and so on for the types of errors I have) that count up all the values that are equal to that error type for each User. The Field "Type Error" gives the error type (A1 or B1 ect.) basically...
  20. K

    Multiple COUNTs in a single Query

    Hey all, I tend to explain to much so I’m going to just throw it out there. I need to produce a Data Integrity report that lists the users of a separate database and the count of errors that they make, separated by error type. Currently my query displays all the users who made errors, and...
Back
Top Bottom