Search results for query: *

I have an Access database that reads data from a SQL Server database on Azure. It has been running for several years with this configuration and no problems. We now have new workstations, running Windows 11 (not sure if it is professional or not). We have downloaded and installed the ODBC...

I am looking for a color chart for the color choices for the color setting available on forms and reports such as the Back Color and Border Color. There are lots of choices in the picklist such as Background Form, Access Theme 1, Access Theme 2 and other choices that are not in the list but...

I am wanting to use columns on a report for the detail section and one of the group headers but not the top level group header. There is no page header as I need the data grouped as shown in the layout picture. I have uploaded pictures of the layout and how it looks in the report. If I do not...

Am I losing my mind or what? There used to be a setting in the Access Options where we could tell it to not do syntax checks when coding modules and it seems to be gone now. This was so that the programmer could type a partial line of code such as "varName = " and go to another place in the...

I have been using PDF Redirect VBA code to merge files from an array into one PDF file. It has been pretty straight forward code provided in samples from the company, EXP Systems, and has been working for many years. All of a sudden it no longer works inside the Access database. I have...

I have an Access db (32 bit version 16) that I have set up an ODBC link to SQL server tables on Azure. Some of the field names do not match up. I have a friend that is an Access expert and whom I trust that is telling me the only way to do this is to create either a SQL server view or an...

My boss would like to be able to get rid of the file server in our office. We are using Office 365 so we get Access from the web. We have an Access database that will be the frontend to a SQL Server database that is being developed on Azure. He is thinking that if we upload the Access...

I need to put a link to a OneNote page into a Hyperlink field in an Access form. I have created the hyperlink field in the table and put the field on the form. I paste in a link - copied from OneNote and it looks OK. I have tried simply pasting in the link as well as editing the hyperlink and...

Hi I know there have been many posts on this topic but I am not finding an answer that works for us. We have a database that manages a doctors office. There is a lot of custom coding in it. We get the System Resources Exceeded error message frequently on .Update statements. The database...

Has anyone integrated DocuSign into an Access database? Currently we use a Topaz signature pad to collect signatures on forms in fields in our database. We are interested in changing to use DocuSign or something to collect electronic signatures. DocuSign is great for emailing documents around...

thread181-1735294 I have had to export all files from a table of attachments fields due to the 2G file size limitation. The files are now stored in folders under a patient's name. There is a table that is an index to these files. I have a form, based on that table, that has an image object on...

Has anyone created Access objects to data-map the ICD-10 diagnosis codes to the ICD-9 codes? I do not want to reinvent the wheel if this is available somewhere - even for purchase. What I'd like is for the Dr to be able to select the higher level diagnosis code and then have the logic know...

I have a rather large database (560 mb) in Access 2013 and get the error message "The VBA modules in this database appear to have been saved with errors...." seemingly randomly. After a compact and repair the VBA code is gone from the database. The module names are there but when I try to view...

I have a database in Access 2013. There is a table link to another database were attachments are stored. This second database is up against the 2G limit and I need to find an alternative. I have cleaned this file up as much as possible. We have most, if not all the files that are in the...

I have an Access form that has a button to read Outlook emails and based on what it finds do specific things. When I click the button it takes about 2 seconds to process the emails properly. I want to add this button to a very complex form and have it be automatically clicked every 15 minutes...

Our office has started using GenBook to allow the patients to book appointments on-line. GenBook creates Outlook appointments in a particular calendar. I know I can import the data from Outlook into Access but am wondering if anyone has ever imported directly from GenBook. This would allow me...

I have a tabbed form that displays patient data. I have a sub-form on one of the tabs that displays exam data for the selected patient. I have a requirement to display three exams at a time for the patient. I can put the sub-form in the tab 3 times and it shows the same exam for the patient...

I have two tables - Patients and Appointments. It is a one-to-many relationship between the two. The common key is PTID - a string field. I have a form based on the Patients table with a sub-form that shows all the appointments for a patient. I have a combo box that allows the Dr to filter...

I am trying to move my Access 2007 database to a SQL Server backend without having to make all the programming changes in the Access front end database for things such as changing "No" criteria to "False" or a numerical value since SQL Server does not have a Yes/No data type. I have a co-worker...

I am trying to output data from a table using either TransferSpreadsheet ot OutputTo. I have coded it with both methods and both work fine. I need to transpose the data during this spreadsheet creation. I have searched on the net and found code that I think might do it at bytes.com, searching...