Search results

Thanks a lot to both of you. Ken..It worked the way you showed it. Really appritiate your help.

I am tring to pull up value from a table to show on Report.. =DLookUp("STATE_ABBR","CODES_State","[CODES_State]![STATE] = Reports![Flagstar Summary Report]![STATE]") This should show me the state abbriviation connected with the state code. but it is coming up blank..please help on what I am...

My temp folder is empty. About changing the size on Temp folder thorugh Control panel..I did as you say but in performance there is no temp folder Drive C: paging File size 756 to 1512 mb paging file size for selected drive dirve: c Space Available: 59951mb Customer Size Initial Size :756...

Guys, I need some help really Urgent..I have report thats about 800 to 900 pages long which is created from a query. When i run the code to create the report, it keeps on giving me Not enough Space on Temporary Disk error. I tried Different ways..I tried to Output it to my C drive which has...

Thank you guys for your input. i will keep in mind.

in Criteria section where the date field is put Now()-[Date]<30 [Date] (Date is name of column)

You can put in a range at the Docmd.Transferspreadsheet and that way you can start importing at Column D. About the date thing, I am also looking for somthing that can trasfer date as date and if you find out how to do it - it would be great if you let me know too. DoCmd.TransferSpreadsheet...

First Create a form named Form and then create a command button called Command0 Then go to the code for the form and paste the following code. the only thing you will need to change is the dir in the bold line. If you need the headings you can keep the True in the Transferspreadsheet else you...

First Create a form named Form and then create a command button called Command0 Then go to the code for the form and paste the following code. the only thing you will need to change is the dir in the bold line. Hope this helps. Option Explicit Private Declare Function...

Thanks james This code worked just fine. You really helped me out here. Thanks again. :)

Thank you for your reply. but as i Said I m not too familier with writing VB code. Is it posible for you to provide me with sample code. I trying using the DoCmd.TransferSpreadsheet, and i can get the file imported but I dont know how to put in the Dialog box to browes the path. Please help me...

Could you please tell me how did you imported data from excel to access. I am trying to do the same but i am not too good with VB. If you could please post the sample code. Thanks

I am new to VB. I am trying to get a sample code to import data from excel spreadsheet to access table. I can do it manually but i want to automate the process as it needs to be done every now and then. If any one can help me in this it will be greatly appriciated. Also let me know if it is...