Computer Support Forum

Newbie : Access database help

Question: Newbie : Access database help

Tôi có m?t h?p ??ng tùy ch?n ?? nh?n ???c ??n 10 qu? táo m?i ngày trong n?m t?i. Tôi chia s? h?p ??ng này v?i ng??i khác. Tôi ?ang t?o ra m?t c? s? d? li?u s? cho tôi bi?t có bao nhiêu qu? táo có s?n trong m?t ngày nào ?ó trong su?t n?m t?i.

Tôi ngh? r?ng tôi s? ph?i thi?t l?p m?t b?ng v?i m?t l?nh v?c cho ngày và n?ng l?c. Sau ?ó tr? ?i 1 l?n m?i ng??i l?y qu? táo vào ngày ?ó.

Có cách nào t?t h?n?

More replies
Relevance 100%
Preferred Solution: Newbie : Access database help

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 75.85%

Very busy and no experience using Access so if anyone has spare time and wants to help me out by making a database file for me...well....thanks! "Go do your own work you lazy *******" or some variation thereof is also an acceptable answer so I'm just throwing this out there in case any benevolent souls wanna lend a hand.

Here's the situation. I'm an overworked pc tech in an understaffed department (I'm sure no one here can relate!) and I frequently receive and ship computer components to/from the vendor as either warranty claims or just straight orders if the part is outta warranty or just something needed. I need a nice neat form to track all this. We also use "Remedy" action request system if you're familiar with that so I'd like to include the remedy ticket number to tie it to the part order. Basically I'd want fields like:
=============================================
Remedy Ticket number.
Customer name.
Customer phone.
------------------------------------
(check box for either "warranty claim" or "part order")
(if "part order" is checked, only the second section should show up......if "warranty claim" is checked then I'll need the whole shebang!

------------------------------------
----- Here's where the info about the defective part goes ------

Part description.
Part/Model number.
Part Serial Number.
Description of problem.
Warranty Status.
Date Claim Placed.
Ven... Read more

Answer:Access 2002 Newbie Needs Database

Have you tried the wizard in there yet? It will allow you to get the general part of the database down, and you can customise it later, with the label;s you want. Continue to add to it, and you will start understanding more.

I started that way, creating a databse for my own contact management, and, with help from folks here, got it working, and suited to my specific needs.

I am by no means an Access techie, but I can understand the basics, and some of the advanced, enough to sell and maintain an order database to another contact. I sold it inexpensively but it taught me a lot about database creation.

What I'm trying to say is, it is doubtful that you will get someone here to create it all for you, but you will more than likely get help from people about aspects you are having problems with.

you will also get a bit more experience, and a good feeling about having created something.
 

3 more replies
Relevance 74.21%

Hi all! First, I'm not a programmer; I'm a technical writer, so please bear with me if I don't understand things right away. I took SQL and Visual Basic, but it was years ago, and I remember little. I've worked with Access before, but again, I'm rusty, and what I'm working on now is more complicated that what I've done before.

I'm trying to create an Access database (Access 2010) to enter and analyze survey data from paper surveys. I understand there should be multiple tables with primary and foreign keys. One issue I'm running into is that there are questions for which multiple answers may be selected. In addition, each respondent takes a pre- and post-survey at each of three trainings, so in total a respondent will have 6 surveys, with some duplication of questions in the pre- and post-surveys.

What's the best way to handle such data?
 

More replies
Relevance 58.22%

Can anyone point me in the direction of a good music database to use for my music collection?
I am new to this but cannot seem to find anything that will let me add my cd's, viynl, etc and then view them in a list to search or print from.
Maybe I'm Missing the obvious so any help would be appreciated
 

Answer:(Newbie) music database - Help Needed

I quite like Music database 2.5.2 (2.38 Mb Freeware)
 

1 more replies
Relevance 56.99%

Hi Guys,

Im trying to write some code that will copy my access database , tables and data to a new sql server database, ive got the code to create the sql database but i need to populate it from my application

Any answers would be grateful

Thanks
Mark
 

Answer:Copy an access database to SQL server database using VB.NET

Google: import access to sql server
 

1 more replies
Relevance 56.99%

Here's the question- how do I open a form in an existing database from another db in Access 2010 using VBA and give it focus. I can open the external db and it's form but cannot figure how to give it focus. I'm trying to create a master form that will call various databases that each have a form. Seems simple, open the master menu, click on a button that then opens the called db and the associated form. Do my business exit the db and am back at the master form. I would be okay to just close the master db, all it has it the main menu or leave it open. Doesn't matter which I just want to open the called db and form and have its focus.
 

More replies
Relevance 56.99%

Hi,
I don't support Access, nor have I been trained in it, but I've been asked if I can help in this problem.
An Access database connects externally to a SQLServer database at login time for the application. How do I find which external database they are connecting to? I know that there is a way to go behind the forms to see the source code, but I cant remember how to do this.
I cannot find an obvious User/System file dsn on the PC to give me a clue.
Thanks in advance
 

Answer:Accessing external database from Access database

9 more replies
Relevance 56.99%

I'm building a database application in Visual Basic .NET and I want to know what is the equivalent code of this when I want to make a connection to mysql:

Protected connString As String = _
"Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = " & loc & "\dbProject.mdb;"

Private cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connString)

Private ConnectionString As String = connString
 

Answer:Exporting MS Access Database to MySQL Database

You would have to have the MySQL driver for it on the server regardless.
 

1 more replies
Relevance 54.53%

I have MS Access 2000. I initially created a long book list several years ago. I recently found a template from the MS database for books that I downloaded that I like better. I have tried importing the data from the old database to the new one but with no luck. Both are in Access 2000. I am running Win2K.
Thanks
 

Answer:Transfer from Access Database to Access Database

6 more replies
Relevance 51.66%

I am working for a company that has four people (four different computers) entering data into four different Excel 2010 files on a shared drive. I would like to create a master file on my own computer for the purpose of generating reports. How do I create one Access database that includes all of the information from the four different excel files? Also, can this Access file be continuously updated as the four Excel files are updated each day? Thank you!!!
 

Answer:Access 2010 Help Merging 4 Excel Files into One Access Database

9 more replies
Relevance 51.25%

According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes?

So why do I have the feeling that something is not going to work? Is it because I have been through to many Access upgrades?

Answer:Any problems using Access 2007 database with Access 2010?

Hi bbinnard,

If you have not purchase Access 2010 yet, what I'd recommend is....download the Trial Version and play around with it for quite a while.

4 more replies
Relevance 51.25%

I would like to set up an MS Office Access 2003 or even 2007 file and put it online for my team to enter data into. It seems as if Google Docs, my first idea, does not facilitate MS Access mdb files.Any safe suggestions would be most appreciated.

Answer:Easy online access to a Microsoft Access database

windows live shared folder. give password into to people who can access the DB or they register accounts and allow them to access the folder

2 more replies
Relevance 51.25%

I have on a Laptop, an Access 2013 program feeding an accdb database. I want to move subject database or a copy of the accdb database to a new PC with Access 2013 installed. Both computers are running on Windows 10. I considered copying the laptop database to my Kingston Data Traveler but I can't even find the directory where the database should be.

The only other thing to add Is that I programmed the record input software using Access 2003 and copied it onto my laptop with Access 2013 installed and which works fine. Later, I saved the MDB database into the Accdb format (Access 7).
'
 

More replies
Relevance 50.02%

Hi, I installed windows 7 prof, and then I installed ms office 2003. Now I am creating databases. I have never got this messages before when installing ms office 2003 on win wp. When I code and make changes, this message pops up. "You do not have exclusive access to the database as this time. If you proceed to make changes, you may not be able to save them later." how do i get rid of it? Thanks. Deon

Answer:You do not have exclusive access to the database. ms access 2003

I can tell you how to change the setting in Office 2010 (I don't have access to Office 2003, so you'll have to hunt around in OPTIONS):FILE - OPTIONS - CLIENT SETTINGS - ADVANCED - DEFAULT OPEN MODEMake sure it is set to Exclusive and not Shared

1 more replies
Relevance 50.02%

Hello All,
Our company had a photo booth with an F-35 fighter jet at a recent technology show. Individuals were allowed to have there pic taken in front of the aircraft with a pretty model. Now I have over 2500 pictures and over 2500 individuals that need their pic emailed to them. I have an Access database with a name, email address and a picture. Each name has a different image. How can I automatically send each person their picture through Outlook? I would like it to automatically populate a new email with the address and corresponding pic then have it be sent on its way while I am home sleeping. Can this be done? Is there a command that can run a VB script in Access to accomplish this? I thank you profusely in advance.

Scott
 

Answer:Solved: ACCESS: Email pic from Access database

16 more replies
Relevance 50.02%

Is it possible to convert an Access 2000 database to Access 7.0? I have an old machine that I would like to run a database on but it only has Access 7.0 for WIndows 95.
 

Answer:Convert Access 2000 database to Access 7.0?

6 more replies
Relevance 50.02%

Hi, I installed windows 7 prof, and then I installed ms office 2003. Now I am creating databases. I have never got this messages before when installing ms office 2003 on win wp. When I code and make changes, this message pops up. "You do not have exclusive access to the database as this time. If you proceed to make changes, you may not be able to save them later." how do i get rid of it? Thanks. Deon

Answer:You do not have exclusive access to the database. ms access 2003

I can tell you how to change the setting in Office 2010 (I don't have access to Office 2003, so you'll have to hunt around in OPTIONS):FILE - OPTIONS - CLIENT SETTINGS - ADVANCED - DEFAULT OPEN MODEMake sure it is set to Exclusive and not Shared

5 more replies
Relevance 48.38%

Ok I have one more question-a few people have other versions of Access in my program and need to use the database that I created in Access 97. A few people tried and couldn't open it. Is there an easy way to converting this so they can use it on their computers? Thanks for the help.
 

Answer:Access 97 database in Access 2000?

Access should prompt them to either open the DB file or convert it to the newer version on startup. If it doesn't you can open the newer version of Access and go to Tools > Database Utilities > Convert Database.
Warning: Everything in your DB may not convert properly so be ready to do some work if this happens.
 

2 more replies
Relevance 48.38%

Hi everybody! I have a problem with my MS Access and can’t use the wizard for creating database objects (forms, report, table, queries, etc). Whenever I choose Wizard option to create those database objects, I get the following error message:

Microsoft Access can’t find the wizard, or there is syntax error in the Declaration section of a Visual Basic module.​
The wizard you need may be missing from the libraries key of the Microsoft Access section of the Windows Registry.
To make sure that the wizard is in the Windows Registry, run Setup to reinstall Microsoft Access, and the compile all Visual Basic modules in the database.​
I reinstalled the MS Access as instructed in the message, but I don’t know where to find and compile those Visual Basic modules. I also don’t know how to get to libraries key of the Microsoft Access section of the Windows Registry.

I tried to reinstall the software by using two different versions of software CDs (MS Office 2000 and XP) and both failed to solve the problem. I also tried unsuccessfully to access Add-Ins feature from the Tools menu in order to add the missing component. Please help me!

ishak
 

Answer:Can't access MS Access database Wizard

Funny I had the same error last night. I ran Setup from the CD (from RUN prompt) checked off the access wizard. Then went and did what I was doing, it still asked to install the feature but it worked that time.

If that does not help the is an MS article, basically, if you are in "Break mode" of a module that could also cause it.

http://support.microsoft.com/kb/208204/en-us
 

2 more replies
Relevance 47.56%

Hi,can smb help me with sites that have tutorials about the relation of vb.net with access databases or sql databases.
Thanks
 

More replies
Relevance 47.56%

We use Accessdata base to keep track of all our orders. All of sudden two days ago, I go to the "main switchboard" and I get a blank order entry form. In that form, there is a small clickable box and when I click on that it says "The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Office Access can't find. *** The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. ***There may have been an error evaluating the function, event or macro."

I have no idea what this means. Please help.

thank you,
renee
 

Answer:Access Database - HELP!!!!

The first thing to try after taking a backup copy of the Database is a "Repair & Compact" of the current one. You should open Accees, not the database and then choose Tools>Database Utilities>Repair & Compact. Choose the current database to repair and Compact and save it under a new name. Open the newly named, repaired database and see if it still has the same problem.
 

1 more replies
Relevance 47.56%
Question: Access Database

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual Basic..to have the form blank..when entering the form..so that you can just add..new data..instead of having to click on add new data..
 

Answer:Access Database

First, this is really the wrong forum for this question. It should either be in Applications or Development. I only saw this post because I was checking on a post I made here before but I don't usualy visit this forum often.

If you want a form to open ready to take new data, set it's Data Entry property to Yes. (You'll find that property in the Data tab of the forms properties.) If I misunderstood the question, post back and give more details.

