adigga1
Last Activity: Oct 2 '09, 02:45 PM
Joined: Feb 28 '08
Location:
-
Thanks ssnaik84 for the response, we will look into it -
Choice of a Database System
Hello everyone,
I am in the process of designing a business system (Database System) for a relatively large organization.
This system must be able to enter data, apply conditions and formulas, perform datamining and data warehousing, to name a few of its functions;
It has to be in a location or structure whereby 300+ users can access and operate in its environ. seamlessly without much bandwith or slow... -
Thank you again for all of your time, patience and assistance with this issue.
It works perfectly!!!! :-)
Regards,
A.......Leave a comment:
-
ChipR, Thanks again for the edit; it works great; but I have one other question:
I now recieve this message " You are about to append 1 row(s)" confirmation message; I press "yes" then the code runs fine after that.
how to stop this message from showing? just run the code?
Thanks again
A......Leave a comment:
-
Thank you ChipR for your response and suggestion; i will give this a shot and give status update.
Thanks again
A......Leave a comment:
-
the data type is text or would you like me to check other attributes?...Leave a comment:
-
ERROR: "enter parameter value"
Hello EveryOne,
I have a situation with a Form running an event; It works fine when it calls or manipulates number values; but when I put a character within the numbers or use alpha-numeric values, I get this error "enter parameter value" when i press my click action button with the alphanumeric value as the problem..
Please assist, I searched the entire forum and the net for answers, but nothin.
... -
HOW Do I: use Coding to Get a Value from 1 Table...
Hello,
Are there any codes or commands that can look up and get a value in 1 table using a combo box on a Form then pass it and save to another table after it has been selected?
Thanks in advance
A... -
Form Issue
Hello Again,
Earlier I posted a copy of my Database for help in solving a Form issue,
the advice I got helped alot and I got the Form to Function with A Single Table,(Patient -Case 2) But someone told me to Normalize and Split the Tables in two,(Patient -Case 3) so I did but I'm having a very had time duplicating the Form operations as the previous one with the Single Table. I would like to go with the Patient -Case 3 in order... -
Form Irregularities
Hello Experts,
Here is my issue:
I am attempting to attach a sample of the database to better illustrate my current challenges;
This challenge originates from the Form (F_PatientCase)-
1. Whenever I enter an Acct Num or donor Num on the MainForm and attempt to manipulate entries in the SubForm, a series of "bugs" occur:
a. I get an error: 'Field cannot be updated'... -
Thanks for the reply Overcomer;
Thats the issue that I'm having, That code is the query that the subform in question is built from, the subform wasnt built directly from the tables.
Thanks...Leave a comment:
-
Please Help: Subform entries are updating in Souce Tables
Good Day Experts,
I have an issue dealing with a subform operation whereby, each time I select the value field of the subform, that same value is then placed into the source table as a new record:
I do not want this to occur! What I want is for the subform to just reference the data contained in the source table and only be reflected in the Query that I had set up where my subform was created and runs from. ... -
mandanarchi,
Thank you for your suggestion; I will try this code and follow-up with the results.
Adigga1
It ran Successfully!! Thank youLeave a comment:
-
RunTime error: 3075 - Dlookup Issue
Hello Experts,
I'm about to go grey with this dlookup statement:
I'm trying to run a dlookup statement, I have the correct expression string, etc. but when I run it under the Immediate window for testing I'm getting the runtime error.
Scanerio:
I'm calling an associated Price value (Currency) for a Code (text) from a Query in order to have an auto population in the fields; here is the code:... -
Yes, that is correct, I've been attempting to get this to work for weeks.
regards,
adigga1...Leave a comment:
-
Trying to create a FORM / SUBform
Hello,
I am running into an issue whereby, I'm attempting to create a form using a combo box selection (CPTcode). Once I make this selection the Charge price should auto populate accordingly. I'm having a very hard time accomplishing this.
I m trying to build the form from a query; The SQL code is as follows:
[PHP]SELECT T_Ccpt.CptNum, T_Ccpt.Charge, T_Ccpt.Physicia nName, T_Ccpt.CPTcode
... -
Thank you very much coolsti ,
As a novice to this art, I appreciate the level of descriptive detail and time allocated to my challenge.
I will utilize and test this technique and post the results.
Again, thank you for your patience.
Adigga1Leave a comment:
-
thank you and I apologize for the incorrect formatting;
What I'm attempting to establish is a condition i suppose whereby, when a particular TaxID is selected that represents ECC the corresponding ECC CPT table is referenced where i have to option to select the CPT code and price from that table.
I have all of the Physicians and TaxID; CPT and Prices loaded in their respective tables and fields.
I am...Leave a comment:
-
Receiving Syntax Error using "OR" command
Hello,
I am attempting to call a particular table if the OR statement is used. When I try it gives me a Syntax error. Please assist?
Here is the code:
[code=sql]
SELECT T_Physicians.Ta xID, T_ECCcpt.CPTcod e, T_ECCcpt.Charge , *
FROM T_Physicians, T_ECCcpt
WHERE (((T_Physicians .TaxID)="58-229xxxx"))
OR
SELECT T_Physicians.Ta xID, T_SibleyCpt.CPT code, T_SibleyCpt.Cha rge,... -
INNER JOINS: how to create??
Hello everyone,
Here is the scanario:
Tables:
T_Physicians
fields: (pk)TaxID, PhysicianName
T_ServiceCodes (I have 3 of these tables)
fields: (pk)Servicecode , ServiceName, Price
Mission:
Associate each TaxID to each ServiceCode, mind you, each Physician have their own Service codes that they bill.
Should I build a Query with a Criteria...
No activity results to display
Leave a comment: