Recent content by ia04

I have created forms to add data. What i do is click the add new record command button and add the details. But when i open the form again, it does not show the record which i have just added. However the record is present in the tables. got any ideas? please help:(

Sorry if this is too trivial to be posted as a new thread, I have spent a considerable amount of time trying to do this but have failed miserably. I want to remove the set of command buttons at the bottom of the forms, (the navigation buttons to move the next record etc.) as i want to create my...

I am creating a table with a field named Payment ID. I want the table to increment the number of this field automatically when the user is trying to enter a new record, i.e. set the field as an autonumber. I know that this is very basic, my MS Access skills is really limited. Cheers.

Hi, i have created a table that would calculate the total payments that are being made by a certain contractor. I am assuming that the contractor pays the money in three installments. In a table I have created three fields which are all checkboxes that would state whether a payment has been...

I have created two queries which calculates a total. I want to add the values of the two queries in a third query to give me a grand total. When I try to create this third query, it gives me an error saying that the fields cannot be used from two different queries. So I'm just wondering whether...

Thanks a mill guys. :) Really helped me a lot! cheers. ia.

I am trying to create a DB that would calculate the totals of different projects and also calculate the global total (i.e. the total of all the projects combined together) So far I have created a query that can calculate the total of the projects in a field which I have named Total1. But now I...