Search results

Thanks for the response! I just need to display an image of the video, I guess it would be just like the first frame. I'm not sure what frame the file manager shows. The file manager just shows the very beginning of the video. I'm talking about like file manager in Windows 10. In file...

I have 2010 Access database that has a table that stores a list of videos for my company. I have a form that shows a description of the file and a button they can click to open the video in windows media player. I have the code to open the video and it works fine. Now I’ve been asked to show...

I need to open a report that is based on a parameterized query. The report can be opened from a variety of forms that users have to access to open the report. I know how to use the do command to open the report and pass a filter argument but that doesn’t work if the report is based on...

I have an report that uses name paramaters. this is the sql for the report PARAMETERS [whatCompany] Text ( 255 ); SELECT tblInvoices.ClientCompany, tblInvoices_Details.Charge, Sum(tblInvoices_Details.Hours) AS SumOfHours, tblInvoices.InvoiceID FROM tblInvoices INNER JOIN tblInvoices_Details...

I’m using a Crystal ActiveX Report Viewer Control 10.0 on an MS Access form Crystal ActiveX Report Viewer Control 10.0. I’ve been able to set the report source and parameters and load the report and view it but I can’t set an properties except in code. The only property I’ve been able to...

I'm helping a friend who's taking a MS Access 2013 course. she has an exercise that requires her to create a macro so that when a forms opens a list box is selected and the first item in the listbox is selected. I know how to do that in code Private Sub Form_Load() Me.cmboQuery.SetFocus...

I'm working on an existing 2010 database that has a table that stores PDF's in an OLE field. The boss wants to be able to see the PDF on a form along with the other fields in the database. He doesn't want the pdf to open up in a separate window in Adobe PDF viewer. He doesn't want to have to...

I recently did an upgrade on my computer. I went from Visual Studio 2008 to Visual Studio 2010. I also have Crystal reports 2008 installed. Everything seemed to be working fine for several weeks until Crystal Reports just stopped working. When I open crystal reports now it locks up...

I am having a problem connecting an MS Access 2007 ADP to an Sql Server 2008 Express Server. I installed SQL Server express 2008 on a machine running windows 7. When I try to connect to the server using an MS Access 2007 ADP. I get an error “Login Failed. Catalog information cannot be...

I have a lot MS Access 2003 reports that has multiple groupings on the report that I need to export to Excel. When I exported the report to Excel everything was out of whack because of the group headers and footers. I tried exporting the report to HTML and all of the columns including the...

I guess everone it entitled to his own opinion and I'm entitled to mine. Where I'm from SOS stands for S*it on a shingle, what does SOS stand for in your case? Instead of hurling insults why don't you try to answer the question genuis " .... I know what SOS stands for in you case - "stupid...

I have been using MS Acces for over 10 years and have come very proficient with creating databases. As I became more proficient I have used VBA exclusively instead of using macros - I've always heard that VBA is the best way. In previous versions I only used the wizards as a matter of...

I'd be supprised if this is the only problem you run across when upsizing to MS Access 2007. I have upsized several databases and have always run across problems. A lot of times the VBA project get corrupted for no apparent reason. If it worked in an earlier version then it supposedly...

I don't know of a way to actually change the function of one of the F keys but if all you want to do is provide a short cut to you button use the ampersand (&) just before the letter you want to use as a shortcut key. If you use "Do&Something" as the caption for a command button, then all the...

Does anyone know where I can download label templates for MS Access 2003? I'm trying to create mailing labels using the label wizard and I need to use avery label wizard AV5161. AV5161 doesn't show in the list of labels under avery on my computer. I know the templates exists because it shows...

I have been using MS Access for over 10 years and with the release of Access 2007 I've had more problems than ever. There are a lot of new features in Access 2007, but there are a lot of things that are just down right buggy. I've had several problems when converting Access 2003 to Access...

I recently upgraded from MS Access 2003 to MS Access 2007. In the database I had a table that had an OleObject field that I used for PowerPoint presentations. When you opened the table you could right click on the oleObject field and either open or edit the presentation. When you opened the...

I think I actually understand. If I use Dim oMsg As Outlook.Message, I have to have a reference to either outlook 2003 or 2007 in my vba project. If I use : Dim oApp As Object Set oApp = CreateObject("Outlook.Application") I don’t need a reference, it creates the object based on the...

thanks, I think I understand now what meant. Would it be possible to get a sample code snipet for MS Outlook 2003 / MS outlook 2007. I have a database that is set up to send emails but I'm having problems because some users still have office 2003 while others have 2007. I assume I would have...

What does late binding have to do with this. Late binding is used primarily with recordsets or so I thought. Even so, if you solutions is "Late Binding" I still need to know how to detect what version of office is being used to I can make a reference to either office 11 outlook or Office 12...