Search results

  1. L

    User Defined Criteria for Number Field

    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...
  2. L

    Count Lines in a text box

    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...
  3. L

    Graph based on dynamic equation?

    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...
  4. L

    Report Output to PDF File name

    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...
  5. L

    Ignore a Dynamic Field using a Switch function?

    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...
  6. L

    Filter a List box using a Combo Box

    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...
  7. L

    Dynamic Field on a Report

    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...
  8. L

    Pace Per Mile help

    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...
  9. L

    Creating a report based on a single record in a Multiple Item form

    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...
  10. L

    Mass setting of Property

    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...
  11. L

    Form Filter not working?

    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...
  12. L

    Sending an E-mail to multiple recipients

    Hi all, I wasn't totally sure where to post this, because I'm almost positive I'll need to use some VBA to get it done, but I have form that it is running from, hence the post here. I currently have a multiple item form which is populated by Agents and their Agency. Currently the form can be...
  13. L

    Emailing to multiple people

    Hi all, I have a report which users of the database need to be able to email. I have the SendObject all set up, minus one little problem I'm having. The e-mails that the report has to be sent to are entered into the database, and there are up to 4 e-mails that the report may have to go to at...
  14. L

    Undo Form Changes?

    Hi all! I've been asked to create an 'undo' button for any changes that users may make to the database I'm building. The way I went about this was creating an "Archive" table. When the user tries to edit information through the form, all of the information for that client is automatically...
  15. L

    I need some help with this code please!

    I am not good at VBA at all. I have dabbled a little bit building this database, but I still can't even really read it, I just know what certain strings mean. I'm trying to get a list box populated with names and e-mails to return the e-mails in a list, and separated by semicolons. Microsoft's...
  16. L

    Queries and List Box

    I have a form which lists names of Agents and the Agencies which they work for. I currently have a combo box which allows the user to pick a specific Agency, so they can view only those agents, and a list box which I want to list the name of the Agents so the user can choose some of them, but...
  17. L

    Mass E-mails?

    Hello everyone, and thank you in advance for your time and help. Just ahead of time, I am using both access and outlook 2007 I'm currently building a database for a company, and something that has been requested is confusing me to no end. The users would like to be able to send mass e-mails...
  18. L

    Using the Switch Function to open Forms based on Criteria

    Hi all! I recently designed a number of reports for a company to use as invoices. They run the invoices quarterly so there are 4 separate reports, 1 for each quarter. I wrote code for a button on a form which will run a specific report based on what month the button is clicked in (i.e. if it is...
  19. L

    Extracting an E-mail address from Access

    Is it possible to extract just an e-mail address from access, and insert it into the 'To' field in outlook? For example if 'Email Address' were a control on a form, or a report, could code be written to extract just that? Thanks for any help!
  20. L

    Using a calculated field from a report in a Query

    Hi all! Just wondering if it is possible to take a calculated field from a report and use it to populate a field on a query? I imagine the name for the field would look something like FieldName: [reports]![rptName]![FieldName], but I haven't been able to get it to work, so I assume I'm doing...
Top Bottom