Good Luck!

[This message has been edited by YSB (edited 08-10-2000).]
 

2 more replies
Relevance 47.56%
Question: Access Database

I have an issue with an access database. When I print out a report one of my columns only prints out 4 out of the 5 digits. This happens with 2 machines. On other pcs the 5 digits appear in output of the report. I have checked the resolutions of the pcs and they are the same. I cannot figure out why only 4 digits appear out of the 5.

Can anybody help?

thanks
 

Answer:Access Database

It may be the version of True Type Fonts that are involved, can't you just increase the column width slightly.
By the way you getter better responses for Access/Excel questions on the Business Applications Forum.
 

2 more replies
Relevance 47.56%
Question: MS Access database

I am developing an Access database, one of the uses for which will be mail merging letters and mailing labels. The database records all contain an Area field, which contains an area code in the range 1-10. I've created a query which allows the viewing of records for specific areas (i.e. it filters the data so I can see just area 1, just area 2, etc). Instead of having a separate query for each area I put [Area?] in the Criteria for Area on the query design so that a box appears when I run the query into which I can enter the area code I want, click OK, and then that area is displayed. This all works fine.However, when I come to try mail merging, the query is not visible in the list of ones I can select in Word! If I make a query without the [Area?] variable in then it works OK (i.e. if I specify "1" as the area criteria).Can anyone advise what I'm doing wrong?

