Search results for query: *

Thanks for the info. That second link is closer to what I am looking for.

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

That looks like exactly what I need. Thanks!!

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

Thank you so much - I thought I was losing my mind. I am sure I want to do it - I have been coding in Access for MANY year and always have it unchecked. A new laptop has thrown things off a bit.

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

Thanks for this information - I almost have it working the way I need it to. It appears that I can't specify a folder for the input or output files - just the file names and defaulted to the Documents folder. Is this your experience as well? I need to put that file in a specific user's...

I have downloaded pdftk software and it works from the command prompt. C:\Users\ballu>pdftk F:\PatientScans\DeaMar\FirstFile.pdf F:\PatientScans\DeaMar\SecondFile.pdf cat output DeaMar_Merge_10182020.pdf Calling it from the VBA code is not working though. I am getting errors - unable to find...

Thanks for the link sxschech. I am looking at their website right now. A code sample would be great especially if they do not have anything on their site.

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

That would be great Duane. I apologize if it was not an appropriate post. Karen

Duane, This is Dr. Kyle. I am willing to pay you to help us resolve this problem. Are you willing to take a look at my database through a secure portal and see if you can solve this problem for us? Please respond to dr@spacechiro.com. Thanks so much! Dr. Kyle

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

MajP - This is Access 2013. I appreciate the ideas. I used FileFormat.info to see what format one of the files is and it says it is JPG. I used Irfanview to "convert" this file to JPG and it is a smaller file now. I saved it under a new name and put it in the folder with the links. When I...

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