Search results for query: *

Hi, in my corrective action database, I want to send report to clients, but that report I want in word. so from my database when i click on send report, then it should send attachnment to the outlook with the word doc. IS it possible to do that? Does someone has any example like that...

hi I have one field on my form, which just calculte the total, like Total=sum(([Blush])+([Burn])) . now when i click on add new record, all forms clears up, but this total field does not. in there value stays the same. any help, how to do clear that. i try to put codes on the add new button...

Hi, actully i am trying to create a chart. I have a data for whole year in my append table, now what I want to do is, I want to create a chart. Chart will be a bar graph, but in there i want to show Quarters first, and then 3 months from the last quater and then 4 weeks from last month. for...

hi on my form i am tying to get total, like total defects, by doing =Sum(([TBlush])+([TBurn])+([TContanmination])). i does calculate sum, but it does not show changes right away, i tried to put requery macro on after update event of thos three fields, so when ever i enter any number it shoud...

hi , is there a way that i can add letter infront of autnumber field. I mean instead of , 1, 2, and 3, I am looking for T1, T2, T3. can someone help me please. Thanks

hi I have 4 tables 1:tblMain =Primerykey:IngID is Autonumber 2:TblTrend =Primery Key=IngtrendID is number 3:tblsymbol =PromeryKey=IngsymbolID is number 4:tblDefects in the relationship window, I have joied, tblTrend and tnlsymbols to tblmain, by ID's. Thats fine. now I want to join tbldefects...

hi I have 2 fields in my update query, one is txtPartNum and other one is txtBaanNum. txtBaanNumber I want to update, it should equal to txtpartNum. so what ever value is in txtpartnum, should update table, so that txtbaannum will have same value as well. when i view the query then it gives me...

Hi there, I have a database, where I am storing company employees names and address etc. Now what I want is, something like word mail merge, so it will fill letter header for me in msword. is it possible? acutully i run a query, like peopel age between 18 to 25, I get 5 people, so then I want...

hi on my form I have text field project, right, so now what i want to do is, when ever soem one enters project in the txtproject, then i want the same value in the txtpartnumber. i try to put the codes on exit event of txtproject, but its giving me error. any idea, thanks in advance.

hi, in my query i have 11 fields, all those all fields have P and F. what i want to do is I want to count P and F, like how many P's and how many F's. any idea how would i do that. I try to do count, but not working, I might be doing something wrong. please help me , thanks

formula IF help Hi i have formula in column AD and that is =IF(AC18>0, NOW()," "), trying to show current time in column AC, which it shows, but the thing is when i move to next row, there i have formula =IF(AC19>0, NOW()," "), it shows me current time, but it also chages the last row time to...

Hi, i have one chart in my report, created that from chart wizad and based on date from table. the thing is when i open the report, chart does not refresh with new data. i have to close and open report 2, 3 times in order to refresh. what should i do to refresh, and how? thanks

Hi , i want to place user name and current date and time in the cells. its row by row, if i enter date in A1, B1, J1 then it should put the persons names, date and current time in cells K1,L1,M1. Thanks in advance

I want to calculate the time, format i have is hh:mm:ss so for example it says 4:16:19 now i want to divide that by 6. i am not getting the right calculation like that. its giving me 3%. but the correct calculation got to be around 70%. becaue out of 6 hours u spend 4 hours and 17 minutes. cant...

HI i have a cross tab query, in which i have date as a row heading, inspector as a column heading and efficiency as a value. this is worrking fine. date format is by each day. thats what i want. but back in my update table if i have data for a month then in the cross tab query it should give me...

Is there a way that I can hide MSAccess messages that can't append all records, etc. i just want to hide messages and run the append query, so it can delete duplicate records and get the correct unique records. any idea thanks in advance

hi i want my query to run byitself, when ever some one opens database. thats going to be update query, takes data from main table and puts that in table 2 and then delete duplicate values from table 2. any help how to do that. thanks in advance

Hi I am trying to save values in my sub form. actually on mu sub form i am keeping the date. when ever user enter date in the main form it gets in to subform date. thats what i want. Forms!frmCMMDataEntry!Form1!Date = Me.Date but the thing is when i add new record on main form, then sub form...

on my main form and have sub form, in my sub form i have two fields, one is ID which is a primiry key to link between two forms, and second field is date. what i want to do is, i wanna capture a date. when ever someone is going to enter data on main form,when he is going to fill the date field...

is there a way that if i enter 10 or 15 records per day, so back in the table i will have record with date. i have on more field in the table, that field is going to capture only default fix value of 6. so back in the table date Hours fixfield 10/12/04 -...