Reedsp
Last Activity: Jun 21 '11, 07:49 PM
Joined: Apr 10 '07
Location: Utah
-
I will see what I can do to get some data. It may take me a few days. -
I wish I could but its 55 MB and contains financial information. The only alternative is to copy the report to a database of its own. You can't run the report but you could look at the structure and code. If this would help let me know.Leave a comment:
-
Thanks for the suggestions. I tried both. The -1 suggestion worked for reports with 3 pages and only showing 2 but not when there is 174 page report. The Cancel Event didn't do anything different.
I will try and explain what is happening, I didn't program the report, I inherited the Database and so I'm trying to solve the problems.
In the Group Header 0 Format property the code reads: linecnt = 0
In the Detail Print...Leave a comment:
-
Report Page Numbering problem
I have a report that displays the page numbering incorrectly. Example page 1 of 3 but only 2 pages are displayed when previewing or printing the report. Here is the details:
Page footer - text box with control source as:
="Page" & [Page] & " of " & [Pages]
There is a group header with the following code in the OnFormat property: linecnt = 0
Group Footer OnFormat property:
... -
Records are imported into a existing table. But the cancel button is being clicked before the import wizard even gets to that point. In Access2003, the import window threw a error when you clicked the cancel button at any point in the wizard. In Access 2007, is seems like this is not occuring that no error is generated. Access 2007 accepts the cancel button and moves on to the next line of code. If this is true, how would you program around...Leave a comment:
-
Import window error message missing
I am using Access 2007. In Access 2003, when you had the import window opened and clicked on the Cancel button, MS displayed an error message. To compensate for this using VB code, I used the "On Error" function because I am opening the Import window using VB code. I want to code to do something if the user clicks on the cancel button.
Code:
On Error Goto Opps2
DoCmd.RunComman d acCmdImportAtta chText... -
Once I typed in the syntax, a window appeared to select the import commands and the one that worked was
DoCmd.RunComman d acCmdImportAtta chText
Thanks for the information. I have always been able to find solutions to my questions on this site. It is a great relief.
If this is the second reply, I'm sorry. My browser is timing out....Leave a comment:
-
VBA code to open Import window in Access 2007
I have a Access 2000 formated database that I am testing the functionality of the database in Access 2007. One line of code of visual basic code in not working in a module. The line is:
DoCmd.DoMenuIte m acFormBar, acFile, 2, 0, acMenuVer70
This line opens the import window. Does anyone know the replacement code to use in Access 2007 to open the import window? -
Thanks for the tip. Here is my new code:
...Code:' This will close the current form and open the form listed Dim stDocName1 As String Dim stDocName2 As String Dim stDocName3 As String Dim stLinkCriteria As String stDocName1 = "PCMS_COLWH_PTC" stDocName2 = "pcmsdata" stDocName3 = "frmInfoMsnVol" DoCmd.CloseLeave a comment:
-
Thanks for your willingness to help. I will try and explain the issue as best as possible.
From my original message, I included the DSN variables I have set up. I have 2 areas the use or access oracle data. The first has information that I look up through a combo box (based on a query to the oracle table) information that in then displayed on the window. As you go to each record you see this information. So when I first open the...Leave a comment:
-
I did figure out the syntax. Its' where to put the syntax that is the 2nd part of the problem. If you have and Idea where to put it that would be a big help.
Thanks....Leave a comment:
-
I did check out the link. I don't know where to put the code. Do I use it as a CONST (Constant) at the top of the Form that views the data. I have 2 areas I connect to Oracle. One is through a look up combo box, the other is viewing a form that shows data from the oracle table. If you know where or how I might use this code let me know. If you need a better description let me know also.
Thanks....Leave a comment:
-
Oracle database password
Version: MSAccess 2003 SP2
Explination: I have a database that connects to an oracle database. I have setup an ODBC connection under the System DSN tab in the ODBC Source Administrator. The first time I go to a form that has fields from the oracle table, the "Oracle ODBC Driver Connect" window appears, as it should. Once I type in the password and continue with the database, that window never appears again. If I enter... -
Thanks, that worked. Very much appreciated....Leave a comment:
-
Update Query -Type conversion failure
OS: MS XP
Access version: 2003 SP2
I am trying to use an update query to replace quote marks with nothing. In essence, I'm removing quote marks. I get a error message when a field is empty or has no value in it.
Query:
Field: Zipcode
Table: tblMemberInfo
Update to: Replace([Zipcode],"""","")
Error message: Microsoft office access can't update... -
Thanks that helps....Leave a comment:
-
Turn confirmation messages on or off
OS using: MS XP
MS Access: 2003 SP2
Is their any way to turn on or off confirmation messages through VB for record changes and action queries without using the menu bar File | Options | Edit/Find and unchecking the check boxes?
The reason for this is because my work uses a server for remote users so they can use Access databases. Many departments use this server for Access databases but the default for the... -
If you use 4 quote marks then Access searches for the quote marks and replaces them with nothing.
I found the solution: DoCmd.RunSQL "UPDATE tblMemberInfo SET tblMemberInfo.F ullName = Replace([FullName"""","" );"
If you use the replace function in a query on the "Update to" line, it works also. Except if the field you are searching only has 1 character and its a quote...Leave a comment:
-
Type Mismatch on Update Query
I am trying to replace quote marks that are typed accidently by users in a table. I need to strip out the quote marks. I get a "Run Time error '13' Type mismatch" with this code. Here is the code.
DoCmd.RunSQL "UPDATE tblMemberInfo SET tblMemberInfo.F ullName = Replace([FullName],""*" & Chr(34) & "*"","");"
Is their a better way to search and replace...
No activity results to display
Leave a comment: