Search results

a maybe simple question: With the mid function one can make sure that a part of a text is token to display on a report, output or whatever. But how to do the following: "John Isaac" "William Bill" "Michael Robert" In the report the following has to be visible: "John" "William" "Michael" The...

problem solved! cSTR(format([datefield]);"dd/mm/yyyy")) Thanks for all the advise(s)

Outline problem fixed by cstr([date]), but . . . I want the format of the date to be dd/mm/yyyy, so i entered (i thought it was correct) the column in the query as follows: cstr(Date([datefield];"dd/mm/yyyy")) But it doesn't seem to be correct... please advise?!

okay, that's an option...only, how to? (sorry...some things i do know, some things i don't...)

i was afraid the answer would be that....it has to be changed on various pc's if that's the case.... Hopefully there will be more suggestions?

maybe only in the netherlands uhm...see my title :)

Teletubbies..... oh sorry...that's my daughter's

I only use the datasheet view to check the information and how items are being displayed; normal use is that a command button does an output to a rtf file; and this rtf file contains of course the table data; but everything has to be outlined to the left (each column, inclusive the...

problem description advanced Hi, i'll try to make the description better: The position of the information when showing the table in datasheet view is located to the right (outline to the right); however, because the column is used in a rtf file the information has to be outlined the left of...

Another question. One of my tables contains a date/time field format: dd/mm/yyyy; in the format property of a table column usually (type: text) the indent can be set to left with "!" (without the " of course); however, i would like the date/time column to the left as well in stead of to the...

Thanks for the solutions; all the code works fine, except for the fact that for some reason i cannot modify the linked odbc table properties.... Do i have to allow the db somehow to manage the linked table property?.

part of problem fixed (i think) Somehow, linking the tables again (manually) and saving the password in the string (checkbox, save password) fixed my problem of not being able to change the property of the connection string manually, however the code does not still seem te work(?)

I have four linked tables within my access db; i need to change the connection string; of course i can refresh by the menu (linked table manager) and choose the right odbc-connection, but i want to be able to do this for the four tables at once by a button. At this moment i have made a local...

uhm..ok, thanks.... but my problem is how to put it in code...

how do i change a connection string from passthrough query; i have about 100 passtrhough querys with of course a connection to a databse (oracle). With one button in a form i want to be able to change the connection to another database (oracle). Thanks for the reply!

solved (!) Thanks to googling around the world, i found a side effect which appearantly caused my problem as well. (found the answer in a discussiongroup of google about mailmerging access and word) There seem to be a problem in acees 95, 97 with the automation of mailmerge whcih starts a new...

..thought my problem with the parameter values was over... it really .... I first had the bypass procedure left out, so i could sort out the problem with the locks and everything. Now i made the bypass procedure again, and at "startup" disabled all checkboxes, so that whenever the user starts...

exclusive lock - how to link without locking I sorted the problem with the parameter values out, in some part which i overlooked, the old parameter came forward, which caused the query to ask for all parameter values. My last problem: In the following code i have set the link to source part on...

one thing sorted out (problem is not SHIFT Bypass) The problem with the locking had (as far as i could tell) nothing to do with the SHIFT Bypass procedure. In the mailmerge module i had, instead of an InPutbox ("please give location of template"), i had put a form textbox there...

I have a problem, which i cannot solve: 1st: i created a [shift]-bypass module and behind a textbox a code which if doubleclicked a password is asked, to disable or enable the [SHIFT] key for opening the db the next time it is started up (found in a trhead here somewhere how to) 2nd: i have a...