Search results

Hello, I have the following query: SELECT tblTempProject.project_number, tblTempProject.Project_name, tblTempProject.subsidiary, tblTempProject.division, tblTempProject.unit_number, tblTempProject.client_name, tblTempProject.resourcing_contact, tblTempProject.project_cat_type_code...

Hello, I have asked this question an earlier time but I didn't get the right answer. I have made a workaround but on the end it's not enough. I'm starting the code beneath from the form: Application.ExportXML _ ObjectType:=acExportQuery, _ DataSource:="qryXMLexport", _...

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 from SQL-server database. The text in these field is cut off by 255 chars. Does somebody know what the cause of this...

Hello, Is there simple function to calcualate with time like: datediff("s", Timevalue(Time) - Timevalue("00:30:00"), rec("par1").value) Has somebody an idea how to solve this? thanks in advance. 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 VBA access a webservice over a network? I export from Access an XML file which is put on a server on the network. When it stays there I have to trigger a webservice on the server. Can somebody help me with this? Thanks in advance. Nico

A kind of proces or deamon or thread Hello, I'm new to Access. I have in a param table where I have put some times in it. I want every day at the times which are filled in de param table, execute a query. Let say: record 1 in param table: 08:00:00 record 2 in param table: 10:00:00 record 3...

Hello, I'm quit new to Access. Can somebody tell me how and where do I define a shortcut like [ALT+P]. I want to open a form when I press this key combination. How can I solve this in Access? Thanks in advance. Nico

Hallo, I'm quit new to Access. I have an existing application. There is a form with some selection fields. When I press the button report then following is executed: - The report object is called with DoCmd.OpenReport Rpt, acPreview - This report has object dependencies with the query...