Recent content by nyrob609

Thank you all for you help decompile help.

HI All, I need some help I am unable to finish creating a database in Access 2010 for some reason after I create some tables, Queries, Forms when I close and try to re-open the database Access stops working I don't get an error or anything it just says Access stop working close program and...

Good Morning, I need to know if possible to create multiple queries or reports at the same time. We have large table that is updated monthly this report gets broken down manually by Manager (30 managers in total) hen email to each manager. Report or query specs will never change only the...

Hi All, I am having a problem with Hyperlink in a form when I click it tells me Run time error Microsoft access cannot follow hyperlink. Each records has its own link for specific file. If I click the link in the table it opens with no problem but in the form I get the error message to debug...

Thank you that work.

Good Morning, I need some assistance. A former employee build a database Access 2003 that only allow to use the form. If you try to minimize the form you got a blank screen by me pressing F11 I was able to get to the database navigation pane and look at the table, queries etc... I got...

Hi, I am having an issue with the event procedure below. I have a form that has several sub forms and what I want is that if the user chooses Plan Name in the main form "No Fault" or 'Workers Comp". I want message to pop and go to the field in the subform to enter data but I keep on getting an...

Hi All, I need some assistance I am trying to get a subform open when specific criteria has been enter in a field. I have a field on the Main form that is drop down list for "Plan Name" I would like that when the user chooses "No Fault" and moves to the another field the subform pops up to...

Thank you both for the replies... Is working Or statement...

Happy New Year!!! I am having a problem completing a IIF Statement I have field name "Provider status" that has drop down with multiple options. "Hospitalist", "Specialist", "Hospital Based Providers", "PCP" etc... I am developing a query with the data requested but instead of listing the...

Hi All, I need some assistance I have a large table with (159,000) records must records are have the same demographic data by account and date of service except there are two columns that have different values. Is there a formula or way in access where I could combine the same records into 1...

Hi, I have different databases from different departments or my own and I find time consuming looking thru the folders or different sharedrives to access them. I could create short cuts on my desktop but I would like to create a form that list all the database and when I hit the command button...

Hi All, I need everyone expertise...I have a database with multiple forms that is currently use by 10. This will increase in next month to 50 the database is on shared drive. The database has been deleted twice in the last two weeks and IT had to restore the database. I would like to set up...

Hi, I need your assistance I have an appointment report that gets dumped daily to shared drive. This report holds the next day appointments. The report doesn't have an file extension so I created a command button that will run the module below giving the file a TxT extension and also imports...

thank you that work great fine...