servantofone
Joined: Apr 9 '08
Location:
-
I will post something when I get to work. Thanks for the response. -
Set Visibility of Controls on Access Report in onOpen
I'm running Access 2010, and I'm trying to set the visibility of a field when a report opens. The field is not affected by each individual record in the report, but rather by a value in a table that is not the source of the report.
What I'm trying to do is get the value when the report opens, and then set the visibility of a few controls based on that value.
I've been trying to use the OnOpen event and the OnLoad event,... -
Well, it apperas it was related to the fact that I was changing the form's font at runtime... So the issue is solved.Leave a comment:
-
Ok, my runtime results are as follows:
Width changes from 73 at design time to 97 at runtime.
X position changes from 40 at design time to 53 at runtimeLeave a comment:
-
VB.NET Form looks different at runtime
I'm designing a rather specific form in VB.Net 2008 Professional Edition for my company per a PDF file I have been provided.
I just noticed that everything seems to shift at runtime... The change is drastic enough that the blank space is displeasing to the eye and doesn't match my predefined form.
Does anyone know what's going on? Shouldn't the runtime view look the same as the design view I'm creating? If I move labels... -
Thanks puppydogbuddy. I searched through google and didn't find much. I guess I should have thought about the Microsoft forums.
Appreciate it.Leave a comment:
-
Linked Table to Sharepoint List - SLOW
I have a couple tables linked to Sharepoint Lists. All queries on these tables run very slowly. Is there a faster way to access these tables? I'm afraid my users will give up and End Task the Access database (never a good thing) while it is still running update and delete queries. Not sure if anyone knows a way to streamline the process, for instance, can I delete any of the columns that Sharepoint automatically adds to each table? Is it faster... -
Thanks so much for the answer. Are you aware of any hosting services and/or purchasable software packages that do this? Is there a name for it that I could google?
I enjoy tinkering around in areas above my head, so I will look into what you said. However, if there is a software solution that currently exists, I may purchase it. I hate the idea of having to update the news page manually every time someone has something to add....Leave a comment:
-
Post Email to News on Church website?
Does anyone know of a service that would allow my Pastor to send an email that is automatically posted on the news section of the church website? I know blogging sites allow bloggers to send emails that are automatically posted, but I want to implement it into the actual church webpage. Anyone have any ideas or heard of something that would allow this?
Thanks! -
My apologies. I didn't realize I had migrated away from the article. I guess Chris Fehily is on his own with his claim. Every other SQL book I read agrees with you.
-Kyle...Leave a comment:
-
It sounds like the footer option should work. Use an equals sign before the AVG function in the textbox. If your query is already set to group by the fields you are filtering for, the only thing you are missing is your Average Percentage....Leave a comment:
-
This article is incorrect. SQL doesn't stand for "Structured Query Language". Its official name is Database Lanugage SQL. SQL isn't an acronym. See page XV of SQL by Chris Fehily (ISBN 0321334175).
-KyleLeave a comment:
-
It just occurred to me that I might have misunderstood your question. Do you want to show a Total Average for all Departments on the report, but only list the individual departments that were filtered? If this is the case, create a second query that totals the percent of all departments (regardless of the parameters chosen), and then use a DLOOKUP to grab the Total Percentage from the new query. The other query can operate as you have it, only...Leave a comment:
-
Add the Avg([Percentage]) to the report footer of your report in a textbox. This will solve your problems.
As far as dynamic reports go, I haven't tried it. This article looks like it might be of assistance to you and has the database examples for download at the bottom of the page.
** Link removed as per site rules - Please check **
-KyleLeave a comment:
-
Suddenly my whole world makes more sense. The first three digits of the date indicate how many years PAST 1900 the year is. I never saw that until now!
Thanks for helping me clean this up! This eliminates a serious amount of function calls. You two are the best.
-Kyle...Leave a comment:
-
This is very clever. Thanks for your help. Each field is either null or a date. So I can just evaluate it using an IsNull and if it returns False, use this statement.
Thank you.
-Kyle...Leave a comment:
-
Date Conversion from Format YYYMMDD
I have dates in the format of YYYMMDD that I would like to convert into an actual date. The first digit indicates that the date is after 2000 if it is a 1 and prior to 2000 if it is a 0. So for instance: 1011023 = 10/23/2001.
I can convert it using the following statement in an Access query:
...Code:newDate: IIf(Val(Nz([ARN-CREATE-DATE1]))>0,CDate(Mid([ARN-CREATE-DATE1],4,2) & "/" & Mid([ARN-CREATE-DATE1],6,2)
-
NeoPa,
I'm not using any code. I'm right-clicking in the database window, selecting import for the menu, and then choosing a file that has Exec within the filename. This causes Access to generate the error prior to the wizard popping up.
-KyleLeave a comment:
-
Just tried that... and Access imports it correctly. It only occurrs when the file is named Exec with a space after it. I have never experienced anything like this before. You can import the CSV file into Excel with the first filename, but Access will not. Well, I guess it doesn't really matter... I'll just use a different filename. Thanks for the info!Leave a comment:
-
Invalid SQL statement stemming from filename
I have a file named:
Exec MIS Report.csv
When I attempt to import this into Access 2003, I recieve an error , "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'."
I renamed the file to:
Executive MIS Report.csv
And now the file imports without a hitch. Is Exec a reserved word? Is Exec part of SQL?
Thank you!
-...
No activity results to display
Leave a comment: