Search results

Ok, so I entered that formula on a form field and it worked. But I need this data logged into the table as well. I don't need it on the form really.

Do I put this in the table or the form? I need to have this data logged into a table based on a date field that is entered by a user, it wouldn't be a form field on the Form. Just for reporting etc... Does that go into the Format under the General Tab in the Table Design ?

I need to populate the Month Name based on a date field in my table. Thanks!!

Thanks I have tried that but I keep getting an error. What is the underscore after the format type i.e acFormatXPS, _ So it would be DoCmd.SendObject acSendReport, sDocName, acFormatXPS, _ , email@email.com,

I found this. DoCmd.SendObject acSendReport, "MyReportName", acFormatPDF, [To], [Cc], [Bc], [Subject],[MessageText],[EditMessage],[TemplateFile] How do I use the [CC] [CC]myemail@domain.com, ??

How can I hard code a few email addresses to the following code? sDocName = "Report Name" 'message subject sSubject = "Email Subject" stMail = DLookup("[name of field with email address in table]", "TableName", "[name of field with email address in table]= Forms![Form Name]![Field Name on...

Actually I just thought of something... Since this DB would be used on a network and I don't want each person to have to create an ODBC connection in order to use the DB. I thought the command was [SELECT].Table Name blah blah.. I would need this in the form field to pull in the data from SQL

I just need to change the main control source then I change the form fields back. So now it works. Thanks,

I migrated all my data to SQL and have a linked data connection (Table) to my access database. I have repointed all the form fields to the new linked table by using =[dbo_Survey_Main]![Reviewer] But now all I get is #Name? in every field. Do I not have the expression correct?

I was able to find the option. IT was the form option in the properties, I had to set this to Editor Locking etc..

I need help on this error as well. I have migrated all my data to SQL 2008. I then changed the form fields to link to the SQL Server table. Now I get the error when trying to switch into Form view from Design View. I have already checked the settings and I am not sure what it could be.

Make sure your excel sheet has headers in the first row and its clean data. Sometimes with werid data access can't read it. Like blank fields etc..

I need some fields in my form to auto populate with the current Fiscal Month and Week based on a table. In Excel I created this very easy by doing a vlookup on a table I built based on WeekNum and matching those weeks up with the fiscal months and weeks. How can I do this in access and have it...

I was able to figure it out finding this. http://www.thepoorhouse.org.uk/linked_queries_in_access Now that I can run a query from one DB to another I have another problem The DB that I have created the query in has a few fields in a table that I use to track Major Incidents. For each day...

On this note how would I link a query from another db without Importing. It appears I can only link tables but not a query

How would I link a form field from on DB to another?

Ok, finally... everything works just fine. I had the wrong field name in the wrong spot sDocName = "Report Name" 'message subject sSubject = "Email Subject" stMail = DLookup("[name of field with email address in table]", "TableName", "[name of field with email address in table]= Forms![Form...

This is my information My table is called TableMain The field in the table containing the email address is called EmailAddress the form that I have has the email field called EmailAddressFrm The report field that contains the email is called EmailaddressRpt I don't understand what I put in...

THanks for the reply, however I am still unclear. I did use the F1 key and nothing came up for the email field. This is my information My table is called TableMain The field in the table containing the email address is called EmailAddress the form that I have has the email field called...

I need to know what is the client_ID in this scenario? Table, Form Field??