VBA Not Working After 2000 Upgrade
Nov 21, 2006
Good afternoon (well, it is here in the UK)
We have just changed from Access 97 to 2000 (only 6 years behind) and I use a database that has this piece of code running:
Private Sub DateOfAction_AfterUpdate()
DoCmd.Requery
Forms![CallLogMain]![CallLogDetails]![Child68].Requery
Forms![CallLogMain]![CallLogDetails]![Child71].Requery
Forms![CallLogMain]![CallLogDetails].SetFocus
Forms![CallLogMain]![CallLogDetails]![CallID].SetFocus
End Sub
After the record was input 2 subforms would refresh to recalculate a field storing the total time and then it would set focus to the main form to allow you move to the next record.
Now the database has changed to 2000, this no longer works which is a pain in the bum.
Any ideas why this has happened?
Regards.
View Replies
ADVERTISEMENT
Oct 6, 2005
Hi,
In 2000 and xp i used this code to count the rows of a sub form : -
subform_controlname.form.recordset.recordcount
this no longer works in 2003 and i just get #Name? appearing instead???
Any idea's on why that is??
Thanks
Adam
View 7 Replies
View Related
Jul 29, 2005
I've been having serious problems with my ASP scripts. Ok, for
the last week or so I’ve been working with you people and my
ISP to resolve this damn problem. Just last Monday, they told
me that it had been fixed. And it was true! I tried it and
everything once again worked fine. I made a dozen tests, and
everything worked fine. But when I tried it again two days
later, it's suddenly back to crashing again, the exact same
damn problem I was having before! I’m so frustrated I could
kill. I don’t think I did anything. Yes, my ASP code still works.
Yes, the HTML code still works. It’s when the code attempts
to open a *.mdb database it crashes.
Call up my demo script (then click "Reservation.") : http://christiansencustomsoftware.com/guestbk/dindex.htm
which will demonstrate the problem.
A newsgroup I work with writes: “This sometimes happens when you try to use the new MS Jet provider on a Access 97 database, upgrade your Access database to 2000, should work just fine.”
Ok, so how can I upgrade my Access database to 2000?
View 1 Replies
View Related
Jun 13, 2007
Hi
At work I was just updated to access 2003. I am trying to update a data base that I created in access 2000. Whenever I try to open a data access page I get the following error. "The installer encountered an internal string error. Installation failed." I've updated the Web components and that seems to have gone ok. My IT people are at a loss.
Any suggestions?
Thanks
John
View 1 Replies
View Related
Jun 6, 2005
I upgraded a 2000 db to 2003 recently. When I ran the function below it gave me an error on the line in green. Any thoughts? Thanks.
Const FIRSTROW = 13
Dim wsp As Workspace, dbv As DAO.Database, tblResolve As DAO.Recordset
Dim tblVchs As DAO.Recordset, tblImpTmp As DAO.Recordset
Dim ObjXLApp As New Excel.Application
Dim FileToOpen As String, WhereCriteria As String, ImportTemp As String, tmpVch As String
Dim TotalDupes As Integer, TotalGood As Integer, TotalRejects As Integer
Dim TotalBlank As Integer, R As Integer, C As Integer
Dim BadSheet As Boolean, ImpFail As Boolean
Dim tmp, tmpType, tmpCtr, tmpRsn
If Forms![Import Block Vouchers]![Import Program] = "0" Then
MsgBox ("You must select a Program to load.")
ObjXLApp.Quit 'Exit from MS Excel
Exit Function
End If
View 5 Replies
View Related
Jan 31, 2005
Hi there, new to this forum but need help.
I have a 22 column report where I am trying to builld search criteria so you can search everything and anything. I have everything from texts, (comments tools) to numbers (weekly periods and reference numbers). Its hard to explain clearly but have tried to get this working. Basically, so far, I have built like and or statements for each column. The Query will run but will not be in any order. If I build the following:
A = Like "open" or "closed" - Information open or closed
B = Like "1" or "2" or "3" or "4" - Quarterly Periods
C = Like "1" or "2" or "3" or "4" or "5" (all the way up to 52) - Weeks in Year
It is more complex than this, but if I build these statements and run a query, Access will search for them but will not bring out the required information. I need Access for instance to pull only the information for say A=open, B=2 and C=3. I dont want to see the rest of the informaiton in that Query. Any ideas how to build this? Please help.
View 1 Replies
View Related
Sep 14, 2005
Hi,
I've created a database in access 2003 with the default file format being Access 2000. Everything works fine on my computer and many others, all of whom are running different versions of access (2000, 2002 & 2003).
I have not had any problems with this database until recently and in the last few weeks we have had 2 users, both of them being Access 2000 users who have had the same problem.
The problem they are having is that when they click on any of the switchboard items, the buttons depress an then come back up again when the cursor is moved away, but nothing else happens - no action, no error message - nothing!!! Its the same for all of the buttons on the switchboard.
Does anyone know what is causing this? I have another computer with Access 2000 on it and this works fine, as it does on several other computers runiing Access 2000, I just cannot understand why it is not working on these 2 particular machine.......
Many thanks in anticpation.
Steve
View 3 Replies
View Related
Dec 7, 2005
i am trying to use access 2000 database onto to access 2003. When i try to click design mode to change something it gives me this message:
You dont have permissions to modify.
If i run it on access 2000 it runs fine.
Someone please help.
View 5 Replies
View Related
Oct 24, 2005
Hi
I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email
chris@ctbjs.co.uk
many thanks
Chris
View 1 Replies
View Related
Jun 2, 2006
I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.
However, there are 2 instances when this stops and waits for a human option to be selected:
1. When the spreadsheet is password protected
2. When the spreadsheet has automatic links I get the message:
"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"
How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?
Any help most appreciated.
Dalien51
View 1 Replies
View Related
Mar 27, 2006
If I have a report in MS Access 2000 generated based on the criteria selected of a project with work order "9999" with the labor costs, materials costs and the Totals of each crew1, crew2,... and I would like to have those expenditures populated in corresponding cel in Excel for each crew, HOW would I do it?
To think it out loud, could I create a button on a form, so when I select the criteria for the work order, and when I click the button, it should refresh/update the Exel file with the new data...?? How do I write VBA code for that...?
Please help...Thank you so much....
View 3 Replies
View Related
Aug 20, 2007
Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.
This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.
I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.
I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.
I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.
Some information on the database in question.
It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.
The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.
Thank you in advance for any help,
Dom
View 10 Replies
View Related
Nov 15, 2006
Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?
Thank you in advance.
View 3 Replies
View Related
Nov 9, 2005
My company is about to join the 21st century and they are upgrading from MS Office 97 to XP and Office 2003.
We have lots of Access databases, many designed by me, so if they don't work next Monday people will start comming to me for answers. As I am only familiar with Access 97 (and I am by no means an expert, even though everyone thinks I am!) are there any problems I can expect when we upgrade to the latest version?
Any tips appreciated.
View 5 Replies
View Related
Dec 3, 2007
I have an old database that is in use based on this one I have created a new one next to it with test data in it. How can I place all data in the new data base there are in some tables new colums added?
View 1 Replies
View Related
Jul 4, 2005
I have an access db in a small lan (12 clients)
I want to make an upgrade and to go to an more powerfull tool than access
It is possible to do that easy with mysql sql server ........... or something else ?
Thank you
View 1 Replies
View Related
Oct 21, 2004
Please help?! We just upgraded from 97 to 2003 version. This is a scheduler routine which auto imports an excel spreadsheet into our main db. After I upgraded it stops on with "compile error variable not defined" Also after the conversion ...there was an error that said "May be due to old DAO syntax that is no longer supported" l am pasting the module code below but this line is where I get the error:
FileFormat:=xlexcel9795, Password:="", WriteResPassword:="", _
I don't have any idea of what to do and this has to run every night.
CODE:
Public Function importisfile(imptype As String)
Dim importpath As String 'path for work or home
Dim impfile As String 'filename of xl import
Dim tempfile As String 'temporary for rewrite
Dim tblimptemp As String 'tablename
Dim stdocname As String 'conversion string
Dim stdocname1 As String 'conversion string
Dim recsetname As String
Dim XL As Object
Dim db As Database 'used in traversal
Dim rec As Recordset 'used in traversal
Dim tbltempstr As String 'table to traverse
Dim x As Integer 'used to count traversal
'importpath = "V:AdministrationImports"
importpath = "V:AdministrationImports"
impfile = importpath + "TOX" + "kit.xls" 'eg. c:importTOXCANkit.xls
tempfile = importpath + "TOX" + "kit2.xls" 'eg. c:importTOXUSkit2.xls
stdocname = "qryappendimportTOX" 'date conversion in this query
stdocname1 = "qrydeleteimportTOX" 'date conversion in this query
tblimptemp = "tblimporttempTOX" + "Kit" 'eg. tblimporttempTOXCANKit
tbltempstr = "tblTOX" + "kit"
On Error GoTo Err_imp1
Set XL = CreateObject("Excel.Application")
With XL.Application
.Visible = True
.Workbooks.Open impfile
.ActiveWorkbook.SaveAs FileName:=tempfile, _
FileFormat:=xlexcel9795, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
.Quit
End With
Set XL = Nothing
Kill impfile
Name tempfile As impfile
'transfers the readable xls file into access database
DoCmd.TransferSpreadsheet (acImport), acSpreadsheetTypeExcel97, tblimptemp, impfile
View 1 Replies
View Related
May 25, 2005
Hi everyone,
I recently added a new page to an existing database in 97. All the previous pages run with a case number. I then upgraded to access 2003 and now the case numbers are out of snyc on the new page.
Can anyone help.
View 1 Replies
View Related
Mar 26, 2006
Hey,
I'm recently starting a new job and one of my tasks is to clean up their Access 2000 database. After looking through it and realizing how much crap there is in it, I was thinking about starting a new one for them from scratch. I was wondering if there are any pros/cons to redeveloping the database in 2003 verses 2000. Its a pretty small company with usually about 6 people concurrently working on it throughout the day.
Any thoughts would be appreciated!!
View 2 Replies
View Related
Nov 8, 2005
I have recently upgraded from access 200 to access 2003 and I am having a problem using my reports. I can run the querys just fine but the reports wil not run at all. I can't open them in design view either. Ant thought how to fix this.
View 3 Replies
View Related
Apr 27, 2007
Hi everyone,
I'm new here and I have a problem I cannot solve. I tried searching for ideas, but I could not find any help.
Here is my problem.
I have a database form used to scroll through records. I use the same form for searching. The user clicks a search button, I clear the form, they enter their search criteria (perhaps in multiple fields). Since upgrading to 2007, the clearing of the form takes many times longer than it did in 2003. I am using the following code to clear the form.
For Each Ctrl In form.Controls
If TypeOf Ctrl Is TextBox Then
Ctrl.SetFocus
Ctrl.ControlSource = ""
Ctrl.Value = ""
End If
Next
This code executes instantly in 2003 and takes almost 1 minute in 2007. Any thoughts as to why this is so different in 2007?
If there is a different way I should be clearing the form, please let me know.
Thanks for your help.
View 4 Replies
View Related
Jun 6, 2007
I've got Access 2000 and was wondering what I needed to upgrade to Access 2007. By this I mean, front page of manual, ID code, etc. And is it something I have to present at purchase or something that Microsoft validates online. Does anyone know?
View 9 Replies
View Related
Mar 6, 2008
I have upgraded from Access 2003 to to 2007 in Window XP. When trying to edit code I get the message Project Locked - "Project is unviewable".
Sandy
View 10 Replies
View Related
Feb 25, 2005
We keep having our backend tables corrupt. We want to upgrade only the backend tables to SQL server. I don't even know where to start. What version of SQL server? I guess I find out if we have an existing licence in the company? Any help on this?
View 4 Replies
View Related
May 30, 2007
We just upgraded to Office 2007 and are experiencing very slow access performance. This microsoft article addresses the problem:
http://support.microsoft.com/kb/275085
It won't let me change Subdatasheet Name property to [NONE].
Even if I am able to change it, will this affect my table links. I have a lot of them.
I am just the part-time Access "programmer" here and am somewhat lost trying to figure this out. Does anyone have a simple explanation and solution? I would appreciate any help so much!!
View 1 Replies
View Related
Aug 17, 2005
Is there an easy fast way to do this:
We are having problems upgrading to SQL server for only our backend tables. The problem is we have SQL reserved words that can only be used by SQL Server. There is a huge list I was given. I assume this applies to all objects, in our ms access database. Any suggestions on how to at least 'find' all of these at once? Or fix this easily? I know which tables would not upload ...but in looking through them I don't even see which reserved word is causing the issue???
Also..our front end application with stay Ms access 2003. Do I still need to update any reserved words in that or just the tables?
View 2 Replies
View Related
