Search results

So you are saying to create a query and only show the affilliated table id on the query along with any expressions that I would have. (ie do not repeat all of the fields in the query that are needed on the form. If this is correct how do i reference the query in VBA. Thanks

Hello, this may be a complicated question but I will try to make it as clear as possible. Currenly I have a form with [Generator Name] field which auto populates the [Generator EPA ID Number] Field through the use of an after update event procedure as below. These two fields are currently in the...

Thanks alot that worked. Kevin

Hi I think this may be an easy question for some of you that know SQL. I have the following expression in a query which strings togetehr on address format from different fields. As you can see I have a comma seperating the City and the St (State) like you see in typical address format. What i...

Can someone help me with this. I want to use a blank form with combo box of a list of plants to use as criteria for a query instead of creating multiple queries with different criteria in each. I have about 25-30 plants, so you can see the delema. I also want it to show up in report form...

When the form is not open it aks for Forms!a!BeginDate. When the form is open it works correctly. Also what did you mean by ammend both ends of "and"

Yes the date is in at table. but the perameters are coming from and unbound form. So you are saying put the name of the table that the date is coming from. OK.

yes but i am confused with your "name of table" field in your code

or should your "name of table " be name of query?

There is not table name though. The form that is used is unbound.??

Not sure what you mean my putting it in the begin date. -Basically the tables and query have a date field. -Currently I have (Between [Forms]![a]![BeginDate] And [Forms]![a]![EndDate]) set in the criteria field of the query. -I put a begin date and end date in the form and it runs the...

Is there a way other than doing sql. where you can use a macro to add text to a criterial field in a query?

Thanks for your input guys, Below is what i put in the query and referenced it to an unbound form. Between [Forms]![a]![BeginDate] And [Forms]![a]![EndDate] This works and I am ok with it, but i also have the need to see all data after I report for 2009. When the referenced form is not open or...

Thanks for your input guys, Below is what i put in the query and referenced it to an unbound form. Between [Forms]![a]![BeginDate] And [Forms]![a]![EndDate] This works and I am ok with it, but i also have the need to see all data after I report for 2009. When the referenced form is not open...

Hello, this posting was very helpful, although i do have one question. When you do not have the form open the query deafauls to ask for a begin date and end date. Is there a way to revise the expression to run in a way that when the form is not open or the fields are left blank, that all the...

Hi, hopefully someone could help me out with this. I have a database with multiple queries. Every year I need to go into each queary to pull reports for that year. Hence, I have to open each querey and enter "like */2009" into each date field. Is there a way that i can form a macro to somehow...

Hello everyone. I was wonderin if someone could help me. I was trying to put in multiple if functions into an excell spreadsheet and the cell would only accept 8 if functions. See below. I needed to put 12 in and the cell would not accept any more than 8. I read that it can take up to 64...

It is just easier for data entry when dealing with numbers. I would like to scroll to the next cell/field with both i possible. This would include using the up arrow to scroll up also. thanks

Can someone tell me how to make the down arrow go to the next field in my form. Currently I have to push the tab button. I assumed it would be in the tab order where it would give you an option to use the arrow instead but that is not the case. Thanks Kevin

it worked thanks