Search results for query: *

I know there have been threads on this before, but none have actually hit on what I would like to do. Instead of disabling/enabling the "AllowBypassKey", is there any way to alter the bypass key to be something like SHIFT+ENTER+E?

Does anyone know how to run a query in another database? I.e. vba code in database1 runs query in database2.

I am trying to write some code in VBA, but when i specify a DAO.Recordset, i get a type mismatch. Does anyone know how to get Access 2000 to automatically reference DAO?

Does anybody know how to change the fill/back color of a Access Graph legend that has been created using VBA?

Does anyone know how to create a dynamic subform? I have 3 queries that bring back different information. There is an option box to select what you want to see. i.e. Qry 1: Date, # of Records Qry 2: Date, FailType1, Failtype2, Failtype3 Qry 3: Date, FailType, Cost What I would like to do...

Does anyone know how to change the Y axis on a graph from "Percent" to "Number" using VB? I have only been able to find how to change the min & max scales using VB, nothing on changing the axis type.

I have created a username table in my database based on a network login. I have created VBA code that is supposed to look up the login ID in a table, but it's not working properly. Can anyone give me a code that will look up the "Environ("Username") and compare it with a table...

I have a problem with changing colours on a combobox field in a form based on a value. If am using Access 97, so it doesn't have the "conditional formatting" tool. To make it simple, here is the scenario. I have 3 records, each one with an Identifier and a combobox field. The...

I am wondering if you can change the control source of a graph through vb code and if so, how? Thanks.

Does anybody know if it is possible to link an MS Access query to a MS Word table that will update when the query changes?

Does anyone know the syntax to query for data between 3 months ago and 1 month ago, ie. >=DateAdd(&quot;m&quot;,-3,Date()) And <=DateAdd(&quot;m&quot;,-1,Date()) or Between DateAdd(&quot;m&quot;,-3,Date()) And DateAdd(&quot;m&quot;,-1,Date()) I've tried both, and neither works. Can you use...

How do I get a list box in a form to create records in a table based on multiple selections in a list box? i.e. - Field: list box: area Field: text box: date Three areas selected plus one date to create 3 records in a table: North 03/22/2002 South 03/22/2002 East 03/22/2002 I'm...

I'm having trouble getting the right syntax for a &quot;like&quot; criteria that needs to get information from a text box from a form. The syntax I've tried is: Like &quot;*&quot; & ([Forms]![fLocCd]![txtLocCd]) & &quot;*&quot; Like '& [Forms]![fLocCd]![txtLocCd]& ' Like...