Search results

Can any one help with this: i havetext box where the user enter the quarter and year , and he ll get the report . there are two conditions, if the report is before the 3rd Quarter 2004 Report1 has to show, if after Q3 2003 then Report2 Has to show. am stuck with the Quarter Declaration.as...

thnx for reply WayneRyan guess i didn't explain the problem very well. this is example of what is happening some dates are not exist in the record set cause they r either week ends or holidays.. at the date crieteria i wrote: CDate([forms]![x]![text0]) Or...

i have a query that compare between two working days. in order to compare between the current date and previous working date am using this in the criteria at the previous working date field :" [current date]-1" the problem comes with the Holidays and the week ends. where "[current date]-1" is...

hi , i have a chart report built on a query you will select a date on a form maped to a query,the query will give you the data related to that date and previous 6 days in addition to the day u already selected. Problem. some records are not available in the date field. the Query is ignoring...

hi, i created a report based on a cross tab query , i have these fields , stock as a row., duration as a colum and deals as data. the duration is divided in to 1, 3, 6 ,9 and 12 months. where there is no deals for 12 months for example, this ERROR msg comes : the Microsoft Data base Engine...

hi, in my data base there is a form with a command button that run a macro for importing excel file to a table of my data base, the table is consisting fields that is uploading when running the macro. and there is" date" field which i desire to make the user enter it Manually ,and let it apply...

hi, i have this main three fields date of buying "date/time" formated duration "number" formated maturity"date/time" formated doing this formula, Maturity = [date of buying]+[duration] where duration is in months how can i convert the number to date/time format , so i can make the formula...

hi , i have two forms of two seperate tables. Form 1 , has these fields : Name "Text", Issue"Memo",Action"Memo", Form2, has these fields : Task ID"Number", Task Subject"Text of 200 characters", what i want to create is : to create a button at form1 that when i press it opens me form2 with...

hi there, does any one knows how to disable the F11 Key ?? thnx in advance

hi, i created a repot for a query which has the field catigory in the creteria of the catigory field , i wrote this [enter the catigory], so when the user run the query he get he data related to this catigory he wrote, my question is , can i change the label which he enter the catigory name to...

hey at the start of my data base, u have a log on form, and then u will go to another form where u will have the information . can we sort"filtere" the forms by the log in user ? i mean , if the user name is "X", this is on a log in form. then the other forms will be filtered Related to X...

hi , i need help with my code, am using this code to send a report as txt file to the desk top, dim x as string x="the report name" docmd.OutPutTo acReport, x with that code am going to the output window to choose the file format ,and then to another window to choose the destination"desktop...