Search results

Hey, thanks for the information. Will give a try.

Hey friends, I am looking around for a way to compare two tables. Compare by what i mean is update the first table too. I have attached an example file. Here, There are two tables: "New Table" and "Original Table". Now, I need to check if any new data exists in "New table". If yes, I need to...

Thanks Neil. This worked. And thanks for the inputs on naming conventions. Since this was my first development in access, it was ignored. Will follow it. Thanks again.

Helllloooo.... any help please...??? Am not able to go further without this.

Hi, I feel this should be simple enough, based on the requirement. The first time, you open the first form. Choose a close event. i.e, write a vba code to close the form. Before close, open the next form. The first code loads the form with a timer intervel. After the interval, it closes...

Hi friends, I need to show the value of a subform in the mainform which pertains to the unique "Proposal Number". Please find the attached where I have shown the date textbox and the subform. The question is, Can I get the value of the last entered date in the date subform, to the main form...

Hey friends, Any hope on this???

Hi Friends, Please find the attached screenshot. As usual, am stuck up with a problem from 2 days. (could not attach the file, as its too large) In the screenshot, there are two fields in the SUBFORM of the Main form. They are: FTE Count and Mandays. I need to have FTE count as a calculated...

Hi Friends, Please find the attached screenshot. As usual, am stuck up with a problem from 2 days. (could not attach the file, as its too large) In the screenshot, there are two fields in the SUBFORM of the Main form. They are: FTE Count and Mandays. I need to have FTE count as a calculated...

Thanks a ton. Declaring parameters worked. :)

Thanks for your input. However, the error message shows as: "The Microsoft Jet Database Engine does not recongnize '[Enter your value]' as a valid file name or expression". Also, I tried the same in SQL code. But in no hope. Can you please suggest? I am using a cross tab. Should that make a...

Hi all, Here is a small question. Maybe easier, but as am a newbie, not able to find out. I have the below query which pulls the information. There is a "where" condition which works perfectly when I input any data like "WHERE ((([Proposal Table].[EBS Project ID]))) = "2435". However, I do not...

Hey Mailman, My problem is writing queries. I do not know how to write those queries. I tried doing it and messed it up. Can you help? Please? Cheers, Praveen

Any help please?

Hi all, This is my first question in this forum. Hope I get help. I have a database created. Now I am not able to write the queries. I have attached the mdb file with this. What I need is: 1. No. of resources Onsite / offshore – Project wise(Proposal Number is the Key) with planned and...

Hi all, I am new to Access and also this forum. I need to create a list for attandence. In other words, I have a data and it should be mannered in such a way that, it should include the leaves taken, number of absentees in a day, remaining leaves, etc., Some information I request are: 1> Is...

Hi all, I am new to Access and also this forum. I need to create a list for attandence. In other words, I have a data and it should be mannered in such a way that, it should include the leaves taken, number of absentees in a day, remaining leaves, etc., Some information I request are: 1> Is...