Search results

Hello Everyone, I have an ergent issue with a totals column whereby the following occurs: When my script perform a tally using currencies then placing a subtracted amount in a separate column, it produces inconsistent results. Please refer to the attached image: 1. when my script tallies...

Hello everyone, I have a problem with adding a formula on a report in order to calulate the Total of a client's "charges" (field name). Can someone assist me in this area: what formula or condition can I input into the design view of the report to Sum or Total the "charges" field of the...

:(Hello everyone, I have a completed MS Access database , it was created in Access 2003 cleared and operates in an Access 2007 environment. The database was working great; entering data in forms, retrieving data, run reports, etc. All of a sudden, a user was handed the database now it has...

Hello everyone, I have a slight issue I, I have a Total charge field = $100.50 and i am looking to subtract = $50.50 And present the remaining total in field Surplus = $50.00 unfortunately the following code I have running is returning $100.50; $50.50 and $50.50 respectively. How do I...

Hello everyone, We are planning to covert an existing access database to accommodate 300+ users; we are looking at using SQL server as the backbone but are unsure of the Front-end for the users: -Some may be accessing the database from outside the intra-network, should we go with a .net...

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...

:confused: 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...

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 A...

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...

Hello everyone, I am using Access '03 and I have included a copy of my database with test data included. The Issue: I have a Form (F_Payments), and my control field is the Case MRN:. What I'm trying to accomplish is this; When I select a Case MRN from the drop down, I want to be able to...

Hello Everyone, I am almost complete with my Database project but have a few bugs to iron out. I need some fresh eyes to pinpoint some areas where I may have overlooked. This main bugs originates from the Form (F_PatientCase) with Subform: a. I get an error each time I attempt to update...

Hello Experts, Here is my issue: I have attached 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...

:eek: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...

Good Day everyone, I have a subform operating within a MainForm, the issue I am having is this: The Subform has functioning auto population capabilities using Dlookup codes, but when I advance the Account on the MainForm, the contents of the SubForm of the previous Record (Account on the Main...

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...

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...

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: SELECT T_Physicians.TaxID, T_ECCcpt.CPTcode, T_ECCcpt.Charge, * FROM T_Physicians, T_ECCcpt WHERE (((T_Physicians.TaxID)="58-229xxxx")) OR...

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...

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...