Recent content by Sanjeet Prasad

Would anybody know how to insert a status bar on a form and control it.Need help on this.Thanks in adv.

Use ButOpenFile command button, and this shld work

I have a form where I want to browse for the directory path and display in a text box.I have done something similar to browse for file and display, but this time round I need only the directory path to be displayed .Need help on this.

Thanks mate...that works...

Can someone give me the code to send email via access form. Thanks

Try this SELECT 5480 Meal Collection.name, 5480 Meal Collection.phonenumber FROM [5480 Master Data] INNER JOIN 5480 Meal Collection ON 5480 Master Data.names = 5480 Meal Collection.names;

Try this : SELECT FROM [Names] INNER JOIN Names_Phone ON Names.names = Names_Phone.names;

I have a statemtn like this DoCmd.OpenQuery("UPD_RECEIPT_IMP") When I run the above, it pops up the input box for user to key in the argument. How can I stop this and pass the argument to the query in macro Need help on this.Thanks...

select the two tables in the query wizard.After that select the relationship and this is where youcan specifiy the retrival criteria to only get reords as you want.

You will have write specific application to do that.

Its a Date/Time field in AR_Invoice.I am not able to see the whole of the SQL123 as it seems its priety long and it folds to .....

I just tried that it still give the same msg. 0 records updated

I have a script as below : Public Sub DoSQL() Dim SQL123 As String Dim TEST As String TEST = "23/01/2003" SQL123 = "UPDATE AR_Invoice " & _ "SET AR_Invoice.IMPORT = 'Y' " & _ "WHERE AR_Invoice.InvoiceDate = '23/01/2003'" DoCmd.RunSQL...