Search results

Hi all, I have never used the Name statement before and I want to rename some filenames to match the path/filename stored in the db. The format is Name oldname As newname Myset.MoveFirst Do Until Myset.EOF TableName = Myset![Picture] FolderName = "C:\Access Files\OurGardenPics\" &...

OK Chaps, and Chapesses I have a form with an underlying table containg many records. Just lately, I was thinking of adding a couple of new fields which exist only once in a table with two fields. These fields contain the dates when an action needs to be triggered, which are generated, but not...

Hi, For many years I have been using the following code to search plant names on Google. Today, it's stopped working and hangs the database. Dim strURL As String, Tempstr As String Tempstr = Forms!MainOptions!MainView!LatinName Tempstr = Replace(Tempstr, " ", "+") strURL =...

Hi All, Interesting problem today. I have a continuous form which shows a few main fields together with an image. On a button in each record I have the following code - Dim TempID As Integer Forms!MainOptions!ID = Me!ID TempID = DLookup("[ID]", "MainTable", "[LatinName]= " & Chr$(34) &...

I have my database which has a button to onclick a link to a site with search parameters - Dim strURL As String, Tempstr As String Tempstr = Forms!MainOptions!MainView!LatinName Tempstr = Replace(Tempstr, " ", "+") strURL = "https://www.google.co.uk/search?hl=en&q=" & Tempstr...

I would welcome suggestions on the subject of economy, and efficiency, of field-use and VBA coding. I have a gardening db which is recording all relevant data about plants in my garden. It has gone well over the years and, with some help from other members of the forum, is improving year on...

Hi All, Access 2010 My problem is - In VBA on my main form, I use the line - Call Me.Command117_Click, to execute the action of the Command117 button. It works fine. On a new form - In VBA, I've used the same method with - Call Me.Command248_Click, to execute the action of the Command248...

Hi all, Does anybody know a way to create a new form and move all the objects and code from one form with all its parameters and make a copy in a new blank form? I have an existing problem which appears to be only on the db's main form. I have so far - decompiled, recompiled, compressed and...

Hi all, I have a VBA search string, called searchstr, which looks through all records for a key word. It works fine. The string uses all 'Or ' as in: Searchstr = "[LatinName] Like "*plant*" or [CommonName] Like "*plant*" or [Plantedin] Like "*plant*" or [PlantDesc] Like "*plant*" or [HardyRef]...

OK, so I'm stuck. I have my database project (retirement pastime) using 2010 version and it's been fine through many years of development. However, in the last week or so, I've had the odd crash, when the db just closes with no warning. It always happens when I'm in Form View and...

Hi code-writers I have a piece of code to use Application.FollowHyperlink strURL command, where strURL is the search word(s) entered by the user. It works well but not as I hoped. At the moment, the code opens Google search page and enters the search words into the searchbox. What I would like...

I have a form with 3 buttons that select 3 views of the data - All data, Archived data and Live data in a subform view. A pop-up form is used for detailed searches but only searches on all of the data. As the existing view on the main form could be any one of the 3 main form button options, I...

Hi All, I have a main form which contains 2 bound controls showing height and spread. Beside each of these is a button which opens a pop-up form ('Measures') and the value of the corresponding bound control (height or spread' in inches)is sent to an unbound control on the pop-up form. So far...

Hi guys, I have a main form that has two subforms, PlantList & MainView - the list shows the Latin Plant names and MainView shows data associated with the Latin name. Clicking on the list name will show the info in the other. I use an unbound field [ID] on the main form as link for the 2...

Has anybody else experienced a problem with aligning/moving/nudging controls using the arrow keys? I've noticed that the control may not move until an arrow is held down for several seconds, after which time the control suddenly moves off beyond the desired alignment required. It also may...

Hi all, I have a form with an embedded google webpage which is opened when a user selects a button on the mainview page to obtain more info on the selected item. It all works well except for the assembly of the searchstr, which I can do manually but not in VBA...yet. So, I have a string...

Hi All, I have a form with 2 subforms. The Form is the 'shell' which holds all the general operations like, opening other pop-up forms for info, search buttons and search fields, Quit button etc. The first subform (PlantList) holds the PrimaryID, LatinName and CommonName from the main table on...

Hi All, I retired from work many years ago when I used to create databases (in MS Access) for a local uni. I vowed never to do any more Access. Until now. I thought I might create a small database to hold the plant details in my garden and include searches and prompts for garden tasks based...