Search results

Without giving notice an administrator changed from Win 7 64 bit with Office 2010 32 bit to Win 10 64 bit with Office 2016 32 bit on a certain machine. Now, our production database application based on Access 2010 Runtime 32 bit does not work anymore, ALTHOUGH I installed the neccessary...

Frontend Access 2010, backend SQL Server 2008: I have a Problem which I cannot solve at all. on a form there are 3 subforms which get their records through 3 passthrough queries from the Server. All 3 subforms have the same Settings like AllowDeletions, allow Edits,Lockings, etc. All...

I get crazy with an error which is not MY ERROR at all. I copied a form from one database to another. In this form is a control named "Invoicedate". After changing a few other controls and adding new fields from a table I debugged the Project and suddenly I get an error "method or Name...

Hi! reading all mails from a Lotus Notes database, a view, a collection is not that difficult. What I Need, but no where found is HOW TO Import the actual marked or opened mail, so only ONE mail, the current mail. Does anyone can help me please as I cannot find any solution for that. In...

I have a Problem which I cannot solve at all. On a customers PC (Win 7 32bit) runs an app in an acc 2010 RT (SP2 already), backend is a SQL Server 2008 Express. I have a couple of reports which do not work properly. Before that I have to state that I did everything I know to check my database...

I made already many applications as accde or addcr and deployed it to users, which only have an Access Runtime 2010. Since a few month (it might be accidential) all the accde crashes on start saying something like "You have to delete the VBA Project..." (translated from the German...

Hi! I Need to find the respective numbers for a textstring when for abcdefghijkl stand the numbers 79 81 82 83 84 85 86 87 88 89 91 92 The textstring to "decode" is for example is 'adgjk' The result (79 83 86 89 91) should be added into a table by Looping. rs.Addnew...

Hi! I am almost sure that there is a bug in the wizard to pack a solution including dependencies. Whenever i try to pack the solution I step throut all mandatory fields, adding of course the accdr, the AccessRuntime.exe All my files have no Special character but still a get the...

Since many years I "fight" with pop-up forms, as in endless view I cannot figure out HOW to fix the heigth. Some forms keep a height which was set by the System and it is suitable others have the full hight of the Screen and I cannot find any Setting which can influence them. Please let...

I'm googling around for days to find a way to receive mails from POP3 or IMAP using VBA and store them in a MS-SQL Server database. Reason for that is, that on our Windows Server 2008 there is NO Lotus Notes Client, NO Outlook, no other mail client installed. While I can SEND via SMTP using...

Hi, I have a problem which I cannot solve since many days. We are using Lotus Notes (obviously the main problem!) where every user need to have his own LotusID AND the Lotus Client to work with. My Access 2010 Database works very well on the user clients, when mailing and sending SMS by...

Hi! On a from ("Customers") with tabs I have on the second tab a subform ("Orders") as a single form with a field "Ordernumber". "Customers" and "Orders" are linked through "CustomerID". On the mainform I have a "searchfield" in which a enter the Ordernumber, I want to find. I cannot...

Hi! After finishing my development on a Access2010 accdb I converted it into a accde and want to run it on a server profile on server 2008 R2. Before that I installed it locally on different users machines. All of them have Windows 7 Enterprise, and Access runtime 2010. For all on them it...

Hi! I was not sure if I should open the thread in Queries or in SQL-Server as it would fit into both.. My problem is that out of two tables I need a result set presenting the number of orders items per PLU and the number of items still on stock. I cannot do in ONE stored procedure. My...

Hi! I have a function with works perfectly to execute a stored procedure by a passthrough query from Access2010 'If QueryName is not provided or is an empty string ( = "" ) no query object will be created but the SQL statement or stored procedure will be executed (useful for DELETE, INSERT...

Hi, I have two tables on a SQL-server 2008R2 tblProducts (fields: ProdID, Description, ProdImage,...) where ProdImage is defined as varbinary(max) tblProductsOnStock (fields: ID, ProdID, quantity, ...) The tables from the server are linked to my Access 2010 front end. In tblProducts the...

Hi! It seemed to be an easy thing in T-SQL to do, but I can't solve it: There is a table tblEventAnmeldungen containing employee number (MaID)and Status ('OK', 'NO', 'XX') of registrations of Events (EvID). I would like to count the number of registrations (not Status 'NO'), the number of...

Hi! I have suddenly a very mystifying behavior in an access 2010 front-end which DELETES a certain pass-through query from time to time. The query sends an sql-string to the sql-server and retrieves the data from the server. The same structure of data-retrieving I use in many othere...

Hi, I would like to use a pop-up form from different forms and need to get the name of the form from which the pop-up has been opened. The purpose is, that when closing the pop-up again I need to requery this form. As I need further two values as Openargs for the pop-up I tried this...

Hi, I'm getting an error while trying to import from an Access-table to a sql-table, but 2/3 of all records are imported correct, 1/3 is ommitted because of this error msg: Messages Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code...