Search results

I have a chart to build using data from my Access Database. Most of the data is coming from one table but I am having a hard time finding a way to build a chart in Access. So my thought was to import data from the Access DB and send it to Excel that way I could format the data into columns and...

I ended up copying the database and deleting the form that was having problems and re-building it. I no-longer recieve the Access not communicating with OLE and ActiveX controls....etc. error messsage. Now I am running into some errors with the VBA code to run on this form. To explain this...

I read through that post but nothing of use there for I am not linking a picture or document to anything. All the code is based off the data in the database. And I don't have Norton AV installed on this machine. Thanks for your input. Any other suggestions are welcome

BTW... this is happening on all of my copies of this database. Even the backups so this has to be an issue with Access and not my code at the moment. Any suggestions will be helpful.

Now I am noticing this error pop up on all of my command buttons. Errror communicating with OLE Server or ActiveX Control The expression may not result in the name of a macro, the name of a user_defined function,or Event Procedure There may have been an error evaluating the function I...

I will try and give you a better picture of what I am doing. The form setup is as follows I have 5 pages setup: Page0- Search Page This page has three combo boxes that queries fields from three different tables.(Field A, Field B, Field C) It also has a search button to execute these query...

Okay I fixed the last enter parmeter value box error. It was a spelling error However, I still get the error with OLE Server....(the one from the the previous post) What I have at the moment is a form with 5 pages setup. The first page is a search page. the other four are pages with...

Hello, Just adding those lines to got rid of the error messagaes. But another error popped up. Not sure what this means. Errror communicating with OLE Server or ActiveX Control The expression may not result in the name of a macro, the name of a user_defined function,or Event Procedure There...

I tried this as well doing the same thing in the property window just to see if it either way would work... It did not work. What seems to be the issue is the query is happening before the form is being loaded so it is prompting for those values to be entered. So I need to somehow manipulate the...

I got it ... it was a stupid ). I was missing one. and it thought that I should have another argument because of not having one. Thanks for your help.

That seems simple enough... I will give this a shot and see what happens. Thanks for getting back to me.

Okay... I was getting an syntax error with that... but I think I got it figured out...I just need to make false condition of one be the embedded iif(). Thanks.

I have a query that pulls out dates from a table and I am trying to build a formula in the query so it can tell me whether or not that item in the record is either on-time, due today, or overdue. There will be two date inputs a planned date and a actual date. A simple example is this: Status...

I have a from with several pages that house queries. What I wanted to accompolish was a simple search to narrow down the data in the queries. I added another page to the form and setup combo boxes that have a record source to the appropriate fields I want to search by. I also have this line of...

I figured out a way...Using the TableB as a subform allows me to edit the relationship it has with the third tableC. I added buttons that switch DataEntry on/off and allows me to add a new record and then switch modes and go in and edit the new record.

Another question related to this one is about establishing a relationship between 3 different tables. In this case I still have TableB in a subform and Table in the MainForm but can I nest another subform inside the subform of TableB to relate TableB to TableC. My idea was have two separate...

Thank you for your post I got it working the way it was suppose to I wasn't setting it up properly. And I apologize for the delay in responding due to the holiday. Thanks again for your help.

I have a issue where I have a relationship that is a one to many relationship that relates FieldX in TableA to FieldY in TableB. The problem I have is that I made separate forms that inputs data into the tables but it does not relate the two. How can I make the forms establish the relationship...

I got it working as a query by making a sum query and eliminating a query on the individual items that make up the criteria field and it gave me the totals I was looking for. Thanks for your help... I have been working on this project for a while and I am simply just overlooking/overanalyzing...

That is what I am looking for. I don't have to use VBA I was just going that way. If I can get away with just making a query I will. In that case do I just set a query to total the FieldX and make the Criteria Box set to CriteriaField? In response to your first reply...Its not just that easy...