Search results

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 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...

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 have an MS Access 2003 database that has code in the open event of a form that sets the recordset to an adodb recordset. This is the code Dim sql As String sql = "Select * from tblQuickenData" Dim RsClone As ADODB.Recordset Set RsClone = New ADODB.Recordset RsClone.Open sql...

I have created an ms access database that uses a reference to outlook. The only problem is that some of uses still have office 2003 and others have office 2007 so I created 2 versions of the database one for 2003 users and one for 2007 users - I know this is the bad way to do things. I know...

I’m using Access 2003 in a Windows 2003 server environment. Is there a way to determine the Windows user name of the current user? There is a user function CurrentUser() that will return the current user when using access security and I was wondering if there was a similar function in Access...

I have created an adp, and have created stored procedures for all of my forms. In the SQL Server database I have given my users permissions as db_datareader and db_datawriter, however they were unable to open any of my forms because they didn’t have execute permissions on my stored procedures...

Hello everyone, I hope I’m in the right forum for the question I’m asking. I’m using MS Access XP with Sql Server 2000 in an Access ADP. I am still designing my Sql Server database and recently I deleted field called “EmpStatus” from my database. When I tried to open the table I got a...

I'm trying to help someone with Access on a CITRIS Server. I'm working with them VIA email. They say they're having problems communicating with printers and would like to utilize their email with Access. Can someone fill me in on common problems using Access with CITRIS Server as far as...

I have an MS Access database that I am upsizing to an Access XP project using SQL Server 2000. In my Access database I have a lot of reports and forms that are based on list boxes where users can make multiple selections for criteria. When the report is opened I pass the users selections as a...