...example I could have 2 crab cakes, 2 pecan encrusted groupers, and 2 flounders on one ticket. I need a quantity total for each item. Then I need a ticket total with tax.
I cannot do an update query, since it says the expression I defined Price: [Qty] *[Price] is not updateable.
Any...
...new tables where the servers can enter the food items from a form and have it do a quantity total (i.e., for example 2 bowls of she crab soup is 2*4.95 for a quantity total of $9.90). Then I want to add the whole ticket up and add tax. Then I want this total to go into the restaurant sales...
I followed your advice. Unfortunately, I cannot run Hijack This. Everytime I run it, Windows encounters an error and shuts the application down.
Spyguard keeps telling me that my homepage has changed.
Help!!!
My home page has been hijacked and the default internet home page just says about blank, but I cannot change it back. I am also being inundated with popups.
PCCillian from Trend keeps telling me that I have the troj_uploader.f virus, and I keep quarentining it, yet I still keep getting it...
I have a Dell 4600 with the graphics built into the motherboard. Can I buy a graphics card that supports dual monitors and install it? Or is this not possible since the graphics are built into the mb?
I have an extra 17" flat screen and I want to use it.
Here are the specs for my computer...
Okay, this is what I have:
in the cboAccountNumber I have in the Row Source:
SELECT tblClientInfo.intAClntAcct, tblClientInfo.chrLastName, tblClientInfo.idsSSN FROM tblClientInfo ;
This displays all the information in the drop down box, however, it only returns the client number...
Now what if I want to show the last name, first name, and social security number in the list box. Sometimes your beneficiaries will have the same last name.
After I select the beneficiary, I want it to update in the life insurance table, to name that person as the beneficiary for that policy#.
Okay this is what I have:
cboAccountNumber combo box
The Row Source is:
SELECT tblClientInfo.intAClntAcct, tblClientInfo.chrLastName, tblClientInfo.idsSSN FROM tblClientInfo ORDER BY tblClientInfo.chrLastName;
The After_Update Event Procedure is:
Private Sub cboAccountNumber_AfterUpdate()...
Okay, I created a form with 2 combo boxes: cboAccountNumber & cboBeneficiary and 1 list box, lstBeneficiaries.
The row source for cboAccountNumber is:
SELECT [tblClientInfo].[intAClntAcct], [tblClientInfo].[chrLastName] FROM [tblClientInfo] ORDER BY [chrLastName];
In the combo box...
This is what I have:
tblClientInfo:
chrFirstName
chrLastName
idsSSN (this is a primary key)
intAClntAcct (this is a primary key)
tblLifeInsurance:
idsInsurPolicy# (this is a primary key)
fidsAClntAcct (this is a lookup where the row source is:SELECT [tblClientInfo].[intAClntAcct]...
Thanks for the quick reply. I actually have not built the form yet. I have just done it in the actual table. Where is the AfterUpdate?
I am sorry, I don't have much programming experience.
Thanks for your help Frink.
I am trying to create a form where the user will select an account number for a life insurance policy. When that is selected, I want a list box with choices for a beneficiary to be limited to a query that filters the beneficiaries table and displays only beneficiaries that are tied to that...
I agree, but access to this machine will be primarily at night after the store has closed.
He has nitwits who work for him and won't remember to log the computer off (while simultaneously not turning the computer off) so that he could RDP in.
We are doing the same thing, except our sites are 2 miles apart. We are using wireless radio and we get a whopping throughput of 45Mbps.
All of our phone lines are at one location and we are using data and voice over the same wireless connection.
We use 3COM NBX 100 phones. Now I just need...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.