Search results

Sir, The Expression code you give me was wrong.. it mentioning "The expression you entered contain invalid syntax"

ok Thanks to all of you... I know the reason... when I try not to have a primary key.. the record what I want is working... but its difficult to remove the primary key because my database is linking by a asset number which is the primary key... you right sir.. this is the rules of access we can...

No I dont want to sort my record in a query... I want just a normal inputting of a record. I want that my new record I input will go to the last record not in the first record. thanks,

Sir, my problem was the new record that I input was going to the first record. instead of last record. I want that my new record I input will go to the last record not in the first record... Please help me.. Thanks

Hi! I just wanna ask if I going to add new record in my database... the new record going to the first record instead of last record. can you tell me why this happened and give me a solution... Thanks you so much & more power.. Thanks,

and also it will not affect the search for my record.. because that code I will input to the combo box that will search my record.. thanks,

Can you give me the code for that... ? Please.... thanks :)

Dear Sir, Another, If I want to open an report from the filterized subform query, what is the conditional Expression for the macro builder to open the filterized record from my subform query. I want that if I click the command button to open a report. I want that, What ever I selected record or...

Dear Sir, Good Day! I have a problem with my database I have a combo box that will search for my record. Actually its working I input the specific number it goes to the specific record. But I want, if there no existing record in my database it will display a Messagebox that "No record Found" I...

but how the report will open base on the value I input in the inputbox? can you give me the full code in event value? coz I am not familiar in too much coding that's why I am using macros.. thanks

Dear Sir, I want to ask what is the code for Macro Builder in a command button if I want to open a report from the given value of inputbox. I made a command button to open a report but it will ask first the required value from inputbox I put. then it will open the report of specific record from...

Yes sir, I already delete the current date in table and also the duration days.. I make a calculation in queries as per your sample.. thank you so much.. sir... :) I hope this is not the last time you will help me.. if I have a problem again in my database work.. thank.. you... :)

Thank you so much sir... I am beginner programmer that want to become a great programmer like you guys.. thank for the help.. if I making a Database again for our company.. I will take advise from you first to make my database much better. :) thank you so much... :)

Sir, Even I put the exact function expression code you given to me. it has also an error.. this is the new error if I put your given expression... "The expression Nz([evlreccved],Date())-[evlsteisued] cannot be used in a calculated column" and Sir, the function of...

sir, NZ Command is Error.. I try like this... NZ([evlrecved], Date())-[evldteisued],[evlrecved]-[evldteisued] and it become error this is the error message.. "The expression you entered contains invalid Syntax, or you need to enclose your text data in qoutes."

Ah.. about NZ? ok I will try it.. :)

Sir, it also become error the message was this.. "Cannot find the field Date.." it means I need the field containing the current system date.. Thanks

Sir, the above expression code you given to me was error.. this is the error message.. The expression IIf(IsNull([evlrecved]),Date()-[evldteisued],[evlrecved]-[evldteisued]) cannot be used in a calculated column. thanks,

if possible to attached of sent my data base on you I will do it.. if you can give me your e-mail...