Search results

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

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...

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...

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...

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

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...

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

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...

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...

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...

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?

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...

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.

I imported the module straight from Irish's example.

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

Thanks so much for helping me out this far. Unfortunately, I'm not very familiar with modules, and I'm having difficulty figuring out exactly what I need to change to adjust it to my own database. What information do you need to help me out with this one? Thanks so much!

Hey Irish, I'm wondering if you can help me out. I'm kind of lost when I'm looking through your modules. Could you help me add a column to the audit trail for Company Name? Some of the companies have overlapping IDs (bad form, I know, but else it would require MASSIVE amounts of...

Ah. Thank you! I want them to be locked if they are enabled, since I don't want the user to be able to change the auto-filled number, but I can just put it in the coding when to lock and unlock it, as well. ^__^

I have a form with a bunch of text fields that the user fills in information for. Now, depending on the company the user has selected on the splash page, certain fields are supposed to be disabled. I have a dlookup on the onCurrent event and it all works just fine, EXCEPT! There are like 4...

Your suggestion to use the NotInList even is working AMAZINGLY. I'm going through all of my forms right now and adjusting them all to use this procedure. WAY better than the scrappy error-trap I was trying to throw together. Thanks a bunch!