Search results

You could add a Yes/No field for each field and do a comparision of each field and if different then mark that fields Yes/No with a Yes and show that in your comparison report. If you have a lot of fields then that is a lot of work.

Bob, I also have the Adobe PDF printer for I am using Adobe Acrobat 8 Professional. When I try to run your RunReportAsPDF code I get a Sub or function not defined error on the AdobeDevice = GetRegistryValue(HKEY_CURRENT_USER, "Software\Microsoft\Windows NT\CurrentVersion\Devices", "Adobe PDF")...

keyboard command Ctrl + G

Check out my old Browse [Find a directory or file] sample. In one of the form modules I have code that will parse the file name and directory from a full path string.

Are you trying to append the data into an existing spreadsheet (new data added to the next blank row) or are you wanting to override (replace) an existing spreadsheet with the new data?

You have to save the current record to make the changes stick to your bound table. I advise against using storing the path/file data as a hyperlink. Store it as text and use code to open the file when the user clicks a button. Did you search the forum? Linking files to Access

might want to try... If IsNull([Explanation]) or Explanation = "" Then Concatenated = "" Else Concatenated = Explanation End If

Maybe this will help if you just want to export the data tables... Export All Database Objects Into Text Files or you could zip a copy of the database but you really do not want to do anything if other users are in the database.

Did you try searching the forum? http://www.access-programmers.co.uk/forums/showthread.php?t=197696&highlight=browse

Bob, your back! ;-) Strange for I have noticed more postings recently with users using the bang ! instead of the dot . in their coding when referencing text boxes.

RTF's are so outdated ;-) but I just tried it and was able to output to our sharepoint site using the same method as yours. No need to open and then close the report, just use the DoCmd.OutputTo command to send your report.

Office 2007 (SP2) and newer has the built-in output option to create PDF's.

Read up on how to normalize your database structure. All of your clients should be in ONE tblClients table.

If you are just trying to create a printout for the teachers to sign then I suggest that you create a report in Access with the values from the selected record and print it and/or export the report to a PDF file to save for historical records. No reason to involve using Word.

Check out my old Browse [Find a directory or file] sample to see how to get the file and path info from a users selection.

You do not need to set any references to Outlook with the code I have posted @ Outlook 2007 & E-mails

Not sure about limiting what the user can select in the calendar control but you can test the date the user selected in the text box or where ever you are storing the users selected date. If the date is invalid, remove it and alert the user to try again.

Do not join your computer to a modified workgroup [.mdw] file. Use a custom shortcut to open a secured database using your customized .mdw file. Check out this thread more more specifics... Help Work Group File I hope that you did not alter the default system.mdw file on your computer.

You can easily turn on the compact on close option when ever you want. Run this each time your database is opened and it will turn on the compact on close option when the database is opened on the last day of the month. If Date = DateSerial(Year(Date), Month(Date) + 1, 0) Then...

You can use code to send emails and you also avoid the annoying "allow" prompt that the send object method forces on your users if you are using Office 2007 or newer. Check out the simple code I posted @ Outlook 2007 & E-mails