Recent content by Lvalencia

This is a shared data base and what is interesting is it is only happening to one person. I checked and the report box is set to can grow so that does not appear to be the issue. Still at a loss????

I have created a report and have a macro created to send it as an email data base object. The fields that I want in the report are MEMO fields on the table so there was no conflict with number of characters. Here is the problem, when the report is created, it truncates some of the text from...

I want to send, in an email, the current record on a report. I have the command button set up to send the report. However I am having trouble using the following code to open the report on the current record. It returns all of the records that I have entered. If I add quotation marks after...

where do you use dlookup at? Currently I am emailing a data base object which sends the entire data base. Do not see dlookup as one of the options in selecting an action. Thanks for the help

Used query designer as you suggested, Still returning names and numbers. At a loss??? drop down box on form is valuable and time saving but wonder if it should be deleted since queries don't return good data.

Ok I thought I had it figured out but still not correct. your suggestion "To get the names corresponding to the ID's you need in the query to bring in that field from the table holding them - the lookup table" I did that. However it only brought the records that had a name in the record. Also...

Thanks appreciate the help. Also had to create the proper relationship in the tables.

I created a query and one of the fields was "name". In the query it listed the names and then changed to the ID number of the names from the name table. The query was created using the wizard. Why did the query change to the ID number mid report and how do I get it to report only the names and...

Right, found out how to do it. Problem now is my data on the sub form remains when I add a new record on the main form. thanks for your response

I would like to add a spreadsheet to my form on a tab just like on the asset tracking data base template in access 2010. Cant seem to figure it out, I can add an unbound object frame but then I can not edit it on the form?? :banghead:Pound the keys or pound the wall.....help!! Thanks...

First off thanks for the responses, I did get my email to work had to send email object. Second question: Can I include information from one of my fields in the email? Maybe it would be after update when count number is >1 send email, include field 1 text description???? Copy and past would...

I created an email macro in tables, basically the macro is to send an email out when a new record is created in a table. However when I test I do not receive an email. Question - does the database have to be web based or on a share point site to work? Will it not work from my PC. This database...