Search results

If I build an access database that uses data access pages, are all users required to have a copy of the MS Access software, or does the database run strictly off of the browser?

Thanks! The second option works great! I guess simply is always better.

I am having some trouble with the code below: Const strSQLWhere As String = "SELECT [LIV_HR_AppraisalLeadershipDetail].[idRating] " & _ "FROM [LIV_HR_AppraisalLeadershipDetail] " & _ "WHERE...

:) Wheres the link?

Now that you've convinced me that an autonumber is required, I've added it to my table as the primary key. Now what do I do?

I understand what you are saying, but I am not sure how I might be able to accomplish what you are suggesting. The way it is currently set up, I really just need to know the difference between end times and start times on records pertaining to the same date and press #. Is it possible?

Thanks for getting back to me! Is there a place online for me to check out some sample code? I would like to hard code it into the db so that my users are all able to use it. Thanks!

I currently have a table with the following fields: dtmDate intPress intCycle intProgram intLot ysnAxial dtmFStart dtmFFinish dtmPStart dtmPFinish dtmDStart dtmDFinish How might I go about querying the difference between dtmDFinish and dtmFStart for multiple records? EX...

I currently have my database set up with links to an ODBC Data Source. Is it possible to write a connection string to link the table without requiring that the user have an odbc data source set up? Thanks for your input!

I am accessing an oracle database that has several thousand records in it. I am quering for specific requirements, but would like to save my query results in a local access database for faster searching capabilities. Is there a way for me to set up a query that will go out to my oracle table...

I have a database that I am using to report metrics based on seasonally available data. What I am running into is the problem that the seasonally entered data doesn't start on the same date every year. An example: I have data that was entered into my database last year starting July 26...

When I get the error, the debugger does not specify a line of code that is related to the error. What I am running into is this: Access exports the data into power point and then gives me the error message. I am able to click ok to eliminate the error message and open the power point file to...

One thing that I am also running into when I export the data to a power point presentation is that I am getting the error message "Object doesn't support this property or method." Any ideas on what may be causing this? I used the code generated from the link associated with Microsoft on this...

duh! don't know why i didn't think of that.. thanks!

horizontal goal line

I currently have a crosstab query that compares data for two years. The results look like this. month 2004 2005 January 98% 95% ..... Decemeber 98 What I am getting at is that the query returns null values for the fields that do not have data recorded for the...

You are awesome! That helps so much! I just have one more question. Is there any way for the graph to include a "goal" line? Currently with the vb that you showed me, I am only able to set up a set of bar graphs. Any ideas would be greatly appreciated. Thanks for your help!

Is there a way for me to export my report/Chart to a powerpoint document? I have seen other articles on the forum but they only refer to later version of access. I am running access 97.

I guess the data that i provided was not representative of what I am attempting to accomplish. The grouping is actually supposed to read Saturday August 5, 2000, Saturday August 12, 2000, ...

I've done a search on week ending in the reports forum and am having some trouble finding a solution to my problem. I have a report set up that groups by week, and it pulls the first date in the week grouping as the header for that week. What I am having trouble figuring out is how to make it...