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

Thanks to you both for the sample and the suggestions. They have been very helpful. I CAN decipher the spreadsheet in the first place, so I am going to try the Recordset operations to immediately import it. I haven't used TransferSpreadsheet before but I will figure it out.

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

Thanks everyone. I am going to try to learn RegExp which I don;t think will be easy, but I will give it a go. I will also try the code offered by all of you as well. I will use a copy of the data so I don't screw up the live database.

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

Thanks plog. I am reading up now and I will give it a go once I have finished.

Thank you so much. This is great and I understand it. YOu are a gem JHB

I have attached the customer table with 2 records and the relevant fields in an excel spreadsheet. The ID type fields are number - long integer and the notes field is the memo field. I have a tbale for contacts with date, time, note1 and note2 text fields rather than memo fields to store the...

Thanks JHB, but I do not know how to do what you are advising me to do. I don't know how to use a recordset to loop through the table to find each piece of the notes data between the <Div> and </div> text. Split function in my version of access seems to be about splitting the database so there...

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

Thanks for this. I will speak to my service support team and see what we can do to fix this. Appreciate your help.

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

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

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

Thanks DavidAtWork. I really appreciate it. Your suggestion worked perfectly and I have learnt something new.

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

HI again Warren, I figured out what I was doing wrong. The As Date was part of it. The other part was me having a blonde moment. I had a typo in the query and had mis-spelled the DATEADDW function. Doh! Thanks.

Hi Warrne, I added As Date and I still get the same message. Thanks for trying to help though. Must be something else.