Search results

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

Hi, Like the idea of combining the text box's on the report. There is always an easier way.

Hi, I have a solution that works for me and was limited to 5 fields but can increase of required. I created a table for selection of fields FieldDesc FieldName FieldType FieldSelectNo I then Created a popup where they place a 1 to 5 in the FieldSelectNo Using the dlookup on the FieldSelectno I...

Hi, SOLVER please see solution below. Can you help. I would like to be able to select any fields from a table to print on a report at time of printing. Was think of a popup with tick boxes but not to sure where to go from there. Peter

Hi, It's me again. I need to add a line feed in a string and write to a field. It works if I use msgbox but not when I write to the field. I have tried all the normal chr(10) and chr(13) and both together. I have the following code: If IsNull(Me.D1AM) Then Me.D1AM = DLookup("[Given]"...

Hi, I have an idea where I have a mobile number in a field and by double clicking it will connect to VOIP and make the phone call. Is this possible and if so how. I know that I will probably have to pay for the call. Regards Peter

Hi, Can anyone give me a idea of adding a help to fields. (by pressing function key?) I know there is a roll over but was thinking of having a table with help for each field and then use a dlookup, but am open to any suggestions Thanks Peter

Hi, Is there a quick code to send an Outlook meeting request via email. If you have it or can refer me I would appreciate it. Regards Peter

Hi, Once again can anyone help. I have a script and I would like to pause the script at DoCmd.OpenReport "R_CourseCard", acViewPreview until the preview has closed. I know I can add the extra script 'on close' on the report but would like it in the original script. Thanks Peter

Hi, Hope you can help. I have a field 'short text' with 'Thursday 10th October' Is there an easy way of converting to 10/10/2019 in date field with VBA Thanks for any help Peter

Hi, I am trying to copy text to clipboard. The only way I have seen is by using focus method Me!txtNotes.SetFocus DoCmd.RunCommand acCmdCopy is there a way of just copying some text ie "17856799" The reason is that our printer requires a code to print and I do not want to have to type the...

Hi, Double checked so thought I would go the whole hog and add Reports!Reportname!image.... worked like a charm. Thanks for you help. Peter