Recent content by Uvuriel03

  1. U

    Need help creating a database table structure

    Ah, didn't realize. Thank you for letting me know!
  2. U

    Need help creating a database table structure

    This database concept is giving me way more trouble than I thought it would, so any help you guys can offer would be most welcome. Overall concept: We're creating a database that will allow our sales team to select the options specific to a product they are trying to sell and have the database...
  3. U

    Date/Time Parameter query

    Actually I figured it out. The problem is that my field *does* have date and time, so just doing a parameter with a date value wasn't working. I created a query field as follows: DateParameter: DateValue([DATEOF]) [What Date?] I had to add "What Date?" to the Query Parameters and change...
  4. U

    Date/Time Parameter query

    I have a table with a date field that I'm building a query for. It has dates in this format: 4/17/2009 10:40:03 AM 4/17/2009 1:25:37 PM (m/dd/yyyy h:mm:ss AM/PM, I think) I would like the query to ask for a date and have the query show all records from that date. However, because of the...
  5. U

    How can you add multiple instances of a random number together?

    Gemma, Thanks for the start. Does this actually add each random number together, though? What kind of boxes will I need to display the appropriate data? Thanks
  6. U

    How can you add multiple instances of a random number together?

    I have this line: [HP] = Int(([HD] * Rnd) + 1) It creates a random number between 1 and the number in text box [HD] and puts that number in text box [HP]. I created another box, [LvlChar], and would like it to add as many instances of code together as is the number in [LvlChar]. IE, if the...
  7. U

    A database structure conundrum...

    Actually, I think I have it figured out. =D
  8. U

    A database structure conundrum...

    I have a database that holds all of the product in our warehouse. What I'm working on right now is how to, using one form, log a location change from one location to another. I haven't solidified exactly how this part of my database is going to function, so I'm open to all suggestions. I'll...
  9. U

    Audit Trail Idea

    Steps 1-3 were successful. Step 4 note: The "Compile" option was grayed out. So I de-apostrophized my call line and... Same error. Eh. This is getting ridiculous. Thank you guys for hanging in with me on this tedious chore. :/ I somehow doubt this should be so difficult...
  10. U

    Audit Trail Idea

    1. The sample you sent does work. 2. Hope this is what you were looking for. =P 3. I did not rename the module. 4. I did try the Find function, actually, when it was suggested that there might be a duplicate, and there were only the references in your module and the one where I...
  11. U

    Audit Trail Idea

    I did try all three calls, sorry. And when I comment it out, nothing happens, no errors, no nothing. Would it be possible that I'm getting this error because data field types and/or names aren't matching up or something?
  12. U

    Audit Trail Idea

    This was as close as I could get for the References... I used the next highest number I had for the ones that didn't match exactly. I'm still getting the same error, though...
  13. U

    Audit Trail Idea

    Nope, the one I imported is the only module I even have. I have compiled the VBA, and that's the only error I get. Or at least, the only one I can get TO, since I can't cancel that error and continue or anything.
  14. U

    Audit Trail Idea

    I imported the module straight from Irish's example.
  15. U

    Audit Trail Idea

    I'm getting this error when I try to save the changed record: Any ideas why it'd give this error? Thanks
Top Bottom