Search results

I need help to develop a query Infact i have two table one is stdtbl and second is temp table i want to move data from temp table to stdtbl table by doing following tasks Move data from temp table which is not available in stdtbl delete data from temp which is duplicate in stdtbl restore...

penguino29 I have done my job with other technique which you have provided earlier i.e with help of IncrementValues function. I am able to do what i want to do. Thank a lot for time you spend for me. One thing which i want to mention and that is not try to give too personal comment on...

Dear penguino29 Thanks for spending and putting too much efforts to solve my problem and comments giving to me. I am posting all message on this forum for help but along with providing help, you comments really discouraging me. I am a faculty member and no knowledge about access or VB...

I think you are missing the important thing and that is you are able to develop query for time and shift but actualy each name is repeated numberous times. Infact there are only 16 student but output query is giving 1400 combination. my requirement is like following name 1 A...

Following is the function which is called in a query. If there no field which is referring a text box of a form then this function returns a serial number but it shows an error if any field is referring text field of a form: look at the following two queries: Query 1 (works fine) SELECT...

Thanks for your reply but i think it does not work as one timeslot is alocated to three member of same Shift which is not possible to do in this technique

hello any body can help me, i am really stuck in this problem I have two tables both are linked, i have develop three queries, one query for sub form, while two other queries filter the data. In both queries i have used serialized function developed by "" THis function works fine when no...

Thanks a lot, with your help and guidance i am able to solve the issu: i am using following code Function IncrementValues(intSR As Integer, intBase As Integer) As Integer IncrementValues = (intSR + (intSR * 2) Mod 3) / 3 + intBase If IncrementValues >= 13 Then IncrementValues =...

Thanks a lot:):) it works fine and according to my requirement Except at one point and that is i want to skip one value from output column.. The value is 1:00 pm, i want to skip this value as this is lunch break and there is no one to do any task. Is it possible to do? Once again i really...

Thanks a lot you have solve my problem. Your function is working perfectly and with the help of this i am able to develop a function with new criteria Function IncrementValues(intSR As Integer, intBase As Integer) As Integer IncrementValues = (intSR + (intSR * 2) Mod 3) / 3 + intBase End...

No one is reply yet, is i m thinking wrong or what else

I am using following function to get increment values THe input value is the colume of a query. if sr is divisible by 2 then increase otherwise old value of increment variable Sr Output required 1 10 2 10 3 11 4 11 5 12 Function IncrementValues(i, Optional myBase As Long) As Integer Dim...

I am using following code to format the excel sheet from access. With xlApp .Application.Sheets(sSheet).Select .Application.Cells.Select .Application.Selection.ClearFormats .Application.Rows("1:1").Select in first row only five cells have values and instead of selecting whole row i want to...

Hello!!! I have exported data from access to excel. From access i was able to format the cells of excel as well. I have changed few properties but can I change the view of exported worksheet from Normal to page break view, change in Zoom and boarder & shading of those cells which have data...

Hello can any body help me in developing following output of a query First declaring a global variable incrementVariable developing a function for increment value (one Hour) but first count the number of records in the output of a query. For your ease i have developed following requred...

Great!!!!!!!!!!!! I am able to format excel file exproted from access with your help Thanks a lot Can I change the view of exported worksheet from Normal to page break view, zoom and board and shading of those cell which have data only instead of whole sheet. If yes then what will the...

Thanks for your reply, I have resolved all issues and only one error left and that is "object does'nt support this property or method" and after debugging following line is highlighted. .Activeworkbook.Save I thinks this problem can be solved and your can guide me better

I have find following code from other fourm to import data from excel into access. The name of site is also available in the code. I am unable how i can use or call this code by pressing a button. Sub DB_Insert_via_ADOSQL() 'Author : Ken Puls (excelguru.ca) 'Macro purpose: To add record to...

Thanks once again You have correctly identify the problem. I have modify the code but once again an error appears. The error is exported file is 2003 format and save as .xls but message appears the access does not file .xlsx is not found. How i can improve this error. error is attached as...

thanks for your reply. I have pasted this code from a thread of same forum " hiding excel manipulations and showing a progress bar" I have modified the coded according to suggession but same error occur after pressing debug the line higlighted was .sheets("YourSheetName").select can...