Search results for query: *

Hi, I need to caculate the number of days between two dates for all the month seperately. so beginning date is 3 may and ending date is 5 july should give me for may: 28, juni: 30 and july: 5. How can I do that. Regards apestaart

Hi, I have a form called "frmworkingours" with a subform "subOurs". I want to check if the user adds a new record. I know that I can check on "frm.NewRecord" But I can´t find a way to declare frm as the subform above. Who can help me? Recards Apestaart

I can't find a way to put labels on a pi chart generated by the report wizzard for charts. Who can help me? Regards Apestaart

I have made a report with contract ours for station and regions. There are many stations per region. In the footer of stations I have an unbound field named "Kontrakttot". Via a visual basic routine I calculate the value for "Kontrakttot". This works perfectly. What I need for the region report...

I try to sum all the contract ours of employees in a report. I want to do that per department. I looked at thread 703-1277036 and tried the following. : Dsum("[contrakt]","report query","[DepID]=" & DepID). In "report query" I check for Null values and do not include these. DepID is in the...

I have the following problem (uppertunity). I have a mainform with a combobox to select a month. In a subform I have info about persons per month. Mainform and subform are linked via a monthID. So I can select a month and via a select query I have per person ours worked, ours vacation etc. What...

Hi, I want to count the number of unique postcodes in a table. So 1433 GS is in 3 other records aswell, but count as one. I need this to calculate the number of books to distribute given the fact that I only distribute one book per postcode. Hoe Can I write a SQL statement for that function...

I have put this thread at the wrong place (VB 5/6) instead of this forum. So I try again with the answers I have got. I am looking for a way to let a range of an Excel worksheet background blinking. The blinking should be started from the VB code while opening a messagebox and stopped by...

I am looking for a way to let a range of a worksheet background blinking. The blinking should be started from the VB code while opening a messagebox and stopped by pressing OK on that messagebox. Who knows a way? Thanks in advance, Apestaart

I am looking for a way to position the messagbox at the rigth site of my Excel worksheet. Is there a way to do that? Apestaart

In a query I use an expression to format a data to mmm and yy. This is used in a report detail. I want to sort on the date bit after format it is treated as text. So it starts with April, August etc. Expr1=(Format([Date];"mmm"" """yy")) How can I solve this? apestaart

In the detailsection of a report I calculate the values of anunbound textbox. (On Detail_format) The unbound textbox is named : Tegoed. I want to set the runningsum for this textbox via the properties of Tegoed. I choosed running sum over group. That does not work. I tried to do it in an other...

I have created a form with a button box to transfer data to an Excel spreadsheet. I used code from "Hellen Feddema" (Access archon colulmn #66)"writing data from an access table to a worksheet created from an template". this works, but only once! What I mean is te following:I print the...

Hallo, Again I have problems with setting a recordset depending of a SQL statement. I am asking for 2 parameters (month and station) to be used in the where part of my SQL statement. I receive an error 3061 (to less parameters expected at least 2). Who can help me on this? The code: Dim...

Dear reader, How can I find and install the missing reference? The objectbrowser gives : Missing : Microsoft Excel 11.0 object lib It gives also the location F:\Microsoft office\office11\excell, but F: does not exist in my PC. Regards Apestaart

In the code underneith I use "set rs as recordset" I set its value via a SQL query. I do this two times. The first one is working ok. But the second one gives me a runtime error 3061: To few parameters. Expected 1 item" I have tested the query first with the form open and that works perfect, but...

I have made a report with a graph using the Graph Wizzard in Access. The wizzard let you chose a query. The query I chosed is based upon another query asking for the "starting date" and "ending date" for a period of time. The graph shows days of illness during that period per departments. That...

Using DoCmd.OpenForm "FormName",acNormal,,,acFormEdit gives me a result that I don't want. It opens the form and goes to the first field in my case a memo field. The complete text is highlighted and the cursor is at the beginning of the text. What I want is to set the cursor at the end of the...

I try to connect my OKI ML 380 printer to my new laptop (HP Pavilion XP). Because the laptop has no paralel port I bought an Targus Mobile dockingstation(USB) with a paralel port. I tried the XP driver for ML380 and also the Epson compatible 24 pins printer. This does not work. Who can help me?

Going to a control in a subform I have already found out. But how to go to the last record of that subform to change data I can't find. Who can help me. regards Apestaart