Search results

I asked what type the fields were, you did not answer that! And your query is a mess, you should pay attention to data types and not switch between data types! Look up the Format function in the documentation, before you create any more accidents by applying it :D I presume the fields in the...

LOL ... here we go again, so I won't even bother. There is something genetic about this apparently, so as Colin the Incorrigible said, it will just go on and on, while we the onlookers maintain our astonishment.

The late Chris O had made a drag-tables layout application using drag and drop, in sample databases or the code repository. http://www.access-programmers.co.uk/forums/showthread.php?t=221317 google him on this site - he made a number of posts on this subject

Yeah. Weekends are to be avoided.

No noooo, US society is by no means primitive or immature. Not at all. Not in the least. It just does its thing by its God-given rights, and all outsiders can just butt out. http://www.smh.com.au/world/oregon-shooting-274-days-and-294-mass-shootings-in-us-this-year-20151001-gjzl9c.html

Start over. Where? If [start] is a datetime field in the query then [start]-0.25 will give you datetimes 6 hours earlier. if start is a datetime then forget about all that format stuff Update: Show the SQL of the query and say what datatype each field is. Otherwise this will take ages to...

You want to export a stored query. So you need to change it dynamically. The way to do that is to use a querydef object (google it) and change the SQL of the query. There you can swap parts of the SQL concerning Order By with your Filter text. Your current method does not work: the field Order...

format([start]-0.25,"DD/MM/YYYY") is a string and not a date, so it will look for the first letters(digits it can match and that's it you need to use #, i.e. write #DateAsString# Second, SQL requires dates given as mm/dd/yyyy

I think you've confused yourself. Dates are stored in the same way, no matter what country or format. That has been explained to you in some other post. Format is "description for how to display a value" and is only concerned with how you look at dates, and when you do not input a Date...

EU is full of it! (and I am otherwise a supporter of EU)

One option: http://www.vbforums.com/showthread.php?639774-How-to-generate-a-fillable-PDF-from-an-Access-form

Your post is unclear how you make this query. Do you write SQL or do you use a QueryDef object to modify it or how exactly? How do you do this? Provide something solid to look at, i.e. examples, screenshots, not just stories.

So one of the multitude of posts on this subject you found using google or on this site is unclear where exactly?

Many shy away from bound forms because they feel they cannot control updates of the bound record, if they wish to discard data. Unfortunately a lot of incorrect information is floating around the web - these things are FULLY controllable, no matter what you might google. Attached is an example...

I do not disagree, but use the right measure for right purpose! The complex passwords and the thing kicking you out permanently after 3 tries are often used left right and center for no good reason at all.

Before you do this THINK! How important is this on some LAN? Will people use brute-force crackers? If so, then Access is not the right tool for you data!!! Otherwise, most of these "security"-measures are just idiotic attempts to show that the author (or, worse, the MANAGEMENT) are aware of...

Great story :D For anyone bothering, I can recommend a similar, but much much more twisted, short story by Ben Bova:

Too many people start suggesting wrong solutions (and do not read prior posts, since the cause has been found and was sloppy data management). No you do not need to convert a date control's contents to a string formatted according to mm/dd/yyyy. When you use fully qualified controls in SQL...

Hrmpf - do I really really need to eat my hat? Could you please attach a stripped down example? I'd like to play with this (but can first do so much later).

I think we are deep into some terminology confusion her. I do not see any subsub form. I see a subtable displayed in a subform (in the standard datasheet format, not in continuous format as per your claim). Show your claimed subsubform object in the design view. You must be able to do that so...