Search results

Your suggestion works well. Thanks a lot.

let me try this one. thanks

Hi, But it is the same code i have posted. Can you please tell me how to resolve the issue when apostrophe (') is used in criteria and how to resolve it)

Hi, I am using dlookup to retrieve value from table. I have set after-update even when user select a department name and got the department id into the field by using dlookup. Me.DepID = DLookup("DepID", "DepMain", "DepName.value='" & Me.Department.Value & "'") Just the problem is when...

Hi, I would like to apply filter on form based on some criteria.(snap shot attached). I just want to view the Department only which i choose from combo box(i will make combo box on form). When I choose a department the form will show only that department and will show All values in Time...

Yes, but have different criteria. DB has two columns to check for duplicate. Column 1 contains time slot like 6:00 Am to 7:00 Am, 7:00 Am to 8:00 Am so on Column 2 contains department like Dep 1, dep 2 so on I would like to color the field in red if Same time slot is used twice in a Department.

Thanks, joining the two tables works. did you know how to high light duplicate value in form or report on single field?

Hi, I have designed the crosstab query, Just like there is option to add fix column headings (for column heading on property bar), can we set fix row headings? if yes then ca you please explain how? Thanks and waiting of your answer.

Thanks, I really don't understand where you have made the report. Can you please guide me. I want the time slots filled by volunteers regarding the activities. Waiting of you.

Hi, I have simple cross tab query (as shown in the attached snap shot). I just want to get result when I chooses the DepID from MainBoard. I am getting error message. Any idea how to resolve the issue. Thanks in advance.

Here is detail what i want. 1. Start and End Times 2. Which Volunteers have been assigned to those Activities so the user can see where there are gaps in the schedule (i.e. Activity times in which no Volunteer has been assigned) or overbooked (with more than one volunteer assigned to the same...

Actually, I want the two reports. I am confused about it that how to get that reports. First. there is table CboTime. I would like to show the time slot in report from that table, Secondly, There is table called Weekly Schedule Detail so also wants activities from there based on the what...

Yes sure, I have attached the DB.

Hi, I have attached the snap shot of report wants and the query in design view. I would like to get the reports like in the snap shots. I would like to see the activities one time and data according to it on cells. How can i accomplish it? Thanks

Hi, I am trying to get cleanup report of table. I have 8 fields and would like to get report where certain field is blank. I actually also want to get its record no. Why I need of record no? Actually i have imported data from Excel sheet that contains about 10,000 records and i would like to...

Hi, I know the programming in VBA, I just want to get idea how to accomplish the task. What table format is suitable etc. Thanks and waiting of you.

Hi Professionals, I would like to create MS Access form for data entry as per attached snap shot. Can any one guide how to achieve this. How to make tables for it and also the form. Thanks and waiting of your suggestions.

Hi Professionals, I have One table(and designed form from it) in which i have recording the daily transactions(it is like a daily book). Daily transactions took place like Purchase of items of Amount 45, sale=70, sold on account=100 etc. What problem i am facing is: I would like to Add Cash...

Yes, Only willing to get weekly report which shows each technician did how many jobs and what payment method he has used with its total.

Hi Professionals, I working on simple MS Access program which have 2 tables. As you can see in snap shot. What I am trying to achieve is. I would like to run a query which shows data between certain dates(It is done) and also to show me which Technician has done how many jobs(i have 5...