Search results

I have over 100 queries of weather data, for each month, and would like to display certain or filtered information for a selected month. I have been playing around with a combo box to select a month from a given year, and was hoping that maybe an 'After Update' would do what I want. The problem...

As the title says I have 3 tables: tblMain BalanceID PK GasID FK ElecID FK tblGas GasID FK? not sure BalanceID tblElectric ElecID FK? not sure BalanceID I created 1 query from all 3 tables, then created the form from that 1 query. Now when I enter data into the form and click to save it ...

I am not sure where this thread should be in forms or queries. I have database which has 3 linked tables by ID in each table. I have built a query on the 3 tables, then created the form. Now when I enter data on the form and save it, when I open up the said form again , the data is not there...

In Access 2007, I have tried using this line of code to number the next record on a form in the BeforeUpDate Event Procedure, but nothing happens: CountID = DMax("[CountID]", "[tblBalance]") + 1 Instead of using AutoNumber, I am using Number as the data type, and I have read that using...

I have 2 forms set as pop ups so I can reduce their size, on a tabbed form. One of the forms does not save or update any information I enter. I have entered 2 records into the said form, clicked on save, then closed the form down, and when I open it up again, the data is not there or showing...

I have built a small but useful, to me, database to log our utility bills etc. I made 3 tables: tblBlances tblGas tblElec In each table I have ID as autonumber and made it a PK, and also linked the tblGas and tblElec to tblBalances in the Relationships window. I have one form which shows all...

I have just joined this forum and looking for help and advice with access 2007.