Search results

Just writing some queries for 500K + records with a various restrictions in the WHERE clause and was wondering if the order in which I restricted the data would have any affect on query performance. Is it better to place the broadest restriction first and then filter down form there or does it...

Here's a scenario I connect to BE SQL server with large tables and to avoid continuous hits to the server and reduce network traffic and most importantly keep the network guys off my back, pull records that are accessed frequently down to temp tables in a locally held access BE (ACCDB) which is...

Hi all using access 2010 32 bit and sql server 2012 Developer edition on win 7 I'm having an issue running pass-through queries to a StoredProcedures that wont show anything in a Money datatype column. All other columns are fine with data showing as it should be in Access but the Money column...

Hi all Using 2010 32 bit on win 7. I've been having an issue recently with forms not allowing changes to existing records or adding new records. These have previously worked for years and I haven't done any design changes in 12 months. Some forms are base on queries that are based on single...

Hi I need some help working out how I could join the results from a procedure together with a Sum from another table (perhaps it could that be done from within a single procedure?) This is what I have for the proc with variables CREATE PROC [dbo].[CASES] @Site varchar(100) = NULL ...

Hi, I think I've been at the keyboard for far to long. :eek: Could someone please show me the correct syntax for calling a public proc on a sub form call Forms!FrmNewOrderConnected!FrmNewOrderItemsConnected.Form!itmQuantity.AfterUpdate() I'm pretty sure I managed this in the distance past...

I've recently come across a problem whilst saving an edited record I get the following message but only sometimes Sometimes the record saves without a problem (mainly on the first edit). However, any further edits of the same record mainly but not always triggers the above message. I can't...

1) I have a query with mail merge fields (QryWordMerge) and a memo field in a Table holding copies of Word templates to be mail merged. The templates in the memo fields look like 2) I have textbox (DocContent) on a form (frmDocuments) which displays a pre-merge preview and was wondering what...

Using 2010 (accdb format) on windows 7 I'm trying to convert a memo field's format from Plain Text to Rich text. The problem is that every time I try to select the Rich Text format option the field immediately changes back to Plain Text. Just as a test a created a new memo field in the same...

Just looking for some reassurance here. I’ve been brushing out cobwebs in an old database which was getting quite full with queries, so I’m rebuilding building many of them on the fly as and when needed with QueryDefs, I recon I could replace many of the 180 or so queries with about 5 temp...

Hi, I can't seem to understand what's amiss here and would be grateful if someone could cast an eye over this and perhaps see what I can't. I'm getting two different results when using a select query with totals and DCount in vba when I thought I should get the same result. The query returns...

I’m using a secured 2K mdb as a backend and 2010 (accdb) as frontend and have a problem in that the FE doesn't recognise DoCmd.RunCommand acCmdUserAndGroupAccounts so users can’t change\reset their passwords or add new users to the workgroup. I thought about giving users another shortcut to...

I’m using the following custom ribbon for print previews on reports (no add-ins tab). However, if I use the /runtime switch at startup the Add-ins tab appears and I don’t understand why. I’m struggling with Ribbons as it is as I don’t fully know how they work, I got the code from someone else...

Hi Using 2010 32 bit I need to change the following form properties to false for a large number of forms and was wondering if anyone knew how to do this through code and iterate through all forms in the database. I have a bout 7 databases each with about 100 forms so want to avoid doing it...

Using 2010 32 bit I've created a custom ribbon that only opens on report print previews. However, I can't seem to get rid of the File tab on the ribbon which allows access to the backstage and the Privacy Options button which then allows access to various setting that I'd don't want users to...

Using 2010 32 bit This is driving me nuts. I've been Googling all day yesterday and best part of today and just can't find any reason why the below isn't working for me. I've place the code in the onopen even of a form but still the darn Ribbon's visible, showing the File and Home tabs...

Using 2010 32bit. I'm running the following code from the on open event of a startup form but noticed the check box's under Options->Client Setting don't 'uncheck'. This code worked fine in 2000, just can't work out how to do it in 2010, any ideas? Application.SetOption "Confirm Action...

I keep hitting this problem time and time again and it’s driving me to distraction. Here’s What I have: A continuous form with the RecordSource as a linked SQL table (QLTblHolidays ) that contains a date field (MyDate). Here’s what I want 1. The date displayed in British format e.g. 01/01/2011...

Wonder if someone would be kind enough to help me out here. How can I amend the following so to only select the profile with the lowest value, if a value exists? Select ProfileID, Name, Profile1, Profile2, Profile3, Profile4 from TblSample - Profiles are an integer between 1 - 9 -...

Hi, I'm drawing data for a report from SQL-Server via a pass-through query. The date fields are showing as yyyy/mm/dd whereas I need them to be displayed as dd/mm/yyyy. If using an ordinary select query know I could use something like; =Format([datefield],"dd/mm/yyyy"). However, there's no...