Search results

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...

Hi, I am having problems creatling hyperlink for multiple records. We have a website that has providers privileges and each is different because of name or deparment so in a query I had the system create the hyperlink address based on data fields. IIf([DeptCode]="Midwives" Or...

Thank you that I made me think actually did VBA code and it works great...plus I had index that can't duplicate this way I am able to copy of the prior index number into another field to keep records together. creating DIM Variant for each field Dim v1 As Variant Dim v2 As Variant Dim v3 As...

Hi, I have a form that needs to be filled out for authroization request and I have status field in the form "Approved", "Pending", "Denied". What I would like to do is keep history of denied cases. For example, If I request an authorization an "Elective Admission" and the vendor comes back...

Hi, Is there a code or away that could use popup calendar to update several date fields. I have two date fields Start and End date if I use the Access Calendar control it only lets me choose one control source. I google and the best option I found to do a form with calendar and add range...

Actually I think I just got it...the file type is "000" just added that as the extension and the file got imported. Thanks