I have seen advertised a number of programs whose developers claim the program will document an application for you.
They're relatively expensive - several hundred $ as I recall. But if they work, it could save many days of headaches.
I was wondering if anyone had used them, if you'd recommend them etc.
I am new to databases as you may of seen if you have seen some of my other posts. I have seen this done on a database that is used in my school. When the user double clicks on the access file it opens but it doesn't open like a normally access database, it opens up and shows the switchboard straight away and also hides the dialog box that lets you view the design of everything, so it stops you from seeing the information apart from through the front end that you provide.
Do any one have any idea how do to this, as i have said i have seen it done in school but the person who created the database has now left and I'm a little stuck.
Thanks in advanced!
Is there a website that contains pre-built access applications?
View 1 Replies View RelatedI have developed quite a few Access 2000 applications for clients and continue to maintain and update these applications. I am starting a new position with a client using Access 2003 at the client's location. I would like to upgrade to 2003 but I still need to service my 2000 clients. Can I install and run both versions of Access or can I still maintain the 2000 apps under 2003? Help!
View 4 Replies View RelatedThe environment
I have 1 application that runs on dBASE4
I have another application we subscribe to that runs online and requires tab delimited text file input nightly
The only front end we have to dBASE4 is through the application and they don't support scheduling queries with joins
Proposed solution
Since Access links to and imports from dBASE4 and we do have a front end to Access, it made sense to use it as a courier, so to speak, between the 2 applications.
One assumption here is that no programming would be required, just clicking on Access functions (I haven't programmed for many years)
All of this needs to be done automatically overnight
The problems are numerous, based on my lack of experience with Access
We are a school and have limited speed on our network. To minimize traffic and time there are a couple of options I wanted to consider
Question 1: Should I run this before or after the dBASE4 database is backed up and cleaned up? What factors should I consider?
Question 2: Should I link to the original tables, link to copies of the tables, import to the original tables, or import copies of the original tables? The database is not being used at night, but I thought the advantage of working with copies of the tables might be that, once the copies are made, the rest can process while the dBASE4 clean up is being done.
Question 3: Does it matter where the input tables, copied tables, Access application, output files are in relation to each other? Which must be in separate folders, which should be in separate folders, how far apart should they be and why? The output files need to be put on another server. Does Access have a problem with that or do I need another DOS step?
The rest of my questions are about fixing things done wrong...
Question 4: I created a macro to import the tables to Access using TransferDatabase actions.
But I keep on getting the message “The Microsoft Jet database engine cannot open the file ‘C:xxxxyyyy’. It is already opened exclusively by another user, or you need permission to view its data.”
Where ‘C:xxxxyyyy’ is the Database Name, i.e. the folder where the dBASE4 files for tables are found.
I can successfully import the tables by clicking File > Get_External_Data > Import using the same folder specifications and file names, however this would not be automatic and defeats the whole purpose of this effort.
How do I get around this problem?
Question 5: I created a macro to run the queries and file the results into a text file using TransferText actions.
The queries were all tested and were successfully run independently of the macro.
I specify the filename ‘C:xxxxyyyyzzzz.txt’
When the macro is run I get the message “Query must have at least one destination field”.
What is a destination field?
How do I get around this problem?
Question 6: Also, I can't figure out how to specify the SpecificationName to make the file tab delimited and not comma delimited. The file also has quotes which I don't want, but that may be the same problem.
I will probably find more problems once I get this part working.
I intend to go to the Control Panel Scheduled Tasks to invoke the macro once it works with a commands something like:
"c:program filesmicrosoft officeoffice11msaccess.exe" "c:xxxxAppIF.mdb" /x Run_Queries
First one delete the old tables in Access, second one to import or link to the new tables, third one to run the queries & update the output files
I hope this posting did not break too many rules
Thanks for your help
Bill@cunyprep
Before I start on this seemingly endless journey of learning Access 2003, I thought it appropriate to ask the question;
Will this program do what I need it to do?
I apologise in advance if this is not the right place to ask the question, I am a complete beginner to Access 2003.
I want to make an electronic log book for the guys at work, there are 5 people of different trades who would need to keep the log.
A typical entry would be as follows
Mon 22/3/06 Alan Smith B Shift
Compressor house (heading)
No 1 compressor (plant)
Oil pump (component)
Filter cleaned (action taken)
Personel (heading)
John Jones (personel)
Phoned in sick at 15:00hrs, will phone tomorrow to update
Boiler house (heading)
No 4 boiler (plant)
Water vlave leak (problem)
Tightened gland (action taken)
There are many headings, probably hundreds of plant, thousands of components and actions taken
We would need to view events to particular plant or areas between certain dates, some personel would need to enter data, some would only view the data without being able to enter it, few would need to alter the data.
Is Access 2003 capable of this, should I start the journey?
regards
culedude
Hello all!
Please forgive me for being a COMPLETE novice at Access, but I am trying!
What I need to do, is have an ordered list, which has check boxes along side each item.
When the relevant items have been checked, I need to be able to save or export to CSV, with ONLY the items which have been checked!!
I need the list to be pulled from a seperate source (like an excel spreadsheet) so that it can be updated easily...
Can anyone help?
so...
Item 1 [X]
Item 2 [ ]
Item 3 [ ]
Item 4 [X]
Item 5 [ ]
Item 6 [X]
would produce a CSV file:
Item 1, Item 4, Item 6,
Simple enough?
Greetings:
I am looking for a program that will repair a MsAccess 2000 .mdb file. So far all I have been able to find is those that repair the tables, does anyone know of a program that will repair the entire file including the forms?
Thanks
Mickey
I believed that Access is a stable DB program. It looks like I may have to change this view. Yesterday, due to some fault in power supply (SMPS), my PC suddenly went off while I was working in my Access DB. My DB is a personal DB (single user). Today, after replacing the SMPS, when I opened my DB, Access gave a message that my DB is corrupted while it was being used last time. It asked to attempt repair with Yes/No button. I clicked the Yes button and it did nothing. In my third attempt, I was able to open my DB but I am worried whether it will work as before. Could the experts in this forum throw some light about Access DB' stability and measures to prevent corruption? Grateful for advice.
View 9 Replies View RelatedCan anyone tell me how on a macro to call another application. I am trying to open up a mainframe session so need to run something like c:mainframe.rsf???
View 3 Replies View RelatedI have tried using the DoCmd.Close method but I actaully want to close the whole program?
Any ideas?
Many thanks. Jon
Can anyone suggest a good program that will handle scheduled emails to people in our Access database? I need to send an email automatically to each of our employees on their birthday. I need the program for much more than that but that is what I am working on at this time.
Thank you!
Ben
I have noticed diagrams showing Microsoft SQL Server accepting SQL statements sent by “SQL Requesters” over connections. I would like to know if Microsoft Access can be used in that fashion?
Put another way, can Access be configured to accept an SQL statement that another program (e.g. a VBA program in a VBA enabled 3rd party app) creates?
Currently, my VBA program instantiates an Access database object and then manipulates it (I just add a record to one of the tables), then closes and destroys it. This solution seems fragile (it stops working—I can explain more if needed). I would like to know if the technique inferred by my question would be more reliable.
We are having a problem with mulitple users leaving an Access db open and then I am not able to make new reports, etc. without calling everyone to close their session.
Is there a way to automatically close a db if user has not used in certain amount of time?
Thanks, Noreene
I have a VBA program that I wrote in access. My question is this: Is there anyway to eliminate or minimize the main Microsoft Access program window so all the user would see is my forms and the desktop? Not that ugly gray back drop? Thank you in advance for your help.
-Rob
hi to all,
does anyone know the code to close the access program.
That is when i select the close button on the switchboard, the whole of MS access is closed.
Thank
How do you use a button on a form to call another access program? We have 8 access programs that we want to be able to call from one form.
Thanks
Hi,
Does anyone know how to set the application's width and height? I have an access application and I want to resize the applicatoins' with and height, NOT the forms!
is this possible?
greetings
nelleh
Hello All!
As in the topic stands that im looking for a code that hides Access and it starts up like a normal program. Ive searched several things on the forums and i actually did found something only he didnt gave the code ;(.
So first question:
How can i do this with a code?
Second question:
What do i need to change on my forms?
Etc etc :)
Thanks alot in advance!
I developed a program. Would you please teach me how to run it automatically when the computer restarted, through the startup.
Plus this I want to let this program run through the system tray, and not shown in the the Taskbar, if this feature is provided by MS Access 2003
Thankful...
Hi Everyone:
I am new to this forum as I recently started working in MS Access. I’m hoping someone can please help me with this query I’m trying to do using MS Access 2007.
This task is somewhat similar to a typical points/miles rewards credit card program.
The problem is as follow:
For every $2,000 of accrued purchases in a credit card, an individual will get a gift card.
So, any remaining balances over $2,000 will rollover and be added to next set of transactions, until it reaches $2,000 again. For instance, if on the first week I spent $2,500, I would qualify for my first gift card. The excess $500 would rollover and be added to the next set of transactions until they reach $2,000 again. Therefore, this would qualify me for another gift card.
So far, I’ve created two tables, one that stores accrued purchases (Promo History) and another table based on an Append Query which takes all qualified transactions from the first table and appends those records to the second table (Promo History Qualified) in order to track those qualified transactions over $2,000.
However, I’m stuck on how I would accommodate the remaining balances to be carried over. Any suggestions would be greatly appreciated!!
Thank you in advance,
marel
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?
View 3 Replies View RelatedI am trying to prepare a mini budget program in ms access for my personal use in my office , but every time i fail to do so, my tables are as under
Field Name Properties
Code ID AutoNumber
001 Cash
002 Bank
846 conveyence
dt: Date/time
Code text (list selected by drop-down list)
des Description
Bill currency
yearly Budget currency
quartlyBudget currency
Query Question:
Group Aggregate function in my Budget data base file
(A) (B) (C) (D) (E)
Code yearlyBudget quaterlyBudget quaterlyused Budget Available Budget
846 50000 12500 5000 7500
850 100000 25000 20000 5000
There are 100 entries in code no. 846 and 50 entries in code no.850 the above given amount is total of each code no.
My question is that how can i get result subtracting amount in column (D) from column (C) to get result in column (C)
Budget Available: in Code 846 i.e column (E)
I currently have a front-end/back-end database, but at some point in time one of the tables has been modified and whenever the front end connects it comes up with a parameter request for a field that no longer exists. I have narrowed it down to MSysQueries, where there is a reference to this field. Is there anyway I can avoid this or change/repair the system table?
Compact and repair doesn't work unfortunatly.
Thanks
I've used the Outputto method to archive reports creted in Access to Word in .rtf.
I now want to have an option to view these archives from Access. How?
Thanks,
Richard
I am creating a database for someone which includes a mail merged document with some data from the database.
Is it possible to allow the user to open the document by clicking on a button that will be on the Switchboard in the database, so that they do not have manually open the document?
Hope this makes sense!