Search results

I want to use a subForm with a Text Box for notes. I would like the text box to Auto-Size height to display the entire note field. I can use Continous or DataSheet or whatever works I guess. The property 'Can Grow' seems to only be for Report and Report preview. Does anyone know if there is...

Cool, Null worked first time. Thank you very very much!!!

I found another piece of the puzzle. it is sorting as a string rather that a date. i.e. 1/15/2008 1/24/2009 10/16/2009 11/22/2008 12/18/2005 2/15/2009 So... even though I used CDate() it still seems to view it as a string and sorts it that way.

I have a table that stores dates like this: 200902015 i.e. 2/15/2009 In a query I am trying to convert that to a date. I am using Week_Ending: IIf( Nz(view_Last_Labor!Max_Week_Ending)<>"", CDate( Trim(Str(Val(Mid$(view_Last_Labor!Max_Week_Ending,5,2)))) & "/" &...

I have a working app in Access 2003 (Version 11 I think). I have a code snipet ' If Int(Application.Version) > 11 Then DoCmd.ShowToolbar "ribbon", acToolbarNo ' End If Note: For testing the If statement is commented out and I have tried Ribbon and ribbon. Here is the odd...

I found it in another forum.... Yeah!!!!! With xlWorkSheet .Range(xlWorkSheet.Cells(1, 1), xlWorkSheet.Cells(iRowEnd - 1, iColEnd)).Sort _ Key1:=.Range("A2"), Order1:=xlAscending, _ Key2:=.Range("B2"), Order2:=xlAscending, _ Key3:=.Range("C2"), Order3:=xlAscending, _...

Okay, Now I am confused... As stated before I use this code often without problems. The only new (added) code is: xlApp.Range(xlWorkSheet.Cells(1, 1), xlWorkSheet.Cells(iRowEnd - 1, iColEnd)).Sort _ Key1:=Range("A2"), Order1:=xlAscending, _ Key2:=Range("B2")...

Yeah, I tried that yesterday. No luck with that either. Microsoft talk about this happening when I use a 'name' option, which I don't. So???? I'm back to square one. Any ideas how to put this code in Excel (which I can do) and call it from Access (which I do not know how to do). Thanks.

Full code??? It is lenghty. It is canned code that I created a while ago to be reusable so there are if then's and commented out parts. 'Sub Display_Excel(Excel_Archive As String) On Error GoTo Err_sExcel_SubRoutine 'Dim Active_Printer 'Active_Printer = B_Size_Printer...

Okay I made it more readable. Oops I should have done that first. Also I changed xlGuess to xlYes. I am not using xlApp.quit because I close it manually. The user will do the same. I do check of the form is already open so I don't open it twice. I use Set xlApp =...

Does anyone have any thoughts on this. I am kinda stuck. A possibe solution is to trigger code in Excel to do the sort. This is less preferable as I lose a bit of control. But if that is the only way to get it to work then okay. I have searched the forums and cannot get the code to execute...

I am having problems sorting an excel spreadsheet. The following code works once. Just once then I get an error. It is a message box that says: Title = Miscrosoft Office Access Message = "Method 'Range' of object'_Global' failed" xlWorkSheet.Range(xlWorkSheet.Cells(1, 1)...

Thanks Bob, Let me check these two options. I have never had a query that existed external from a form refer to a form before. I didn't think of trying that. Let me check your sample and give both a try. Thanks again.

P.S. Yes I can have the form fill in the parameters for the query. How would I do that? Remember.... The source query the form is based on does not have any parameters. Rather two of the queries that are linked in the source query do.

The parameters are dates. I would like the form to open and have the user select the date ranges via a calendar control or something similar. This give me more control and error checking than having the user fill in the default message box that the query would otherwise pop-up. Any help...

I have a query (actually several joined into a single query) that has parameters (actually three parameters in two different joined queries). I want to base my form on the query but I want to answer the parameter questions programmatically rather than have the user answers. Can someone please...

If you're using code now, there shouldn't be any difference. You just call the routine (or function) from the Timer Event or put the code in the form itself. Either way the database and form both need to be open, but other than that it should work. Do a search for AutoLogOff. This is an...

You can use the Time Interval property to set the amount of time. Then use the On Timer event to preform your action. You will need to keep the form open so you may wish to open it hidden.

No matter what I did it did not work. I tried my best to trace the flow. I should have mentioned that the query is a pass-through. I don't know if that was the problem or not. Since the query is already written, I ended up changing the text (SQL) of the query on the fly. It does the same...

P.S. I can write a manual me.filteron and me.filterby = But this function has worked so well everywhere else. I can't seem to find the problem. Thanks