Search results

EDIT 2: I found the error, but do not know how to solve it: The error message in detail says: 916:[Microsoft].[SQL SErver Native Client 11.0].[SQL SErver] The server principal "porter"(rem.: the login-name on this database) is not able to access the database "AnotherDB" under the current...

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

This is my solution for "sending" data through a passthrough qry to a SQL-Server table. It would not be neccessy to link the tables in your access project. 1) Build a function with the connection string: 'If QueryName is not provided or is an empty string ( = "" ) no query object will be...

Hi TJ, sorry for very late reply due to holidays. I tried the code and it works. Due to the fact that the design of the products change, I changed my concept as well and have to copy the picture to each record anyhow, which makes it easier to present the image anyhow. But thanks again. Michael

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 Martin, I solved my Problem when I put the complex criterias in VBA and built a SQL string like this: If not isNull(Me.MyField1) then sql1="AND MyField1= " & Me.Myfield1 end if If not isNull(Me.MyField2) then sql2="AND MyField2= " & Me.Myfield2 end if If not...

Hi Paul, i hope it does not matter that I jump in in this thread with the same question, as I am having the poblem, that to many selection fields which a get from unbound fields in a form the query is to complex and does not execute. I tried this: SELECT * FROM tblLeistungen WHERE...

Althoug we discuss about calculations, my main problem is still there. But I solved it meanwhile that way - and it works: set @Reliability=case when (SELECT count(*) FROM tblEventAnmeldungen WHERE Status='XX' and tblEventAnmeldungen.MaID = @MaID) = 0 and (SELECT count(*) FROM...

Hi namliam, 6/2 is 3, but 2/6 is 0,33 ! 0/0 is not possible, so the result should be 0, allthough you cannot calculate it. Of course a reliability rate would be: 1-(2/6)= 0,66 (= 66%). XX means canceled registration. But my problem ist, that even 2/6 (AnmeldungenXX/Anmeldungen) in my...

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

Try this: Dim strPassword As String Dim strInputPW as string strPassword= "test" ' or retrieve yr Password from a table field e.g. or somewhere else strInputPW=InputBox("Please enter the password:") If strInputPW <> strPassword Then Msgbox "Password does not match"...

Hi Marie! strPassword is empty! You compare the result of the Inputbox with nothing! You did not assign any value to the variable strPassword. What about this: Dim strPassword As String Dim strInputPW as string strPassword= retrieve from a table field e.g. or somewhere else...

I think I found the reason of deleting the query: two events which runs at the same time used the same query. This might be the reason for the deletion. After changing this, the query does not vanish anymore.

As neither the datebase is new, nor the code in VBA is new, I am puzzled. So there is no code who deletes this query.

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

I used the SQL Server Native Client 11.0 ODBC Driver before. Thanks for the links!

Thanks, now I got it! acDialog make the code wait for execution as long the pop-up is opened! Thanks your help!

HOW does the form from which I opened the pop-up REQUERY?? HOW can I name this form in the requery? That was the question. Maybe to make it more clear. I open my "frmEmployee" (my pop-Up form) on time from FormA and another time from FormB. In the Employee_AfterUpdate-event where I set the...

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, thanks your reply, I am using the SSMA normally, in that case, as I had just one table to Import I used the wizard, but I could not solve it anyhow. By the way I found an error in all those thousands records which most probably leads to the "skipping" of about 1/3 of the records. ONLY 4...