Recent content by mkaeser

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

So I uninstalled, reinstalled the SDK. I changed the preference in Quickbooks to "Always stay running". Now, when I used the SDK to connect with the company file OPEN, then I close out of quickbooks and try the SDK again, it will access quickbooks and the company file. BUT, when I close the...

Quickbooks does when you open the company file by yourself, but when you download the SDK and run it for the first time, it creates a prompt in Quickbooks asking if you authorize the SDK to access quickbooks when it isn't open and asks what user name you want it to use. Like I mentioned before...

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

Ok so like I mentioned before, I isolated the issue to a query. I have a login form that opens to a splash screen that contains several different sub forms that show which stage of the process a project is in (being prepped, being analyzed, completed, etc.). This query that is throwing the...

I have isolated the problem to a specific query. I have NO IDEA why there is an issue with this query, as it is very similar in design to others in the DB. But, when I delete this query and open the database, there is no error. Now, I have re-created the query and form associated with...

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

Is there a reason why you wouldn't use a select query and dlookup to get the customer name associated with the customer ID, that way your users don't have to do a secondary search to get the right customer ID?

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

I would like for anyone with some knowledge in Access design to be able to step into this database and see what is happening in a glance, INSTEAD of having to trace things back to their original source. Or encountering fields that are called "Type" and have a value of 1 or 2, but NO description...

Ok well it would be best to design this with the possibility of moving to an sql server so I will stay away from the multivalue field and just stick to assigning a customerID to each invoice. Thank you all for the great advice, this forum is a lifesaver!:D

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

Well, the more I look up multivalue fields, the more I don't like em. Seemed like such a great idea.... Anywho, I guess this leaves me with these two options: Creating a field in tblInvoices with a CustomerID OR Creating a 3rd table with a many to many relationship Unless there is another...

So, I would think the Invoice records would need a customerID associated with them, UNLESS, like you mentioned before, there is a way to have the customer table and a field called "Invoices", which would show the PK for invoice 1,2 & 3 associated with that customer, and that field would retain...