Search results

Thank You very much! works perfectly! :D

The problem is that my datefield is in such a format which is dd-mmm-yy. This would def cause a problem right? since the extracted year is in yyyy format... is there a way to work ard this?

Hi Everyone. I have a table and one of the fields is a date field. I need to create a query based on this table such that only records from the current year is displayed. So I need to retrieve the year part from the date and compare with the current date. I m not too sure on how to do this esp...

thks guys .. will look into it :D

Hello Everyone! I have a table with with details of a site. Each site is identified by its siteid. Each site id might have a few records. I want to get the latest record for each siteid. Like I have a field in the table which shows the date. I wan the lastest date for each site id. Is this...

helllo sorry for the late reply. yup not in the before_update. i put the code behind a button on click event. Thanks for all ur help :D

hey vbaInet due to security reasons i cannot post this database here. but now i just used a button only instead. Thanks all the help :) really appreciate it!

actually i tried in the before insert also.. then it had the same problem. so i thought maybe i was wrong and did it in the before update .. but still same problem :(

hey thanks a lot! it seems to work when i put it behind a button. However it does not work when i put it in a beforeupdate event. thanks alot for ur help :D

yup. cos I just said it as payee table for reference while asking my doubt. the actual name of the payee table is info of payee

hey this works. But right the value it shows for payee id is actually an existing record with alot of empty records. ( eg like it has only 1 field filled). I tried putting - in the empty fields but it does not seem to solve the problem

sorry the error it gives me is that i cannot assign a value for this object.

hey I just looked up the DMax function and did the following code Me.PayeeID.Value = DMax("PayeeID", "[Info of Payee]") however, it does not seem to work. any idea wat is the problem?

ooohhh icic. I will look into it.vbaInet thank u very much for ur help. really appreciate the effort :D thanks!

ooo cool! I realised that u can actually set even in the format to ensure no duplicates right? would that be enough actually?

control the unique id in code? do u have any code to start me off?

hey yup doing all this on a copy of the db. I have tried that too. Another problem is that this table is already a link table to an existing db. Do u think it wld be much better if i change this autonumber field to number field?

the thing is this is the table with the primary key.. the other table is foreign key.. so it is supposed to create the record here in this table first. This problem particularly started like after i created a form to allow the user to insert a new record into the table. However, now I have even...

hey! yes that is the only primary key and its an autonumber field. Yup its also linked to another table.

hey I tried it but its still not working :( I really need this to work! Please help!