Search results

Oh, I tought that maybe was that on the table the field is a long, so I change it on the module, but now it's giving me error 13.

Now it says Error 3464, Data Type Mismatch in criteria expression.

Error 13, type mismatch

I tried changing a lot of things inside the line of the rs, but never achieve something that allowed the code to show the next line.

Is the number of the PK, it should at least work with one result, but alas it does not.

Hi, I'm trying to code a function that writes directly the status on a query field when called. The code I wrote is just for test as for now and looks like this: I just want a column that shows "bing" for everyrow, because I am trying to check my code, but the thing is if I set the rs it...

Just came back to tell you that everything is working fine! Thanks a lot for your help

Just one more thing, that would be cool to fix if its possible. When I arrange the results on that column on ascending it messes the order when reachs the 100 records, any idea how to make sure that goes subsequently? I was starting to consider having that autonumber column for that purpose...

Hi Arnel! That worked perfectly as I wanted to! Thanks Man!

Hi jdraw, thanks for your input! At first I used that option, but then I wondered if I could format the entire thing from vba, and it mostly worked but well, then it doesn't work past the number ten. I think im going to give up the full code option and just use the Dmax option.

I supposed it could be that... Gonna look how to get a workaround it. Thanks DBguy!

Hi, thanks for your reply. I thought about using the one that access generates, but I need it that way for regulatory reasons.

Hi, I was trying to code an autonumber for the PK of a Table that only ID field and a text field. I came with this: Option Compare Database Option Explicit Public Function Nextus() As String Dim pref As String Dim lastCase As String Dim csNum As Integer Dim nxtCase As Integer Dim anno As...

Well it was that, the link to sharepoint. I solved it by splitting the database and having one frontend without the link to sharepoint that is dedicated to the excel files. Nice patch I think. Not the ideal solution, but it's the one is working and can be done by me.

To me, the problem is the link, I don't think the problem is in updating through the query because even if I not use it the error appears. But as far as now, I don't know how to use currentproject.closeconnection with sharepoint, so gonna keep looking that way, I'm mostly sure the problem is...

Hi DBguy, always a pleasure talking with you. I don't think it's possible to add records manually, because there are a lot of FK related fields, such as names of products. I was thinking in using something like currentproject.closeconnection when I close the db, but I'm not sure if thats going...

Hi, I was wondering if someone else had this problem: My db has a linked table to sharepoint to add records through an update query, but since I made this now I can't use the excel files that are linked to the db through some queries without having the error "The database has been placed in a...

Ok, My db is on shared state and on a safe location, so I can discard those. I don't know about that binarybuffer that I have read down on the thread if it can fix my problem, seems complicated. EDIT: Just made a rollback on the DB and it's working perfectly, I think the error might be...

Going to check it out, if I fix it I will come back, thanks in advance :)

Hi, I have stump with an error when I try to update/refresh the queries or tables on my workbook, it's the error "The database has been placed in a state by user...(etc.)" any idea on how fix it? I have been told it might be related to the build version but maybe any of you have found a...