Search results

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

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?

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

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

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

I have a main table that I just imported all of my data into, I have 41k separate hyperlinks attached to each of the separate number. The problem is on the excel sheet before I imported they all would open the default browser and pull them up. Once imported they will not open, the field is set...

I am stuck right now and I am unsure what would be the best way to move forward, I have a form that is button launched from a main form. The main form and this form are linked via their id#. The problem I am at is there are two different types of information that a user would need to fill in...

Alright I am still new to the VBA world but I am giving my coding a try, and so far it is no good. Here is the problem, I have a combo box that pulls down 36 different selections. Each of the 36 selections all have different responses and as well a different value. So if the user pulls down the...

Alright I am still new to the VBA world but I am giving my coding a try, and so far it is no good. Here is the problem, I have a combo box that pulls down 36 different selections. Each of the 36 selections all have different responses and as well a different value. So if the user pulls down...

I have a subform that stays in data sheet view for entry, the form this sits on is launched by a macro. This macro on the main form launches the form and adds in the linking numbers by a setvalue. The main form has the linked number on it and this number is then linked by master and child to...

I new to VBA and I am having problems having my combo box auto fill the next text box. The table it pulls from is called Code-LeaseProvision and it has only 2 columns in it. So when built the combo box it pulls the both rows. One is labeled "Code" and other other "ProvisionDescription" I...

I have a form that I need it to run a query when the form is being close, but I am running into a tad bit of trouble. First off this is my first VBA code so please bare with me! Here is what I have so far: Public Sub Form_Close() With DoCmd .SetWarnings False...

I have a database which has been in production for quite a few years, it even made the swap from .mdb and .accdb without losing any of the functionality. Well I just had to export from access to new access to start a new file for one of our projects and now one of the subforms is not adding...

I am fairly new to the Access world and i have run into a problem with my macro enabled button. The forms name is called Well Master and has an autonumber every time a new record is created. All this information is fed to a Well-Master Table, but here is where I am getting into problems. I have...

Hey guys I am having problems trying to get my IIF to work! I have been working it awhile now and I think I am truely over thinking it! I first tried: Expr4: IIf([State]="La","Parish","County") I want the county text box to show county if it is any other state besides La, and if it has La...

I am just starting out and I have a form that is linked to 2 tables and has a relationship with another. It will not allow me to delete from the tables because it tells me that it is also in another table. I tried the button command to make a delete button but how do I tell it to delete from...