Recent content by Cire

it worked!!! tks lagbolt!! i always thought i have to put quotes when i use string, but this case is different. tks once again :)

Hi all, i'm trying to design a new Navigation Bar/Menu for my application to improve the navigation. Previously i was just using command buttons but now i want to try to use a combo box and place all the names of my forms in it. I have setup a module: Public Sub...

have u take a looked at this thread? http://www.access-programmers.co.uk/forums/showthread.php?t=107647 i've answered many questions about multiple criteria search in there. however VBA coding is used so it would be good to read up on it beforehand.

questions that i answered regarding search forms: http://www.access-programmers.co.uk/forums/showthread.php?t=107647 and if u want to display the number of records. Open up your sub-form which displays the results, create a textbox in its form footer and under controlsource put "=Count(*)"...

no problem :) if u find VBA a little too steep, there other example databases that don't use VBA but i don't have any links to them atm...

there are couple of search forms based databases in the sample database sub-forumn. u can take a look at the code and see the comments to gain a rough knowledge. another tip to start off, use the Help file :) some examples on top of my head db as codedb() --defines ur database qdf as querydef...

anyone? sigh i have perpertually given up on using a module for the export to excel functionality and just the old method, putting everything into 1 form. Until i can figure a way out..

SELECT tblTechnicalIncidentReport.Exercise_Name you only selected ONE field to display from your table, of course it shows only one field!!! you need to add more fields to it. if they are all from the same table then u can use SELECT fieldname1, fieldname2, fieldname3, fieldname4 FROM...

you need to put a .requery in the form's on load/open code i believe. either that or on the listbox's code itself. something like me.listboxname = "yourqueryname" me.listboxname.requery not tested though..just something on top of my head

do a search..there are lots of posts on this. You will need to manipulate with recordsets and the the createobject functionality

and the windows dialog prompt code and finally the windows dialog save to module, modSaveFile which i gotten off this forumn or mvps, can't quite rem: Option Compare Database Option Explicit ' Declarations for Windows Common Dialogs procedures Private Type CLTAPI_OPENFILE strFilter As String...

guys please help here..i've no idea where i went wrong, apparently excel doesnt capture the path where i designated nor the filename i typed. It actually creates a "Book1" temporarily and prompted me whether i want to save the changes i made to it, if i click yes i am prompted in another window...

yes sorry its snippedm i didn't quite have the whole picture so i posted part of it, here is the entire code that i've used so far modFormatExcel: Option Compare Database Public xlApp As Object 'assiging the variable xlApp as object, xlApp will be declared as excel application...

Try this: If IsNull(Me.txtExerciseName) Then 'this is to ensure user keys/select at least 1 criteria; add on rest of the controlnames as desired MsgBox "Please enter at least one criteria" Else quot = """" strSearch = "SELECT Exercise_Name,BoxNo FROM tblTechnicalIncidentReport WHERE...

thanks but it isn't working...no file is being exported..i'm still trying to troubleshoot.. edit: do the sub FormatExcel need to pass any value to the main form? right now my flow of logic for the whole procedure: User clicks on "Export to excel" button, in the code: 1. VBA 1st launches the...