Search results

Worked great, thanks!

I have been trying many different ways to get a box that shows interest in a property to give a statement if it equals "0". The interest shows to the 8 decimal point and is fixed. So numbers could range from .00001245 to .99999999, but what I need to have it do is when it is 0.00000000 to have...

I am running a query that uses the table and a joined table looking for information. It is based off a yes/no off of the main table, if it's yes it add to the report and the report looks fine. When there is no data with the "yes" then it just shows blank boxes for it's portion in the report...

So if I was running a VPN instance on a local machine I would just need to keep the same folder location for the backend or into the sql machine?

I am wondering how I would be able to connect my front end sitting on my desktop to my access backend sitting on my companies sql server? What types of addresses would I need to be able to connect? How responsive is it via the internet?

The table name is Lease Basic, and yes 00101-00001-00001A.pdf would be perfect!

Sorry about the naming if you could make it the same as lease num1

Sorry my boys got sick and I had to get them back to healthy. Here is a screen grab of what the table looks like in design view. The folder location is: Y:\SouthCross\pdfs

I'm still trying to get it to work for me! I keep getting different errors each time I put this into the VBA code!

Sorry I was out of pocket over the weekend! Thanks for the coding! The field that has the ole object is set from a form that someone just right clicks into to insert object. Would there be a better way to change it for the future without effecting everything already in or should I get all of...

Thanks you!

Ok this is exactly what I need, but the coding for the ACCDB is that run through VBA or what other coding source?

I have been passed down an older database that I am having problems with. I am trying to query out the OLE objects that people attached to each record. They are all .pdf but when queried all I get is the tage "OLE OBJECT" instead of the pdf. What do I need to adjust to get it to export the...

I am currently stuck, maybe it's the weekend or lack of coffee! I have a form that is fed by a query that pulls from 2 tables and a cross reference table. They are all connected via a property number in all tables. The form has a subform in the middle that pulls from another table and...

WHAT I am trying to do is make an easy way to add what is within a table to input into a subform by using a button. The user have to input 25 unique fields because that is what is being tracked by management. As I said I have a table tMinData where I house the min 25 fields I would like...

I have a split database that I am trying to help speed up a slow process. We currently have a form that our brokers are having to fill out on every lease that they open. In the subform they have 25 minimum items that need to be populated on every lease. I have loaded a table with the current...

Alright I have split the database, and made the front end a ACCDE so they can not modify any of the forms. I am still getting the problem, and i know it's half the users fault. They have a minimum of 19 answers for the initial combo box that sets the rest of the dynamic combo boxes. So the...

So if I split the database, and add a FE each user than the VBA will only effect that specific user? I have split databases before but I dont know all the benefits you can get from it!

Well the same form but linked to different unique numbers. It is a subform within the form.

I am currently having a set of 3 dynamic combo boxes that define what is being inserted into the combo box by what is selected on the first combo box. The problem is that I have numerous users on at once, and when a person makes his selection for the initial combo box the requery works. If...