Answer:MS Access database

Searching around on the internet, I found a solution to this.Within Word, you have to go into Tools > Options > General Tab and select confirm conversion at Open. This, for some reason, displays a different menu when you select the database as the source for the mailmerge, from which you can select a DDE connection which then gives you the full list of tables and queries from Access.

1 more replies
Relevance 47.56%

i think this is the place to post my questions. hear goes.....

my sup wants me to design a database to log network equipment with their corresponding users. now i plan to do this in m$ access 2003 and have created all the necessary fields so far and customized them to what they ought to be.

question #1 what should i do next??
question #2 give me some ideas please of how to really get this database app going please.
question #3 how do i make it seem like a program for the end user.

please help.
if you got any questions please feel free to ask.

Answer:database in access.

create a form by using wizard

3 more replies
Relevance 47.56%

What I have done is combine the Order Entry, Inventory Control and Customer Management databases together in Access 97 and I’m trying to get them to work together to be able to update when inventory comes in and goes out of my business.

I’m trying to figure out how to complete the actual receipt of merchandise on a purchase order in the database. I want to put in the current date or earlier (I may use yesterday's date when I finally get around to entering data) as my variables for the timing to update the inventory transaction table (units received and units on hand fields).

Can you give me the operators and operands in the expression builder and the complete proper syntax that I would need to tell an event has happened and to update the table.

Thank you in advance - you guys are so good!!
 

Answer:Help with Access 97 database

9 more replies
Relevance 47.56%

--------------------------------------------------------------------------------

Hey i need some help with a project i have for work.

my boss wants a type of program set up that controls our stock and products.

In this program i want to be able to input product codes categories invoices suppliers stock on shelf and stock on order and maybe a few similar things.

do u think microsoft access will be able to help me create this? or is there another program out there that will make it easier to do?

please help i havent started it yet just trying to educate myself as best i can and everday my boss asks how its all goin.
 

Answer:database help access 03?

Access is perfect for this application.
What kind of products are you dealing with?
Do you "Supplier" lists?
Do you have more than one Supplier for items.
Is the stock used within your area ie by yourselves rather than being sold to a Customer?
Do you want Categories and Sub Categories of stock?
Do you have "Re-Order" levels? (Minimum stock when a new order is required)
 

2 more replies
Relevance 47.56%
Question: ACCESS DATABASE

I have set up a database and form saving an old database and form. It has worked but the automatic numbering for each of the forms will not zero. Any ideas, as I can't understand the help responses.

Answer:ACCESS DATABASE

The only wat to reset an auto number in access is to compact and repair

4 more replies
Relevance 47.56%

My son is trying to design a booking system for time slots completely in Access as part of a college project. We are having trouble in making the availability of a slot conditional on it not having been booked already.We have designed a booking form which offers timeslots in the form of a combo list box. We are able to apply validation to eliminate multiple bookings, however we would like the booking form to only offer available time slots (and not to display those already booked). Any ideas how this can be achieved please?

Answer:Access database - help please

I don't know if the following link will be any good to you but it seems to cover a similar topicclick here

4 more replies
Relevance 47.56%
Question: Access DataBase

I have an access database, one of the forms I am working with has a subform. I want to be able to print part of the main form, and parts of the suboform. I can do this by inserting the form key number and the subform key number, then it prints what I want. What I am looking for is to be able to be in a clients record and push print and without having to enter anything it prints the fields in the form and the subform that I have in a report. I hope this makes sense. Is there a macro that I can put together to do this?

Thank you in advance for any help. .
Chad
 

Answer:Access DataBase

The simplest way although it may not seem like it, is to do the following:
Create a Join Query that includes both tables/queries (whatever your using), and create Joins on the 2 Key fields (related), this query should then become the control source for you report.
Now in the new query go to the field that contains the data you will be selecting on the form. eg the ID for the Main form

In the criteria row right click and select Build, find your form and find the Id field control name. The syntax will be:

[Forms]![FormName]![ControlName]
Now if you don't already have one, place a button on your form that opens the Report or query, it should only display the records for the selected records.

This called "Filter by Form"
Any problems let me know I or some one else can walk you through, it works I use it all the time.
 

1 more replies
Relevance 47.56%
Question: Access database

I am trying to produce an access database for client names and addresses to be entered using a form but I want the establishment address to be automatically completed if the establishment name when entered is in an existing table of names and addresses. I want to store the address in the new client database table and be able to add a new address if the establishment name does not already exist.

I have tried various ways of doing this including dlookup, and on afterevent with no success. It seems a very logical thing to do but I cannot get Access to do it. I would be grateful for any help.

Many thanks
 

More replies
Relevance 47.56%
Question: MS Access Database

I have a working Access database on a machine running WIN XP and MS Office 2003. I transferred that database file to a new machine running Vista Ultimate and MS Office 2007. When I try to open the database on the new machine, I get this message: missing reference dao2535.tlb. How do I resolve this?
 

Answer:MS Access Database

Open your database.
Hit Alt+F11.
Hit Tools-->References.
It would seem it's missing from there.

See:
http://support.microsoft.com/default.aspx/kb/824259
 

2 more replies
Relevance 47.56%
Question: MS Access Database

Father is running a television repair business. I thought that an access database would be a great way to log in when a customer called. Some information on the customer, television type, the problem etc.

I've looked through the microsoft template, I found a 2003 version of the database program that I want but it involves a lot of b.s. that I can't figure out. the 2007 versions are a bit more user friendly, but I'd rather turn the 2007 version to want 2003 can do or atleast the template does. It's found here,
customer Management
the really cool part about this database is probably the different things you can do. One, you can create an invoice based on the items you set to price and add the taxes to them, then you can add things like different employee's etc etc. I've tried to do it myself, but, there's no real 'help' and i honestly don't know my way around access.

Answer:MS Access Database

Hello,

If you want to save the access database as 2003 open the database and do file save as and 2003 but you may loose some functionality

4 more replies
Relevance 47.56%
Relevance 47.56%
Question: Access Database

I am using a form to enter data that is updated to table. The problem is that the calculated fields in the Form do not update in the table while everything eles does. Can anyone help please.
 

Answer:Access Database

Generally, calculated data isn't stored in tables. There is no need for it. If you calculate data, you use it in queries or reports . . . when you create a report, you base it on your query, not your table.
 

1 more replies
Relevance 47.56%
Question: Access database

I have an access data base program that we use as our special orders program, we use to be able to have more than one person log into this, but now only one at a time is able to.. The file is shared for all users.

thanks.
 

Answer:Access database

10 more replies
Relevance 47.56%
Question: Access Database

I have this access database that I from another user which I want to customize so that I can use it. The form has about 28 records with a yes or no fields. Now what I need to do is add more records as I have stuff to add that will require the user to ans. with a yes or no answer. My problem is that I am unable to add more questions (lines or record). Is there a way to do that?
 

Answer:Access Database

8 more replies
Relevance 47.56%
Question: Access Database

I am unable to pen my database. It gave me an error message saying it is corrupted. I tried to do repair it but I was unsuccessful.

HELP
 

Answer:Access Database

Don't you have any Back-ups?
Try opening a "new Blank" database and on the Main Menu, File>Get External Data>Import and then point it the corrupted file just to see if it can be opened that way.
If it can then on each set of Controls (tables, queries, forms etc) click selct all and then OK
 

1 more replies
Relevance 47.56%
Question: Access Database

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual Basic..to have the form blank..when entering the form..so that you can just add..new data..instead of having to click on add new data..
 

Answer:Access Database

First, this is really the wrong forum for this question. It should either be in Applications or Development. I only saw this post because I was checking on a post I made here before but I don't usualy visit this forum often.

If you want a form to open ready to take new data, set it's Data Entry property to Yes. (You'll find that property in the Data tab of the forms properties.) If I misunderstood the question, post back and give more details.

