Search results

Hello All, Any advice on how to bypass the security messages that come with Outlook 2013? The code I have would send a message when a used locked themselves out of the database. Now, a warning message comes up saying a program is trying to send a message through your account and you have to...

Hello All, This problem is driving me nuts and Intuit help is atrocious. Dim SessionMgr As New QBSessionManager SessionMgr.CloseConnection SessionMgr.OpenConnection "", "DB NAME" SessionMgr.BeginSession "FILENAME", omDontCare I installed the SDK to open my quickbooks file. This USED to...

Hello All, I have a database that was built in Access 2010. I have several users that have access 2013 and they are able to use this database just fine. I have switched computers, and I am not trying to open this database in 2013 and it crashes when it tries to open the main/dashboard...

Hello all, I am connecting Access to QuickBooks with the QODBC. I tried to do this in MS Access 2010 with Windows 7 and it worked fine. Then I tried it on a new computer with MS Access 2013 and Windows 7. Now, when the VBA gets to the line: oConnection .Open "DSN=Quickbooks Data;OLE DB...

Hello all, So I have read through threads, such as this http://www.access-programmers.co.uk/forums/showthread.php?t=270155&highlight=tempvars In regards to tempvars and what (if any) benefit they might have. The database I am working through uses these everywhere, in macros, in VBA, in...

Hello all, Figured since I'm on a role of question all that is my knowledge of access... I have read several articles/blogs/threads/whatevers that recommend against using the lookup wizard at the table level, and that you should instead use this in forms. It seems to cause a lot of issues...

Hello all, Is there any benefit to archiving records using the append/delete method? I have found plenty information on how to do it, but no real benefit other than if your table is in the 100,000+ record range (per Allen Browne). I need to import calendars from google, and there are...

Hello all, As mentioned before, I am going through a database designed by someone else and trying to salvage what I can. This database has about 10 union queries. I have never used them as I was under the impression they are quite slow, and I never needed to compare data from two queries...

Hello All, I am redesigning a database and there are some queries that use the Min total. I understand why you would use this for numeric fields, but I can't find anything online that explains why you would use Min for text fields. Is there any reason why you would or need to? When I remove...

Hello all, I am redesigning an access database, but I have no formal training so I am not sure what it the best practice to use here. Currently, there is a new data entry form with a record source of a selection query. When new data is entered, it is split between two tables (the two that...

Hello all, Looking for a way to fully integrate MS Access 2007/2010 with Quickbooks Enterprise Solutions. And I mean, fully integrate. It seems like most options I have found are import/export drivers with the occasional perk, but they all seem to lack something import. Currently, I am...

I am making a calendar form in Access and want it to look like Google Calendar as much as possible. I am wondering if there is a good way to go about setting up the form to allow for multiple appointments scheduled for the same time. Designing the form to be in Week View with half hour blocks...

This question involved MS Access 2010 and Windows 7 Professional. I have a .chm file located on at C:/Windows/Help and it is opened in access using the following code: [CODE] Declare Function HtmlHelp Lib "hhctrl.ocx" Alias "HtmlHelpA" _ (ByVal hwndCaller As Long, ByVal pszFile As...

Hello All, I have a bit of code that generates the following error: Run-time error '-2147417856 (80010100)': Method 'CopyFromRecordset' of object 'Range' failed. Here is a piece of the code: With rsEMP .MoveFirst If !EmpID = 1 Then...

Hello All, I have the following code: techid = Forms!Main!txtCurrentUserID Task = 2 note = "Work Instructions" strSQL = "SELECT *" strSQL = strSQL & "FROM [tblTracking] " strSQL = strSQL & "WHERE ([EmpID]=" & techid & ");" Set rs = CurrentDb.OpenRecordset(strSQL)...

Hello all, I am trying to write some code to search for similar strings. I am creating a database with records that all contain street addresses. These addresses may have more than one record attached to it, and we would like for folders to be created containing the records with similar...

Hello all, I have some code set up to automate scanning from access to a specific folder on the server. I have searched the web for different codes and have not come across anything that will scan an unknown amount of documents. The best I found was the code I am currently using, that will...

Hello all, I have a database which has several records with at least 5 documents needing to be attached to each record. Using attachments or OLE would cause considerable bloat, so I opted for hyperlink fields for all the document types necessary to save with each record. However, now I am...

I am wondering if there is a way to disable the "saveas" in excel from access with vba? I have the following code: Private Sub cmdReport_Click() Dim path As String Dim XL As Object Dim oBook As Excel.Workbook Dim pic As Excel.Shape Set XL = CreateObject("Excel.Application") If...

I have the following code, which works the way I want it to when I click the button the first time. However, if I close out the excel and click the button again, it errors at the line "ActiveWorkbook.Worksheets("Ref").UnProtect", with the message "Run-time error '91', Object variable or With...