Search results

Thanks Markk. Marvelous! That works correctly. PDF version of report is saved to usual folder with correct contents relating to the open form with a chosen record this time instead of the default. So what is going wrong with my version then ?

Thank you Markk. I get an empty version of the report opening in print preview. The only field visible is that of three concatenated fields from another form that is not currently open. That form is the usual calling form for the report. But by having the calling form open at default record the...

Having read posts including those by "GemmaTheHusky" about this issue and followed the advice given I am still stuck. "Enthusiastic beginner" with Access 2010 on Win7u. Have been using this line behind command button with complete success between Dec'15 and Aug'16 DoCmd.OutputTo acOutputReport...

Have found the page about ="http://office.microsoft.com/en-001/access-help/command-line-switches-for-access-HA010166605.aspx"] And have the full path to the test accde on the target machine (in another country). And know the default location for 2010 on a personal machine should be "C:\Program...

Thank you Pat From reading some other pages from various places it seems that there are features in 2010 that will prevent the accdb/e from even opening on 2007 full version - whether runtime or not. http://msdn.microsoft.com/en-us/office/cc907897.aspx...

Just sent a split accde front with accdb back to another country for test. Included with 2010 runtime and SP2. This tested prior to send on a spare machine with 2010 runtime and full 2003. I have 2010 and 2003 Access but not 2007. Just found out that test user has 2007 on machine. Can I send a...

Short progress report: No joy - have tried a number of combinations and nothing will work in RunTime. Correction - a standard accdB will run correctly. And an accdB renamed to "R" will also run. Also cannot get a simple accdE to function in runtime. (Wants the entire vba project deleted!) -...

Thank you GinaWhipp - will look at these and post result.

From a beginner using 2010. Have functioning and compiled accdb. Wish to send a test version as a split FE/BE to another country via web - this will include the runtime. Am now testing this scenario and have split the accdb to accde front and passworded the BE. When FE&BE are transferred to the...

I have been given a VBA suggestion and have tried it with success - this is what I have done: Created a module and used this code - courtesy of "RJD from Gulf South USA" Public Sub CreateRecords() Dim db As DAO.Database, rst As DAO.Recordset Dim InsertNumber As Long, Sequence As Integer Set db =...

Thanks for the suggestions and I do wish to learn more about Access but have limited time and perhaps I have been a bit too concise in my description of this project. The purpose of the accdb is to display a collection of historical information. This is within a finite time frame and uses a...

Having looked carefully at the "numbers" idea I am unable to find the repeat/increment components. I understand the idea of grabbing an existing set of numbers then inserting into another table. Still have to get the sequence I need before that is possible. But I am adding new records - and so...

Thank you "ButtonMoon" and "Pat Hartman". I will try the numbers idea - if I understand correctly. My junction table has three fields - autonum for ID + PersonID + crewID The current highest crewID number is 7269 and each crew has between 1 and ten personID numbers - these have been manually...

Hello Beginner with Access 2010 - making additions to one field in a JunctionTable. Need to extend a field by adding some new numbers but have found it easier to Export to Excel - make changes and replace in accdb. I have found an Excel formula that does what I want but starts from the number...

Hello to the forum. From a beginner using 2010 to display historical records. A folder of individual PDF files with the project and using "FollowHyperlink CurrentProject.Path" to get each one to open from Command Button click. This works correctly / as expected - BUT - I have a basic error...

Hello Simon_MT Have been reading up on the creation of html and the trials of others far more experienced than me. Found some help and code and even a number of ways of having an html editor within Access. But it seems that this method is way beyond my current abilities. But I will need this...

Thank you again Simon_MT Will give that a go over the weekend. Your help very much appreciated. I had managed to get the WMP version plating by using the URL line I found elsewhere but was having a few teething troubles. So will test both methods and report back. I am presuming the html code...

Thank you Simon_MT Interesting suggestion - do you mean put a web browser control on the existing form? Very happy to try this suggestion but I do not yet understand exactly what you mean and how to start.

Reading the advice of some others and looking at the Windows Media Player SDK and Object Model I am now thinking along the lines of an embedded WMP control. Using Shell and Execute may well solve the error messages but still relies on knowing the correct ".exe" for the application. As this DB...

Thanks DJkarl I have been playing with "Application FollowHyperlink" method which does work but relies on the installed payer default and always shows a Hyperlink Warning message. So I am going to try your suggestions but have to learn about "ShellExecute" I think? - so it will take a while.