Search results for query: *

Hello, I'm messing around with Dhookom's calendar style report and it works like a charm, BUT.... i'm missing some data in some weeks. This is the DateAdd line I use WeekOf: DateAdd("d",-Weekday([RotationDate])+2,[RotationDate]) , I basically want all first days of the week (week starting on...

I have a report with a schedule of Call duties and use colors to distinguise teams! If I print this (13) page document it takes forever on my inkjet and I really don't need the "Nice" normal print-out. However if I print in Draft speed on my color inkjet it will just give me graytones for the...

Can anybody tell me what events are triggered when you update the data in a subform through the main form. I click on a date on a DtPicker control which updates the data in the subform to the right information. Now however I want to format the fields using code!! BUT I CANNOT find an event...

Hey, I use code to format the color of a control depending on what dat is in it. Currently it looks like this: If DLookup("[Team]", "EmployeeLetters", "[LastName] = '" & Me!Mo & "'") = "1" Then Me.Mo.BackColor = T1Color If DLookup("[Team]", "EmployeeLetters", "[LastName] = '" & Me!Tu & "'") =...

Hello, Is it possible to view more than 1 record in a single form without using subforms? I have made a scheduling database and every record has a full week of call duties, in my case however a full schedule consists of 5 records! I can show this easily in a report, but can't seem to find how...

Hello, I have created a database with scheduling rosters. The basic idea is to have 4 teams rotate a "call" schedule with the monday team also taking the next weekend schedule (don't ask, they want it like that). I made a rule table based on all the "rules" they have for call rotation. When I...

hey, I want to open a recordset and use the WHERE part to filter the records I need! When I call the Openrecordset it gives me a error saying: "too few parameters, expecting 3" What is this for, I tried putting all the fields separately in the SQL statement in stead of * and all kinds of other...

Hey I can succesfully open a mailmerge document from a access form with the right query in it, BUT..... I want to make this procedure able to do all kinds of mailmerges and wish to include a SQL statement to select a certain record. How do I do this. I did look at the mailmerge FAQ somebody...

Hey, is there a easy way to open a Word document that has merged fields in it and connect it to a current record in a form. Say I have a tenant and I want to send him/her a specific letter (like a late rent letter), I want to use the access data in the form to show up in the Word document to...

Hey, I'm trying to calculate a Sum of Payment amounts in a form. However I get a #error no matter what I try. The form uses a table as source and there are no filters running. I have another similar form and it works on that one, I'm puzzled?????????? This is the source code I use...

Hey, I've got a form with 2 subforms, the 2 subforms have the same linked field "Property ID" The form data source is a table that contains 1 record and the subforms contain several records with the same "Property ID" The problem is, that the form does not show the record in the table, it...

Hey, I used to program vb in school and at work a couple of years ago and I always used the following code to create a recordset so I could fill in data in tables, validate, etc... Dim dbs as Database Dim rst as recordset set dbs=currentdb set rst=dbs.openrecordset("table_name")...

Hello, I have a report that displays Properties, Units and Tenants. I have succesfully grouped and the report looks nice. For my question lets say I have a property with 3 units and only 2 units are occupied by Tenants. Now when I open my report the first and last names of the tenants show up...