Hello All,
I have a call center and Im trying to work out a call que.
I have 8 operators.
10000 records that need to be called.
I'm trying to create a query that will select the first record avilable from my table. when the next operator has completed his call do the same thing and so on without duplication of efforts.
Any help would be appreciated
Rich1968
The database is to track and evaluate call center associate phone calls. I created yes/no fields for multiple common errors (accurate/complete, Security, and client experience. and under each are @ 20 common errors)
(the problem is that I did not create a seperate table for each main category which I think might have made things easier)
Now what I am trying to do is create a report that allows me to show (or select) an error and have it show all the associates that had that error in a given time frame.
I already have a report to show all associates and all the errors that each had in a certain time frame. (so vertically I have associate detail and horizontal I have error detail).
is there a way, without creating 25 separate reports, to show all associates under an error type?
I'm having to recode some old MS Access DBs so they will run in the following environments:
Office 2000 on WinXP
Office 2003 on WinXP
Office 2010 on WinXP
Office 2000 on Win7
Office 2003 on Win7
Office 2010 on Win7
When I wrote my code for Office 2000 on WinXP things were simple because directory paths were the same across all computers and I could hard code pathing when using a shell command to launch other files.
My new approach is to make a function call to the Windows registry to determine the default executable and path for opening a file based upon its extension (see apicFindExecutable in basWindows API module).
I'm able to use code to create a shell call and debug print it to the immediate window. If I put my cursor in the immediate window at the end of the shell call and hit [enter] the external file will open as desired. If I try to open the external file directly through code, I get a file not found error.
To recreate the error take the following steps:
(1) browse to files that are accessible from your computer
(2) click the PREPARE DATA AND OPEN MAIL MERGE DOCUMENTS command button
Shell function call is made by the fnOpenFile function located in the basOpenFile module. There has to be a trick here that I'm missing.
Why is it that auto center doesn't auto centre? Yes it centres horizontally - but not vertically. Does anyone know how to actually center horizontally and vertically i.e centre!? (I have used both spellings in order to appeal to a larger audience!)
View 4 Replies View RelatedWhen i make the maximized on opening by docmd.maximize, coud i get the form centered too?
right now im just adding form space on the leftside so it comes somewhere in the middle but if somone has a diffrent ressolution then it wont work as well.
I have quite a few forms and reports in a database that are pop-up and modal. I've also auto centered them so they do not jump all over the screen. However, these forms and reports are centering when you open them but move whenver you close them. I am hiding the database window, which usually means that it minimizes to the upper left corner of the desktop screen. These forms then wind up closing or relocating to where the minimized database window is. Is there any way to fix this problem so that the users see centered forms and reports every time they are using the program?:eek: Thank you
View 1 Replies View RelatedI am using the below code to centre a popup form, both horizontally and vertically. All my non-popup forms are 25cm wide. It looks weird that the popup forms appear on the centre of the screen, when the centre of the form is more towards the left. This is especially true in widescreens. How can I alter this code, so that the popup form appears on the centre (horizontally only) of the first 25cm of the screen.
25 cm = 9.8425 in = 14173 twips = 945 pixels
Code:
' API declarations:
#If Win64 Then
Private Declare PtrSafe Function apiGetClientRect Lib "user32" Alias "GetClientRect" (ByVal hwnd As Long, lpRect As typRect) As Long
Private Declare PtrSafe Function apiGetWindowRect Lib "user32" Alias "GetWindowRect" (ByVal hwnd As Long, lpRect As typRect) As Long
[code]....
I'm try to centre a logo image in the middle of email but I having issue doing it doesn't seem to matter what I try I can't seem to get it to do what I want . The code below works but doesn't centre the image
Code:
Dim txtLogoURL As String 'this is for your logo
txtLogoURL = "C:UsersDellPicturesoie_transparent.png"
strHTML = strHTML & "<p>"
strHTML = strHTML & "<a href=""http://www.testing.com/""><img border=""0"" src=" _
& txtLogoURL & "' align='Centre' width =200" & " alt=""testing"" /></a>"
I have created a report with the report wizard in Access 2007 that includes a check box. The check box is located under the label but to the far left side. How can I center the check box under the label?
View 10 Replies View RelatedI am running a report from a form that is to produce an excel output:
Private Sub cmdTransferToExcel_Click()
On Error GoTo Err_CmdTransferToExcel_Click
Refresh
DoCmd.Hourglass True
DoCmd.OutputTo acOutputQuery, "Temps_Margin_Output", acFormatXLS, [Forms]![Revenue_Output]![output], False
Exit_CmdTransferToExcel_Click:
DoCmd.Hourglass False
MsgBox "File Created", vbOKOnly
Exit Sub
Err_CmdTransferToExcel_Click:
MsgBox Err.Description
Resume Exit_CmdTransferToExcel_Click
End Sub
but receive an error "Invalid Operation"
Can anyone suggest anything?
Thanks
hello,
I have a table with "fieldA", "filedB", and "filedC". I want "fieldC" to be the result of multiplying "fieldA" and "filedB". How can I do this?? I don't want to have to type in the result in "fieldC", I want this to be done automatically when I fill up "fieldA" and "filedB."
thank you very much
I have a calculated query field that says this:
1 wk Wins: IIf(([1 week price]-[PRICE])/[PRICE]*100>=[s],1,0)
It prompt me for the variable [s] when I run it, as it should.
However, the results for whatever I type for [s] are not the same as the results if I just put the number in the query instead, ie:
1 wk Wins: IIf(([1 week price]-[PRICE])/[PRICE]*100>=5,1,0)
The above should return the same results as if I input 5 for the parameter prompt for [s], but they do not, and I cannot for the life of tell what Access is actually doing with the number I input for [s]. I cannot see a trend in its results from record to record, it just seems random.
Any thoughts on this appreciated.
thanks,
andrew
I have developed a MS-Access application for a small call-center (20 users).with approx 1500 customer-records to call everyday.
What I have done:
There are 20 front-ends residing at the Telecallers desktop and 1 database@server. Presently I am allocating 1500 records (clients send 1500 data everyday) everyday to 20 telecallers so that they get their respective calling details (75 records/telecaller). The no of cases that they need to call is predetermined.
They see cust-details and call up the customer manually.
What I intend to do:
I don’t want to allocate records to telecallers. Instead, when they open the FE-screen they will get the record that is available. (Of course keeping in mind that no particular record is opened by more than 1 telecaller).
Any help in this regard is highly appreciated. Any idea will encourage me to make the application more pro.
Say I have a table full of tasks. Some tasks are performed each day (Mon-Fri, Friday only, Saturday only, etc). Each day someone has to mark which tasks were not completed, and move those to another table (?). Each task may have small changes to it (length of time, who performs the task, etc.).
There is one person tracking these 350 tasks per day, which they run a report generated from another server that tells them what wasn't completed.
I would like form to be able to show what was completed for the day (by basically subtracting what wasn't completed), as well as for a range of days.
Most of this I can do, but the basic problem is how to generate a "daily" schedule, or a list that he can select what wasn't done? I thought about make a table of days from now until about 2010, and make a query with no relationship so that it assigns a date to each entry (which creates several hundred thousand lines), but that wouldn't do because there can be change that occur for that task for one day or several months.
How does one handle reoccurring events like this? I've gotten fairly good with Access over the past several months, and 90% of what I want to do is no problem, but this one problem, with scheduling, is something I've never been able to figure out. I really need this for 3 separate projects!
The closest I've come is using an append query that pulls a date from a control on a form with a button press, and adds to a list of tasks, but I feel there should be a more elegant (and foolproof) option.
Hello,
I was hoping someone on this forum might be able to help me.
I am trying to update a table with info in another table, using a nested query.
strSQL = "UPDATE tblTemp SET AdminNum = '" & cboAdmin.Text & "', " & _
"Size = (SELECT Size FROM tblEquipList WHERE AdminNum = '" & cboAdmin.Text & "')"
DoCmd.RunSQL strSQL
cboAdmin is a combo box on my form that is populated by tblEquipList.AdminNum.
When run this gives me:
Runtime Error '3073':
Operation must use an updateable query.
The SELECT statement works by itself, and the first part of the UPDATE (without the nested select) works by itself, but not when I combine them. I also need to update other things in the same manner in which Size is being updated, but when I can get this to work it shouldn't be a problem just added the updates for the other fields in there.
Thanks in advance,
Jeremiah
Edit:
Also, I figured I should add that when I remove the SELECT statment and put in a number (IE: Size = '400'), the query runs just fine. So I know the problem lies in the nesting, but am unsure how.
Hi, I've been progamming Access for a couple of years so am not a complete novice but I can't seem to work out this problem.
I downloaded some code from "databasedev.co.uk" from the query section called "Using a Microsoft Access listbox to pass criteria to a query". It works fine. However when I import my own table and change the code to SELECT the imported table and change the WHERE statement to my new string within that table , I get an error. When I select from the list box and click the command button I get the message "You canceled the previous operation".
However if I select the "ALL" selection from the list box it does return all the records.
Any help would be gratefully received!
JeffT
this is vexing me.
I have 4 tables, 2 entities, 1 relationship and 1 lookup
Entities are tblOrg and tblForm
Relationship is tblVentureParticipation
Lookup is tblInfo (Has many different lookups)
When an organization (these are listed in tblOrg) turns in a form, a new record is inserted into tblForm with the ID of that organization and the ID of the form
I want to identify the forms that have NOT been turned in.
So I figured
Step 1:
Identify all organizations who are participating (WHERE tblOrg.OrgID = tblVentureParticipation.OrgID)
Step 2:
Join all of the previously selected organizations with all of the forms (FROM tblOrg, tblInfo WHERE tblInfo.LookupID LIKE 'F##')
Step 3:
Remove all of the entries in tblForm that match the result of Step 2.
I have verified that both of these individual queries return the right information ...
I am asked to display this, "List the Client Numbers, Name, and Balance fields in the design grid. Sort the records in desending order by the Balance Field."
AND THIS: "Display the top 25%"
I need to know how to show the top "25%" when I press run, in the datasheet without manually having to arrange them.
I would love detailed instructions ASAP!
Hey all... I have three searchable fields in my query ATM if i search the MO, and the job code by themselves they don't error out. But if i try searching the FName field. It says "You have canceled the previous operation? Can someone help me with this
View 1 Replies View Relatedanyone know of a reason for this error: "The save operation failed"? I attempted to edit some code and tried to save but got this error. Also been getting some out of memory errors. Not sure why though. Thanks
View 1 Replies View RelatedI have tried to create a form page that when filled in by a user updates a database.
However i get his error messge
Code:Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query./tpvsite/RegisterUser.asp, line 62
In my page it aligns to this line objRS.Update. Which i think means there is a problem with my database as anyone any ideas how to fix this. (all my tables and fields are correct)
Cheers
I am trying to use to update the field in a record, What I am trying to achieve, is once I press/click the update button, cursor needs to move to next desire field which is "txteditcid", but after pressing the update button, I am getting following error (however, field is updating in table)
Run-time error '2110':
Microsoft Access can't move the focus to the control txteditcid
Code:
Private Sub Butupdatecustemail_Click()
Dim dbs As DAO.Database, update1 As String, rcount As Integer
Set dbs = CurrentDb
update1 = "UPDATE CustomerProfile set custemail='" & Me.txteditcustemail & "'" & "WHERE cid='" & Me.txteditcid & "'"
[code]...
I'm very confused with this "first" and "last" criteria
I can easily understand for "max" "min" "sum" etc ... but not the "first" and "last"
I import monthly data for the year 2013 and for each month I import, it will have a record showing 201301 (for january 2013), 201302 (for february 2013) etc... until today which is 201312
I import them in order that is: 201301 first till the last one which is 201312
Now is the Criteria "first" give me the date at which it is First entered in the table or just the first that he see in the table? ( can putting them in order either a->z or z<-a affect this criteria?) or what if I put import them not in order but randomly like?
When I used last it didn't give me 201312 but 201311...
I'm getting an error when trying to run a report. "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again."
1.) I tried to install both the V-Tools and Rick Fisher add-ins, and neither one could be added. I got errors from both.
2.) I'm working with a small test database to create a report. Db is tiny, 1.8Mb. But I've also created a report which has several embedded subreports. Everything is based off of queries which certainly have to sort through some data.
3.) I have compacted and repaired.
hi,
I'm having major problems with my database in that the database has lost all its functionality overnight!
If I click any button it gives me a message about indexes. (indexes1.jpg)
i cant seem to view any tables, queries etc in the database view! (BlankDB.jpg)
When i click a tab i get the message (invalid.jpg)
My understanding of Indexes is minimal so please help :(
Thanks
WHAT IS WRONG WITH THIS CODE:
Dim wsp As Workspace
Dim fInTrans As Boolean
On Error GoTo C4Err
fInTrans = False
Set wsp = DBEngine.Workspaces(0)
wsp.BeginTrans
fInTrans = True
DoCmd.OpenQuery "query1"
DoCmd.OpenQuery "query2"
DoCmd.OpenQuery "query3"
DoCmd.OpenQuery "query4"
wsp.CommitTrans
C4Exit:
Set wsp = Nothing
Exit Sub
C4Err:
MsgBox Err.Description
If fInTrans Then
wsp.Rollback
End If
Resume C4Exit
I WANT TO RUN 4 BIG APPEND QUERYS BUT IF USER PRESS ESCAPE BUTTON BEFORE ALL QUERYS ARE FINISHED - THEN ALL RECORD CHANGES MADE BY THOSE QUERYS MUST BE CANCELED.
SO I MADE THIS CODE. BUT IT DOES NOT WORK.