Recent content by edowling

I have a, Access DB that has a bunch of records in it "flashcards" that display questions and answers. I have written a VBA sting that will randomly select a new record each time I click the next button. However, I don't want the program to repeatedly select the same record. I need...

I created a nice neat little database and created a single password for it through the Tools > Security > Set Database Password menu option. I entered the password twice to veryify it, and did everything I was suppose to. I compacted the database, closed it, and made a copy that I transferred...

Okay, I tried searching for IsDirty in the forum and I only got 3 records that use it in passing. I searched in Ms Access and there was only 1 example that I didn't really understand (it was under Dirty Property, nothing about IsDirty). Can you give me a little more information? I've tried...

I have a form with a "Delete" button on top. I want this button to delete the current record and then close the form after. I have created a SQL string that runs to delete the current record: DELETE [EnrollmentTable].* FROM [EnrollmentTable] WHERE...

I have a field on a form that I have set the default value to enter the current month. The string I used to do this is: =Format(Now(),"mmmm") When I open the form, the month does not show up in the correct format. Instead, it displays -1 Any ideas on how to fix this? Thanks, Lis

Larry: Thanks, that did the trick! I knew it was something simple. I guess I just thought there was a "shorter" way of writing it. Thanks, Lis

This may be a simple question but I've been hitting my head against the computer screen all day trying to get my query to work. So, try this... I have an IIF statement that searches through all the records in my database and keeps a running sum of the instances that a certain value is found in...

No, I haven't tried creating a new form. The code is liked directly to the form, it's not stored in a module. So, I can just copy the code and paste it behind the new form and try to run it. I'll try that tonight. Thank I'll try reinstalling Access 2000. Thanks, Lis

I have a database that I built in Access 97. I recently took it home to work on some VBA coding over the weekend and tried to open it in Access 2000 (which is what my home computer has). When I tried to open the database, I got an error saying that my "Visual Basic For Applications is...

At this particular moment in time, none of the forms are set to Pop-up.

Yeah, I tried that already. My Switchboard is still in front... :-( Any other ideas?

Hi there folk. I've been using Access for years and I'm having a problem that I've never encountered before. Here's the gist of it: I have a form that is my Switchboard. I've written and AutoExec macro to open and maximize the Switchboard when the database is first open. Several of the...