Search results

Any suggestions. any ideas, anything so many days and not even a single answer

hi, i have been using the following method for somtime and it had proven really good for my db. 1. create a new module and place the following code in it. Public Function CheckForEntries() As Boolean 'Error-handler inserted on 18/09/04 at 12:14 by ' On Error GoTo CheckForEntries_Error...

hi, i have been using the following method for somtime and it had proven really good for my db. 1. create a new module and place the following code in it. Public Function CheckForEntries() As Boolean 'Error-handler inserted on 18/09/04 at 12:14 by ' On Error GoTo CheckForEntries_Error...

hi, i am presently using the following cirteria in my query to search multiple fields Like "*"&[Forms]![FormName]![Search]&"*" this works perfectly for my search. what i want to do now is ,, when it performs the search the fields with the search criteria should be highlighted. forexample if i...

in your design view go to subform border and right click to see the properties . see the relationship between them... you might have changed the relationship... that what i can figure out .....

hi kashif use the following select case keycode case vbkeyEnd docmd.gotorecord, "WhateverRecord you want to go " case else end select

is it possible to change the Colour of toolbar. i means to change the coloure for whole toolbar not just the icone or image but the whole toolbar?

how can i customise access messages forexample when a user enteres a dublicate value in product id with pk it gives me an error message as duplicate value how can i customise error message. inshort if the value is already in the pk and i enter it again it should look up that value and then...

hi i have a selfmade db just for this purpose.. i tried to upload it here but it is too large. please provide with you email so ican send it to you.

hi, it is an access file. i just download it again from here just to make sure.

Hello friend, I had read this thread here with the attached db in 97. Basically what it does is to change the colour of title bar. The problem I am facing right now Is that this when I close my form the title bar become black in colour where as it should turn normal to its own colour Secondly I...

Quite Simple Leave the Textbox Blank.. Just out of Curiosity why are u using a textbox ... you can use the same combo box as your source for report in the report, the text box which refers to you textbox in form use the following [Forms]![YourFormName]![ComboBiox] this will print or preview...

its kind of hard to understand ... can you possible drop a demo here so i would workd with ....

hi Kashif use an if statement here such as if isnull(me.bill2) or me.bill2 = "" then Msgbox "YourMessage",YourButton,"YourTitle" me.nextfield.setfocus endif This code should go on the Afterupdate event of your CustomerID This should work..

hello whiteReven Create a Form using "Create Form By Using Wizard" Select all rows from from table 1 and table 2. Access will automatically suggest you how to make you form using the wizard. carefully forllow the steps in the wizard and you will get a form with a subform in it. try inserting...

Yes the Form Are Alwasy used for Data Entry.

I am using the following code to refer my active form and add new record Pubrlic function AddRecord() If [Screen].[ActiveForm].NAME = "InvoiceCredit" Then DoCmd.GoToRecord , , acNewRec End If Else End function This works fine all the way till the end of my main form, but as...

i know that the stored ages are not even close to being accurate but to be honest this is what my employeer is asking. they dont have any records about there employees working with them for the last 10 years. fortunately for them and unfortunately for me they have only age of their employee. God...

hi, i know how to use the DMax to get an autonumber but what i want is somthing likethis in my invoice number , it should look like this 0001/04 0001 is the serial number of invoice and 04 is the year in which the invoice is made further more while using the dmax function i ahve noticed...

Sorry i havent.. Can you Provide some more details.