Search results for query: *

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

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

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

I have a form that is used to save employee termination dates. I have another form that is used for promotions and job title changes. The current process forces a person to add the Termination Date..then open the other form and change the Job Title End Date. What I would like to do is this...

Hi all, I use the following code to add items to my table: Private Sub Command40_Click() On Error GoTo Err_Command40_Click Dim ctl As Control Dim varItm As Variant Dim myStr As String Dim strSQL As String Set ctl = DaysOffSelect For Each varItm In ctl.ItemsSelected myStr = myStr &...

I have a Form that has a button that opens another form which displays various promotions and blah blah.. I use this to open the form: Private Sub Command28_Click() On Error GoTo Err_Command28_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

Is there a way to check and see if you have Office Web Components installed on the PC?

I submitted this problem a while back and I had since moved to other projects and have now come back to this issue and thought since last time maybe the issue was unclear that I might clarify with som screenshots that might help get me a solution to this issue...I dont know any other way to...

I am using a combo box w/ this query: SELECT DISTINCT [ReceivedData].[Date] FROM ReceivedData; I amd using this box to seect a date for a report run using this: Private Sub Command14_Click() On Error GoTo Err_Command14_Click Dim stDocName As String stDocName = "AbanRateForForm...

Hey all, I have 4 textboxs on a form and if I accidentally bump my mouse wheel down it makes the text disappear in all my text boxes, then if I push the wheel up the text come back. Is there a way to not allow scrolling within a textbox? TIA

I posted this in the other topics section as well cuz im not sure where to really put it. Hope you dont mind.... Hey all..I have a Report that contains 2 SubReports. Within these SubReports there are 2 lists of numbers in % format using the following query expressions: Report1...

Hey all..I have a Report that contains 2 SubReports. Within these SubReports there are 2 lists of numbers in % format using the following query expressions: Report1: Format$(IIf([SumOfAban Aft Thresh]=0,0,([SumOfAban Aft Thresh]/[SumOfCalls Offered])),'Percent') AS [Aban Rate1] Report2...

Hi all, Im probably just drawing a blank here. Im hoping there is a way to do this. I have 2 queries w/ the following fields: Date Skillset Calls Ans AnsAft Thresh Answer Delay Talk Time Not Ready Site(Dont need this) Skillset Type Now heres what I want to do: I want to use the Date...

I have a few DAPs that I created but I really need to get the database and everything of my "local" drive and moved to the Network drive. However when I copy the .mdb and ALL the HTML files associated to the DAPs I open the DAP and the database connection is gone. I then have the DAP connect to...

I am using Access 2000 and have the most recent updates to my knowledge. The problem im having is that every time I try to create an ADP Access just locks up and I have to "end task". Am I missing some add-in or reference that might be causing this. I thought it might even be the .mdb but I even...