Search results
-
V
slow group by in query
in the following query when I just run the inside query, it runs instantaneously. I get about 19,000 records. When I run the query grouping the data, it takes about 9 seconds.:mad: Can someone please let me know why it's so slow and how I can make it faster. SELECT year, event_id... -
V
passing parameters to chart on report
I've already figured this out. Thanks -
V
passing parameters to chart on report
This is my 1st access report and I'd appreciate any help. From a report menu, I open the report which opens a form and prompts for report parameters: date range and state. On this report I have a graph which works off a query and works fine without parameters. I added a where clause to the query... -
V
ms 2010 security
I'm trying to find some documentation on how to set up the security and so far I'm getting nowhere. I need to be able to have users logon with an id and password. I can build a user table and logon form, but does ms have anything in Manage Users & Permissions area that I can use? If I build the... -
V
control group yes/no defaulting to no when no default set
I have a form with control groups for yes/no answers. They wanted separate boxes for the y/n. I set no default on these since we want to force them to click on a yes or no. Yet when I open the form and add a new record, they all default to No. How can I get the form to show nothing in both the... -
V
in form move block of fields together
Found it & it worked! Thanks a lot :) -
V
in form move block of fields together
I'm in version 2010. In the Arrange tab, I do not see anything labeled Control Layout group or a group button. How can I find them? Thanks much -
V
in form move block of fields together
I have a form with lots of boxes and controls. I want to be able to move a block of them together to a different position so that I don't have to realign them all again. I can select them by clicking on each with the control key down, but when I drag, only 1 box moves. Help would be much... -
V
form NOT to update table automatically
That seems to have worked! Thanks a lot! -
V
form NOT to update table automatically
That worked to stay on the record. Thank you. But now when I do try and save a record with my Save Record button, it says "no current record". Do you know what I need to do now? Thanks much:confused: -
V
form NOT to update table automatically
My users do not want the record saved until they've looked at the data & hit a save or cancel button. I've been researching this & found this code to stop the update (I'll work on code updates after I figure this out): Private Sub Form_BeforeUpdate(Cancel As Integer) Cancel = True... -
V
problem in form with field whose value calcualted in query
I have a form, frmTests, that updates table A. I need to display a field that is a calculation of 4 fields in table A with them being multiplied by values in table B. I wrote a query that calculates this field. It will work correctly if I select 1 record from table A. I think I have the where... -
V
get value from combo box, save in variable, pass it to query
I figured out what my problem was. Thanks for leading me there.:) -
V
get value from combo box, save in variable, pass it to query
This is what I've done & it's still not working the way I want. Code in combo box named EventSelect: SELECT Event.Event_ID, (Event.Event_ID & " " & Event.Organization) AS EventDisplay FROM Event union select 0,'0 All Events' from Event ORDER BY Event.Event_ID; (works fine in box)... -
V
get value from combo box, save in variable, pass it to query
I'm new to access. I need to update a mini system. I can't find where or how to capture the value they selected in combo box. I see I can use something like ComboName.selected, but wherever I've put it hasn't done anything or given me an error. After getting that value, they want to be able to...