Search results

Hi.. I have a field date and i need that on particular dates for example on the 01/01/2011,05/01/2011 etc etc the back color will become red for example. The date is already entered in the database. thanks for you help.

Hi. I created a small database which I have as fields date of entry , req no, etc etc. When i enter the date of entry, the req no must be shown automatically commenced with number 1,2,3 etc etc I need some help that when its 1st january of every year, the reqno must begin again from 1 and...

I have this card.. its attached in the image, how can i get those that are - 1 has to be shown as A and 0 has to be shown as B. thanks a lot Any help please..

I have made this command to prevent duplicate dates, but sometime it does not work. Can someone help me why? Thanks If DCount("*", "LEAVE", "[Date Taken Leave]=#" & Me![Date Taken Leave] & "#") Then etc etc Thanks a lot

I have made this command to prevent duplicate dates, but sometime it does not work. Can someone help me why? Thanks If DCount("*", "LEAVE", "[Date Taken Leave]=#" & Me![Date Taken Leave] & "#") Then etc etc Thanks a lot

Hi. I have the following code after update For intCnt = 1 To 12000 rst.FindFirst "[reqno]=" & intCnt If rst.NoMatch Then Me.ReqNo = intCnt DoCmd.RunCommand acCmdSaveRecord My problem is that on the 1st day of every year it continue get the next number, and not...

I have this porcedure after update to get the next REQNO. Its working fine but after reaching the 1000 reqno it became slower to get the next number. Can someone help me to fasten the process?? Thanks Dim rst As dao.Recordset Dim intCnt As Long Set rst = CurrentDb().OpenRecordset("stock"...

I have a table which contains 50 employees. I have another table which stores the DATE LEAVE TAKEN for every employee. My difficult is how can i append for example a PUBLIC HOLIDAY DATE to all employee at the same time, instead of inserting the date one by one. I have a form with a DATE field...

Hi.. I am trying not to duplicate DATES for each Counter. If i have Counter 1, and inserted a date for example 01/01/2008 and already exists it gives me a message and if i go to Counter 2 and inserted same date 01/01/2008 for the first time it passes ok and so.....so in the table i must have...

Hi. I have a table which conatains DATE of Entry and Tick Box. I need to DCOUNT those tick boxes which are yes for the month of January from the field date of entry. Can someone help me please. Thanks a lot

I have a report which includes the MALE and FEMALE as gender. I have made this =Sum(IIf([gend]="M",1,0)) which sum all the MALE. It works but my problem is if there is duplicate person in the report, it would sum as 1 MALE not 2,3 etc tec Any help pls. Thanks

hi, is it possible to have a form where you enter a word in a text box and it searchs a table and brings up all records which match it,and if it is null, it will show me all records. e.g. if i enter: PENCIL it will show exact match example 1)PENCIL...

Hi. I want ot create a query for specific users. I have 10 users. my problem is that one of the users can view all the other users entered in the database and the other 9, can view only what each user entered. example user1 : view only his records user2 : view only his records...

I have two fields which i need to search neither with MAIN CATEGORY(field1) or with MAIN CATEGORY(field1) AND SUB CATEGORY(field2) together. These are both COMBO BOXES. My problem is what shound i put in the criteria of the SUB CATEGORY to search neither if sub category is empty either search...

I am newbie and i need some help, i need to create a report, in which i have a field BATCH NO. I have some batch no with same numbers. I want to count the batches, but those that are duplicate it must be counted as 1. Any help pls?? Thanks

Is it possible to send a Message to a user from the database??? For example, "CLOSE DATABASE DUE TO MAINTANCE" Thanks

Hi.. I need some help how can i get all persons that age is equal to 25 years till the end of this year?? any clue please??

Hi.. I have a subform with these fields DATE,ITEM DESCRIPTION and QTY. Also I have a YES/NO button for RETURNS and another two fields will be displayed on clicking on it. the fielda are QTY BACK and DATE. My problem is if I have for example 10 items in the suborm and I want to click the YES/No...

Hi.. I am trying to make an update query using this criteria [Forms]![Personal Issue Subform]![Date] and when i run the query it says Enter Parameter Value [Forms]![Personal Issue Subform]![Date] Note: The date exsits in the subform. Can anyone help me pls??

Hi.. I have a subform which contains FOLIONO,NAME etc etc. Also I have the PRINT BUTTON to print the REPORT. My problem is when i want to print, i want to update the PRINTED field with same FOLIO NOS. Example. If i had 2 same FOLIONO, it will update them Both not only one. I have made this...