Search results

Just bumping this

I know this is an old thread, but I have used the code in this thread to lock down my 2007 database. The problem I have now is as follows 1. The database opens by calling a form. As an event "On Open", I run the vba code of DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.ShowToolbar "Menu Bar"...

Thanks for that. It worked. Greatly appreciated

Galaxiom I added you expression to the criteria but got the following after entering the dates "the expression is typed incorrectly, or is too complicated to be evaulated" Any other clues?

Here is the SQL ( I use the design window) of the main query SELECT qry_KevinN_Logistics_report.add_date, qry_KevinN_Logistics_report.scale_ticket_id, qry_KevinN_Logistics_report.plc_id, qry_KevinN_Logistics_report.ship_date, qry_KevinN_Logistics_report.vendor_id...

1. I understand adding time could and should resolve this.How would you add the time to only those records where there is no time. Remeber the original value is a is a Date/Time type field 2. Making suer add Time component to the user input criteria - Users are not that clever!

I am using MS access via OBDC to a DB. A column in a table contains dates, however they are in the format DD/MM/YYYY and DD/MM/YYYY HH:MM:SS. I have a query (main) that calls other queries (sub), and the Main query requires the user to input a From and To date. The results of the query...