Good Luck!

[This message has been edited by YSB (edited 08-10-2000).]
 

2 more replies
Relevance 47.56%
Question: Access Database

Hi i created an access database for students that keeps track of their personal information as well as a monthly evaluation that they have to fill out, however i do not know how to create a button that i can place on the form that can allow the administrator to go to each student by either last name... sort of like a search engine. I don't know how to do this though, as well as just making a query that only gives me information for just 1 person and i don't have to manually put in the information in the criteria.. this i would also like to make a button or something of that sort..

please help!!! I'm close but no cigar!
 

Answer:Access Database

8 more replies
Relevance 47.56%
Question: access database

I have created a tracking program using access, the main tracking page contains name, address, phone numbers, computer information etc. I also have two fields that I insert the problem, and then the fix, then that is printed out to give to the customer. whenever the customer brings their computer back in for service, I do a search for their account, and it brings up all the pre existing info. There last problem and cure are still in there... I would like to find some way if it's possible to make this dump the items to a database for each customer in case I want to go into it again and look at past events. Then the next time I open their account, the problem and cure fields are empty, but their data past problem and cure will still be in there.....
I almost have this program or database to where it will do everything that I want it to do.

Any help would be very much appreciated.
Thanks
chad
 

Answer:access database

10 more replies
Relevance 47.56%
Question: access Database

I have a database where I enter part number description, and cost. I also have another database that is updated all the time with this information in it. I would like to be able to link or however you do it. I would like to lets say put in the part number and then when I push enter or tab the description and cost field populates.

any help would be great.
 

Answer:access Database

you can link by selecting the table tab in the DB window and then click NEW followed by selecting Link. Then search for your other database and select the table you want to link to.

You will now have access to all the fields, it is the same as a table now except you may have sharing issues if the table is opened on the source DB.

You can use this linked table just as a regular table to make reports forms, queries etc. so you may not need the table you created with the same information as it is redundant.

So you can make a form with your linked table with a combo to select the product.
=========================================================
I don't know to what degree of detail you want or how much you know so if you need more help just post back.
 

2 more replies
Relevance 47.56%
Question: Access Database

Hi

I have a DB that I did. It works fine except when I click on a cancel button on a text box and then it gives me the error shown below. Im totally lost as to why its doing this. If anyone can help I would appreciate it. Even just pointing me in the right direction. I posted it as a zip file on this site

http://www.geocities.com/jbfen/index

the password is horror (and sorry for subject matter of horror movies)
 

Answer:Access Database

Listen...I looked and can't find anything wrong with it. I recreated the button (find by director), and it appears to work fine...just tells you the macro has been cancelled.

This isn't the first time I've been unable to find something wrong with something in Access...I'm pretty sure it's not uncommon either.
 

3 more replies
Relevance 47.56%
Question: Access Database

I need help in creating a database that can be searched.

3 Items are needed...

A 2 digit year entry
A 6 digit numerical entry (need to be able to enter less digits)
A 4 digit numerical entry (need to be able to enter less digits)

I need to be able to search the 6 digit number and have it tell me what 4 digit number is associated with it.

I am hoping I am making this clear...

for Access 07 or 03? (the previous version)

TIA

Tom
 

Answer:Access Database

16 more replies
Relevance 47.56%
Question: ACcess Database

I have this access database that I got from another company and I would like to use it but I would have to customize it to fit my needs. Is that possible
 

Answer:ACcess Database

7 more replies
Relevance 47.56%
Question: Access database

Hi, i'm new for using database (mic. access)
i hope u can help me.
i'm currently developed a database using microsoft access. the database is about an insurance company. i need to do a database that store the unit manager, agen, client, policy and proposal.
i had build the table and relationship. i also had input the agen and unit manager (UM).
but what should i do now.
i need to separate each agen according to the um and also the client.
i also need to give output so that when i insert um code or agen code, user can see the client info, or the agen info.

please.. i really need your help...
 

Answer:Access database

16 more replies
Relevance 47.56%

Hi,I have a simple MS Access database that has a nice an simple Import routine, whereby an excel file is imported when the user clicks import. Would it be possible for me to somehow log the path of the excel file that has been imported and record the windows user name that performed the import, in a simple report or table - E.g.Date:File:User:Thanks for any help.

Answer:Access Database Help

No-One???

5 more replies
Relevance 47.56%

Hi

I have a MS Access database with forms, reports, queries, switchboard & so on. I would like to move it to a web server... since it is used by multiple users on one network it is getting a bit slow..

Any suggestions for an easy way to do this and keep everything working

Thanks in advance

Ryan

More replies
Relevance 47.56%
Question: Access database

Hi

I have a requirement to allow the user to do a 'compact and repair' from the system I have developed. I have looked at some code online and tried the following:

https://www.experts-exchange.com/viewCodeSnippet.jsp?codeSnippetId=10-28247792-1

but this is failing with the following message

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Any ideas why this is failing? or is there a better method?

