Search results

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.

Hello, I am trying to change the color of the CDHardCopyFiled field in a report turn red, when the value in the field is “No”. The No responses in the report do not turn red for the CDHardCopyFiled field. Here is the code I used. Private Sub Report_Load() If CDHardCopyFiled = "No" Then...

Hi Bob, I added an another field in the InputTable called RecComID to identify the record no associated with the communityIDNO. I changed the RecorIDNo field type to autonumber so would increment autonumber in the InputTable. I also made it a primary Key indexed with no duplicates. That...

Hi Bob, Yesterday I sent you the database. Were you able to find out why I am not able to always retrieve the correct record.. Thanks again. GMSRE

Here are the two things I am trying to do: 1. Filter the add records based on the community that is assocaited by state, county and community. This part of the database is working correctly. I can add records. in the database. 2. The second part is that I am trying to be able to retrieve...

Hi Bob, To Retrieve A Record: Select a state first. Then select a County. Then Select a community. Then select a record. Here is the attached database. Add a Record: Select a state first. Then select a County. Then Select a community. Click Initiate Record. Thanks again. GMSRE