Search results

Haha, that explains a lot. Thank you again for all of your help.

Would that be like this? & Format (DLookUp("TCVersion","TermsAndConditions","ID=1") & " updated on " & DLookUp("TCVersionDate","TermsAndConditions","ID=1") ,"Long Date")

Once you concatenate fields, is there any way to get the date format to LONG DATE instead of SHORT DATE which seems to be the default? If not, I can certainly live with this. Thank you everyone for your help.

That is what I tried first, but received a message stating Enter Parameter Value

That is perfect! Thank you. Is is possible to combine two DLookUp fields so I get the version number and the update date? I want the end result to look like this: TCVer3.11a updated on June 29, 2013 I tried something like this, but it did not work...

Thanks Dale, I will give that a try. I have no experience with modules and they look complicated. Actually, it may be anyways, but I will give it a go. I appreciate it! @nanscombe - I have the document as a PDF as well so it is more difficult to edit. By attaching it to a work order in a...

Thank you, I will do this in a form. I am the only one using this table/database.

Thank you for your help. This is exactly what I want to do. I do not understand how to put code behind the report though. I can write HTML so I am okay there...

Sorry, so this should be added to the table and pulled into the form?

When I send a customer a work order, I want the final page to be a list of conditions of the current sale. In Word, it is nearly a full page of 7pt font with bold and italic. What is the best way to add this to the end of my report in Access?

Sorry, but the only tab in the property sheet for a table is "GENERAL." I wanted to know if this was possible to do within a table, but instructions look like they are telling me how to do this in a form. Unless I am reading something wrong.

I am using Access 2007, does that matter? I cannot find "format" in the property sheet.

I am working with a table where I want to be able to add choose the customer name from a dropdown and have the customer number automatically populate. I set up the dropdown already using the query builder for customer name and it works perfectly. I also chose customer number in the query, but it...

Thank you Pat. Yes, there are dozens of records. I wanted to have a breakdown of each payment that was made by multiple manufacturers and their totals. That part is easy. However, I worked with one manufacturer for two time periods and wanted to separate each period for that single manufacturer...

I have a manufacturer that has sent me payments from 8/2/2012 to 05/20/2013 but there was a wide gap where we did not do business from the end of 2012 to April 2013. How can split the date ranges up in the query so when I create my report, I can get two ranges for the same manufacture. For...

There is nothing wrong with it - it is a great idea, actually. I was just looking to see if there was a way to add a checkbox so it would look as professional as possible.

I want to make a list from records on a form, and when I generate a report for the appropriate customer order, I want the list to show as a check box so the manufacturer can use it to ensure that they have followed all the details, then I can also use it to doublecheck the item when the...

Is there a way to have a button on a form that is assigned to a different PDF for each record? Laymans terms if possible! Thanks ;)

Brilliant! It works perfectly. Last question for this. Can I sort by last name, but display it exactly as you have done? Thank you so much for this!

Thanks Pat, here is the SQL view: SELECT [Costume Designer Table].Prefix, [Costume Designer Table].FirstName, [Costume Designer Table].MiddleInitial, [Costume Designer Table].LastName, [Costume Designer Table].Suffix, [Costume Designer Table].Prefix & " " & [FirstName] & " " & [MiddleInitial]...