Recent content by rejome

Well, I'll auto-answer my own thread, cause I found the reason why. The problem comes from the fact that I had some BIT fields in MSSQL, converted in Yes/No in Access. The Yes/No field can takes NULL as a value but not the bit one. I just put 0 in MSSQL as the default value, relinked my table in...

Hi guys, Using CurrentDb.OpenRecordset with Access 2000 thru linked tables, I have sometimes an error when I try to edit some of my data: "Writing conflict. An other user is trying to edit your data, yakyakyak". As an admin, I see that in the same time that I use OpenRecordset, I create a...

Hi guys. Here's the fact: I have a form and sub-form, talking to each other by the way of child/parent textbox. On my XP, works perfectly. But on an other XP, I got an 'expression too complex' error. Same Access, same version, same dlls. What's f**** wrong?

Oh yeah! Forgot the view. Thanks to all of you guys. Great help, as usual.

Well guys, a lot of good ideas here! But all of them don't work in Access. Yes I must do it with Access. Still have some ideas?

I have a text field in MSSQL, query made with ACCESS, where some of the data are 1.1.1, 2.3.2, 10.2.3. Right now, an ORDER BY on that field is made and the result is: 1.1.1 10.2.3 2.3.2 ... I'd prefer to order them in a 'numeric' way, like this: 1.1.1 2.3.2 10.2.3 Is that possible?

Sorry PHV, it didn't work. Here's the code I tried: s = "\\files\Excel #.xls" s = Replace(s, "#", "%23") Application.followhyperlink s

I'm trying to open a file with followhyperlink. I got an error cause the name of my file is "Excel #54.xls" and the sharp is seen as an html tag...well I think. Any suggestion to bypass this?

Well thanks for the help. For now on, I stick with the select case (CCLINT's idea) but I've tried the TypeLibInfo. Very useful. But like CCLINT said, you have to use a select case anyway. Trying too to combine all the things togheter. By the way, I'm glad my post makes some of you guys thinking...

Well CCLINT, you really stick with the select case ;) I'll go with this cause TypeName doesn't do what I want. I just wanted to use the table definition cause the const will probably not be the same if the version of ADO is different of mine. Anyway, I wanted to do that: -Table in Microsoft...

Using a recordset, I want to list all the type of the fields used in a table. By this way, the user will be able to decide what kind of field will corresponding to, for example adBinary. I want to create a SQL to create a table, using some conversion to adBinary and, for example, number type.

There is more than 40 const. Is there any chance I can use the definition table of VB, WITHOUT using a select case?

Hi, Using ADODB, everybody knows that adBinary has the value 128. By using the number, 128, I'd like to obtain the corresponding name of the const, adBinary. How can I do that?

Hi guys (and girls too ;) I'm trying to convert a DB from Oracle to Access. Easy. But, I got a 'Multiple-step OLE DB operation' error when I try to convert an Oracle TimeStamp field to an Access Date/Time field. Well, not for all records. The error appends only when my Oracle field contains...

I got a list box set on single selection. When I clik on a check-box, I want my list box to use multiple selection and I wanna do the opposite too (multiple to single selection). Is it possible with a property of a list box?