Hi Ling
Thanks for the feedback, I see where you are heading with this, but still I need further guidance, as the next level of design is still not quite evident to me:
Assuming separate tables, how do my calculations in queries decide which table to use? How is the decision made? Yes I know it must look at some or date criteria to make the decision, but I am not sure how to implement this?
Am I on the right track?
Mi...
MikeSA
Last Activity: Nov 16 '07, 08:33 PM
Joined: Dec 21 '06
Location:
-
Retaining quote/order info based on a previous price list
In Northwind, a price change populates through the database, changing historic quotes that should remain at the values when they were first created. How do I cater for different versions of updated price lists, so that older records retain there original information from the old price list, but new records assume the values of the new price list?
This I think is more of a principle question, that must have been asked before many times. IS... -
MikeSA replied to Add record in subdatasheet query dissapears when table added to relationship windowin AccessYes, my problem was that my query became non-updatable when I added a table to the query relationships window, and I did not know why.. but have since resolved my lack of understanding in this particular case..
Thanks!
MikeSA...Leave a comment:
-
Hi Luke
Thanks for the help, I will try to explain:
The Update Query updates the Orders Table VAT% Field from the Constants Table VATRate field if the check box VATable is ticked by the user.
The Constants Table contains the field VATRate, so that the VAT Rate can be changed in the table by the user, only having to change it in one place, using the update query to populate the changes throughout the rest of the...Leave a comment:
-
Hi Luke
I have an Orders Table with a field called VAT% that must be updated to a value held in a table called Constants, with one record only, containing a field called VATRate. In the Orders table I have a check box field (Yes/No) called VATable that is used as the criteria for the query to decide which records in Orders Table needs to be updated. This works successfully, update query works fine.
But on the Orders Form derived...Leave a comment:
-
Run update query if a check box is ticked
Hi
Probably an old question....
I'm trying to run an update query which needs to update files in a table if a check box is ticked.
Please advise.
Thanks!
MikeSA -
MikeSA started a topic Add record in subdatasheet query dissapears when table added to relationship windowin AccessAdd record in subdatasheet query dissapears when table added to relationship window
Hi All
I have a Orders query and a Order Details query both derived from their respective tables, of which the Order Details query then eventually becomes a sub-form of the Form Orders. Standard stuff as in Northwind..
Different to Northwind (and the source of my despair), I have defined a Constants Table to store data that can be updated by the user in one place. (eg. VATRate)
The Order Details query however loses the last 'add... -
Great Thanks! Works like a charm!
MikeSALeave a comment:
-
I have the same problem. Looking forward to a reply from someone who knows...
MikeSA...Leave a comment:
-
Thanks for the help, still a bit puzzling (Suppose I need to walk before I can run, still battling with some fundamentals..)
I have inserted the code below into the 'on open' field on the properties menu of the form named "Order Details":
...Code:Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) With Me.UserField.DefaultValue = Nz(UserID, "")Leave a comment:
-
Hi again,
How do I set the text box to this variable?
Me!UserField = UserID
Have I declared the variable in the right way? (See code below)
Please explain more explicitly in elaborate terms, still learning..
[CODE=vb]Option Compare Database
Public UserID As String
Private Declare Function apiGetUserName Lib "advapi32.d ll" Alias _
"GetUserNam eA"...Leave a comment:
-
Thanks Mac, now how do I insert the variable's value into a table field? My code so far is as follows (public variable you mentioned not declared as yet in this version, edit below):
...Code:Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name DimLeave a comment:
-
Another example is if I have a price list change, I want to keep the previous records reflecting the old pricing for example, and the new records to use the new pricing. In both examples, I need to store calculated values if I use a query as mentioned in the first example.(This I know is taboo!)...Leave a comment:
-
Storing computer username in field of a table
Hi
The idea is to record and store the computer user's ID in a record, so that I can track which user created or altered the record. Eg. A certain user creates a quotation in a table called 'Orders' and 'Order Detail', I want to know which computer user created the record.
Currently I use a query to calculate the TotalPrice from the Qty and Price and to retrieve the computer's username through VBA. But every time I run the query,... -
Hi Mary
below is a dump of the code from the query resulting in:
Records (rows) "Jan, Feb, March etc"
Fields (columns) totals for each month, field names sytarting with "Sum of..."
The report cumulatively adds the monthly totals. So the last month will shows the final total to date. This I have achieved successfully. All I need is to plot this report on a graph. When using the chart wizard, it does...Leave a comment:
-
Cumulative monthly totals in charts
Hi
Simple in Excel, appears difficult in Access. Posted a similar thread before, but cannot find it. All I want to do is create a chart that shows cumulative monthly totals.
I have pro(de)gressed to the point where I have a query in datasheet view that shows the month (rows) using 'Group by' property and the values in the columns/fields. Then created a form using "Running Sum...Leave a comment:
-
Okk ,it works, but how do I get the report to reflect monthly totals? Currently it gives me a cumulative total, but on a montyhly basis?
Mike...Leave a comment:
-
Cumulative monthly totals in charts
Hi
I a trying to create a chart that reflects monthly cumulative totals from a query.
The query fields show sales opportunities forecasted invoice date (OppForInvDate) , Opportunity Description and Estimated Value of the opportunity (OppEstVal). All I want is to chart, cumulatively for each month, the totals for the month?
Why is it so difficult, or is just me?
Mike -
Hi Mary
Yes I suppose I should print out of a report, but sometimes it is just nice to print exactly what is offered by the form in some cases. Am I breaking the rules?
I have the form open and press print, everything prints fine, only no data in the fields, whne printed..
Mike...Leave a comment:
-
Print query/table does not pull underlying data from the table
Hi
Probably simple, please help:
Printing a query does not pull through the underlying data from the table, or the calculation rsults in the query? Please some advice..
MikeSA
No activity results to display
Leave a comment: