I have 6 fields that display a price based on a combo box selection
I can get one to subtract from another but not all add up
It should also be a running total so it updates as I pick more options
And how can you get the combo baxes to start out blank they all have
selects already made when I open the form
I have an artwork book which I am cataloging. Each page of the book contains 24 pices of artwork. What I need to do is display a page number to whatever record number I enter into the field.
Example 2: I enter any record number from 1140 and the field will display 48 for the page the artwork is on in the book.
Example 2: I enter any record number from 1153 and the field will display 49 for the page the artwork is on in the book.
Example 3: I enter any record number from 457 to 480 and the field will display 20 for the page the artwork is on in the book.
I am a wiz at formulas in excel but am not sure yet how to make them work in access. I have a main form into which I put the date recieved of many items for each facility. Next to each of the dates I have entered I want to have a non inputable text block that will look at the date then do the necassary math automatically. Some of the formulas will also contain conditional statements based off of a date, type and rating. Can anyone suggest the best way to do this or point me toward a resource that explains how to use formulas in access. Here are a few examples of the formulas that are already in place in the excel version.
=IF(I28="Unsatisfactory",C28+60,(IF(F2="AA&E",C28+365,(IF(F2="Major Funds",C28+365,C28+1470))))) in the above formula C28 is a date entered by the user, otherwise most formulas I need to input are simply (date + 1 year or date + 4 years)
What the best way to perform math functions on data in a table? I have a form and a subdatasheet in it. I want to be able to: Average out data in cells. I.E One field will have a list of numbers and I want to be able to average those out.
The other is that i want to be able to check the previous cell(year) and see if the number has gone up or down?
I want to have a query that will subtract a Due Date from todays date and tell me how many days are left/passed in either a positive number or negative just like the DateDiff Function. how do i do this?
I have created a table that holds the inventory information of some items i have in stock. What I want to do is this:
1.)When a customer orders something, i enter the quantity ordered and hit a process button. When this button is clicked it automatically reduces my inventory count to reflect the reduction
2.)When I receive shipments, i want to enter the information and hit process so that it automatically sets my inventory counts to reflect the addition of the new units
I am having trouble figuring out how to go about doing this. I was thinking of somehow setting up some textfields and then adding buttons that set fields accordingly.
I have a table with some prices that are charged by the pound and some that are charged by each.
tblPrices ID 1 - 1.00 per pound ID 2 - 1.50 per pound ID 3 - 2.00 per pound ID 4 - 5.00 each ID 5 - 7.00 each
My form is set up so that way I count how many containers I have and their weight, separately. I need ID 1 through 3 to do the math based on the pounds (essentially $1 per pound at 36 pounds) and ID 4 and 5 to do math based on how many of each are there ($5 each, and there are 3 of them).
I am in desperate need of some advice. Today I set to work building some math functions in my queries to calculate delays/turnaround times for work, etc.
I have found that where there are null values in my table - the calculation seems to break down.
Let me explain...
In it's simplest form (I have removed some fields and will deal with DATE only, not TIME which is a seperate field) I have the following -
I am completely new to Access but probably all I will need is a gentle push in the right direction. I'd like to think I'm fairly quick at learning new things. Thank you in advance, here's where I am, (first step anyway):
Table 01 Parts List ID - name - cost
Table 02 Item List ID - nick name - description
Table 03 Items to parts relationship (this is where I fall apart) ID - Item ID (relationship to table 02) - Item nickname - PartID (relationship to Table 01) - Part name - Part quantity.
What I am trying to do: I resell items in table 02 which are built of various parts from table 01. I need to generate a table that says: Item 1 is built from 4 of part 1, 2 of part 2, 9 of part 3, and the total cost of parts for Item 1 is x. I want to update the parts list cost on a regular basis and have the item price change reflected.
If I can understand how to make this work, I can ultimately add in labor and overhead etc etc. Baby steps for now.
how to do anything with it outside of tables and queries. I have been tasked with creating a form to do fairly basic things. Via tutorials I have managed to use the Expression Builder to do virtually everything I need except one thing.
I need to pull a value from row 2 in a specific column from a subform and subtract it from row 1 in the same column and subform leaving behind a + or - number for the user. Similarly, I need to do the same but subtracting the LAST ROW from row 1. If there is only one row at the time the operation is being performed, a value of No Data needs to be returned instead of a number.
i am using access as a front end to SQL Server 2005 and link tables via ODBC.
Today when I run a query (normally works fine) I receive an ODBC Failed message box. I have tried opening each link table connected to the query and can open fine.
I have three cascading combo boxes that, when a selection is made, will auto-fill 3 following text fields. So I had it working just beautifully, with the data pulling from the correct columns. All of a sudden, they stopped working, and the text fields are displaying #Name? instead of the appropriate data. Nothing has changed on my form, and I have really been struggling to determine what happened and to fix it. Any help or suggestions would be welcome. Thanks.
I have a new user who is trying to connect wirelessly. I set up the ODBC connection on his laptop but when he tries to run a report that uses queries looking at linked tables he gets ODBC call failed. Is it because he is trying it wirelessly. I'm just the data guy so I don't know too much about networking.
I have a standalone Access DB with 4 linking tables therein. They all point to tables that are stored in a server Access DB. I can open 3 of these tables in datasheet view without any problem, except one. Whenever I try to open it, I am prompted following msg "ODBC call failed etc... server API error (#669) etc..." And when I click OK to close the Error msg box, then another msg box appears with the msg: "Microsoft Access can't open the table in Datasheet view"
I've deleted the link table and recreated it. But I still can't open the table in datasheet view. Does anyone knows what's to do? :confused:
Getting an error on the rst.Open statement of "Method 'Open' of object '_Recordset' failed"
I am using the same code that I have used before, just tweaked some. Earlier I had an error because the ActiveX control was not checked off for the ADODB connection.
Below is the code...any ideas? THANKS!
Dim Conn As ADODB.Connection Dim rst As New ADODB.Recordset Dim lg As String Dim frmOffset As String Dim tagnm As String Dim sql1 As String Set Conn = CurrentProject.Connection
frmOffset = "3. Offset Printing" lg = "PT" tagnm = "Label22" sql1 = "select translation from translation where lang=" & "'" & lg & "'" & "and formname=" & "'" & frmOffset & "'" & " and tagname=" & "'" & tagnm & "'"
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
I am running Access as a front end to SQL and maintain all reports and forms from a .mdb. I then release an .mde to a different location for end users to use.
Each time I release an .mde and a user attempts to run a report an "ODBC call failed" error appears. So I have to re-link tables on users pc's. The Users ODBC connections are set up the same as mine.
I am tyring to set up a query, that runs from a selected date range, to return only the records that don't meet the requirments. For example, I have four fields:
Name Date Attended Required
I want to start the query from a date range usesing Between [StartDate] And [EndDate]. There are mulitpule records containing the same date. Then from there I want to return only the Names that don't attend the required number of sessions.
Ex. Attended = 2; Required = 4; Return name Attended = 3; Required = 3; Don't return name
Would this be possible with one query? If so, how would I go about setting up the criteria. If not then how would i link the 2 queries together?
I'm using Open Form, and setting the Where condition to a Parameter called search, so that a pop up asked for search parameter from user. If there users search fails to get any matches, a blank form is returned.
Can anyone suggest a better way to achieve this, so I can include a message to say no data found??
This is all my click event reads thus far...
DoCmd.OpenForm "FindLesseeForm", acNormal, "", "[Lessee]![LesseeName] Like [Search]", acReadOnly, acNormal
I am facing a problem with ODBC call failed error latly.The problem doesnt occur on my development PC but only on other PC's.I'm a beginer in Access, vba and I cant find a solution to make it work on every machines.
Code:
Dim qSQL As String DATA = "#" & DatePart("m", DATA) & "/" & DatePart("d", DATA) & "/" & DatePart("yyyy", DATA) & "#" qSQL = "SELECT Sum([IL]*[TO])" & _ "FROM PUBLIC_S INNER JOIN PUBLIC_SD ON PUBLIC_S.U = PUBLIC_SD.U " & _ "WHERE (((PUBLIC_SD.DAT)=" & DAT & ") AND ((PUBLIC_SD.ANA)='" & ANA & "') AND ((PUBLIC_SD.IA)='" & ia & "') AND ((PUBLIC_SD.AN_C)='PIMSS')); Set Db = CurrentDb() Set rs1 = Db.OpenRecordset(qSQL)
I'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.
I have an ODBC connection to our company's data that uses Macola. I can enter criteria in the fields in Access to filter that data, but when I try to put a parameter query in such as [Enter order number:] I always get an "ODBC-call failed" message, error# 3146. Can I even solve this problem, or am I just not going to be able to actively change the criteria unless through a pivot chart or table, or by hand? Can anyone help? Thanks.