Search results

Perfect! Thanks.

I just tried it and when I try to open the report to print it, Access asks for the value of "0". I think it's interpreting 0 as the field name and since there is no field named 0... Thanks for the suggestion though.

[Solved] Force Unbound Check Box to False/No Gray Fill I have a report that generates an in-house physical invoice for an event. On this report is a small section for a staff member to make hand written notes regarding when we call a week before the event as a final confirmation. I want to...

I can see why you believe that the animal lists should be structured in a separate table. I have already explained why I didn't (I didn't think of it) and why I feel, in hindsight, why it wouldn't have helped. To try and improve I am willing to listen to suggestions. What are your other...

When I said that having everything in one table is easier than several, I wasn't specifically referring to the animal lists. I was referring to the idea of large, separate tables for ZooMobiles, Guided Tours, Wild Encounters, etc. And in that case I know it is easier to have them all in...

Well, the table is for all of our education programs: there are 8 different ones, each requiring slightly different information. While, yes, I could have made different tables for each program, they require enough shared information that putting them in one table is FAR easier than different...

I understand where you are coming from and perhaps that might have been a good idea from the start. Still, what's done is done and I don't want to go back and change things (there are already over 450 records in the database). So *shrug*. Plus, I DON'T want people to manipulate the...

Aha! I had the module and the sub named the same. When you said that the name had to be unique, my thinking was that their naming was one and the same. I didn't realize that Access recognized the two things as separate. Now it seems to work fine. Thanks!

Smig: I tried using the Case Select technique and it didn't resolve the issue of Access producing an error when trying to reference a public module from my form. I'm sure that it could replace my ElseIf statements if I ran it as an event procedure within the form--not as a public module--but I...

Yes, but that's what I have, isn't it? Here's the codes again: Module: Public Sub AgeStartSetCombo(frm As Form) 'Sets background age code With frm If .AgeStartCombo = "All Ages" Then .AgeEndCombo = "All Ages" .AgeStartCodeTxt = "1" .AgeEndCodeTxt = "16" End If...

Galaxiom: The module is called AgeStartSetCombo. The event procedure is AgeStartCombo. I purposefully chose a name that was different from anything else. BlueIshDan: The codes can be found in my second post on this thread. Smig: Thank you for the suggestion of Select Case, but it doesn't...

Yes, but how do I do that? I thought that I was successfully doing that with Galaxiom's suggestion but Access is giving me a warning saying "Compile error: Expected variable or procedure, not module".

BlueIshDan, thank you for the suggestion, but again I'm not very familiar with booleans. I think this is breaking away from my initial need into things that are far more complex. My understanding of modules is that they are essentially pockets of VBA code that can be referenced from event...

I don't know what select case does or how it is used. I have it in one other module in my database, but that's only because in a previous post I asked how to do something and someone gave me the code straight up, so I copy/pasted it in. It was one of those "it works so I'm not going to...

Thank you Galaxiom! Unfortunately, when using the form in a test, I get the warning "Compile error: Expected variable or procedure, not module". Here's the code I am using (the earlier example was just a section, I'm including the whole block this time in case somehow it means I have to do...

I have several controls that do the same thing in different forms. I currently have individual private subs in each form associated with each control. Each private sub has the same code that I copied/pasted from form to form (the names of the controls have remained constant from form to form)...

Thanks guys. I had a feeling that "no." Would be the answer. And, yes, this is part of database documentation. I was just hoping to be able to identify and comment on individual aspects of query code. For example, I have a query that identifies program payments that are overdue. Certain...

I thought that might be case. That would be great. Do you know how I can do that?

[Solved] Commentary in Queries I know that you can insert comments and notes in VBA code using a singular quote, like the following: 'Comment about what the code doesIs there a similar way to insert comments in the SQL of queries? I found other forum posts that say this isn't possible but...

I created a booking database (in my case it was educational events where we go to a client's location) and I was also interested in this feature. Unfortunately I came up with a complete blank. At least according to my research there is no way to view records in a table (in this case your...