Search results

re: Hi, word has a table of contents feature you can utilize to easily achieve what you want. Have a look at this or this! HTH Good luck

re: Hi, there are two methods to achieve this...if the application is open 24/7 then use a form's on timer event to check the current system date and see if it what you need...then execute the query/report...if it is not open all the time then create a macro which checks the query/prints...

re: Glad you got it sorted out. Good luck on future projects!

re: You're welcome. Good luck on future projects!

re: Where did you specify the criteria I gave you? I'm not seeing it...right now you have a regular select query...without any criteria in place. BTW...you should avoid spaces in field/object/control...names...they are not valid characters and can cause problems. HTH Good luck

re: Hi, check this sample you might also find this code interesting. HTH Good luck

re: No problemo...glad you got it sorted out. HTH Good luck

re: Sure...no problemo

re: Hi, just as an addition...in Acc2000 and higher you do NOT need the UDF IsLoaded function anymore...all it takes is: If CurrentProject.AllForms("YourFormName").IsLoaded Then ... HTH Good luck

re: Hi, sure...create a new custom form...add a combobox to the form which holds all possible values...now reference this form control in the criteria section of your query field e.g.: [Forms]![YourForm]![YourComboControl] Put a button on the form which runs the query or opens a form/report...

re: You're welcome. Let me know if you hit any walls and I'll try to help you further. Good luck on future projects!

re: Hi, I'm not sure if you should store the date the warrenty actually expires...it is a calculated value and can be calculated at runtime as shown earlier. You can store the components which make up this calculation like the date purchased and the interval of month/days/years till the...

re: Hi, sure...just reference the combobox form control in the query criteria instead e.g.: [Forms]![YourForm]![YourControl] The form needs to be open at query run and the value you are trying to reference needs to be in the bound column of the combo. HTH Good luck

re: Click the TransferSpreadsheet link in my initial reply of this thread...it will show exactly what the syntax is and also gives a small sample. Adjust it to fit your needs. HTH Good luck

re: Hi, check this solution. HTH Good luck

re: Hi, have a look at the TransferSpreadsheet method. You can specify what you want in the AcSpreadSheetType argument of the syntax. HTH Good luck

re: Hi, sure...I'm not sure what your setup is like but normally you would just create a query to do the calculation and you can then display these filtered records or give warnings by checking if the query holds records with the dcount() function. Lets say you have a DatePurchased and...

re: Hi, use this code to open the standard File Open/Save dialog...use a variable to store the returned path e.g.: Dim strFilter As String Dim lngFlags As Long Dim strPath As String strFilter = ahtAddFilterItem(strFilter, "Access Files (*.mda, *.mdb)", _...

re: You're welcome. Good luck on future projects!

re: Hi, if the procedure is executed from the form this control holding the value is in then use: DoCmd.SendObject acSendReport, "Confirmation_email", acFormatHTML, Me.email,,, "Membership Confirmation", "Please see attached", False If not on the current form then use: DoCmd.SendObject...