Search results

Normally I'd suggest a subform but since “Not in Area” is a possibility I think you maybe stuck with a DLookUp and Nz to handle the null case. So you could try something like: Sub GetArea() Me.NameOfAreaTextBox = Nz(DLookup("[Area]", "[FS_Area’ table]", "[AddresFieldName] =...

If the locations are randomly distributed maybe some gain could be achieved by dividing the problem up let's say in quarters. You could find the borders of the region by getting the maximums and minimums of the longitudes and latitudes add them and divide by 2 to get these new borders. You...

I did a test similar to the one JDraw did. I put the zip codes for the state of California in a table name ZipCodesCA (2666 records) and the rest in a table named ZipCodesAll (42049 records) and ran the following query: SELECT ZipCodesAll.zip_code, ZipCodesCA.zip_code, ZipCodesAll.latitude...

With that many records a cross product of them certainly wouldn't be a good solution. I suggest narrowing the result by adding a join between the tables that basically implement's Jdraw's box idea. This would be just to narrow it down ruffly. You would follow this query with another one that...

I think you want Me.cb_samples.ListIndex = Me.OpenArgs instead of Me!cb_samples.ItemData (Me.OpenArgs)

With the method used in the database I posted you can filter on the date range, the Option Group, both or neither at any time.

Both distance functions in the database I posted take less than 1 millisecond to execute as measured with this function Public Declare Function GetClock Lib "winmm.dll" Alias "timeGetTime" () As Long So whether or not you will have to narrow down the number of records with a faster expression...

Just put <3 in the criteria for the distance. I've updated the query in the attached database with that and also put in the code from Jdraw's link. You can see that for your distances either would work fine.

I think you want to combine these filters. The way you have it one will overwrite the other. I've attached a database that demonstrates how the values of multiple controls (in this case text boxes) are combined together to form a single filter. I think you should be able to adapt this to...

A simple way of setting this up is demonstrated in the attached database where a cross product of the two tables is formed in qryLocationCrossProduct. The cross product is just the tables in the query without a join which results in the permutation of the entries of both tables. The distance...

I suggest googling "determine if a point is within a circle" and after you've found the equations you like create a function that given the four coordinates gives you a Yes or No.

Maybe: filename1 = "D:" & Replace(Me.txtd,"/", "_") & "_queryname.xlsx" the replace function would replace the slashes with underscores.

I've always found it irritating that Access opens all of the modules. If you are only working with one then as missingling said it should be the one on top and as long as the code window is maximized no problem. However if you need to work with more than one after a while it can get confusing...

This mean anything to you?

If you don't keep the plain text then you won't be able to tell the users what their passwords were if they forget. But if you keep the plain text then there's not much point in having the hashed version.

I tried that with my regional settings set to United Kingdom in the attached database and I didn't get a syntax error. However I then changed the date/time from Now() to a textbox that defaults to Now() so I could test other dates. 3/22/2017 or 22/03/2017 will be entered correctly; however, a...

I just got some work rehabbing a PHP/MYSQL Web site so regretfully I won't be able to contribute much on the AWF for a couple of months. I suggest you post this question in a new thread so that it gets more attention from other forum members. Good luck on your project.

That was post #6. We are way past that now.

To remove a line click on it to select it. It will get slightly thicker when selected. Then just press the delete key or you can right click on the line and click Delete. To add a line just click on one of the field names in the join, hold the left mouse button down and drag to the other...

First I suggest you make the text format of the LessonLearned field the same in the table, form and report. A Rich Text format will allow some formatting whereas the Text Format is just text. I think you have the report field set to text format as I was seeing HTML tags. I don't understand...