Search results

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

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

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.

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

Ah, that works. Its dissapointing that this couldn't be accomplished as easily in the report, but thankyou for helping me get the same end result :)

They weren't on the actual report intially, but I just added them now and nothing changed by there mere presence. I don't see why when I just want to do the same thing, just use the data to print out in a If statement that they wont display.

Yes I can access them and display their values on the report

Well, I guess I will tell you my whole problem. I want to print a list of names with the text "<Inactive>" in front of it only if [Inactive] is true. It works when I do that in two separate textfields, but for formatting issues, I want it do be done entirely in 1 text field.

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

I think its a query. This is my database structure: 3 Tables Event - Each volunteer can have any number of events associated with them Person - linked from a different database - contains information on posters. Volunteer - stores the id of a Person once they are identified as a Volunteer in...

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

Yes that works, but it needs to use data from a table that is a 'subsection' of the table the form uses. So the ID will come from a different table than the one used by the form, and then use that ID to select the ID in the table that the form is built on.

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

I guess I wasn't using the query to make the report. I made a new query and a subsequent report and it works. Must have been the outer-join that did it. Thanks

hm, I didn't know about join types until now. I tried changing it to both of the outer joins, but it didn't seem to change it. Right now I have the relationship type set to 'One to Many' and the join type set as Include ALL records from 'Person' and only those records from 'Event' where the...

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

Thanks for you reply. I have figured it how to do it now. I created a new column in the query. In the Fieldname box of the new column I added the following Phone: Mid([HomePhone],5,12)+" ("+Mid([HomePhone],1,3)+")" 'Phone' becomes the name of the column in the query. What this code does is it...

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