Search results

Hello, Part of my job involves keeping tabs on unusual incident reports. Everytime a report comes in, a follow-up report has to be filed with our regulators at 30-, 60-, and 90-day intervals after the initial incident. As simple as this might sound I have a difficult time keeping on top what...

Hello there, I hope this is a simple issue. I have a form that is used to provide update information on in-house incidents. The form is populated by two tables--the first is tblIncidents which hold data on the initial incident (time/date/those involved, etc.) which never changes throughout the...

Hi John, Well, I've thought for quite some time that I'd have to go back to the beginning and start over again, however, in the meantime is there a way to fix my current issue without restructuring the entire database? Thanks, David

oops! Thanks John. I'll do that right now and repost. David ********************** Here's the repaired and compacted version. Much smaller!! http://www.box.net/public/static/flkxlzav6f.rar

Boy, I'm still not getting it... Thanks so much for your help. I tried as best as possible to model the example you attached but I still cannot seem to get it to work and I'm at my wits end. The only thing I can think to do is upload the database and see if there's anyone willing to download...

Hi, Thanks so much. However are you sure you attached the amended DB? The only one I see here is the original posted by Ansentry. Let me know if it's here and I'm missing it. Many thanks, David

Thanks for the reply. Ok, that sounds logical however do you have any idea what code I could write in order to make that happen? I am pretty oblivious when it comes to actually writing the code. If you could provide the code or point me to where I could find it I'd be greatly appreciative...

Per the instructions detailed here... http://www.fontstuff.com/access/acctut08.htm ...I created a parameter query in the form of a drop down box that, once an option is selected, should display a form with a number of fields pre-filled from a record chosen by the drop-down selection. The drop...

Hi Robert, Thanks so much for your help. However sorry it took me so long to reply; the database was at work so I couldn't try out your suggestion until this morning. I adjusted the code with my form name and got the following: Private Sub cmdCreateReport_Click() DoCmd.OpenForm...

Per the instructions detailed here... http://www.fontstuff.com/access/acctut08.htm ...I created a parameter query in the form of a drop down box that uses a command button to produce a query. The code is as follows: Private Sub cmdCreateReport_Click() DoCmd.OpenQuery "qryUIRFollowUp"...

Hello, I have a form that utilizes a combo box called cboProgAddr (for Program Address). The cbox has 5 columns each of which fills in an adjacent text box. Since I needed the option of making corrections to these text boxes once they were filled in I need to set them up as unbound via the...

Hello Neil, Well even thouigh I did not do a very good job of describing the problem, I used the feedback you offered and it worked! I eliminated the underlying query in favor of working with the table and combo boxes. Thanks so much.

Hi Neil, I am having almost the exact same issue as our friend Mr. Curtain but I guess I'm still too much of a newbie to figure out how to apply his solution to my problem. I'm really at a deadend here so I'm hoping you can help. I'm getting the exact same error message. I have a form that is...