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...
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
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,
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,
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")...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.