Search results

Hi :) I am trying to pass an argument in my module function. Right now I just want help by giving you all a simple problem. Lets suppose I have two Forms....FormOne and FormTwo...I want to build a function like this Function GiveMessage(StrFormNumber as Integer) Dim StrMsg as String If...

Hi I have one text box and List box on my form. Whatever I enter in my text box and press Find the List Box displays the relevant data. I was just wondering that is it possible to capture the time the query takes to display the data as my table containss over 100,000 records to search n...

Hi I ma trying to set a Input Mask property and my Rule is that Only 'W' as letter should be entered at the start and my second rule is that Any letter except 'W' should be entered in the start. I have set my Input mask as Input Mask = >La Is there anyway that I can fit my rules in the...

Hi Me too like to be joined in "Anuaz Beneficiaries Club" please send me the DB or code at mukhtar@dph.uwa.edu.au Cheers! Aqif

Hi The way I do this image change is as follows 1. Put all images in any fixed directory 2. Refer the path of the image in my code. 3. Place an unbound Image control in ur name and name it as Pic 4. On current event of your form write: Private Sub Form_Current() Dim strpath As String Dim...

Yes Please I will like to see the code. Please mail me at mukhtar@dph.uwa.edu.au Cheers! Aqif

Hi The best way is to create a query which gets all the fields of the table. Then make a grouping report and open the Report directly from the form by using the code. DoCmd.OpenReport _ "MyReport", acPreview, "", "[Forms]![MyForm]![MyID]=[MyTable]![MyID]" Just replace the...

Yes Stephen: Thats what I was thinking tht this Conditional formating feature was not available in Access 97. So will it run if I will save my DB in prior version is remains to be seen. But i was looking for a code which sort of loops through every text box n sets formating...any suggestions ...

Hi I have got a form in which I have about 30+ text boxes with number either '1' or '0'. What I want to do is at Form Current event or any other event, all the text boxes having '0' value should show as black in background and all the text boxes with value '1' should appear in red...

Hi Is it possible to have your custom buttons on message box which says like Insert Print Cancel Then can you refer like If Msgbox("---",--,"--")=VbButton1 or VbInsert First of all am I making sense ? and secondly is it possible? Cheers! Aqif

Hi There... I am trying to run an Append query like this Dim Str1,Str2 as String Str1 = Date() Str2 = Me.ItemId DoCmd.RunSql("Insert into TableName(OrderDate,ItemId) values (str1,str2)") End When I try to run this query Access doesnot recognise Str1 and Str2 and prompts me for value. I...

Hi Is there anyway to change the color and style of the Status Bar Text for different fields in my form? Cheers! Aqif

Hi is it possible to use Dlookup Function Like Dlookup("FieldName","TableName","FieldName1= " & Forms!Form1!Text1 "AND FieldName2= "& Forms!Form1!Text2 I am trying to match tow conditions in Lookup function...any suggesstions? Cheers! Aqif

Dear Rich: I am using both the statements like DoCmd.GoToControl "SFrmAssessments" DoCmd.GoToRecord acForm, "Forms!FrmAssessments!SFrmAssessments", acNewRec it is still giving me same error as "The object Forms!FrmAssessments!SFrmAssessments is not open any suggestions? Cheers! Aqif

Hi I've got an unbound form which acts like a calculator and it has got a subform which is bound to a Table. What I want is that after calculating the values from Unbound form the Cursor should goto NewRecord position in Subform but for some reason its not working. I am trying something like...

Hi I've got two autonumber question: 1. How is it possible to get an autonumber in the shape of 00001 and 00002 etc. Or tell me if I have 1, how can I turn it into 00001 through function. 2. Is it possible to autonumbers like FM0001, FM 0002 etc? Cheers! Aqif

Hi: I want to put and run a database from actual web space. I've got a space on web but I dont know how I can create a DSN for that database and how can link it to my asp coding. Any help will be appreciated. Cheers! Aqif

Hi Anuaz..I also want this code..send me at aqifali@yahoo.com Cheers! Aqif

Yes i agree with pat. But if u really want to use word n then u might need to enter the information on table form in word n then save as text format so that you can easily import them in database. Cheers! Aqif

Hi I am opening a word document from a button on the form. The code for opening the document is: Private Sub CmdHelp_Click() Dim RetVal RetVal = Shell("Winword""C:\Help manual.doc""", vbMinimizedFocus) End Sub When I run Access is its normal or standard edition, the button opens the...