Search results

In the form below, I have manage to set the format of a row where the accession number is 0 to this yukky green. How do I undo this. I have tried highlighting the columns with "Ctrl" in the layout view and was able to fix the "JPG Image" column but can't go any further. There are separate...

That was it. Thank you. John

Once again I thank you for your response. I had the statements all there, just didn't think to put them in a function and call that from a query. John

try these.

Yes, but how does that happen? There are no controls on the form and the screen shots are from design to open with nothing in between.

I have a very simple little form with two buttons. The little button is the home of the progress bar. The trouble is the size of this form seems to be controlled by the size of the frame in design view. Regardless of the size I make the form. it displays as the size of the design frame. See the...

I have a continuous form where the field "Notes" is reliant on the results of a few tests done on other fields. All of the test need to be done on each record as the form loads. These tests include checking for no data in a field, dcount a list for duplicate entries and comparing the entries in...

My original code was missing the "HAVING" clause and this was causing it not to run but was also creating no error message. My original code. Public Function getCollSearch() As String sQry = "SELECT herbarium_collection.Collector " & _ "FROM Herbarium_Collection " & _...

First, an apology. I posted the wrong function code. By aggregate in the SELECT statement I assume you mean DISTINCT. I've tried this and there is no return from the functions. The first of the two images below show the result of modifying the code as you suggested. The second is the result...

When the blue button is pressed, the "Family" value is set to "" which, in turn, sets all the other controls to ""

<Why are you using ANSI92 SQL syntax? Is there any benefit?> What is that and what is the alternative? My knowledge of SQL is very limited. Thank you for your reply David. As for your suggestion, nothing worked. In the "getMColl" function, which was working, using "DISTINCT" and "WHERE"...

I have a series of functions that return sql strings as variable rowsources depending on requirements. For the most part these functions perform as expected except for one that refuses to work, "getCollSearch". see the code below. When replaced by a query with the same sql the control performs...

I use an external drive for for developing and it had only just been connected to the laptop for the first time when this happened. I have since had it disconnected and on re-connection all is good. Access being consistently inconsistent. Thank you for the reply. John

Hi Doc_Man. I'm having a similar problem on a laptop in develop mode with no one else connected and open shared. Deleting the laccdb file says unable to deleted because the file is open in Access. The file was closed and Access closed. retry with the same message if I try to modify code or a...

Thank you for your offer of help and, in particular, for recognising that it is my application to manage. John

Tell me what field names need to be clarified and I'm happy to do that. I have added 60 or so records to the database. Bear in mind that not all fields are used in every record and some are rarely used but required for consistency, none the less. It does seem, however, that nobody listens to...

I've been away for a while so apologies for the slow response. Attached is a sample of one of the tables. I have included some data from the beginning and end of the table. NOTE. I have changed my email address to segref23@gmail.com.

Plog. Firstly, normalised, or not. Separate tables, or not. It is what it is and will remain that way as it is the way I was instructed to do it. I understand normalisation and how it works and if you're a purist you will go to any lengths to accomplish this. There are, however, many ways to...

It seems wrong but the sub is called "ssetSources" not "GetSources". It is as it should be. sTable is a private variable with form scope.

Point of interest here. I replaced the "HAVING" clauses to "WHERE" and nothing works, changed them back again and it's all good. John