Bre035
Last Activity: Jun 11 '19, 03:53 PM
Joined: Sep 25 '07
Location:
-
It does but it also inserts the row into a status table to set statuses of the project at different intervals. -
I wish I could share the database which would probably help to understand the workings.Leave a comment:
-
It’s erroring at the insert where I’m assuming it’s not creating the ID or ProjRowID. I’ll attempt to edit the code submitted.Leave a comment:
-
Project Tracking DB - Adding new row error
I'm receiving error "Error entering Project. Invalid use of Null". I cannot determine why the VB script is not adding the "ID" number and writing to various tables. The database was inherited from another department.
...Code:1.Private Sub btnCreateProject_Click() 2. Dim dbs As DAO.Database 3. Dim sSql As String 4. Dim projRowID As Integer 5. Dim CompletionDate As String 6. Dim dateRequested
-
Convert Access Report to Word/RTF Retain Formatting
Does anyone know of VBA code or software to use to retain formatting when converting Access report to Word/RTF? -
I modified the original post with the code/query from the module that is causing me issues.Leave a comment:
-
Thank you for your guidance.Leave a comment:
-
Record Source Locking - all users open form get the same records
I have a database that has a form and subform.
However if user A access access the 'Manage My Projects form', then User B access the 'Manage My Projects' form. User B form will be loaded with User A records.
Apparently the creator of the database used a module to create the subform, which carries and saves User A information.
Below is the module that I cannot figure out how to edit to ensure multiple Users can use... -
Send report using automatic email via access
I am attempting to send two reports 'RPTEMP_EMP_DUE ' from Microsoft Access 2010 using Outlook email.
I want the report to generate either when the database is opened or at a scheduled time.
Nothing seems to be working. I do not want to use a macro that opens the Outlook Mail that you have to hit the 'Send' button. -
SQL Error: State:21000, Native Code: FFFFFCD5
I have received the error State:21000, Native Code: FFFFFCD5 when attempting to run the following SQL Query to update column using the data from another DB2 Table column.
...Code:UPDATE db2prod.arts_case_research SET agent_ID =(SELECT db2prod.arts_case_research_AUDIT.agent_ID FROM db2prod.arts_case_research_AUDIT WHERE db2prod.arts_case_research.case_number =db2prod.arts_case_research_AUDIT.case_number AND db2prod.arts_case_research_audit.audit_action
Last edited by Rabbit; Oct 31 '13, 03:41 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data. -
The DB2 queries are retrieving data from DB2 Tables, but populating a Access table. The queries are Make table queries.Leave a comment:
-
Multiple Users locking DB when running DB2 Queries.
I have created an Access DB using 2003 version, split the DB with Front End and Back End. I placed the Front End on Network Shared folder also. However, the users of the DB are using versions 2003, 2007 and 2010, everyday someone locks the database when running the queiries that access DB2 Table to perform the Access Make Table queries. -
Converting/Trimming XML VARCHAR Tag to Date
I am attempting to trim/convert XML VARCHAR Tag to date, but have not been successfull. Below is my XML SQL:
...Code:select X.*, A.CASE_NUMBER, FROM DB2PROD.ARTS_OGC_CASE_ACTION_DETAIL A, XMLTABLE ('$d/artsProbationBean' passing Case_Action_XML as "d" columns CASE_NUMBER integer path 'CASE_NUMBER', indicatorCode varchar(20) path 'indicatorCode', extendNumberOfMonths varchar(40) path 'extendNumberOfMonths', -
Thank you all for the responses I left this issue up to them to decide what to do.Leave a comment:
-
Huge company so, this decision comes from Upper Management without the thought of the business impact to multiple business units.Leave a comment:
-
Migrating to Access 2007 is corrupting Access 2003 DB with VBA code
I need a response really quickly. My company is migrating to Office 2007, but many of the departments have created Access 2003 database to use to complete multiple job functions. We have over 30 Access DB created in Access 2000/2003.
When a user with Access 2007 opens an Access 2003 Db with VBA code the database is being corrupted or the VBA code is. What can we do to resolve this issue?
I have a 4:00 PM meeting with... -
Increase the time an Access Form opens
I have created a database for a phone unit to enter their call details. The Database works great once the form opens. I am tiring to figure how to increae the response time the user clicks the form on the switchbard until it opens.
It is taking about 15-20 seconds for the Form to open. Some of the forms open from queries and macros. -
Trim Timestamp XML Tags in DB2 column - Using SQL to query
I have a project were programmers decided to use XML to code additional fields in order to decrease the number of DB2 Tables. This is caused me to have to learn how to query the XML column that hold the data. I am attempting to pull information for a Case Action that exist in the DB2 Table. The table name is ARTS_OGC_CASE_A CTION_DETAIL. The columns are case_number, case_action_det ail_code, case_action_xml
I want to be able to Trim the...Last edited by Dormilich; Jul 9 '11, 12:08 AM. -
Thank you. We were trying to avoid since we dealing with over 20 database and 40 plus users.Leave a comment:
-
Majority of the database are still in the Microsoft 2003/2000 format.Leave a comment:
No activity results to display
Leave a comment: