Search results

I have a form based on a select query (query does calculations as well). The query pulls from 2 linked tables, and it's not allowing me to add new records. On the form properties, I have "allow additions, allow deletions, allow edits, and data entry" set to yes. I've tried adding code to go...

Yes, it worked great! For others that may be reading this post, I want to include how I called the function, as I was unclear about this portion until I tried it in Access. I changed the code a little in that I called a query instead of a table. I want Expr2 in Query1 to be the median of...

Hello: I have read the Microsoft article at http://support.microsoft.com/kb/q95918/ several times. However, I am looking for an expression I can place in the field name to calcluate the median of another field in the same query. Is this possible? If not, I don't understand how to call the...

I sure will. This is my first attempt at subforms. Thanks for the advice.

Not sure exactly what I did. By your advice, I tried extending the size of the box and size of each area within the form (headers, details, footers, etc) and that did it. Thanks

Hello. I want to hide the scollbars on a subform. I selected "neither" for scroll bars under properties, and it works. However, the formatting is ugly. I have a blue background but get grey boxes where the scroll bars are supposed to be. Can I get rid of this and have the area blend in with...

Well, I think I figured out the problem. The problem turned out to be in other sections of my VBA code. I have DoCmd.OpenQuery("queryname") instead of CurrentDb.Execute("queryname"). When I use CurrentDb.Execute instead of DoCmd.OpenQuery, this makes the problem go away. You cannot use...

Hello. I am performing update and delete queries and don't want the user to see the alert messages indicating fields are about to be changed / deleted. I've tried using the SetWarnings command, but the alerts still appear. Any ideas? My current code is below. Thanks in advance dcnick...

Great. My database isn't large, so I couldn't tell a difference in time...thanks for the info.

pbaldy - I've tried it with both DoCmd and CurrentDb.Execute, and they both work. Can you explain the difference and why one is preferred over the other? Thanks

That fixed it. Thanks so much!

Hello. I am setting up a button on a form to delete all records from a table and refresh the form. I have set up a delete query to do so. If I run the query by itself, it deletes all records in the table as intended. However, if I call the query from the form, it deletes all but one record...

I guess I meant to say [ID number] is already a field in my crosstab query, however it is not a row or column HEADING. Therefore, when I try to create the report, [ID number] is not an option in the "Sorting and Grouping" box. The crosstab query works great and the rows print in the correct...

I used the same approach [ID number] to sort my crosstab query. Problem is, this sort order is not carrying over to my report. Since [ID number] is not a row or column in my crosstab query, it is not an option in "Sorting and Grouping." Is this possible? Thanks in advance

That did it. I am obviuosly still a beginner when it comes to Access programming and forget to utilize the Relationships screen. Thanks for your help :cool:

The Plan # is already saved as another field in the database. For required reports, I also need to store the corresponding description. Plan # and Description are "corporate visions" that will be tied to multiple Projects in the database. So, fields in my base table, tblProjects, include...

I am trying to use a combo box to store a value in a table from a form. The combo box shows the following: Plan # Plan Description I used the combo box wizard to store Plan Description in my table tblPlan.PlanDescription, and I set Bound Column to 1. However, it stores Plan # instead of Plan...

Not strange at all. Your response answered my question and it works perfectly. THANKS