Search results

Hi, I have had a strange request for a database I am writing. We have a string field for a phone number so we can keep the '0' at the beginning of a mobile number. However some people are adding land lines with words such as 'ext' etc. My question can I search for alpha in an alpha string so I...

Thanks all for your help. I have fixed it at the source.

Hi, Can you help. I currently have two tables one that I need to update and has 4000 records and another table with 60 records that has data I need to update the first table. I currently loop thu the first table and dlookup on the second and if found update the record. To do this I need to loop...

Hi, I have an issue with the DoCmd.TransferSpreadsheet acImport command. One of the import fields is a phone number which has all kinds of numbers such as 03 87698076, N/A, as well as mobile 6756434546 (majority). It appears it read the data as numeric and drops all data that is not numeric or...

Hi, Thanks for your reply. Your idea is a good one will test tomorrow. Off the 15 fields only 5 are required for massaging the data. I can check these 5 fields to see if they have been changed. Of all the other fields only 6-7 are required for display purposes. Peter

Hi, Once I wrote this I had an idea that worked. Import the spreadsheet and read the table field names from there. Peter

Hi, I have an issue where I need to import an excel sheet and then query the table. However they keep changing the headings of the spreadsheet and I then need to change my vba code. I was thinking if I could read the first line of the spreadsheet (which has the field names), then use this...

Thanks for your help.

Hi, Still trying to work out connecting ms access front end to sql back end. Seems I need to add an sql connection to my win10 pc. When I go there there are 3 options. (see attached) Can you tell me which one is best to use or are they used for different applications? Thanks Peter

Hi, I am thinking of splitting my ms access so I have a ms access front end and sql on the back end, is this possible, and if so can anyone direct me to a youtube or web that explain how to do it in simple terms. I have my own hosting and know my way around it. Thanks for amy help. Peter

Hi, I have another issue for you. I am importing an excel spreadsheet into a table. The issue is that in the first 2 rows of the spreadsheet they have merged some columns and rows so I cannot use them as headings. However in the access table they appear a two rows. What I need to know is there a...

Good luck Doc_Man

Hi, Another alternative is that you ask on this forum for someone to help you as a 'one on one' via video link. There are a number of retires (like my self) etc that would be only to happy to give you time. Peter

Hi, I hear and understand what you are saying but I am thinking that this is a cloud based DB with only a few people will access when I have given them permission. My plan is to get a free 2gig onedrive ,whatever, and just use that as I can give permission to an actual folder. Peter

Hi, I have been using Accessworld for sometime and thought I would introduce my self. I started using Borland database many many years ago and then switched to Access. I have worked in the IT world all my life and are now retired. Looking back I think I started using database because I think I...

Hi, I am after some advice. I am writing an ms access database for a charity, not to complicated or many users (5 at most), my question is I want to put it online and want some advice on my options. I plan to just move the database to a cloud storage and give access to the users, or should I...

Hi, Thanks for your help. Worked like a charm. I think I was over complicating the issue. Peter

Hi, Thanks for the reply. I must be missing something or making it complected. | I believe that there are 2 questions to ask. 1. Who the student is and 2. who else attended, as the student has attended a number of courses during the period. If I create a query with a student number I will only...

Hi, I have written a database for a local community house that run courses for locals. I now need to account for convid19 in that if someone has attended a course I need to be able to identify all the people they came in contact with. I have attached a database with the 3 main table to give an...

Hi, I have just discovered you can upload an excel spreadsheet with multiple addresses to Google maps and it will flag each address. I can export the data from Access but does anyone know how to automate uploading to Google maps. Peter