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 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
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 RelatedHello 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
anyone 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.
Hi,
Am not sure if its possible with access but have a hunch that it might not be something very difficult.
I have developed an access FE/BE application (in the network). The front-end users run query and view the results fine.
They copy (ctrl-C) the data from the query datasheet and paste (ctrl-V) it to Ms-Excel which I want to stop. Is there any way that I can stop/restrict them from copying the data and pasting it somewhere else. I want to stop this operation.
Thanks in advance.
Can someone tell me why this query is causing this error? I don't understand it:
UPDATE 1_2_06 SET ROLE = (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO)
WHERE EXISTS (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO);
thank you
I am trying to update rows in an access database by retrieving data from dynamic text boxes created through a loop. I keep getting the error message: System.Data.OleDb.OleDbException: Operation must use an updateable query. My code is as follows:
Dim myInsertQuery AsString
myInsertQuery = "INSERT INTO tblTestQues (Answer) Values ("txt" & loop1);"
Dim myCommand2 AsNew OleDbCommand(myInsertQuery)
myCommand2.Connection = MyConnection
MyConnection.Open()
myCommand2.ExecuteNonQuery()
myCommand2.Connection.Close()
Please help or contact me if you need more information. Thanks in advanced.
asp code:
Code:<%Set Con = Server.CreateObject("ADODB.Connection") Con.Open "db"dim username, password, mailusername = Request.form("username")password = Request.form("password")mail = Request.form("mail")sql= "INSERT INTO users(username) values('" & username & "')"Con.Execute sqlCon.closeset Con = nothing%>
error:
Code:Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query./site/content/register_act.asp, line 13
It's says it has something to do with permissions...
I set writing & reading permissions for the db and the directory that contains it through
contorl panel->Administrative Tools->Internet Information Services
I have no "security tab" when I rightclick->properties the db file or it's directory even though the file system is NTFS
in spite all these when I rightclick->properties the directory that contains the db I see a "read only" square marked in the general tab-attributes, when I try to unmark it seems to be unmarked but when I rightclick->properties again it's marked again...
what should I do?
The following search operation have to search some operation in the database, but there is a bug and I don't know why..
View 4 Replies View RelatedI'm beginning to lose the will to live over this one. I've been merrily developing a large application (ADP) in Access 2000 and 2003 over the past 5 years. The size of the ADP is now around 30MB and it contains the following quantities of objects:
23 modules
424 forms (409 with modules)
296 reports (284 with modules)
My problem is that whenever I use the decompile switch and then recompile I get the dreaded "The Save Operation Failed" message on saving the code and the whole ADP is then rendered corrupt. My only option is to create a new ADP and import each object type (Modules first, then forms then reports) separately, compiling as I go. This seems to work OK but when I open a file I've been working on in Access 2000 on an Access 2003 PC it seems to decompile it by itself and then won't compact/save. Does anyone have any ideas about this? I've searched Google and can't come up with any reasonable suggestions.
Environment: Front-end Access application developed in 2003, with back-end database in 2003. Being deployed in a mixed 2003/2007 environment. Users with Office 2007 will have to open and use the 2003 Access application without converting it to Access 2007.
Problem: When I take the Access 2003 application and open it with 2007, some forms give the following error message (whether selecting Open, Layout View, or Design View):
"There isn't enough memory to preform this operation, Please close unneeded programs and try the operation again."
The real problem is some of the most complex forms open in design view, and some of the simplest do not. There appears to be no ryhme or reason to it. Some of the forms are bound and some aren't. Some of the bound forms are bound at run-time with embedded SQL, some aren't. All query objects seems to be fine, when they are used on bound forms. Some forms have significant amounts of code behind them, some do not.
All report objects execute fine with no problems opening any view.
I can open the same file in Access 2003 and everything is fine. I've compacted and repaired the DB in Access 2003, no help when I go back to 2007.
Wondering if some references are off? But I have some really simple forms that can't be opened. I find nothing on MSDN on this.
I have subform where access lists orderitems(the main form contains the order info). The subform uses a query to lookup items thats in the orderlist. Everything works fine execpt when I change something in a dropdowncombo list in the orderlist sheet(like in sample northwind db) the I get "You cancelled the previous operation". The post IS changed and everything seems to work nice but why do I get this error?
The combo uses "SELECT DISTINCT Items.IDItem, Items.Item FROM Items;" as rowsource and also "ListedItems.IDItem" as controlsource.