Search results for query: *

Hello, I'm a newbie to SQL and if it is not to difficult I can succeed to write querie's. I don't much know about PL/SQL. We are working with Oracle. The parent ERD is this. Table 1 --> linking Table --> Table 2 --> Table 3(detail) 1 | 1 1 1 1 1 n |--> Table 1...

Hello, You can look at http://www.vbaexpress.com/forum/showthread.php?t=16843. Here I have the code which I'm using and is working. My solution beneath is straight forward and simple. [code] Sub openMSProjectFromExcel() Dim pjapp As Object Dim strValue, strStartDate, strEndDate As String Dim...

Allright, I have already solved by my self. So If anybody need support about this subject I can help him or her Nico

Hello, I have to export data (date's, description) from a excel file to a MSProject file. Oke, I can understand that I can open a MSproject file. But then: how do you paste certain cell data from excel into the MSProject cells? Does somebody have a example Thanks in advance, Nico

Hello dhookom, Till now I see the truncation directly in the datasheet view of the linked table. How can I see that this is happening in the query? It seems to me normal SQL query. Nico

Hello, If I read the documentation then memo field in a Access table can be 65.000 chars long. I have three memo fields in a linked ODBC table which is filled by a append query. The text in these field is cut off by 255 chars. Does somebody know what the cause of this can be? 1. Is there a...

Hello, I want at some stage everytime look back for half an hour like: Datediff("s", Timvalue(Time)-Timevalue("00:30:00"), rec("par1").value) Is there in VBA a simple function for? thanks in advance! Nico

O sorry, I see now that Crowly also has mentioned this. Nico

I have found the problem. It must the "%" sign instead of "*" because the application which I have to maintain uses the DAO microsoft rubish specific wildcards. Thanks anyway. Nico

Hallo, The following what I do not understand: Set cmd = New ADODB.Command Set cmd.ActiveConnection = CurrentProject.Connection cmd.CommandType = adCmdText cmd.CommandText = "SELECT par1 FROM tblparameters Where tblparameters.gcnf = 'XMLexp' AND ((tblparameters.ccnf) Like...

Hello, Is it possible to call from Access over a network a webservice? How? Thanks in advance. Nico

Hello, I'm new to access. I have in Access at certain times to execute a query which is exporting an XML file. Is it possible to write some code in VBA access which is running in the background or sleep for a certain time. Wake up, checks if a certain time is passed and if so the query is...

Hello Paul and Missingling, Missingling you're right. That's what they did. On every form they put a button. Thank you all for helping me. Nico

Hello Paul, The hidden objects and system objects checkbox where not checked. But when I made thes boxes checked, I see now some system query. I don't if it made a slight different if I say I'm looking for a key combination ALT+p. I read something that in my autokeys you can only define for...

But thats strange. The Access application which I'm working on, has at least two shortcuts ALT+U en ALT+D. Both are opening a form and are working correct. No problem at all. But under the object macro there is not a Autokeys macro!!! Or where must I look for the autokey macro???? Or must I...

Hello Paul, Where can I find this? In the database objects macro I have found only two macro's: - mcrCleanupTempTables action setwarnings and RunSQL tblTempApplicants - mcrDelivery with action SetWarnings and RunSQL as wel statements. But I can't find any Autokeys macro like here while...

Hello, I'm new to MSAccess. I have to maintain an access application. Can somebody explain to me how to define a shortcut key like ALT+P. When I press these key combination I want to open a form (popup), without closing the "parent" form. In the existing application they define already the...

Hello, I'm maintaining a application. In this application there a files (like .doc, .txt, .jpg) opened with: setFrame('frm_file', '/ALGEBESTANDEN/' + file_link); Where file_link is a variable wich is comming from sql-server database. But now somebody has deleted the file, while the name is...

Hello, First of all thanks a lot to help me with solving my problem. Really thank you. I hope not that you or somebody else is gonna shoot me because afterwards it's very easy. I believe that somebody has already mentioned or pointed in the direction of the problem. Thirst of all on advise...

Hello, First thank you all for helping me. I have tried a lot of different things post, get, request.form, request querystring even with a variable (see my piece of code). If I try to fill a session variable with a request then I get a timeout error. 'hulpvariabele = Request("strURLvar")...