Search results

This is bizarre behavior if I've ever seen it. Any input on how I can repair this issue would be appreciated. I have a database that is linked to a MYSQL database. When I open the database, I can see the data from my database and view reports. However, when another user opens the database...

I have a Single Form(frmSequenceTemplates) that contains a Continuous Sub-Form(frmSelect). I have a series of fields in frmSelect(one in particular called templateVersion and another called templateComment). In Sub, I have an event procedure that is called on the "After Update" command that I...

I am querying results using Access 97(Yes its old and no my company is not willing to upgrade.....:confused:). Anyhow, I am connecting to a corporate database that has two tables I am querying that should be joined on one field (wmg.wmgtk01_tnk.sys_i = wmg.wmgwo04_halfleg_actl.tnk_sys_i). I am...

I have the code below - what I am trying to accomplish is determine whether or not there are any records in "tblEquipmentSchedule" that have a matching date and schedule type as the forms current view. I know for a fact that there are some records that exist - for example if I put in the date...

I have the code below - what I am trying to accomplish is determine whether or not there are any records in "tblEquipmentSchedule" that have a matching date and schedule type as the forms current view. I know for a fact that there are some records that exist - for example if I put in the date...

I currently have a form with the subform being a datasheet built off of a query. I am having issues with it because I want the user to be able to select a record from teh datasheet and click a button on the main form to open up an order based on the selection. Is there a reason that when the...

I currently have a field set up on a Schedule Form(frmSchedule) that requires a user to enter in a Schedule Date (dtmSchedule). In the end, the form is supposed to check to see if there are any records in the Equipment Schedule Table (tblEquipmentSchedule) - if there are no records with that...

I have a query that returns 1000's of records and there are some simple data entry errors that I am unable to prevent because of administrative rights being restricted. When I query the tables, is there a way for me to exclude the records where "#ERROR" is showing up?

I am building a database that is going to have multiple users and would like to hard code my datasources into the database. The reason behind this is because the multiple datasources are required in my ODBC Datasource admin on each computer. Is there a way for me to hard code the connection to...

I am exploring some new areas (at least to myself) of Access and was hoping someone would be able to point me in the direction of some resources that could explain the role of Workspaces and how they work. Let me know if you have any questions. Thank you.

I have the following code that is causing some problems for me and I was hoping someone might be able to help. It works, sometimes, when it wants to.. and then there are other times when it processes my request once and repeats the same values over and over. What it is built to do is look into...

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?

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

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

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

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