Search results

I want to update a table using multiple ID values from a table. The ID values are selected within a form and built up in a string for example 4, 5, 7, 10 etc. I want to know how to read these values into a query. Could anyone give me any advice on how to go about this? Any help is much appreciated.

I am planning to develop and application using a asp form that is used to record data from a user input. The input by the user will be used to calculate various calculations such as percentages etc and then add the results to an Access db table. I just wondering is this fairly easy to do using...

I have a macro within my access database that exports data to an excel worksheet and this works great. However i now want to add data to an "existing" excel worksheet ie one that already has data in it from a previous export from access. Can this be done, if so can anyone point me in the right...

I am having a problem with a command button within a form, the command button runs a query used to find a specific record in my database. The search works fine but before the results are displayed i get the following error "Error 3265: Item not found in this collection". Can anyone help me try...

I have created a form with a command button that has a query assigned to it to find a particular record (AdmissionNo) and this works fine. The query opens the table view instead of displaying the results in the form. I have done this for another form but i cant remember how i did it, is there a...

I am having trouble with a form the is used to view the records in a table. The problem is that two options in the view form are displaying incorrectly, i have two combo box options (hospital and ward) in a form called "Admission" both of these are used to populate the combo boxs for hospital...

I want to know if i have lots of code for eg If statements in the "form current" section of my code will this potential slow down the running of my form, or does it depend on the complexity of the code?

I have a form that includes to comboboxs populated form two table, the second combobox changes values depending on what has been selected from the first combobox, this is working fine. The problem im having is when i try to add a textbox and save the records, the records save by the textbox...

How do i format this date: Me.date = Now() To display only the date, not time etc

I would like to start and learn how to use sql server and im wondering if someone could point me in the right direction as to where to begin learning the basics etc

I need to join two dates from two tables, "Patient" and "Admission". I have Date from the "patient" table and a date from the "Admission" table and i want to calculate the number of days between the two dates, i think i need an inner join to join the two tables but im unsure how to do this. Can...

Im having a problem with a form when i open it in Add Mode, i get an error "Division by zero", the error points to the line below in Form_Current: "Me.Q_Total = (100 / [Opp_Total] * [Action_Total])" Can anyone help? My database is below:

I am having difficulty changing the format of a form textboxs to 1 decimal place, i have tried to change the decimal places option in the properties windows to 1 but its not formatting the textbox to reflect the change. Can anyone help?

Im having a problem adding two textboxes that contain calculation value to a table. The calculations are inside two textboxes called "Total" and "Action". The form i am working on is series of questions and i need to calculate an overall percentage based on the user inputs at the end of the form...

Sum IF NOT IsNull Help I have a formula for calculating value within a table field called Indication with the value "bef-pat": Sum(IIf(Not IsNull([Indication1]),1,0)) i want to add another field and to the formula, for example Sum(IIf(Not IsNull([Indication1] & [Indication2]),1,0)) I...

I have a form that has various fields with the field property required set to yes, i want to add validation that validates if a required field is equal to null for example If IsNull(.Required) then MsgBox "Required fields incomplete" End If I want one msg to check all the fields set to...

Im looking to add some validation to textboxs within a form ie if a textbox is empty/has not been completed output an error message. Can anyone provide me with an example of validation for this?

I want to disable the close form from saving/updating records in my database table when i close the form, i have tried setting the "Add Additions" setting in the form properties to "No" but it doesnt same to work, can anyone help?

I have an insert statement inside i command button ("Add") on a form and the code at present adds the values from two combo boxes populated from two tables (Hospital and Ward). The insert statement inserts the values into a table called "Admission", at the minute the combo box values for the...

I have created two combo boxs which are populated by value from two tables and i want to add a command button to be able to add these records to another table, can anyone help?