Search results

Thank you for the suggestion, but unfortunately it had no effect.

I have a continuous form, and I have set a couple of the text boxes in the Header section to sort by the corresponding field in the Detail section. It was working fine, but now it isn't, and I don't know why. The only thing I can think of is, I changed the field name at one point, to remove a...

I am still pretty new to databases, so I have no doubt the way I came up with to handle this issue is probably not the most efficient. The problem I foresaw with importing the existing scores into the SCORES table is that it has a couple of foreign keys. And one of the tables it relates to...

Nope. Had never even heard of it. I knew Excel could do that, but not Access. I'll google it and read up on it. Thanks!

I have a continuous form, and there's a button on it that runs some VBA code. The code takes information that's in the detail area of the form and writes it to a table. There will be some records on the form that will be ignored -- every record will not have data that gets written to the...

A little background on what I am building: I know how to write VBA in Excel, so I created a spreadsheet system for my Dad, to track the golf scores for an amateur seniors group he plays with each week. For each game, he enters a couple of different things on what he calls the Sign-in sheet...

Thank you! That seemed to fix the problem! :)

I am trying to use a collection in my code, and I'm seeing what appears to be some weird behavior which I can't explain. Essentially, I am adding values to a collection, and sometimes, the next line of code changes the first listing of the collection. It's hard to explain in words, so I...

Yes, I wrote some VBA code to read the value of the field in the Options table when the form is opened and then apply the result to the checkbox. Then if the checkbox is clicked, it will write to that field in the Options button. It took a little bit of experimenting but I finally got it to work.

Thanks! That did the trick! :cool:

In my database, I have a continuous form that lists all records from a table called Members. I added an unbound checkbox to the form header to filter the results in the form, and it is working properly. However, I would like the status of the checkbox to be remembered the next time the...

You can ignore my previous post. Once I got modMetrics imported into my file, the code for Form 3 worked perfectly. Thanks very much!!

Thanks for the tip! I will search that and read up on it!

Oh, I didn't realize I needed to download the actual file. I copied the code you had on the web page, first for Form 4, and then for Form 3. I didn't realize for Form 3 I needed to get code out of the actual file. I just opened the file, and I see a discrepancy. I'm wondering if I used the...

I decided to try the code from Form 3, just to see if the same problem occurred as I mentioned above, and I when I compiled the code, I received an error. It said the following variable is not defined: MetricsScreenWidth It looks like MetricsScreenHeight is also not defined. It doesn't appear...

Thanks for that. I tried the code for Form 4 from the site, and it worked great except it didn't make the forms quite wide enough. Here's what one of them looks like now: See how the Cancel button is cut-off and there is now scroll bar at the bottom of the form? Any suggestion for how I can...

I am creating a new database that I am hoping to eventually make operate like an application. It will be used by my Dad, who doesn't know Access at all. One thing I am trying to do is create forms (let's call these pop-up forms) that are opened by buttons on other forms. I want the pop-up...

Hi all! Just thought I'd introduce myself. My name is Matt and I live in Los Angeles. I've been developing in Excel for a few years now, so I know VBA in Excel pretty well. (I created a budgeting file that is used for projects such as TV commercials.) I attempted to make a database with...