Search results

Thanks very much for the quick response!

I'm currently tasked with creating quarterly Invoices which can be run through Access to send to clients for a company. My biggest problem (which is small to say the least) so far is that I don't know much VBA coding, and currently have to place 4 buttons on a form (1 for each Quarter). I was...

Yea, I figured that out and got it all worked out. Thanks so much for your time and help, I really appreciate it.

Got it! Thanks so much for your help:D

Been trying it, but when I go to the Query and enter the IIF statement in the criteria for the control field - iif([Control]=0,Is Null) - i get a type mismatch. :(

That's brilliant! Can't believe I didn't think of it. Just having a slight problem trying to figure out where to put the IIF statement. Could you help me with that too?

I currently have a form which serves as an invoice. It pulls information from a query and a form, and creates an invoice from them. Certain text boxes on the report don't need to be there if the value within them is 0. I'm trying to figure out how to get access to recognize to make the...

Sorry, maybe I wasn't as clear as I thought I was. The table is set up in a manner such as this: Client|LivesJan|LivesFeb|LivesMar...|LivesDec A .......5 ............. 6 .......... 7................ 6 B.......10.............8.............12.............11 The form that the textbox is...

I have a text box on a form which shows the number of people covered under medical coverage for a certain company. My dilemma is that the number of people covered may change month to month, and invoices need to be run quarterly, so at least 3 months worth of covered lives need to be stored. I am...

Thanks a bunch!

I'm currently building a Query which will be used to produce Invoices in the form of a report. The query has 4 fields: Client, CoveredJan, CoveredFeb, CoveredMar, and Fee. Following these fields is an expression, TotalBill =([CoveredJan]*[Fee])+([CoveredFeb]*[Fee])+([CoveredMar]*[Fee]) My only...

It seems like that would probably work, except I cant seem to get it to let me put in another buttons name for it. Where would I do that? Ex: Private Sub ButtonA_Click() <code> DoCmd.RunCommand acCmdBringToFront End Sub Where do I put in "ButtonB"?

Great, Thanks for all your help Michael!

Essentially, yes. I just was wondering if it was possible to invoke that through code or a macro, i.e. without clicking the button on the ribbon.

Yeah, I couldn't find a similar property, which is basically why I cam here wondering if one existed. Thanks very much for your response!

Hi all, This isn't really a necessity or a priority on my database, it's simply to add some flair. I was simply wondering if there was a way to write some code that would move a button to the foreground by pressing a separate button. i.e. I hit Button A, and Button B is moved to the...

Nevermind! Got it all sorted out.

Hello all, I'm very new to Access, and I've run into a small problem. I have a client form, as well as a form which adds new records ('Data Entry' set to 'Yes') for the Clients Table. What I've been trying to do is add a where condition to the macro which closes the new client form (after it...

I had the combo boxes set up, just didnt think of hiding the ID field for some reason. Thanks a bunch!

When creating a new record using a Form, is it necessary to use the Foreign Keys which relate to Primary Keys in other tables, or is it possible to have the form understand that Subject A has an ID of 1 and automatically change the text to a number? For example, if a table is designed so that...