I'M NEW TO DATABASE PROGRAMMING AND HAVE LIMITED PROGRAMMING EXPERIENCE. SIMPLE EXPLANATIONS AND TERMINOLOGY ONLY PLEASE
I've been tasked with producing two database systems at work.
1) A job ledger (currently excel)
2) A stock condition survey database
Question
For future proofing:
* what coding should I be investigating (I expected to use Visual Basic, I understand this has now given way to Visual.NET?)
* Should be upgrading to Access 2007?
* Where the best place for sample databases of this kind?
* What's an SLQ system? Should I be using this instead?
I have a fully operational Visual Basic program that uses MS Office XP and it's related MS Access. Because of security concerns, I recently upgraded to MS Office 2007 and MS Access 2007. I can open MS Access 2007 using the shortcut on the desktop and run any of the database queries. When I try to run the Visual Basic program (called prjPathfinder) and open Access 2007, it says "Error 5: The type initializer for prjPathfinder.Upgrade Support threw an exception". It then shows the first form in prjPathfinder but does not open Access 2007. What am I missing?
I got a new job (another one, actually) and though it has absolutely nothing to do with databases, or computer work for that matter, I told my boss that I like building database apps with Access. He sparked up and said that he has a program in Visual Fox Pro, an application that's "more powerful" than access, but someone came in way back when and wrote a "program" that did some calculations to the existing DB, but the PC is dying and when it does, will take the addition with it. He said that he'd be interested in me looking into it and hopefully being able to replicate the work the prior person had done.
Has anyone worked with VFP and worked in Access with it? It doesn't seem very flexible at all and it's not very intuitive. I'm not impresses with it at all, but I have an opportunity here with my boss and would like to "get her done" so to speak.
Any help or links to good VFP tutorial sites would be greatly appreciated.
Here is something I wonder if it has already existed or been asked before, a program or an add-in feature that can compile an Access database (including forms, reports, tables...) to a stand-alone .exe application, just like Visual Basic does. The reason why I think it's doable is because in Access, we use VB codes anyway and it wouldn't need to be rocket-science for Access to do something like that or this would be an improvement for future versions.
There are plenty of advantages of going from an Access form to a stand-alone app, i.e. we wouldn't need codes to hide background and menu or status bar; we wouldn't need to disable mouse-scroll or prevent users to go back and accidentally delete past records; or we wouldn't need to worry about users seeing your terrific coding techniques and on and on.....Agree that all these can be done within Access but imagine how much time it'd save you from not doing all these things.
hi... i have a form that display things in a table in access. when program the form to delete a query it deletes it but does not do rs.movenext what i want to do is the form to display the next set of data from the database. i am using dao.... please help me!!
On trying to import an Excel 2007 file into Access 2007 I get the following:
1) Choose "External Data," Import, Exce 2) Select small file in MS Excel 2007 format. 3) Click on Import the source data into a new table ... 4) Choose OK
Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.
Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.
Event Viewer gives following message, which is of no help: "ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."
Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.
I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.
I have an access Query(named newSerial) : SELECT TOP 1 (Productbase.Serialnumber+1) AS Expr1 FROM ProductBase ORDER BY (Productbase.Serialnumber+1) DESC;
I want to access this new value. Its not a key since an autonumber may be any number. When I create a new product. How do I get this value inside a form? It works fine when clicking on it. But if I use an unbound box I get 1 as result and not like 76067 which it should be. If I click the query in access it works fine and show 76067. I tried: outbox=Expr1 ' gives null 'or outbox=[newserial].[Expr1] ' which gives "Access cant find the field "|" refered to you in your expression"
What should I write? Whats the correct expression?
I am trying to find out how to integrate ms access with source safe and also the cost of source safe. The microsoft website does not give me information on the cost or even how to buy source safe. Can any one help me??
I am not new to Access, however I am just starting to get to the point where I need visual basic to complete some things I want to try. My question is, how do I code a button (or modify an existing one) in my form that will email the same output I get when I use a Print Report button. Here is what I have from my standard buttons:
Private Sub Save_Svc_Record_Click() On Error GoTo Err_Save_Svc_Record_Click
I installed Office Enterprise 2007. Then I installed DEveloper Exrtensions, then Access Runtime 2007. All appear to have installed OK - they appear in Program and Features. Instructions on runtime packaging tell me that a Developer option should appear in the resulting drop-down when I click the Office button (top-left round thing) when I have a d/b open in Access. It's not there! I have un-installed and re-installed the extensions and the runtime - still nothing! Help! I do have Runtime 2002 (XP) on the same PC, is that relevant?
Have you guys ever used this scheduling tool from FMS Software that will do a nightly archive and compact/repair.
I tried it out on our live database (not so smart I guess) on a Friday and when I came in Monay it was corrupted. It seems to point to the FMS software corrupting my db.
I wanted to validate and use this software but ain't sure it I will now.
I like the nightly compact/repair. Is there another way to do that with Windows Scheduling or something?
Is there any way of converting MS Access Forms(And module behind) to Visual Studio.Net?
I have a pretty comprehensive MS Access DB that has several complex forms. I want to redo this DB App in Visual Studio.Net but don't want to recreate the forms from scratch if there is any way of converting/importing or any shortcuts/tricks to accomplish this.
Thanks in advance for any help!
Mitch
Side note: Anyone ever added credit card billing capabilities to their db? Where to start? (I know.... Post in another thread....)
I have developed an Access mdb file with lots of tables, forms, queries, reports, and VBA code. I want to be able to distribute this to Access-less users. I understand that the Access Developer Extensions enable this to be done and that the two wizards assist.
My first question is this: Are the Access Developer Extensions and the two wizards included in Visual Studio 2005 Professional Edition?
I ask because this is what was recommended by a Microsoft representative and is what I’ve purchased. This came along with something called MSDN Library, but I’m not sure what that allows me so it is possible that this library will contain the elements that I’m searching for, but so far I’ve not found it.
Are the Access Developer Extensions only provided as part of the Visual Studio for Microsoft Office Tool package, as I’ve seen referenced in several forums and articles, including yours, or are these in fact part of other tools, such as the Professional Edition of Visual Studio that I’ve purchased?
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard. But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007. I can't use the Package Wizard.
Attached is a screenshot of the relationships in a database I built a couple of years ago. It's worked absolutely fine in Access 2003 and currently has over 18,000 customers with associated information in it.
However, when I open the database in Access 2007 the performance is awful. All the forms are very slow to respond when tabbing between form elements. I've experimented by reducing the number of form elements calling on related data on a given page and whilst this improves performance it reduces usability - something I don't want to compromise on especially since Access 2007 should be able to cope with this.
My next question is therefore whether I've got the most efficient underlying table design and I can't see any other way of doing it than my current method so I'd be grateful for any feedback or advice anyone has.
Background Info: I developed our main department's Access 2003 split database which is on a server for 15+ Users. I've now been given Access 2007 for development -- Users still have 2003. There are also 2 other smaller databases that are not split (.mdb).
Problem: In the split database, I've saved the Application .mdb as 2003, relinked and made a new .mde. But the Users still cannot open the database. (I did this in a copy until I figure out the nuances with 2007.) The 2 other unsplit databases can be saved as 2003 version and Users can open OK.
I'm grateful for any suggestions on working with Access 2007. I've been trying to tackle the ribbon which is a whole other question.
Having a problem here after installing 2007. All my previously created databases work fine in 2007 (after clicking the enable, which is a pain,but don't know any other way) When I return to 2002 and try to open the databases I get different errors all something like this on....... "The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events. Whats up here?????I have found a site here...http://allenbrowne.com/bug-17.htmlMentions this problem,but refers to Vista..... Does the same apply to XP? And which is the best fix?
I have an Access 2000/2003 database which opens up and displays correctly in Access 2007, but when I go to use the File>Print command, or for that matter any of the other pull down menu's nothing happens?
Has anyone else experienced thisproblem, or does anyone know what I am doing wrong?
I have created a database in Access 2007 that now works well, and one that I'm quite proud off. However, I can easily convert it to an Access 2000 format as can anyone else here, but when I load it up there is a major problem.
I have used the tab control in my main form and that has three tabs on it. However, it's positioned correctly in Access 2007 it's not positioned correctly in Access 2000 as I have to move the tab control down a bit, but that would seem fine. So I lowered the tab control form and changed my form layout slightly, but even then the tab control over all over the Access 2000 form whenever I interact with the tabs - most bizzare.
I recently heard that Access 2007 ( part of MS Office 2007) can be purchased as a stand alone program. This sort of confirms that : look at pricing breakdown on : http://techrepublic.com.com/5254-6257-0.html?forumID=99&threadID=174062&messageID=1961442&id=3053951
