Search results

  1. A

    save form data on button click

    I have a form that the user can edit values in. Each record in the form has a button to view a report based on that individual record. The data for the report comes from a query. The problem is when I edit values and then immediately view the report, the report doesnt reflect the changes made in...
  2. A

    transfer data between tables

    I have imported a table from another database, and so I need to transfer data from the imported one, to another table in the database; only certain fields though. I have created the fields I want to copy the data into, in the second table. So I just need to go through all the rows in the second...
  3. A

    Generate list of emails separated by commas

    Hi, I want to get all the email addresses from a query, and put them into a textbox in a form, where I can copy and paste them into an email. I don't really know how to do it. First of all, not all the records in the query have emails. Any ideas appreciated.
  4. A

    link table by relative path in same folder

    I want to link a table from a database that will always be located in the same folder as the current db is in. I have the following code from another thread: DoCmd.TransferDatabase acLink, "Microsoft Access", CurrentProject.Path & "\data_be.mbd", acTable, "Persons", "Persons" It doesnt work...
  5. A

    printing data from if statement

    I want to print [FirstName] from a query if [Inactive], which belongs to the same query, is true. This give me #error: =IIf([Inactive],[FirstName],"") However this works: =IIf([Inactive],"<inactive","") and so does this: =[FirstName] not sure why a combination of the two gives me #error
  6. A

    update report for new data added to query

    I added a new field to a table and then the query. Now I need to update my report to show this information. In the control source field of the checkbox im adding, the new data field doesn't show up. I click on the "..." to go to the expression builder and select the new datafield i added into...
  7. A

    retrieve one value from Listbox

    I have a listbox that uses data from a query. The query contains the names of people and their ID. I have the listbox only displaying the name. When I select an item in the list box, I want to use the AfterUpdate() in VBA to change the current recordset to the ID of the person just selected...
  8. A

    sub report not showing up when empty

    My database has a table of Persons, and each person can have any number of Events associated with them. My problem when creating a report is that the report only lists people who have 1 or more Events associated with them. If the person has no events associated with them, they don't show up at...
  9. A

    format telephone number

    I need to format a telephone number so that the area code is at the end of the string. I'm not sure where the best place for this to be done. In the query or in the report? I can't do it in the table, as the data comes from a different database which I cant edit. I'm only concerned with having...
Back
Top Bottom