Search results

Sometimes but not on this moment because I could not found the group by or I had still problems with it. So I thought I do it on the PHP/MySQL way! I have put all the SELECT fields in the GROUP BY and then it's working but I have still doplicated project_numbers in the result!! What is the...

Hello Dennisk, huhh? I think it depends more on me then on you but I don't know what you mean? what do you mean by a totals query? I did some investigations. The next example is working: SELECT tblTempJob.sar_status FROM tblTempJob GROUP BY tblTempJob.sar_status; But if I add a field after...

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 Allan57, I think that this is not where I'm looking for. The only thing I want todo is substract a half an hour from the time now. Only calculating with time. Oke now I understand the misunderstanding. The thing I want is: Time - Timevalue("00:30:00") Let say the time is now 13:43:15, so...

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

I have found it. It must 'ExpTijd%' in stead of 'ExpTijd*'. So now it's working. The only thing what I not understand is that if you are looking in the books or search with google on the internet you see everywhere examples with the "*". Why? Can somebody give me a explanation for this...

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 matt, Oke, that's working so far. But If add this code, then my whole access application (=main thread) is sleeping or dead. So what I really need is a kind of a thread in VBA/Access. So that I have the main thread and a subthread which is started in the main thread. What I not...

Hello Matt, I think this is the otherway around. The function is going to sleep for a while and after the sleep period its going further or do I mis understand you What I need is a function/process which starts automatically after a certain time? Nico

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...