Search results for query: *

cmmrfrds: That's a very handy site! I knew www.connectionstrings.com, but this site has much more info. On the site, I found the following info: My problem now is: I want to connect to a remote access file, with the "myUsername" and "myPassword" I used to login to the versionmanager... I can...

@Zion7:i'm sorry for the confusion, I ment the second rst: rst.open "SELECT max(versie)..." I select a max, because in that table I put records with all the new additions to the system. It's a string, because it contains digits and letters. The whole idea is to compare the highest version...

Hi all! I want to make a versionmanager that will automatically copy the newest version of my frontend on the server to the workstation. I'm using the access security by using a custom .MDW file, with a disgranted admin group in it. In the frontend I have a local versiontable, in with I want...

Hi all! I want to develop an access front-end application based on a postgresql back-end. I've worked with access back-ends before, there I used the following commands to open a new connection: Dim cnn As New ADODB.Connection Set cnn = CurrentProject.Connection I know how I open an...

Wow, how stupid can I be... Maybe it's because it is 11pm in the netherlands? Thanks!

Hi all! I want to add a column to a table and I wrote this piece of code to do that: Public Sub mc_add_column_table(in_tableName As String, in_columnName As String, in_columnType As Integer, Optional in_columnPrecision As Long) Dim cnn As New ADODB.Connection Dim cat As New...

Mufasa, it works! you deserve a star! Thanks... greets, Tom

Hmm, it 's a bit early here, in The Netherlands. forgot to tell you witch column is the windows column... the first column is the windows ascii-value, the second column is the mac-ascii value

Hmm, in the last post of me I posted a bitmap... now you have to type it all out... here's a list in text-format, so you can copy-past! chr(192),chr(203) chr(224),chr(136) chr(193),chr(231) chr(225),chr(135) chr(194),chr(229) chr(226),chr(137) chr(195),chr(204) chr(227),chr(139)...

Hi Mufasa, in general the characters in the following bitmap has to be converted: http://www1.tip.nl/~t876506/Comn1.gif, with two additions: character ® (windows: chr(174), Mac: chr(168) character ™ (windows: chr(0153) Mac: chr(170) Thanks for your help! I really appreciate! greetz, Tom

hmm, looks like you don't have a network-connection...

Hi all! Our program based on a Oracle database makes an export of some data in de DB on a windows machine. One of our clients saves that file on a fileserver, opens it in a mac and reads it into Quark. Now all the characters with a ASCII value above 127 are changed, because the mac has a...

OK, I want to go to the 'public variable' option, that seems the easiest and best way for me. Now the following problems occurs: I have 5 matrices (see first post) witch contains subtable names, foreign key names etc. These matrices only can't be public declared... I could make a get function...

Can you tell me what kind of error you get?

Name your macro autoexec, it will start directly when you open the access MDB or MDE file

ok thanks CautionMP, I will try this!

The easiest way is to store the value in a database table. make a tbl_constants for example, containing 1 row, and store the value of the option on exit in the column option3default

Sorry, my english isn't good enough to say my problem in a few words. This is what I want to do: I want to make a generic 'class' all my forms are based on, so I can dynamically make a recordset for the form and lots of other things like creating dynamically searchstrings. Therefore I want to...

Hi! Beta 3 is out for some weeks now; but when I try to download it from a mirror server, going into the map win32, I only see beta 1, beta 2 div 1, beta 2 div 2 and beta 2 div 3. Where can I download the beta 3 version? thanks for your answer! Tom van der duin

Roy, Yeah ok, I was hoping you didn't say that... I also thought a direct query was better. but consider the following code: '--------------------------------- Public Function volledige_naam(in_p_id As Integer) As String On Error Resume Next Dim cnn As Connection Dim rstPE As New...