Search results for query: *

Are they going to be editing or just viewing?

You know its odd I never saw that.. THx ill just re-link them.

Yeah I tried that just linking to them and letting access name them however it them says cant find "MyTable1" when I try to query from it using the ODBC connection string. The one just called "MyTable" works fine.

I have 2 different databases both with the same table names for our 2 locations. I am linking to these tables in my access database I have to rename these tables in order to have them both linked in the database. Is there a way to make Access understand that the renamed tables real name is...

I have 2 databases that I am using linked tables to connect to. The problem is that the table names in both databases is the same. Hence I have named my linked tables as such: dbo_iAgentPerformanceStat_PHX (added _PHX) dbo_iAgentPerformanceStat_STP (added _STP) What I am trying to do is...

So I assume that design changes would be inclusive of anything new added as well or only on items that were currently existing?

Open databases using record level locking" I read the help file but im not sure what this means exactly. What im trying to do is set the database so that if im working in it and someone else opens one of the DAPs they dont get and error saying "The database has been in a state by BLAH that...

I am using a list box for our scheduling database in which the "Days Off" are selected for an employee. What happens is if for some reason nothing is selected you get an error saying: "Invalid call or procedure" What I would like to do is have a msgbox pop up if nothing is selected so the...

I have 2 tables with identical fields that I query from. I created a query to each table and then used a union query to stack the information. I then use that union query to sum up the information based on certain criteria. I then create a crosstab query from the summed query. This all works and...

I am still having this same issue however now I have select queries that its saying have no columns. Is there a reason why it assumes I have no columns in my query?

I am trying to create a DAP and I keep getting an error saying that the query has no columns..how can I fix this?

Is is possible to create a DAP from a crosstab query in Access 2000? It just tells me there are no colums when I try to create it. The TSI converter gives same result. Thanks.

That did the trick right there..Thx sir.

thx rjoubert...that works but its updating the first record..more efficient than actually having another query.

Let me get a bit more defined. I have a form that simply has an Employee ID#, and 2 text boxes. 1 for Transfer Date and the other for Termination Date. Since a person may transfer to another Department many times they appear on the table more than 1 time in many cases. When a person transfers to...

Can this be done? I have a text box that I would to update the Date in 3 fields in 3 different Tables. Basically if a person is Terminated or Resigns I want to simply put a date in the text box click a button and it change the Last Record for that employees termination date to the value in the...

I even screen shotted this post cuz I know im gonna do it again later hehe..thx again

Perfecto Mundo..Thx a million guys.

I am trying to get this statement to calculate based on 3 parameters: CallsAbandoned1: IIf([dbo_dApplicationStat_PHX].[Application]<>"DI_CF_App" Or "DI_IBank_App" Or...

Cool thx.