Recent content by GMSRE

Hello, I am working in Access 2007 I am trying to copy and paste a record using VBA code. I am also trying to increment RecComIDNO after the record has been copied and pasted. Listed below is the code I am using. I can’t figure out why the code will not copy and paste the record in the...

Hi Xproterg, I posted the database as requested 8/1/11. Did you have a chance to look at the database see why the county combo box will not populate the commmunity combo box? Thank you. GMSRE

Hi Xproterg, I am not sure if you got this message last week. Attached is the database. Click on the reports button. The state comb box populates the county. The county is supposted to populate community, but it does not work. I don't know what is wrong with my VBA code. Your help will be...

Hi Xproterg, Attached is the database. Click on the reports button. The state comb box populates the county. The county is supposted to populate community. Thank you. GMSRE

I appreciate your quick response. I copied and pasted the code and it still doesn't work. Thanks.

I am stuck again. I was able to repopulate the County combo box, but I was not able to repopulate the Community combo box. When selecting a state from the State combo box it will repopulate the County combo box based on the state selected. When I select a county from county combo box it does...

The database I downloaded was very helpful. Thanks so much. GMSRE

Hello I am using Access 2007. I have two combo boxes called state and county. When I select a state it will populate county combo box with counties that are associated with the state selected. I also created a command button on my form called “Clear Entry”. I used the code County .RowSource =...

Hi Taruz, It works. Thanks so much for your help. Greatly appreciated.

Hello, I am working in Access 2007. I access to determine how many records I have for a specific CommunityID from the InputTable. For example I want know how many records there are for CommunityID 00001. I don’t know what is wrong with my code. It is giving a total of how many records are in...

It works. Thanks so much.

Hi Paul, I tried DoCmd.OpenReport "Community_Records", acViewPreview, , strFilter. I still get all the records instead of the ones the records assoicated with community I selected from the list. Thank you. GMSRE

Hello I am working in Access 2007. I am trying to generate a report "Community_Records" that will only retrieve records that are associated with a specific community. For example when I select community ID “00001” all the records for all the communities are retrieved instead of the records...

Re: Forecolor of a Field in a Reprot Hi Paul, It works. Fantastic. Thanks so much for your help. GMSRE

Re: Forecolor of a Field in a Reprot Hi Paul, Would you mind giving me an example code or conditional formatting? I was not able to find what I was looking for conditional formatting. Thanks.