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?

Lonnie, the answer you gave me worked great!!! Thanks so much. I'll post it below for others to benefit from. The only thing people should keep in mind is that if you are using a front-end, back-end application, this code must be written to the back-end. Here's the code: Public Function...

So far I've had no success in getting these methods to work. Any more suggestions? I'd greatly appreciate it.

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

Thank you for helping. DAO was not on the list of options, but it did have a browse button in order for me to append the .dll file to add DAO. Thanks.

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?

It's probably a trendline. You can add or delete trendline lines using the following code: GraphObj.SeriesCollection(1).Trendlines.Add GraphObj.SeriesCollection(1).Trendlines(1).Type = 1 GraphObj.SeriesCollection(1).Trendlines(1).Delete

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...

If your subform is based on a query, you can use the [VenID] in your query. When this field changes, you requery the subform in code and it will bring back your data. On an &quot;AfterUpdate&quot; of the [VenID] field: <subformname>.requery This will update your subform.

Does anyone know how to change the Y axis on a graph from &quot;Percent&quot; to &quot;Number&quot; 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 &quot;Environ(&quot;Username&quot;) and compare it with a table...

Unless the &quot;select case&quot; part is different than an &quot;If..elseif&quot; statement, this does not work. What happens is all of the comboboxes in the continuous form turn the colour you've selected, regardless of the value in subsequent records. The &quot;conditional formatting&quot...

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 &quot;conditional formatting&quot; tool. To make it simple, here is the scenario. I have 3 records, each one with an Identifier and a combobox field. The...

I have a problem with this also. To make it simple, here is the scenario. I have 3 records, each one with an Identifier and a combobox field. The combobox options are Yes, No, NA. When showing these fields on a continuous form, how would I be able to have record #1 combobox field show red...

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?

Yes, it was already selected and the query still isn't returning the proper data.

I tried it and it doesn't work. I'll copy a piece of my sql: ((Format([FIN_DATE],&quot;mmmm yyyy&quot;)) Between DateAdd(&quot;m&quot;,-3,Date()) And DateAdd(&quot;m&quot;,-1,Date())) I get 0 records, and there should be some.

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...