Search results for query: *

Who knows the best way to (or a link)... table clients (form) client calc date range : beginclientdate - endclientdate table contracts (subform clients) clientcontracts with table index (subform contracts) yearly index date range : beginindexdate - endindexdate table items (subform clients)...

I was thinking to make a table with dates and indexes filtered for each client(record) The calculated field must look for the last index (start)date before the pc 'now()' date (so you change pc date to see the previous year calculations) query out the right indexes & date was ok but can I do...

What is the way to go for: 1)look in all (sub)records from one client(record) if there is a checked box? (validation???) 2)Event before/after update : If a checkbox is set to true --> every other (sub)recordscheckbox must be false thanks already

Is it possible to put a total 'Y' in the recordlinenumbering I have a working functioncode but don't know how to put the total(lines) in it. Function GetLijnNr(F As Form, SleutelNaam As String, LnStWaarde) Dim RS As Recordset Dim CountLines 'Dim maxcount As...

With which code is that possible? event = on click down?

Hey, I have to make a Lotus Notes JobCalendar in Access! Has somebody already made a procedure for the repeat (date/time) function? And is a view like this possible : date1 timestart1 timeend1 jobtekst1 timestart2 none jobtekst2 timestart3 timeend3 jobtekst3 date2 none...

hi, maybe you can solve my problem. I have a form(clients) with primClientID and putted two subforms in it, both linked to the (client)form primClientID. In de clientform i look for a persons name and if it's found,subform1 shows me all his contracts with the possibility to add records in the...

I normaly use a automatic filter in my view to filter a resourcename.

How do I do that? thanks already

Hi there, I tried with a macro to print automaticaly my lists pro resource and daterange, and every resource has to have different numbers of copy's ! But I didn't succeded. Can anyone help me with this?

example, I made a form with one unasigned inputbox! I want the User to fil in the different criteria items Type item1 (enter) Type item2 (enter) . . . leave blanc (enter) the criteria for the query should be like select* from table where fielt1 = "'*" & item1 &"*' or '*&quot...

I have a job for two resources with differend workregime! How can i demand the jobs to schedule within there working time without interupt of non-working time or the non working time of the other resource. example: resourcekalender a = 24/24h work = 5h resourcekalender b = 6-->22h work...

Witch is the solution for a rapport with one multiple input fielt that has to have a partial match for the different inputs? e.g. Fielt A input 1 = 10 Fielt A input 2 = 20 . . . Result should be --> a query with the where instruction fielt A =(like '*10*' or like '*20*' or like ...)

If i enter a peace of the name i'm looking for into the combobox, i want the pul down let me show the partial mach names bv. *meul* has to gif a pull down like van der meulen Willem meulenaere Jef de meule Jan

I'm working with access 97. Can someone tell me how I configure a combo box that finds a pease of the fieldname(like *[fieldinput]*)