Recent content by andyeastes

Hello, I am calling a stored procedure with the code below. When i log in as my user it works great. Any other user and I get an error the execute line of the code below. I am calling @user a few times in the stored procedure but it does not make sense why any other user would make a...

Yes you are right again it does not run the queries. So the only way for this to work is to make sql stored procedures. How do I call them from my VBA?

Sorry took so long to get back, so I have it almost working but it keeps giving object required error - is this because I need to go to tools and make sure the DAO library is checked? If I try that it just says that there is an error and it could not load dll. Public Function...

So for anyone wondering here is what I ended up getting to work: ElseIf Me.Type.Column(1) = "Out" And IsNull(DLookup("Location", "InvTranInvCheckQRY", ("Location = '" & Me.Combo11.Value & "'"))) Then

Ok I have never used the find first or If before but I am trying it, it was working how I had it just only checking first (or current record) like you said and not the whole list - here is what I have now: With Forms!PullToShipMainFRM!InvLocFRM.Form.RecordsetClone .FindFirst...

I am using this snippet: Forms!PullToShipMainFRM!InvLocFRM.Form.Location <> Me.Combo11.Value to see if the values in subform1's combo11 does not have a match in subform2's location field. Subform 2 is a datasheet subform and could have either zero or multiple lines. If it has zero or one it...

I somewhat know SQL and am not real familiar with ADO but I looked it up and I would want to use the command execute method correct? Can I not just call the queries regularly but still use the code for transactions?

You are right, it was not the loop, tried the edited first one without the loop and same thing just went forever. It really is just calling the queries in a different manner if I understand correctly so why would it take any longer than the previous way I had it.

It just runs forever. It does seem to make since, could it somehow be looping non stop?

Alright, tried this and for this part of code got error: compile error, user defined type not defined Dim qdf As QueryDef Any thoughts. I looked it up and found that it says to fix chekc your references and make sure activex library is checked and it is on mine? Also, you sort of lost me on...

OK great you are right,, so I am going to try this method, so basically, I do an if statement, If there is an error I use rollback else I commit?

Pat Hartman, I do have the first table the data goes through as a local table now with the FE on their local machines, this accomplishes what you mean right? Also, I do have the user specified and they have to login so I guess I could say for each instance of the db within this function only...

Hello, So I was reading up on commit trans, rollback, and begintrans and found this: You can't nest transactions if you are accessing ODBC data sources through the Microsoft Access database engine. Does this mean I cant use this method since some of my affected tables are linked to sql server...

Set it up and it gives a type mismatch error when you type in the textbox. Any thoughts?

So I have the now local table that data from form goes too, then it goes into a transaction table and then is processed from there. That transactions table is not local, it is a linked table because that is the table I use for history. Is that what you are talking about transactions. So, I...