Search results

Looking at this..... It looks like you need a group by query. To show the data in the report, link the report to the query and then use the report functionality to show the totals.

Hi and welcome........ Hope these are of use to you. They are examples of combo boxes that someone emailed to me from this site. :) :)

Sorry, but I agree with Colin. Seperate the Patient information into two tables. Patient ID to link the tables. 1 showing the Main information like:- -Patient_ID -PatientNHSNumber -HospitalNumber -PatientPostcode the other showing the rest of the information as well as the -Patient_ID...

Cats and SubCats I work with Categories and SubCategories and these are usually in seperate tables. If you look at how EBAY works, You search for an item and it displays the item in various subcats, select the relevant subcat and you get just what you want.

You will need to run a new query to find the MaxofID and then the next field will be a calculation of NewID:[MaxofID]+1 This is then brought into your form.

Sorry to say this but it is very messy. The only way I have been able to sort this out is by doing a query to create a table and to show the MEMO field as text fields. IE MEMO Field is 700 characters, Text Field1 = 1st 255 characters, Text Field2 = 2nd 255 characters and so on. Then on the...

I have set the Repeat section to YES for the parent and child report. Set the Repeat to NO for the Parent Report. Leave the Child Report as is. Stuart :)

Welcome. Try reducing the size of the field on the detail part of the report and set the CAN GROW attribute to YES. This will then grow and shrink with the Text. Also, try setting the Keep Together to Yes.

Try having a look at the wizards for a new Database. Very helpful as they are already setup for you.

Also look at the Tools\Startup on the menu bar. Insert the Form you wish the users to view on startup.

This is from a form that I have used. You will need to use the Common Dialog box with it. Private Sub cmdBrowse_Click() Dim strMsg As String ' Disable all other command buttons cmdExit.Enabled = False btnClearNewFlags.Enabled = False cmdCalcMetric.Enabled = False 'cmdConvertPackSizes.Enabled =...

Why don't you do this in VBA and get the user to select the file that is to be brought in. This way the Macro will not have to be changed. Also, this is more user friendly than having to change a macro and then typing the file name incorrectly.

Sal, Glad to be of assistance. :D

Does the user enter a month at the start of the printing process. IE, how does the system know what month to print? If the Month is selected from a dropdown, then a field can be added to the Month Table to represent the 2 digits.

Try using the Instr() function. Create a Query to run a Report. In the query, have a new field that is something like this. iif(Instr([DOB],3,2)= [Enter Month in Digits],-1,0) This will then select the 3 & 4 digit of the Date Of Birth where the Month is equal to the Month that the user enters...

I've had something similar. I Repaired and compacted the database (both FE & Server) and relinked the tables. This then resolved the issue.

I have done this before and the best way that I have found was to import the spreadsheet into a temporary table and then update / append the information. You may also want to think about a delete function too as the client may wish to remove current records (unless history is required).

Replace ??????? Tried using a Replace function but want to do this in a Query not VBA. Is there not a way of just removing it through a query?

Join Properties Carly, Try changing the Join Properties on the second query to show All records from Table A (Main Data Table) and only those records from Table B (Table created in Query1) where the joined fields are equal. Then if you are selecting on the VENDOR CODE, bring in the Vendor...

I have been able to do this before, but I have forgotten how. We have a user that Constantly puts a CR at the beginning of the text in a memo field. Can this be stopped or even better, changed with a query before a report is run as it is causing serious problems with report printing...