Search results

Markk - Thanks for the response. Unfortunately, there are no calculations which go on anywhere within this database. All of the data that exists is pulled in from a report which is sent to us by another source, so all of the Balances are hard coded. For right now there are very few clients...

Greetings! I'm in need of some help on a query that I have built to create a subform on one of my forms. It's my goal to make the subform easily navigable/query-able for the users, and that is where I've hit a roadblock. The subform contains a field - Balance - which I would like users to be...

Yea, it was only for aesthetics, but I'm an aesthetics kind of guy. Thanks for your response though, and I'll abandon this hope for now.

Hi all, I have a memo field that feeds to a textbox control on one of my forms. I would like to re-format the textbox using the .Height value based on how many lines appear in it (i.e. it will fit only 3 lines if there are 3, but 5 lines if there are 5, etc.). Is there any way to count the...

Hi all, I'm currently working on a project that calls for a graph that is based on an equation which the users can change while in the database. the equation is basically an annual compound interest formula: 65*(1+x)^([YearNumber]-1), where x is the rate of change as a decimal, and what the...

You are the man, Thank you so much!

Hi all, I currently have an invoice report that runs through my database which is e-mailed to clients (automatically through vba), and then saved to a specific file path. I'm currently having an issue with the saving part of the process with certain clients who have illegal characters in their...

Thanks for this information! The SQL for the record source just brings together clients and fees, so something like SELECT tblClients.Client, tblClients.Fee1, tblClients.Fee2... tblClient.DynamicFeeField FROM tblClients So the invoicing shows the client, all of their fees, and then has some...

I know there is a boolean Yes/No option for fields, but that displays check boxes rather than strict "Yes" and "No" strings, which the userbase for the database did not want, so yes, it is a text field, but all of the entries are either "Yes" or "No". The Default Value for the table is "No", and...

Hi All- I'm currently working on putting together an invoice in the form of a report and I'm having some trouble figuring something out. One of the fees that our clients get charged is dynamic, but it also doesn't always exist. I'm having trouble setting up a dynamic field that Access will...

Hi all- I have a list box and a combo box on a form based on a query. The list box is a multi-select, with column values of Client, ClientEmail, and Medical. Medical is a simple yes/no field, and it is what I want the combo box to help sort by. I have a Where clause in the query: WHERE...

Nevermind, I'm stupid. I just put the dynamic fields directly into the Query and it works much more nicely.

Hi all!- I'm currently creating an invoicing report for a company, and for record purposes they need a dynamic field on the report for the specific Invoice Number of each client they invoice. I have the field set up currently as a text box =[Invoice#] so they have to enter an invoice number...

Thank you very much :)

That's fantastic, thank you! I don't think I'll be running over an hour any time soon, but if/when I do, would it be easier to use hh:mm:ss or continue with mm:ss for pace calculations?

Hi all, I've been trying to put together a running database for myself and I'm currently a little stuck. I'm trying to get a query out that will display my distance, time, and time per mile for my runs. The distance (in miles) and time (mm:ss) are easy because they are being pulled straight...

Hi guys, I'm currently working on a database which requires invoicing as a part of it. The invoicing is done based on quarters, and I want the users to be able to use a multiple items form, listing all of their clients, to create the invoices. Each invoice must be created individually so they...

Got it. I just moved the If/ElseIf statements from the OnLoad of the form into the button that opens the form. Thanks for the videos though :D

Hi all, I have a number of fields on a form which are divided into three groups. I'm trying to get the OnLoad vba for the form to make certain groups invisible depending on criteria for the individual client loaded. The groups are controlled by 3 invisible text boxes which draw their Yes/No...

Hi all, I'm trying to build a convenient database for myself to use for school. It's fairly simple, with 2 tables, one listing my classes, the other used for storing homework assignments. I have one form that lists the class, has an attachment field for notes, and a subform that is populated...