Search results

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

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

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

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

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

Hi, I need some assistance...I created a command button for the user to press and import a file. This works great but then I had to involve IT in my company and I am getting is headache... IT function is to everyday automate the process by taking the file from one system and dumping it into the...

Hi, I have several vendor forms that must be completed each asking for the same data but all have their format. I would like to do is in a form I would like for the user to pick the form and put the ID # of customer. Based on that run the query and merge the data to a word, pdf, excel...

Hi, I am trying to import a text file using my own Impoort Specification the DoCMD transfertext works but it gives me to many blank rows because the way the report was created. I would like access to get the file and appy the code below and so that all I get is rows where ":" is listed and...

Question, I created a database that holds information on authorizations we obtain. What I would like to do is scan any paper works related to that specific record and create a link to the folder where I am holding the scanned document. I also would like for the person working the case to...

Hi, I need some assistance, I created a searched form that opens a query with the records that I want. What I would like to do is to be able to double click on a field an open a form with the full details of that record. Is this possible on a query I don't see an Event option on the fields...

I would like to create a filter on a form that will show records based on my selection from drop down box (combo box) and show the data in a subform in Datasheet view that I query. How do I do this? Please help thank you.