Search results

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

Hi, I have just watch a youtube video () where you can upload, manually, into Google maps from an excel spreadsheet that will flag a number places on Google maps. My question has anyone done this from MS Access. Maybe export the excel and run from there. Any ideas. Peter

Hi, Can someone explain what a TemplateFile as the last object in the Sendoject function is. If it can be used as the body of an email can you explain how to create and use it. Thanks Peter

Hi, Airdroid allows you to connect an android phone to your PC then you are able to send SMS (see attached image) and make calls using your PC. It also allow you to use your smart phone as a web cam. I've just found airdroid and it looks like a handy piece of software. In the past I have used...

Hi, Has anyone managed to use airdroid with access to call or send SMS? Thanks Peter

Hi Can anyone give me the vba code for getting google maps and earth (different buttons) in a browser from Street,suburb,state and post code fields. Thanks Peter

Hi, How do I hide a row field based on another field in the row. When the field has "Team Leader" I need to make visible and hide the [P] button on all the others. Thanks for any help. Peter Please see te

Hi, I have a report with one Grouping. When I insert a page break (Tried each of the group header, Group Footer and end page) I get an an extra page per group but it only shows the Header information not any data. It's a bit like the margins are to wide but have tested the theory. Any ideas Peter

HI, Thanks for the quick reply. 1. IDautomation does not appear to be free. 2. I had read the second posting and could not find the image control as mentioned. I place an image on the form changed the ControlSource to a text field but no image control? I must be missing something. Peter

Hi, Some years ago I found a addin? for ms access to produce data (255 chr) QR Codes but cannot find it now. Does anyone know what I mean or can help me to produce qr barcodes. Thanks Peter