Search results

I have database of referrals for patients receiving psychological services from various providers. Three main tables are referrals, patients and sessions linked by the referral number (rid). Some psychologists delay sending in data so as new data is provided, the session number needs to...

Hi everyone, We have multiple invoices in an excel format that has been setup like a document with an invoice header and then invoice line items and totals. We have hundreds of these that have to be imported to an existing access database. At the moment people are manually entering the...

Memo field is called [Notes] and data is like this... 5/05/14 - Perry was on another call. LM 2/05/14 - Perry only at centre in the mornings, need to speak to him before sending samples. 13/06/13 - Perry in a meeting. lm 30/05/13 - See Little Hampton Early Learning - s/w Perry, has already...

I have a notes field in the customer table that is a memo field. An example of one customer's notes field data : <div>20.3.14 Ordered 2 cartons</div> <div>4.3.14 Ordered 2 cartons</div> <div>18.2.14 ordered 1 carton</div> <div>30.1.14 ordered 3 cartons SCENTED wipes</div> <div>14.1.14 ordered...

I have two combo boxes in the form header and command buttons in the form detail. The combos allow the user to select either a customer or a prospect, then the command buttons open forms that only show records pertaining to the customer or prospect selected. Combos are "4Custcbo" and...

Is there a way I can take each entry in a memo field and put it into a text field in a separate table. The database is getting really big and the customer notes field for each record has lots of entries. The memo field looks like this: 8.4.14 Ordered 2 cartons 20.3.14 Ordered 2 cartons 4.3.14...

We have an Access 2010 database that is accessed by some users from another location. Each user has their own copy of the front end. For some reason two users in our Sydney office enter orders, but after they have entered and saved the order, sometimes for no apparent reason they get an "invalid...

I have an "order details" table that needs to populate a field called "Voucher" with data from another table called "codes". The "codes" table also has a true/false field called "allocated" because once allocated the code cannot be re-used. I am trying to work out how to automatically...

I have a sales sytem in Access 2010. New customers have to be imported to MYOB daily. I have a query that finds new customers and appends them to a table for importing at a later stage. I export the records in that table if the field "imported" is set to false. The results are exported to...

I hope someone can help me. This module is giving me the "undefined function" error message when I try to run my query. I don't know why, but I have checked that there are no references with "missing" and there are not. I also added the word "Public" to the function becasue that was advised...

I have an order form that auto-populates details from the customer table into adderss and contact controls. But I don't want it to auto-populate when the underlying order table already has data in the related fields. I am a complete novice so I am sure the answer will eb simple. Here is the...

I have a form with 3 controls boudn to the following fields: DPBatchNumber - textbox where the company batch details are recorded. SupplierBatchNumber - textbox where the supplier's batch info is recorded SupplierBatch - query control where either the DPBatchNumber or the SupplierBatchNumber...

I have something wrong in my code. I want the cursor to be positioned at the control "SupplierBatch" after the message box alerts the user that they need to enter the supplier batch details. The code works as I expeceted except that the cursor go to the next control on the form istead of...

I am a novice and learning update queries for a document register I have at work. Can someone tell me how to update the records in a hyperlink field to remove the last character ONLY. I imported data from another source and the hyperlink has an extra "\" at the end of each record that I...

I am a novice with MS Access, so I need all the help I can get. I have a main form with several checkboxes and I would like the subform to change based upon which checkbox the user checks. I have 3 different subforms and I would like them only to be displayed once the user has checked the...