Search results

not sure i understand i am new to this so please advise?

thanks DJkarl! i did that but now i want it so it looks up the vlaue in the table where i have all the text in a field. How do i do that? I went to control source and did the following but it doesnt display anything ControlSource: =DLookUp([longtext_text],[longtext]) also tried...

Hi, I want to create a form where all it will do is have a 2 pages worth of wording in it (so there would be a verticle scroll bar) and 2 buttons at the bottom where they would accept or deny, if they accept then the main form opens, if they deny then it would close out the access database. What...

Thank you Boblarson. however its not deleting the excel file.. here is my code ... If Not rst.EOF Then DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, ctl.Name, fileIn, True, "" End If rst.Close Set rst =...

Hi, want to know if there is a way to delete an existing file in excel that i export out of my access DB? What i am trying to do is, export many queries to excel worksheets in one excel workbook (i have this part working fine and its creating a spreadsheet and formatting it and putting it out on...

oh sorry and thanks for the reply

nevermind i figured it out.

ok so when i use the toggle button, i can get it to select all but how do i clear it when i click off again... is it the lostfocus event? Private Sub Toggle266_GotFocus() chkbox1.Value = True End Sub

Yeah I was thinking the same thing but is it on focus and would it be as simple as having the queyname.value = true ir false??? Is there a more complicated code that needs to be written? I want to avoid using 2 buttons and that the issue...

Hi, I know how to do the select all clear all buttons, however is there a way where i would have a lable/text box where when the mouse is over it, it would select all and the mouse is away it would clear all check boxes? Can this be done? thanks! Summer

THANK YOU Bob!!! that works really well. appreciate your help on this!!!

thank you Bob, but even with the correct code it doesnt formatt correctly. Here is what the code is... i think i maybe doing something really wrong here cuz this is very simple and its should not be that hard... any help you can provide will be great. For Each ctl In MyForm.Controls Select...

thank you Bob. for the above i've tried everything, here is where i am at now but still its not working and auto fitting the columns. Am I doing something wrong? If strFileName = "SCF Records.xls" Then Set xlApp = CreateObject("Excel.Application") Set xlBook =...

worked like a charm Bob. thank you! one question in my code i have this line ".Columns.EntireColumn.AutoFit" however it doesnt expand the columns to their fullest, do i have it coded incorrectly? Also, everytime i have to delete the spreadsheet if i want to export it out again, is there a...

Hello, with help of many folks on this website I was able to export many queries into different tabs on excel. However i am stuck at how i can format excel. Currently my code only formats the first line in excel but after that is done, i would like it to format the entire sheet with the...

I saw this code but when i try to implement in my code it gives me an error If Dir(strFileName) <> "" Then Kill strFileName but doesnt work for me... it doesnt delete the spreadsheet and the old results are still there... please help

can you please help me on how to delete a spreadsheet if one already exists?

ok sorry my bad i forgot the DIR ..its working fine now... now running into how to delete the spreadsheet if one already exists... should i use KILL to delete the spreadsheet?

thank you...almost there where would i put the else if message?? i tried few places but not successfull it gives me the message and create the spreadsheet and doesnt format it.. i am sure i goofing it up some how... If fileIn = "Record 01-05.xls" Then Set xlApp =...

sorry quick clarification above... (was typing too fast) :) 2 questions 1.) if i pick all 60 queries it only exports those that have true results and the queries with no results are left alone.... but the 1st query that i have is always exported even though it does not have any results...