Cheers
Code:
using JRO;
private void CompactDatabase(string Path, string Database, string Password="")
{

string Database2 = Database + "1";
string oldmdbfile = "";
string newmdbfile = "";

if (Password != "")
{
oldmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + Database + ";Persist Security Info=True;Jet OLEDB:Database Password='" + Password + "';";
newmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + Database2 + ";Persist Security Info=True;Jet OLEDB:Database Password='" + Password + "';";

}
else
{
oldmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + Database + ";";
newmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Sou... Read more

More replies
Relevance 47.56%
Question: Access Database

Hi all,

I have an issue with an access database. When I print out a report one of my columns only prints out 4 out of the 5 digits. This happens with 2 machines. On other pcs the 5 digits appear in output of the report. I have checked the resolutions of the pcs and they are the same. I have expanded the column widths in design view and still the problem persists. I cannot figure out why only 4 digits appear out of the 5.

Can anybody help?

thanks
 

Answer:Access Database

7 more replies
Relevance 47.56%

I have a database for an engineering project that has 3 main tables. These are the ProjectCode, the Area and the Costs
The ProjectCode has multiple Areas and the Areas have multiple Costs. Data entry to the Costs table includes a [ProjectCode], [Area] and an [Amount Aus]

My Area Table has all the area / project code combinations entered as these all have an individual budget figure that needs the costs to compare to

I want my database to be able to sum up the [Amount Aus] in the costs table and update the field [AmountAus] in the Area table, but only for the costs that match the [ProjectCode] and [Area]

Area Table
AutoIDBudgetAusAmountAusAreadDescriptProjectCodeArea4$900,700.00 Crushing1125$1,939,820.00 Process Plant Design 015$1,413,854.67 Milling126$953,957.33 Flotation137$450,176.00 CIL148$356,532.00 Elution / Recovery159$140,000.00 Reagents1610$254,666.67 Plant Services1711$362,757.33 Concentrate Handling1812$1,096,594.67 Village / Camp12026$32,609.33 Village & Camp02013$2,662,938.67 Mining Services12114$0.00 Gold Recovery12215$3,312,594.67 Plant HV Power Distribution12316$449,604.00 Communications12417$584,370.67 Construction Tools / Equip12518$740,558.67 Travel12619$1,270,021.33 Plant Buildings12727$42,493.33 Budget Re-validation02820$0.00 Meetings & Administration12921$1,270,021.33 Roaster14122$0.00 Waste Heat Recovery14228$32,609.33 Waste Heat Recovery04223 Power Station14329$70,852.00 Power Station04324$0.00 Off-Gas14430$30,916.00 Off-Gas044

Cost T... Read more

Answer:Access Database Help

Database

I have attached a word document that shows structure as the tables didn't work on my thread
 

3 more replies
Relevance 47.56%

I have two separate access database files that I cannot access. when I try to open either one it says unrecognized database format. When I tried to compact and repair, it says the same thing. how can I get back into these databases?
 

More replies
Relevance 47.56%

ok , i finally got a site , with some ex. for loading jpg into ACCESS,

http://members.tripod.com/accdevel/imaging.htm
http://www.lebans.com/loadsavejpeg.htm
ok now without eating any1's head, i have to create a small catalog, with itemcode and pic of the item,both have to be related ,so tha I can search , for itemcode adn get the picture....

now both of above ex. codes are free and can be changed, so any1 cna help me out here,who konws access in advance , modify the scripts above if they can , so taht I am asked for like item code and pic.......

!!!!!!
 

More replies
Relevance 47.56%

I have an access 2003 database that calls a VB6 module. The module starts and then I get a run-time error 75 path/file access error. I can execute the vb module outside of access but I have to run as administrator for it to work correctly. What can I fix so that the call from access will execute? I believe the issue is with comctl32.ocx and the status bar control inside the vb module.

More replies
Relevance 47.56%

Hello, I am using Access 2000 and have created a database with a command button that opens up a report via a macro. I would like to know how to open up single reports instead of pushing a button that brings up every report, I've been able to open up reports that are based off of queries, queries that have paramenters that need to be inputted in order to bring up single unique records, but I would like to be able to just create a button that brings just that particular unique record-report off of that particular unique record on that form. Meaning that for a record that had just been inputted for John Doe on a form, I would like to know how to create a button on that form to pull up John Doe's single report without having to build a query that asks for a parameter. Is there anyway to do this?
 

Answer:Access-Printing a single report off of a single record from an Access database form

You will have to adapt this to your own form setup; but it's just using the Where line of the OpenReport macro action.

If on the form MyFormName you have two controls called txtFirstNm and txtLastNm, and in the query underlying the report you have two fields called FirstNm and LastNm, you would put into the Where line of the OpenReport action:

Code:
[FirstNm]=[Forms]![MyFormName]![txtFirstNm] And [LastNm]=[Forms]![MyFormName]![txtLastNm]
Hope that helps.
 

1 more replies
Relevance 47.15%

Hello there, this is my first thread I've been struggling with this for a few days already so I hope one of you can help me

I have a DB in which I store contact details like name, mobile, email, notes etc, etc
What I want to do is every time I write a note on whatever contact, somehow being able to show the date and time of that note. Also I'd like a box where I can add the notes in just like the Contacts Database template from Access 2010. I tried and succeeded to do so by using a different table to store the Notes, a filed with the automatic date and time and another field that looks up the names in the main table, but now that I know that adding lookups in tables is a sin (I can tell why, cos I'm not able to import data from excel) I'd like some help! anyone?
 

More replies
Relevance 47.15%

I picked up a "like new" R52 with a clean install of XP on it.  I am trying to get it back to the original Lenovo factory state.I have used the Thinkadvantage program to update all drivers, but I cannot get the "Access IBM" button to work and therefore cannot access the owners manual.The button will work on start up to get to the Bios screen,  but it does nothing when running under XP.1.  What SHOULD happen when I press it under XP?2.  I have installed the "Access IBM" program several times, but it does not show up under XP software listing (add or remove software).3.  Have installed Hot key features software, but when it finishes installing it gives a "program does not support this system" message....but R52 is listed as supported system.4.  Don't know what next step should be. Any help, suggestions or ideas will be appreciated.

More replies
Relevance 47.15%

Hello - Norway calling! My first post and the question may be regarded a simple one. Nevertheless, I need your advice.

I have a wireless connection in my house and I have one computer up and going. I am now trying to get my other laptop to connect to my router. It connects and I am receiving signals. However, I can not access any websites and I do not access the router (its a Fritz!Box).
I am sure there is a silly solution to this - what should I do?
(does one need more information to be able to give advice?)

Thanks and have a great one!
 

Answer:Newbie trying to get internet access.

14 more replies
Relevance 47.15%

I am trying to install Outlook 2000. I get ..."Error 1919, error configuring ODBC data source, ODBC error 6, MS access database component not found in registry. Verify that the file MS access database exists and that you can access it." I have tried searching for this file with out luck. I have downloaded all XP updates. The "free" expert phone consultation that comes with certain services and hardwear, had me doing a lot of reconfiguring of my system to solve other problems. All kinds of things didn't work after that. I have finally managed to get every thing working again, but wonder if this is something else that the "expert" had me turn off. Any suggestions would be appreciated.
 

Answer:can't find MS access database

Hi nvb,I dont know if this will help,I found it during a search,
This error is caused by missing operating system components on your PC. These components are required to connect to ODBC databases.

Resolution
1. Download and install Microsoft Data Access Components v2.7 from Microsoft. Note that the download link is at the bottom of the Microsoft's web page.
2.
Download and install Microsoft Jet 4.0 SP3 from Microsoft. Note that the download link is at the bottom of the Microsoft's web page

And I think the place to go to for that is here http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860
 

1 more replies
Relevance 47.15%

I have been playing around with my copy of MS Access just to try and find out how it works. I put a Table in and then a Form trying to show the Electricity readings and hence costs! (I have a similar one in Approach which works fine!)I have tried to get the Form to actually calculate the actual units used in a quarter by having Fields of "Present Reading" and another of "Previous Reading". The Units used then should be "Present Reading-Previous Reading". No it doesn't, it doesn't give any figures!This is what I have in Approach, but it will do nothing in Access. Is there any way that the Form can calculate the Units figure?I hasten to add, I am only playing with it to see if I can get it to operate as a reasonable Database, but I must admit, so far I have been singularly unsuccessful!!TonyV

Answer:MS Database Access 2000

You need to set the text boxes in the form to be "bound" to the fields in the table. You can do this by either using the Create Form wizard and selecting the fields or by setting them in the text boxes' properties (e.g. Control Source = "Present Reading"). You then create a new text box and set the Control Source property to "=[Present Reading]-[Previous Reading]"

6 more replies
Relevance 47.15%

i'm very much a beginner at java. i'm currently working on a database application and i'm using access to create my database. my instructions say that i'm to create a database w/ four tables and then lists the fields for each table. but i'm having a little trouble w/ the access part of this.

my problem is that my instructions for the fields will look something like this:

create table names (
personID int DEFAULT AUTOINCREMENT,
firstName varchar (30) NOT NULL,
lastName varchar (30) NOT NULL
)
i can create the table and, of course, i can create the fields, but i'm not sure where i need to implement "int DEFAULT AUTOINCREMENT" and "varchar (30) NOT NULL." will that be done in my java code or do i need to do that somehow in access? i'm not asking anyone to do my homework for me, i'm just having trouble w/ access. i've emailed my teacher w/ this same question, but i have a feeling that i'll get faster replies here. any help will be appreciated. thanks.
 

Answer:access database java help

Sorry, I do not know Java at all, but I do know Access. Those look like instructions to Access.
The first "int DEFAULT AUTOINCREMENT" means Use an Integer value and it is Autoincremented by the table.
The other 2 mean Text of 30 characters (maximum presumably" but must not be Null ie nothing, so an entry must be made.
Why not try implementing it and then make some entries and see if that is what happens.
 

1 more replies
Relevance 47.15%

hi i have a 2010 database with a form which is linked to a table, the form is made up of text boexes and combo boxes, i would like to creat a button that clears the data in the combo boxes only. can anyone help with this,. thanks in advance
 

Answer:Access 2010 database

6 more replies
Relevance 47.15%

I tried to open a database but I can't open it. I got an error message "unreconized database format". Is it corrupted? Please help me to fix and how can I open this database. thanks.
 

Answer:Access database problem

14 more replies
Relevance 47.15%

--------------------------------------------------------------------------------

Hey all,

I have at least two user's that access a 212 MB Access database. It was working fine up to a few days ago. Now they are having some funky stuff happening. Using both or either Access 2000 and Access 2003 they are getting this error message some times when they try to open the database:

"You do not have exclusive access to the database at this time. Any changes you make may not be saved."

This happens to multiple users. When they access the database a .ldb file appears indicating it is locked. Some times the user can make changes and some times not. The file is located in a place similar to this: G:\share\subfolder\atc board database.mdb

I've Google'd the error message and haven't found anything that really fixes the issue. Any thoughts?
 

Answer:Access database issue

Has one of the users set up a Short cut where the command line is using the Exclusive option?
Have you Compacted and Repaired the database?
 

3 more replies
Relevance 47.15%

i created an ms access database a while ago, locked it and now forgot the password. Is there any way to unlock it? thanks,

Christian K.
 

Answer:ms access database locked

Well, you could try downloading the trial version of this program:
http://www.5star-shareware.com/Business/MS-OfficeAdd-Ins/access-passkey.html
and it will tell you the first 2 letters of your password - it might help you remember...

These guys will apparently remove the password for free if you send them the file, but I've never used it, so caveat emptor...
http://www.intertek.org.uk/services/

There's lots of programs which you can buy to do the job, costing from $15 to $150....

HTH
Gram
 

1 more replies
Relevance 47.15%

Hello,

I am upgrading my membership database for local sports club

I am trying to visualize payments, but I dont know how to link the toggle buttons in my form with table fields (see attached file)
 

Answer:MS Access members database

Can you tell me what the database is designed to do?
As it does not appear to be designed correctly for keeping records of membership payments etc.
What are the p, n, s and plj field for?
 

2 more replies
Relevance 47.15%

i have microsoft access and the database doesn't have any login or anything and i can't change the tables or anything. it is read only and does the system.mdw have to be in the same folder of the database?

Answer:permission for access database

I wouldn't think so but what problem are you having?

1 more replies
Relevance 47.15%

I have following Raw material in my kitchen
Flour 10Kg
Sugar 10Kg
Butter 5Kg

The recipe for butter cookies (1Kg)
Flour 700g
Butter 200g
Sugar 100g

Objective: I would like to design a database using Access 2007. If I prepared 3Kg of Butter cookies, I want to calculate remaining stock based on this recipe

Answer:Help me to create a Access Database

Hi Yalpanam,

Is this for a school project?

2 more replies
Relevance 47.15%

Hi all,

A few months ago I was asked to build a supply and demand database. Sounds simple in theory - a database that draws a supply line and a demand line on a graph with a couple reports. Voila. I am a complete DB novice and posted here back then asking for some help. Fast forward a few months and I'm pleased to say that I got it to work however, it has severe limitations, the data is in one big table rather than in several joined by queries, it's very slow and not really user friendly.

I've essentially decided to build something from scratch as I've been asked to bring in a new team and the current database just isn't scalable. I'm looking for some advice on the best way to do this to avoid repeating the same mistakes I made a few months ago.

I'm starting with a table imported from a sharepoint list. In this list, I need 4 pieces of info, ID (essentially the sharepoint's primary key), project ID, Project Name and Project Manager. I've created a query to that effect and I've got the info I need showing on the datasheet view.

I then need a table, connected via the "ID" field, that I can record the number of days spent per month working on each project. I'm getting stuck here as I skipped this part by having one big table the last time. I need to be able to record it up to 3 years in advance, depending on the project duration. I.e. there will be 36 lines per project.

I also need a 3rd table that records sta... Read more

Answer:MS Access Database Noob

16 more replies
Relevance 47.15%

click hereIf you take a look at the above image you can see that all i want to do is be able to add a Customer into the form and then check wehter the room is booked in another form. Does anyone know if this is possible and how I would be able to go about it?Thanks,Live Wire

Answer:Access Database Impossible - Help?

Furthermore, if I wanted to remove a customer than I would need to delete his record.However, if I do this I will have no back up data of him. I assume I cant keep a record of customers becuase if I want to clear the room than he will dissappear from the database completely????

3 more replies
Relevance 47.15%

Does anyone know of a program/option/tool to repair a microsoft access database that can be run from command line (I don't want any user interaction, I want to be able to schedule it).

The systems do not have Microsoft Access installed, they use a Delphi program with ado connections to an ms access db, and the delphi program runs a compact every time it opens, but the db still gets corrupted and needs repair from time to time.

Currently, I have to log onto the machine, open odbc and do a repair through that, but I would like to be able to schedule a regular repair to run without needing a connection to the db, and hopefully avoiding the user ever seeing the error message.

So far, all I have been able to find are programs that use a gui interface (which I can do with the odbc), or programs that require ms acess or ms access runtime installed, neither of which exists on these machines.

Any suggestions are appreciated!

Thanks
 

More replies
Relevance 47.15%

Is there a way in an access database to not display data that is older than the data that is being entered?

For example, I have a database that keeps track of when users become certified. I do not want to get rid of the old information, but I do not want to display the old data on the form.
 

Answer:Solved: Access Database

16 more replies
Relevance 47.15%

Hi, not sure if anyone here will be able to help me out here, but I am currently studying databases, and am a bit stuck on a particular link between the following 2 tables:- 'Jobs' (Primary key = JOBID) - 'Employees' (Primary key = EMPLOYEEID)Each job can have more than one employee involved, and each employee can have more than one job involved. I believe this is a many-to-many relationship and I understand that I need a linking table.Does anyone know how to do this so that when I go onto the employee table, I am shown a list of jobs, and vice versa?Regards, Tom

Answer:MS Access Database - Many to many relationship

Just worked it out! No probs =D

1 more replies
Relevance 47.15%

Hi there,

Just checking with you guys.

Will this database work if a job needed one or more parts?

I can post a print screen of the relationships between the tables.
 

Answer:Should this work Access Database

16 more replies
Relevance 47.15%

I want to make a database listing CDs and track titles. I can't figure out how to go about this, since the number of tracks vary so widely on different CDs. Some CDs have 23 tracks! Do I need to create 23 fields just for those few?

Better yet, can I make an expandable field that will keep creating new data fields as needed?

I know how to set up a basic database, so I don't need help with that.

Thanks.

Answer:MS-Access: How to Create a CD Database

The idea that you propose in having a single table that lists the CD Name (Album Name) and the tracks together as a single line item isn't a very effective method of making that database for exactly the reasons you raised. Rather than having them in one table, split them up and relate them.

The way I would go about doing this is...

Table 1: Albums
Fields: Album Name, Artist, Year, Genre, Whatever other fields you might add
Primary Key: Either make it a composite key with Album Name and Artist or create an additional field which contains a unique identifier such as a Number. I would suggest creating a unique field as the primary key as it is easier to work with.

Table 2: Tracks
Fields: Song Title, Artist, Album, Track Number
Primary Key: I would go with Song Title and Artist as a composite Primary Key.

Table 3: Artists (If you so choose)
Fields: Artist, any other info about the artist or group you wish to include.
Primary Key: Artist Name

The important thing is the relationships between these three tables.

Albums Table is related to Tracks Table in a One to Many Relationship (One album has Many songs).

Albums Table is also related to the Artist Table in a One to Many Relationship as well (One Artist may have Many Albums).

You need to determine what you want to have as your primary keys which will determine what the foreign keys will be in the related tables. For example, if in the Albums Table you use the Name and Artist as the Primary Key, then these fields would... Read more

1 more replies
Relevance 47.15%

Hi, I'm having problems opening my access database - I've an awful feeling its corrupt. I get this message when I try ot open it ...
Unrecognized database format and it lists the file path. The file is in .mdb format so I'm confused as to why it won't open. I need this file to be accessible as its got 2 weeks worth of data on it - both of my backups are corrupt too
Any ideas ...
 

Answer:Corrupt access database

13 more replies
Relevance 47.15%

I have a membership database created by someone who is no longer available to consult. It contains fields to check for organizations joined. The information was for 2008. I am getting ready for a new year and would like to keep the 2008 information but create a new form that clears those fields to insert 2009 information. Do I need to copy the 2008 database and save as 2009. I know this will sound crazy, but how do I do that? When I open the document and click save as it says save switchboard to _____________; save as _____________
 

Answer:access 2000 database

16 more replies
Relevance 47.15%

Hi.. I've been asked to do up an access database to keep records for a computer workshop.. My knowledge on Access is a tad (ok maybe fairly) rusty..

Here's what I've got in mind.. (see attachment).. hope that you can read my scribble.

I'm just not sure on how to get access to actually perform the phone number lookup to see if the customer exists in the database, and also use the customers info to link (or fill) fields in the jobs table.. so basically each time a service job comes in the customer doesn't need to be re-created in the database each time.
 

Answer:Service Database in access

8 more replies
Relevance 47.15%

I have an Access database which was copied to an USB device and has become corrupt. I am getting the following error message: The Microsoft Jet database engine could not find the object 'Databases'. Make sure the object exists and that you spell its name and the path name correctly. (Microsoft JET Database Engine). I have attempted to repair the database, run the JETCOMP.exe, import the data from another Access database, SQL Server, Excel; and continue to get the same error. I do not need the forms, queries, reports or macro's, only the table data. I am looking for a reliable company to look at the database and extract the data or software to get the data out. Thanks.

Answer:How to do Access Database repair?

firstly make a copy of your database so that you have a backup just in case any attempts to recover the tables destroys the database. 1) Backup2) Shift and open your database3) compact and repairif that doesnt work thenCreate a new Access database and try to import your tables (i note you have tried this already) soWhat happened?did the table import but were corrupt?did you receive an error during import?I have never used the below tool below but a google search recommended this, it is free so no harm in tryinghttp://downloads.tomsguide.com/Repa...

3 more replies
Relevance 47.15%

Hello:
I have this database that I need to complete. I have completed the basics but can not seem to figure ot how to do the rest of it. Can someone help me.

Here is what I am trying to do:
1. Final section greyed out when no is selected for response
2. Change current stage field when key fields are populated
For example:
- When exit meeting is entered, the current stage should automatically change to tracking.
- When response needed is not checked, current stage should be completed.
- When response needed is checked, current stage should be in acknowledgement.
3. Have the BOG and Internal Due Dates Met fields automatically calculated in the background

In addition: I also need a switchboard created but I think I can figure it out. I do have reports I need though.
1. Open Report
2. Tracking Report
3. Completed Report
4. Acknowledgement Report

I have attached the file. Thank so much
 

Answer:Need Help with Access Database/MACRO

16 more replies
Relevance 47.15%

Hello All.

I am 17 years old currently studying ICT for As-level. For my coursework we have to create a database for a business(real or not..doesn't really matter). We have been working on this for several months now and we are currently on the implementation section which consists of actually creating the database.

I have so far, successfully managed to make everything work, until now. My database is for a newsagents but they are unaware of this creation.

I have created a form entitled Customer Sales Receipt which is based upon all entities from two tables named Customer Sales Receipt and Sales Details. I also have a similar form entitled Purchase Orders which is based upon all entities from two tables named Purchase Orders and Order Details.

I seem to be having trouble with the SaleID in this two forms. It is meant to be an Autonumber but when i try to add a new record to either form the autonumber does not show up. I then get a pop-up telling me that

'The field 'SalesDetails.SaleID' cannot contain a Null value because the require property for this field is set to True. Enter a value in this field'

This comes up after I have selected the ProductID in the subform of the customer sales receipt. Upon attempting to close the form I get a message saying 'You cannot add or change a record because a related record is required in table 'Customer Sales Receipt'.

I tried using the Access Help files but they are pretty much useless to m... Read more

Answer:Access Database Problems.

8 more replies
Relevance 47.15%

I have several databases in Access 97 that reach their maximum size during operation. I have to compact the database and start over each time. It sure would be nice to be able to insert some code in the startup module/macro that would compact the database before running the remaining code.
Is it possible to compact the database that is currently open with some code in the startup macro/module?
 

Answer:Access Compacting a database

Databases must be closed in order to compact.
A closed DB cannot run VBA.
You'll be happy to know that Access 2K has a "compact on close" feature.

But check this out:
http://www.mvps.org/access/general/gen0013.htm
 

2 more replies
Relevance 47.15%

Season's Greetings!

Anyone have any rcommendations for a free or inexpensive alternative software to MS Access that can open and work *.mdb files?

Thanks,

Geolbob
 

Answer:MS Access Database Alternative

Hi

Their is Open Office 2.1.0 and its Access clone in BASE, but from what I have read its not as good as Access, but maybe worth a test on a backup DB to see if it fullfills your need?
 

1 more replies
Relevance 47.15%

hi everyone
i have question may someone can help me please
if i want make id card for some employer by Microsoft Access is this program helpful for this
cand i make design for id and put it Microsoft Access and put information in it and like this

i think may question is not verey clear but any way you can tray to understand
at the end could i make database by Microsoft Access

 

Answer:about Microsoft Access for database

no one can help
 

2 more replies
Relevance 47.15%

Hi
I have downloaded a free Bill of Materials that I have modified
slightly to handle my data. The problem I have is that in the output table it doesn't display the ProductID. I have tried to do this with a query but when selecting the ParentID the query shows all instances of the componets.
Question is can anybody add the ParentID to the output table I have read through the module and it may as well be written in Martian!!!

Module for BOM:
Option Compare Database
Option Explicit

'The Bill of materials processor:
' is designed to allow you to decompose an assembly into its component items.
' operates at multiple levels, where each item at each level can be a component
' or a sub-assembly. (SubAssemblies are further decomposed by the breakdown).
' uses 3 tables
' :Table 1, Assemblies contains the list of items needed to assemble any assembly.
' the items can be subassemblies or components.
' Comprises the following fields.
' : ComponentID, a text field to allow the user to recognise the item.
' : ParentID, a code field to allow linking.
' : NumberRequired, The number of units required for this level of this assembly.
' For a given assembly, the items that go into its construction are entered into the
' ComponentID field, while the parentID contains the code identifying the given assembly.
'
'Table 2, Components contains the list of items recognised by the Ass... Read more

More replies
Relevance 47.15%

I am configuring a new machine with Windows Vista Home Basic and trying to access a database on a Windows XP professional machine acting as a server.. this is a peer to peer network..

I am running Microsoft Access 2002..

When I click on the icon it opens Microsoft access, but then I get an error that says

"Microsoft Access cannot open this file"
" This file is located outside your intranet or on an untrusted site. Microsoft Access will not open this file due to potential security problems."

It opens it fine if I copy the file to this computer..

What am I missing???

Both pc's are in the same workgroup and the file has security set for full access to everyone..

Thanks for any help..
 

Answer:Cannot open Access database

romlisys, can you create a new Blank Database on the "Server", close it and then open that?
If you can then I would suggest that you open that database and "Import" everything from the copy of the original on your computer (that you can open). You will need to import all of the
Tables, Queries, Forms, Reports, Macros and Modules. It is very quick because you can use "Select all" for each section.

If you can't open a new Blank database it would suggest that you have some "Folder" permission type problems.
 

2 more replies
Relevance 47.15%

I have a database that has failed to open. {pervously accessible on a network}. I want to copy files from this database and use them in a new database. Its called MPO.mdb and its path is C:\Users\Fred\Desktop\MPO. The table in MPO is lkagent. The path for the new database is C:\Users\Fred\Desktop\MPO2. Any help

Answer:Corrupt ms access database

I dont mind if the solution is a DOS solution.Thx

5 more replies
Relevance 47.15%
Answer:MS Access - building a new database

A friend of mine is starting a database for the first time. The help files to Access have not been installed and she cannot find the install disks.Rather than talking her through the whole process, does anybody know of a website that shows basic database theory, possibly with a beginners guide to MS Access thrown in?Any leads would be very helpful.

5 more replies
Relevance 47.15%

Hi All - I'm the new girl on the block and any assistance you could provide would be greatly appreciated!! To begin I'm developing a Training Provider db in Access to hold various information. I've been going nuts for most of the day trying to figure out how to create a search field. I want to be able to pull information by provider, instead of scrolling through each record. This is my 1st attempt to ever create my own db and I really want it to run smoothly. It would be fantastic if someone could teach me how to create a search field.
 

Answer:Search an Access Database

Welcome to Tech Guy, new girl! I'm the old girl on the block, hee hee.

Guess what. It's sooo easy, and the instructions are right here:
http://www.theofficeexperts.com/access.htm#SearchForm

Oh...I changed the title of your post. Sometimes, people only have a few minutes to answer questions (usually 'cause they're at work and oughtta be working, LOL), so it's best to provide the application in the title name, and also put the version in the body of your post. Some people put that stuff in their signature so they don't have to remember it every time.
 

2 more replies
Relevance 47.15%

Is there a way to check or uncheck references using code in Access?

I have a database that will be opened by Access 2003 or 2007. Both versions will need to be able to use the Access Reference "Microsoft Outlook 11.0 Object Library" or "Microsoft Outlook 12.0 Object Library".
 

Answer:Access Database - References

6 more replies