Windows Support Forum

Access 2007 Database

Q: Access 2007 Database

Hi Everyone I am new to techguy so if I am posting this in the wrong forum please point me to in the right direction I am working on a database project that involves skip tracing loan borrowers and cosigners who have bad phone numbers The process begins with a list that includes their names SSN last known address email address loan number balances charge off status and how many days past due After the list is work it gets added to an excel spreadsheet with new information such as phone number accounts that were found gets added to the bal found column charge off accounts gets added to the charge off column track source is added in I am designing a database to help Access 2007 Database keep track of resolved account their balances how many times the account have been Access 2007 Database review last date of review and so forth Again I am new to database and this is a real world app I am working on just started and I am stuck on the table and relationship I am attaching a screen shot of the tables I have so any suggestions and input will highly be appreciated Thanks in advance nbsp

Relevancy 100%
Preferred Solution: Access 2007 Database

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/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevancy 76.97%

I m trying to get the results of Access queries to be linked to an Excel workbook I ve been using the Data tab in Excel clicking the quot From Access quot button in the upper left / - 2007 to database Access Solved: a 2007 Excel Linking and choosing Solved: Access 2007 / Excel 2007 - Linking to a database the Access database Then it asks what query I want to link The problem arises when I try to link a specific query which we ll call qry x This query is based on Solved: Access 2007 / Excel 2007 - Linking to a database several other queries one of which is qry z Frustratingly when I try to link qry x to the Excel workbook I get an error Solved: Access 2007 / Excel 2007 - Linking to a database message that says that Access can t find qry z and suggests maybe I spelled the name incorrectly However qry z definitely exists as part of the database and when I run qry x which is based on qry z in Access the correct results are displayed with no error Note qry x is the only query this is happening to I can link any other query with no problem at all including qry z What could be going wrong Thanks in advance nbsp

Relevancy 73.1%

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?

A: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.

http://www.sevenforums.com/microsoft-office/191698-any-problems-using-access-2007-database-access-2010-a.html
Relevancy 71.81%

I have been searching for a while for the answer to my question with very little luck. So I thought that I would ask on how to this without my file becoming so large in my tables.

My issue is that I am trying to figure out how to do a long range schedule with no consistent work schedule. Things are constantly changing where I work and need a better way to track who is suppose to work what days. Is there something that I am missing in database design to figure this out.
 

A:Access 2007 Database for Scheduling

Zedrenael, welcome to the Forum.
I am not sure what your problem is regarding "how to this without my file becoming so large in my tables".
I can't work with Access 2007 only Access 2000-2003.
Can you show me Screen Shot of your Table Relationships?
Can you provide a brief description of what the currrent database does?
I have created a few "Appointment" type databases which is similar in concept to Scheduling so if I knew what you were trying to do I may be able to help.
I am in the UK and I am about to sign of the Forum, but I will be back on tomorrow.
 

https://forums.techguy.org/threads/access-2007-database-for-scheduling.1029246/
Relevancy 71.81%

when trying to open an access database i get the following error:

'the expression On Open you entered as the event property setting produced the following error: Object or class does not support this set of events.'

I know next to nothing about access databases, anyone got any idea what's wrong or how to fix it?
 

A:Access 2007 database error

matt, welcome to the Forum.
It sounds like Access has a Form to open when you open the database, it is usually a Switchboard.
Does the Error message include a "Debbug" button?
Can you still look at the database after the error message?
 

https://forums.techguy.org/threads/access-2007-database-error.880549/
Relevancy 71.81%

I have an Access 2007 database. On the main form there is a command button that opens a table. If the user adds a record to the table, how would I requery the combobox on the form to show that new record?
 

https://forums.techguy.org/threads/solved-access-2007-database.753223/
Relevancy 71.81%

Hi Solved: Database 2007 MS Access I started using the Call Tracker template on MS Access for a new Call Logging System at work I am having trouble linking different fields to one another On the Call Lists page I have created Solved: MS Access 2007 Database new text box fields in design view However I can t get these fields to link with fields I created in the Call Details design view I have followed the same format the existing fields i e Title is in but I can t seem to get them to link properly I think it is done by using the Control Source but as I hae no experience on Access I m not sure if I am doing it right As well as this I need the text entered in these text fields to populate fields below it with information from another database that I have imported into the Call Tracker For example if I have three fields called Company Name Company ID and Customer ID and when text is entered into Company ID it looks up that ID in the other database and enters the required text Company Name Customer Name into the corresponding fields Any help would be appreciated Regards Archie nbsp

Relevancy 71.81%

I'm in the process of trying to teach myself Access 2007 and write a training database for my company all at once. The problem I'm stuck on at the moment is logging training for the employees. I have a table that has all the employee info (name, id, etc) and a table that has the training info in it (class name, date taken, instructor). What I need to be able to do is show the name of the class, the date and all the employees on the screen at once and then easily register them as having attended the class, preferably with a check box or something. Thanks for any suggestions.
 

A:Access 2007 Training Database

If you search this forum you are likely to find posts on a training database.
What you need is a "Many to Many" Linking or Joining Table. This table holds the EmployeeID and the CourseID from the other 2 tables plus any other data you might need, like pass level etc
 

https://forums.techguy.org/threads/access-2007-training-database.839207/
Relevancy 70.95%

Hey all I m currently creating a database as a project and I have nearly finished it but I have run into some major problems that I just can t seem to figure out I have three tables in my database TBLPRODUCT TBLSELLER and Database 2007 Access problems :( Solved: TBLPRODUCTSELLER The primary keys from TBLPRODUCT and TBLSELLER have been stored as foreign keys in TBLPRODUCTSELLER with the relationship to it from the two other tables being one-to-many Anyway I ve created a form that allows the user to view products from TBLPRODUCT I did this by creating a query that fetches all of the fields from TBLPRODUCT and places them onto the form Additionally I created a combobox that allows users to filter the records by the category so for instance electronics furniture etc However as each product has seller information attached to it which Solved: Access 2007 Database problems :( is linked by the primary keys of the TBLPRODUCT and TBLSELLER tables which are called PRODUCTID and SELLERID respectively I need that information to be viewable in the form for each record also so for instance I need the Seller First Name Seller Surname and Seller Telephone information for each product to be viewable The problem is that when I edit the query in the form to allow fields from TBLSELLER to be placed onto the form the form no longer works and now displays no records at all I don t want to use a subform because I just want the fields to look like the Product fields that are already on the form plus I already tried making a subform and it didn t work I am relatively new to databases and I m not proficient with code so if this can be solved without any code that would be great Thanks nbsp

Relevancy 70.95%

Hi I have a table which only ever has one record in it at a Access 2007 event Open Database time This record is created during the use of the database so when you first open the database there is Access 2007 Database Open event no record If the database is closed properly using buttons etc i have created then the record is deleted and the table is empty However if for some unforseen reason the database crashes or is closed a different way the record will not be deleted Because of this i d like to know what control you can have either when the database is first opened or when it is closed by any method of closing i e can i delete the record by default on opening the database Could i delete the record by default on closing the database Or if neither is possible is there a way Access 2007 Database Open event to drop and re create the table while opening or closing the database Help always appreciated Cheers Lewis nbsp

A:Access 2007 Database Open event

I normally have a splash form load that handles this type of stuff.

You could also use an macro named AutoExec that will be automatically run when the database loads.

You can use either of these methods to run an delete query to empty the table.

It also never hurts to also delete the record on close.

I use a main menu for that will not allow Access to close unless the user click the "exit" command button. This way I can be sure that code runs when the database is closed. This only takes a few lines of VBA code to implement. Let me know if you are interested in how to do this.
 

https://forums.techguy.org/threads/access-2007-database-open-event.956039/
Relevancy 70.95%

I am very novice at Access and have gone through most of the Microsoft online training tutorials but in building my database I feel there is a key point missing that will enable my database to work fluidly I am buliding a project management database At the end of the day I need to be able to view high level details about a project its budget and completion status I have created the main table for this with the appropriate headers My main confusion is how to get all of the information relationship and trouble Access 2007, database to work in sync I know have tables created each with specific breakdowns and any information data that would be entered regarding a project ie Dates budget completion status Person of contacts location etc I guess I m having trouble putting the last piece of the puzzle together to get these tables to interact with each other There are some Access 2007, database and relationship trouble fields that I need to auto populate taking the information from other tables I am just not sure how to go about it nbsp

A:Access 2007, database and relationship trouble

Without detailed information about the tables it will be very difficult to help you.

Do you have a question?
 

https://forums.techguy.org/threads/access-2007-database-and-relationship-trouble.949133/
Relevancy 70.95%

Greetings I m trying to develop design a very simple Access database that will allow me to create invoices Invoices Auto numbered invoices Ability to select the customer code and then Database - Invoicing form Access 2007 display the customer name balance of open invoices Able to select inventory info rows with item unit price quantity row total etc Invoice info and total should be able to be viewed under a tab in the Customer Master Able to key in a payment receipt details in a seperate tab under each invoice multiple rows which will allow for printing of a Receipt document vs total invoice if there is an example of partial payments Payment receipt can not exceed the invoice total Access 2007 Database - Invoicing form All invoices in total should be able to be updated backwards in regards to total on the Customer Master I m able to create the master data like Customer Master Employee Master Inventory Master but I have no idea on where and how to start with the Invoice area Any help would be great nbsp

Relevancy 70.95%

Hello

I am using Access 2007 under Vista in a Server 2003 environment.

The user has full rights to the DB and to the PC.

The database code appends a table and then exports the table to a folder on the PC. I get the message:

Database or object not updatable.

I use this exact code in Access2003 on several other work environments with no issue. I can export manually from this database.

Any ideas???
Thanks
 

https://forums.techguy.org/threads/access-2007-database-or-object-not-updatable.664602/
Relevancy 70.95%

Hi folks,

I made my database with a user interface. I have been using my desktop PC at work.
When I tried to query it (I was successful in opening it) with my personal laptop, I got this message:

"Your network access was interrupted. To continue, close the database, and then open it again"

Of course the patch they suggest, doesn't work...

Could you help me?

Thank for your time.
Have a good one

stefano
 

Relevancy 70.09%

Question:
I have a form that shows the user all their inputs for the day in a list box - they can click on a record and be presented with that input so that they may make changes and edit their input.

The coding to collect the primary key from their list works - I can show it on the new form BUT
how do I open the table so that it populates the form. Or do I have to collect all the fields in embedded SQL in VB - assign them to unbound fields in the form and when the user has finished editing, I have to use VB to update the fields.

I really hope there is an easier way to do this than the VB way.
 

Relevancy 70.09%

I have an "Unrecognized database format" error on access 2007 every time I try to open the file this pops up how do I fix it???

A:Access 2007...Unrecognized Database Format Error...

See if this helps: Unrecognized Database Format - Fix Corrupt Database

http://www.vistax64.com/software/295693-access-2007-unrecognized-database-format-error.html
Relevancy 70.09%

I have a 2007 database split to allow multiple users input information. One of the subforms on a form is not allowing input. The Record Sources check out all the way to the back end.

I am stumped! Please help.
 

A:2007 Access Database Subform not allowing additions

Can you Convert the database to Access 2003 format?
 

https://forums.techguy.org/threads/2007-access-database-subform-not-allowing-additions.1047969/
Relevancy 70.09%

I am a beginner trying to design a customer database in Access for my company They sent me to full days of classes on Access and I am still having trouble I mostly understand all of the basic concepts of Access but the design part is hard for me I half understand the point of normalizing and am having trouble with the concept that nothing can be repeated Every customer has a different amount on of Solved: Access Help in 2007 customer design database of information Some customers have addresses physical and mailing some don t Some customers have email addresses and phone number and some have email address and phone number In my database I want to include -Customer name -Address es -Phone number s -Fax numbers s -Email s -Contact Person s Solved: Help on design of customer database in Access 2007 -Notes Section Pretty much the same info as a contact card in outlook but in database form So from what I learned in class my understanding is that anything that has more than one option should be made into a separate table Then you should link them up through the relationships What is the most efficient way to design this Please help My boss thinks that this should be a super easy task and it s not for me nbsp

Relevancy 69.23%

I have found from several forums and support sites including Microsoft that many users are asking solution for the error generating by MS Access 2010 or 2007 while running their custom made Access 2003 database usually after after upgrade.
The error is showing as "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 solution is as below:
This error is causing due to disabled macro setting by default. So you will need to enable the macro as per the following method.
Go to File > Options > Trust Center
Then Click on "Trust Center Settings".
Here click on the Option " Show the Message Bar ... ..."
Re-open the Access File in exclusive mode
Now click on the yellow message bar on to to enable macro..... ..... problem solved.
 

A:Access 2010 or 2007 upgrade error for 2003 database

Welcome to TSG and I appreciate the pro-active post.

A another solution is to learn the Trust Center. In there you can enable all macros.
 

https://forums.techguy.org/threads/access-2010-or-2007-upgrade-error-for-2003-database.1091718/
Relevancy 69.23%

I am building a database to track and manage Sales, Customers, Products, Orders, etc. and am running into some difficulties. I have an orderform with a subform detailing the products the customer ordered. I need to have a conditional total as each product has two "Prices". The three totals are conditional on a Field called Free. If Free is true the item costs one price (and is negative) while it costs another if Free is false. I am getting a #Error message on my total field in the subform footer. I have a query that the subform pulls from that sorts by an IIF statement for based on the Free field, these fields are calculating correctly but not totaling.

This database is based on one origally built by Cosla in this thread.

I appreciate any help I can get on this issue, I hope to have this working by tomorrow at 5PM Pacific.
 

A:Building a database in Access 2007, having problems getting a total from a subform

https://forums.techguy.org/threads/building-a-database-in-access-2007-having-problems-getting-a-total-from-a-subform.948459/
Relevancy 69.23%

I created an application in Access with a form and database I have to make it a client server type app now I need to put just the database and report files on the server for users to use Each will have the form portion of the app The app will now have to connect to the Access database on the server I need to know the best approach to connecting to the database this way and how to use record locking Originally I could just use CurrentDB on the form as it was integrated with the database But to connect to the database on the server I tried using a connection locking? & on connecting to database server record Access 2007 object and creating a recordset that way But I don t seem to be able to lock the record ussing existing things like the recordset locktype property or setting the Recordlocks property on the form Please help me figure out the best method of the various ones to connect to the database on the server as in ADODB DAO database object or whatever and how to use record locking so the users cannot have the same record open at the same time Thank you Valhalla nbsp

Relevancy 69.23%

Greetings I'm a new member and this is my Access Not In When Users Database Responding 2007 Multiple (vista) first Access 2007 Not Responding When Multiple Users In Database (vista) post - bare with me I'm curious if any of you have had issue with Access on Vista in a multi-user environment I recently upgraded a clients office from XP to Vista and also upgraded their MS office package to They were previously using office Their CRM was located within an Access MDB Since the installation the database was upgraded from MDB to ACCDB to The database is located on a server which is a trusted location within the new trust 'feature' of Access Database size is mb network is mb Performance previously was nearly instant Since the upgrade the application will stop responding when switching back and forth between windows say Internet Explorer then back to Access for several seconds Queries that took second now take I'm kind of stumped at the moment With one user in the database it works just fine Performance degrades the more users open the database I'm sure it has something to do with security settings either on vista in the new version of access or both Please respond if you've ran into a similar issue or can point me in the right direction Thanks --Jake

A:Access 2007 Not Responding When Multiple Users In Database (vista)

Jake the problem isn't your access, it is your network. Vista has a dynamically adjusting IP setting. This is a common problem with Vista/2000 Server. Copy to a command file and right click "run as Administrator" or login in as administrator and start, run, cmd. Type in the dos window.

netsh interface tcp set global rss=disabled
netsh interface tcp set global autotuninglevel=disabled

http://www.bleepingcomputer.com/forums/t/108028/access-2007-not-responding-when-multiple-users-in-database-vista/
Relevancy 68.8%

I currently have a small store room inventory database in access 2007. I would like to set up a form that allowed users to search a few columns via text box and a button. The search would return all records found in a datagrid. But it has not been an easy task. Any direction on how to get this accomplished would be helpful. I can do some programming in vb.net.

Is it possible to do this in Access or do I need to use vb.net?
Thank you,
t
 

https://forums.techguy.org/threads/vb-net-search-access-databound-2007-database-and-return-results-to-a-datagrid.917903/
Relevancy 63.21%

I ve built a reasonably complex database system that maintains bookings attendances timetables payments etc for a music tuition school using Access as both the front and back end sigh only because that s all I have to database error... Access "3734" 2007 lock work with Apart from all of the little annoying bugs and restrictive designs I ve come across an error quot the database has been placed in a state by user admin quot commonly referred Access 2007 "3734" database lock error... to as error I ve scoured the net for similar issues and every one of the problems I ve found discussed refers to either multi-user databases or opening and closing the mdb repeatedly My problem is this is a single user database only one PC is connected to the database in any way and it only occurs when I try to run any of the design wizards either chart wizard or combo box wizard etc I ve tried restarting the PC opening the database without running ANY macros or forms and designing a new form chart wizard BAM error pops up can t create any charts Could this be because the database is corrupted I would have thought I d get other errors if this was so and so far I haven t except the odd debug due to coding errors Now even more strange after doing NOTHING different sometimes maybe out of times it works as per normal no locking errors Any thoughts or ideas would be hugely appreciated As an afterthought I d like Access 2007 "3734" database lock error... to re-design the db interface on a more stable platform anyone have any suggestions on what database back-end is easy to maintain and import access data into and what front end is relatively easy to work with and stable I was thinking MySQL and VB nbsp

A:Access 2007 "3734" database lock error...

I stay away from Access these days specifically because of problems like this. I can't offer you much help with the problem other than to say that I think your project probably is corrupted, but at least your data probably isn't. You may be able to re-create it in Access by attaching the mdb file to a new db project and then copying and pasting a lot of your forms and functions over, one at a time, testing after each step so that you will hopefully catch the problem and not transfer it to the new project.

I would definitely recommend getting out of Access. MySql and VB is not a bad idea. I think, however, that, since you are used to Access, you might have an easier time transitioning to SQLServer (Microsoft SQL varies in some key areas from the pure SQL you'd use with MySQL). Also, the free version of SQLServer is probably easier to install and configure (on a local machine) than MySQL.

Depending on your needs, I'd steer you more toward ASP.net than just straight VB.net. I've developed several of these types of applications, on both platforms and I always feel handicapped when working just in VB.Net. ASP.net brings in other elements that you'd need to learn, but also provides a lot of very easy methods for displaying data that are more or less absent from VB. Plus, the web browser eases a lot of the formatting burdens that can drive you insane in VB.net. Either way, I'd recommend downloading the Express version of Visual Studio and running through some of the "Getting Started" walkthroughs; they are very helpful and will help you get a better idea of what your options are.

Good luck!
 

https://forums.techguy.org/threads/access-2007-3734-database-lock-error.975312/
Relevancy 59.34%

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
 

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

Google: import access to sql server
 

https://forums.techguy.org/threads/copy-an-access-database-to-sql-server-database-using-vb-net.1045442/
Relevancy 59.34%

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
 

Relevancy 59.34%

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
 

A:Exporting MS Access Database to MySQL Database

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

https://forums.techguy.org/threads/exporting-ms-access-database-to-mysql-database.389139/
Relevancy 59.34%

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.
 

http://www.pcreview.co.uk/threads/how-to-open-existing-database-from-another-database-using-access-vba.4070487/
Relevancy 56.76%

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
 

Relevancy 53.75%

started workbook with data input sheets Those are where I cut and paste monthly financials from other Excel spreadsheets Using this formula to pull data from the input Building database 2007 Excel spreadsheets into the main database spreadsheet That s mapping okay as an example using this formula IF ISERROR HLOOKUP Core Data L amp Core Data M amp Core Data O DI NonVPPM B XFD FALSE TRUE quot quot HLOOKUP Core Data L amp Core Data M amp Core Data O DI NonVPPM B XFD FALSE problem is I want to pull the data from the main database spreadsheet into reports where I want to present the data sliced several ways Was using this type formula to pull it before in a smaller workbook and it seemed to work okay But now with a bigger data set I m getting a Value message back saying Building 2007 Excel database the data is Building 2007 Excel database not the type need for the formula Here s what I ve been using IF SUMPRODUCT Core Database H H B Core Database M M C Core Database K K E Core Database Q Q SUMPRODUCT Core Database H H B Core Database M M C Core Database K K E Core Database N N D Core Database T T SUMPRODUCT Core Database H H B Core Database M M C Core Database K K E Core Database N N D Core Database Q Q Lookinig for help I m pretty good with Excel but think this project may be a little above my head but I m determined to learn and get it done By the way I m using an HP Laptop with G ram Windows XP Building 2007 Excel database and the Excel file has grown to about meg thanks in advance for any help you can give dpatrickassoc nbsp

A:Building 2007 Excel database

welcome to the board.

All the message says is that the expected value in one of the fields is not what the formula can work with, it's either an empty field where no 0 values or null values are allowed or whatever.

With this information and no access to the source data it's like looking for a needle in a pitch dark room with no flashlight.

What I mean to say is I think insert a new (empty) worksheet and then put each value in a different cell and see what you get in return:

e.g.

A1 ='Core Database'!$H$2:$H$8400=$B4
A2 ='Core Database'!$M$2:$M$8400=$C4

etc...

Then you can build the formula based on A1, A2 , etc and see what happens with which one.

Step-by-step will get a longer way than running when you keep tripping (wow that's philosophical )

I mean, just try this, I'm sure the problem is quite simple since it worked before.

Good hunting.
 

https://forums.techguy.org/threads/building-2007-excel-database.979345/
Relevancy 53.32%

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!!!
 

Relevancy 53.32%

Hi I Sage Problem database opening 2007 (9.0) ACT have a probem opening my ACT database I used to use ACT and when I did a back-up I simply copied a numbr of files from one machine to another With this newer Sage ACT 2007 (9.0) Problem opening database database I m not sure I have done this back-up properly So I m concerned that I can t simply uninstall and re-install I m worried that my backup data isn t complete The problem is that when I try to Sage ACT 2007 (9.0) Problem opening database open the database the opening routine gets as far as reporting quot contacts loaded quot then stops someties showing any overdue alarms but not showing the main screen s The ACT logo appears in the taskbar at the bottom of the screen and on right clicking this it shows a number of databases but none of these will open I have two suspicions My virus checker reported a Trojan that it could not clean I managed to get rid of this by contacting you guys on another thread I had recently tried to set up blue tooth with my phone and had tried to get to use ACT with that phone but it never worked Nor did blue tooth with that phone for that matter Any help would be gratefully received Using Windows Professional Regards john nbsp

Relevancy 52.03%

Please can someone help me.I manage a band and we have a database of 3,000 contacts. The headings are name,location,email, website. I wanted to put all this into my contacts sheet so that rather than getting a mailing list program I'll just use outlook and distribution lists. I was going to set up different address books for each location. i.e USA.

A box saying you have not named the ranges keeps coming up. Honestly i dont have a clue and could really do with a step by step, baring in mind i know nothing.

Problem is that it wont import from Excel into Outlook. Im getting desperate now their album is out in February and i have not used the direct mailing yet.

I cant find a step by step idiots guide to doing this anywhere.

Can someone help there is a free album in it if you can lol

Please help.
 

https://forums.techguy.org/threads/problem-put-my-excel-2007-email-database-to-outlook-2003.766140/
Relevancy 52.03%

A client recently is mig What exchange mailbox method Fresh and create the 2007 to best a database had a failure with their mail database The database was repaired using the ESEutil and isinteg utilities to get What is the best method to create a Fresh exchange 2007 mailbox database and mig the database back into a clean state exchange SP However after the above processes there have been a number of What is the best method to create a Fresh exchange 2007 mailbox database and mig quirks that have appeared for instance some users could not open up mail in another users shared mailbox some users had all mail from different mailbox folders deleted that were from a date prior to the database going down One user could not see any new mail in cached mode in outlook Generally a lot of niggly issues My thought is that the database still has a number of small corruptions and I would like to create a new mailbox database and move the users mail across to this new database Office tech info SBS Client using outlook sp and outlook Total mail database size GB What would be the best method of achieving a fresh database and moving old mail across I have considered moving the mailbox database and log files to another location and then getting exchange to create a new database I would then look to create a recovery storage group and put the old database files and logs in the appropriate folder and move mail form the old database to the new one The other method I have looked at is to export all mail to PST's and then reimport it into a fresh database I have not used the recovery storage group before so your opinions and advice to achieve my goal would be much appreciated

A:What is the best method to create a Fresh exchange 2007 mailbox database and mig

You're going to have to do the Database move and Recovery Storage Group.  The RSG does work and is not that hard.
See this site for help...
http://blogs.technet.com/b/messaging_and_beyond/archive/2012/05/10/exchange-recovery-storage-group.aspx
Or it may be easier just to set up a new storage group and move the mail across to the new database that will be created....can anybody see any problems with that method? 
See if the following article would help:

https://social.technet.microsoft.com/Forums/en-US/82b432a2-12e7-46f7-b27d-46a1a94c23f7/how-to-get-outlook-recovery?forum=officeitpro

 

http://www.bleepingcomputer.com/forums/t/587035/what-is-the-best-method-to-create-a-fresh-exchange-2007-mailbox-database-and-mig/
Relevancy 52.03%

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.
 

Relevancy 52.03%

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
 

Relevancy 50.31%

I have an Excel workbook in which I keep racing records The data goes back about years and as i have accumulated several hundred thousand records I have moved much of the historical data onto separate sheets in the workbook so that values for calcs that rely on the historical data can be auto updated For current data I use a separare sheet as i was finding that Excel 2007 Help Workbook convert to Large Access 2007 to required sucessfully it was takin Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007 g a long time to perform calcs when all the data up to rows was all on the sheet I wanted to know Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007 if it was possible Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007 to convert what i have to Access as it has been suggested that a database would do a better job of handling so much data rather than Excel I have moderate knowledge of Excel and have been able to build up the series of formulas for calculations in Excel over the years and have it pretty well doing all the things i want now but I have very little knowledge of Access design so not sure if I can convert and how to do it The Excel workbook contains a lot of formula that do calcs on past results and then use those calcs to do predeictive calcs for upcoming races Because it was very quot maths quot based to start with I started off using Excel and it has all grown from there Is it possible to convert what I have to Access Is is reasonably able to be done by a moderate user like me with some expert help The files i have are too big to attach here but would be happy to prepare some sheets without much data to show what i am doing and get advice nbsp

A:Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007

https://forums.techguy.org/threads/help-required-to-sucessfully-convert-large-excel-2007-workbook-to-access-2007.890648/
Relevancy 50.31%

I m trying to run an Excel macro active to Access sheet code Excel 2007 2007 VB run macro in from Access when I get to the point where I want the macro stored in the active workbook I m getting the following run-time error run-time error object variable or with block variable not set It won t run the macro Access 2007 VB code to run Excel 2007 macro in active sheet at all I would greatly appreciate it if someone could help me fix my code so the macro will run The code is listed below step is where I get the error Code Option Compare Database Sub GetJournal Entry Data transfer to Excel 'Step Declare your Variables Dim MyConnect As String Dim MyRecordset As ADODB Recordset Dim MyQueryDef As DAO QueryDef Dim MyDatabase As DAO Database Dim MySQL As String Dim MyRange As String Dim s As String Dim Db As Database Dim xl As Excel Application Set xl CreateObject quot Excel Application quot Dim xlwkbk As Excel Workbook 'Dim xlworkbk As Excel Workbook Dim xlsheet As Excel Worksheet Dim i As Integer 'Step Declare your connection string MyConnect quot Provider Microsoft ACE OLEDB Persist Security Info False Data Source P FINANCE Balance Sheet Inventory Project TAN Project TAN accdb User ID Admin quot 'Step Build Your SQL Statement MySQL quot Select From mtb-TantasticJE's Where mtb-TantasticJE's Dscrptn Text 'Culls Stat 'and mtb-TantasticJE's Co Code ' ' quot 'Step Instantiate and specify your recordset Set MyRecordset New ADODB Recordset MyRecordset Open MySQL CurrentProject Connection 'Step Instantiate Excel If Excel isn't Loaded Error occurs Set xl GetObject quot Excel Application quot 'Step Open TAN JE Export xlsx Set xlwkbk xl Workbooks Open quot P FINANCE Balance Sheet Inventory Project TAN TAN JE Export xlsm quot Set xlsheet xlwkbk Worksheets quot Culls Stat quot xl Visible True xlwkbk Windows Visible True xlsheet Cells ClearContents 'Step Find First empty cell and use that to build a dynamic range With xlsheet xl Range quot A quot CopyFromRecordset MyRecordset Columns quot B B quot Select Selection Insert Shift xlToRight Range quot C quot Select Range quot C quot Select 'Cols To Insert 'Worksheets quot Culls Stat quot Range quot B quot amp Chr Asc quot B quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot F quot amp Chr Asc quot F quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot J quot amp Chr Asc quot J quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot M quot amp Chr Asc quot M quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot Q quot amp Chr Asc quot Q quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot T quot amp Chr Asc quot T quot Cols To Insert amp quot quot EntireColumn Insert End With 'Step Add column heading names to the spreadsheet 'For i To MyRecordset Fields Count 'xl ActiveSheet Cells i Value MyRecordset Fields i - Name 'Next i 'Step save as text file amp Close active recorset xl Visible True xl Run quot Export Stat culls TXT File quot xlwkbk Close True COLOR red ActiveWorkbook Close ------ This is where I get the run-time error COLOR ActiveWindow WindowState xlMinimized MsgBox quot JE Has Been Exported to Excel amp Text File quot 'Step Memory Clean up Set xlsheet Nothing Set xlwkbk Nothing Set xlApp Nothing Set Db Nothing MyRecordset Close End Sub 'Step Close Excel Private Sub Workbook BeforeClose Cancel As Boolean Dim wBook As Workbook Dim LCount As Long If Cancel False Then For Each wBook In Workbooks If wBook Name lt gt Me Name And UCase wBook Name lt gt quot PERSONAL XLS quot Then LCount LCount End If Next wBook If LCount Then Excel Application Quit End If End Sub nbsp

Relevancy 50.31%

Hi everybody I have a problem with my MS Access and can amp 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 amp t find the wizard or there is syntax error in the Declaration section of a Visual Basic module Wizard Can't access Access MS database The wizard you need may be missing from the libraries key of the Can't access MS Access database Wizard 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 amp t know where to find and compile those Visual Basic modules I also don amp 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 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 nbsp

A: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
 

https://forums.techguy.org/threads/cant-access-ms-access-database-wizard.553449/
Relevancy 50.31%

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.
 

A: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.
 

https://forums.techguy.org/threads/access-97-database-in-access-2000.443343/
Relevancy 49.88%

I have Office 2007 on Windows 7.

When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen).

If, I switch to another open sheet/doc and then switch back the ribbon is accessible again!

I have uninstalled/reinstalled Office plus SP's twice but the problem persists, and, as is usually the case, this does not happen all the time but enough times for it to be really annoying!

Any ideas?

Thanks for your time on this

Neil

A:Cannot access the Ribbon functions in Excel 2007 or Word 2007

Could you please post a screenshot or two?
And what are file sizes (MB)?

http://www.sevenforums.com/microsoft-office/190324-cannot-access-ribbon-functions-excel-2007-word-2007-a.html
Relevancy 49.88%

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

https://forums.techguy.org/threads/vb-net-with-access-database.879782/
Relevancy 49.88%

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..
 

A: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).]
 

https://forums.techguy.org/threads/access-database.28990/
Relevancy 49.88%

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
 

A: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.
 

https://forums.techguy.org/threads/access-database.271656/
Relevancy 49.88%

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
 

Relevancy 49.88%

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)
 

A: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.
 

https://forums.techguy.org/threads/access-database.225858/
Relevancy 49.88%

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.
 

A: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.
 

https://forums.techguy.org/threads/access-database.69985/
Relevancy 49.88%

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.
 

Relevancy 49.88%

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!!
 

Relevancy 49.88%

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?
 

A: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
 

https://forums.techguy.org/threads/ms-access-database.780963/
Relevancy 49.88%

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?
 

Relevancy 49.88%

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!
 

Relevancy 49.88%

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
 

A: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.
 

https://forums.techguy.org/threads/access-database.686973/
Relevancy 49.88%

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
 

Relevancy 49.88%

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
 

Relevancy 49.88%

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.......

!!!!!!
 

https://forums.techguy.org/threads/database-ex-here-need-help-with-access.82658/
Relevancy 49.88%

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
 

A: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
 

https://forums.techguy.org/threads/access-database.706441/
Relevancy 49.88%

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..
 

A: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).]
 

https://forums.techguy.org/threads/access-database.37131/
Relevancy 49.88%

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

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.
 

A: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)
 

https://forums.techguy.org/threads/database-help-access-03.707936/
Relevancy 49.88%

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...
 

Relevancy 49.88%

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.
 

A: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.
 

https://forums.techguy.org/threads/access-database.228833/
Relevancy 49.88%

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?
 

https://forums.techguy.org/threads/two-access-the-database-is-not-available.1169220/
Relevancy 49.88%

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
 

A: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.
 

https://forums.techguy.org/threads/access-database-help.382787/
Relevancy 49.88%

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 access database 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 nbsp

Relevancy 49.45%

Can anyone please help. I'm trying to look at Outlook 2007 Calendar Appointments in Access 2007.

I've seen many postings discussing adding appointments from from Access into Outlook, but I want to look the other way.

The code I've started with is

Dim olapp As Object
Dim olappt As Object
Set olapp = CreateObject("Outlook.Application")

...but that's as far I can get. I'm lost after that.

My game plan is to link our Exchange Calendars used on ipad2's to our Access database, to store Sales Rep visits against customers visited, straight from the ipad into the database.

Anyone know how? I'd be very grateful.
 

A:View Outlook 2007 Appointments in Access 2007

Exchange server is a database that can be queried by other databases. Look up Exchange OLE DB
 

https://forums.techguy.org/threads/view-outlook-2007-appointments-in-access-2007.1000362/
Relevancy 49.45%

I have a access database thAT exports data to an excell file. A macro in access then opens this file and another in excell. The second excell file reads data from the first then uses a macro to format it properly and print the info. Right now I can only run this macro from the excell file. Can I run this macro (called Button2_Click in Module 3) from access? I have been using the OutputTo and RunApp action to run this macro so far.
 

Relevancy 49.45%

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.

http://www.vistax64.com/system-security/261294-runtime-error-75-path-file-access-error-call-access-database.html
Relevancy 49.45%

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?
 

A: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.
 

https://forums.techguy.org/threads/access-printing-a-single-report-off-of-a-single-record-from-an-access-database-form.99807/
Relevancy 49.02%

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.

A: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 be related to the corresponding fields in the Tracks Table.

You don't have to follow my model exactly, but do you understand the idea of splitting up the Tracks and Album Names fields into different tables and relating them? This eliminates the problem of constantly having to add fields for new tracks. It'll also make queries significantly easier to sculpt.

Hope this helps

http://www.bleepingcomputer.com/forums/t/339703/ms-access-how-to-create-a-cd-database/
Relevancy 49.02%

We have quite a hefty database (approx 90meg) that we would like to split into 2 smaller databases.

The plan is that if a certain "Date" field is older than a set date or another field = "Closed" then these records can be move to a archive database. The archive database needs to still have all the forms, queries and reports.

Is there software to do this or is it a case of make a copy of the database as the archive then manually delete the records that match the above criteria.
TIA
Raw2K
 

A:Splitting Access Database

In access, create a new blank db. Go to File...Get External Data...Import...

Import all tables, queries, reports, etc. that you want.

In the table in the new DB, run a maketable query, pulling all records where Date < (cutoff date) or other field = "Closed".

This new table will have your backup info. Delete the table you initially imported.
 

https://forums.techguy.org/threads/splitting-access-database.312851/
Relevancy 49.02%

Im creating a database to book both rooms and resources, assign them to staff etc, iv created a barebones system that lets you book the room/resource and assign it to a person on a date, what i need is.. if someone can help that is, is when a date reaches a certain point, say 1 day before.. to pop up a reminder, also.. i need the room to pop up as booked if between dates that are already booked.

Any help would be greatly appreciated,

Steve.
 

Relevancy 49.02%

I am working on a class assignment Basically we are a group programming a business application We are making a personal finance application and I am working on the database in Access I have a table for credentials which has the username password and ID The next part is where I need advice and perhaps reference if you can I need to have an expenses table of some degree I Database Advice Access was thinking about making various tables with a date column I would have many of these the date column is for an object in the actual application there will be many expense tables obviously I was wondering how would I structure that Would I make a table Access Database Advice of just foreign keys and one of the foreign keys link back with the userID How would you actually program that in VB Would I reference the actual table of the expense say savings or would I reference the table of just foreign keys Advise tips Thanks nbsp

https://forums.techguy.org/threads/access-database-advice.1157624/
Relevancy 49.02%

Built an accounting database:AR, AP, CD,PR,JE, GL........etc.
Looking for help with some access 2013 issues.
1 Need to tie all those tables to create a general leger and a financial statement(It's not the GL I'm concerning
about as much as how to move data from tables to GL
e.g.- For AP every entry on a form has two sides one debit another credit and they need to be reflected in
GL by account number and that where my problem is

2 In my forms need to have a multiple line entries per transaction (like a sales order)
 

A:access 2013 database

nphcpa, welcome to the forum.
I am not sure what "AR, AP, CD,PR,JE, GL........etc." are, but it sounds like the overall design of the database may not be optimal.
The fact that you have to have the "move data from tables to GL" suggests that the data should be in a GL table but identified by it's source and split up via Queries for data input/editing.
As for item 2 it sounds like you should have a "Line Entry" sub table and subform for the Transactions.
Can you show me a screenshot of your table Relationships?
 

https://forums.techguy.org/threads/access-2013-database.1125481/
Relevancy 49.02%

I set up and maintain an Access 2000 database in a hospital to track patients in a particular program. The hospital has signed with another info system operator and it looks like they are changing to Oracle. I know nothing about the database and am wondering how much different it is from Access and if I will be able to import my Access database and queries into the Oracle database. The hospital does not support Access and has not done so in the past. Our department is apparently the only one using Access; however, we may be able to keep using Access even tho we aren't supported by the IS operator. BUT if we can make the change w/o a lot of problems, maybe we should do so. I'm self taught on Access and will probably have to take outside classes on my own for Oracle.

Any suggestions for me.
 

https://forums.techguy.org/threads/ms-access-vs-oracle-database.303829/
Relevancy 49.02%

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

A:Help me to create a Access Database

Hi Yalpanam,

Is this for a school project?

http://www.techsupportforum.com/forums/f217/help-me-to-create-a-access-database-576765.html
Relevancy 49.02%

There was made mention by an Access Expert that they shared a Training Records Database with members. I am new and read this post - something I have been searching for for months! May I have a copy of your db so I can personalize and add to it? This would be an amazing help. Thank you in advance.
 

http://www.pcreview.co.uk/threads/ms-access-training-database.4071289/
Relevancy 49.02%

I am planning/trying to build a database that will track the dates certain classes were taken by users, and if the classes were passed or not.

I am very new at Access Databases so any advice, suggestions, opinions, or help anyone can offer will be greatly appreciated.
 

Relevancy 49.02%

I am creating a database to track customer, vendor, and investment information. I want my queries to include the following:
By Vendor
By Customer
By Mature/Surren Date
By Investment type

Later down the road...I want to create a form to input new customers. I want the form to have a pull-down menu for both the vendor and the investment fields.

I was thinking I should have a Vendor Table, Customer Table, and Investment Table. However, Vendors and the investments they offer vary from vendor to vendor -- A vendor typically has between 1-40 different investment options.
 

A:Access Database Creation

In that case you will want (1) your vendor table, with their names and details and an ID-key field, (2) the vendor-investment table, in which each vendor's ID key from table (1) is used with the various investment options offered, (3) a customer table, with their names and an ID-key field, and (4) a customer-investment table, in which the customer's ID key is cross-referenced to the selected vendor investment record(s) from table (2).

Hope that makes sense. You might want to check this link for a more thorough introduction.
 

https://forums.techguy.org/threads/access-database-creation.84278/
Relevancy 49.02%

Hi,
Is their already tables set up to use with drop down boxes, that once you pick the Country the next set of drop down boxes will automatically have the states within that, and once you pick the state it will automatically have the cities in that state ect... Also is their something like this for the country's dial code.
Thanks,
Joe
 

Relevancy 49.02%

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 ...
 

Relevancy 49.02%

Currently I'm working on a project at work and am unsure as to what would be the best way of implementing the following concept: There is a need to track certain access to labs and software within the building. An end user should be able to submit a pre-created form (likely in infopath) and it should automatically be added to a database over a network drive.

I am happy to provide more detail of the task if needed, I just need to know what the best implementation of this concept would be. The process should be something an end user should be able to just submit without difficulty. Thanks in advance.

--
Burroughs

http://www.bleepingcomputer.com/forums/t/406986/infopath-to-access-database/
Relevancy 49.02%

I want to share a database from my Windows XP pc with a laptop with Vista. I have tried network sharing, usb replicating and cannot get the information I put into the laptop to replicate on the pc. I have a feeling this should be easy, but cannot find a way to do it. Help much appreciated?
 

A:Sharing access database

Are you using replication to allow you to work on the laptop remotely and then synchronize the changes later on? If so, after you make the data changes and network them back together are you using "Tools">>"Replication">>"Synchronize Now"? This will synchronize the changes you have made in both.
 

https://forums.techguy.org/threads/sharing-access-database.599379/
Relevancy 49.02%

Hi Folks I have a desktop running Win Pro and acting as a file server in an office There are other Windows computers in the office all with a mapped network drive from the server We have an MS Access Database which Access Sharing Database an quot lives quot on the server's hard drive and therefore is accessible to all those in the LAN By default MS Access is set up to allow more than one user access read write the database However for some reason we cannot achieve this in our office Once one person has the database open the second person can double click on the database icon there is a flicker as if the application opens and instantly closes Sharing an Access Database and that's it No sharing The strange thing is that if someone on the LAN has the database open a user physically at the server Sharing an Access Database can open up the database thereby allowing more than one user The key is that of the two people accessing the database one of them must be accessing it from the server itself This is obviously sub-optimal Is this is a Windows issue or something relating to MS Access Any ideas Thanks

A:Sharing an Access Database

No one has any ideas?

http://www.sevenforums.com/network-sharing/159773-sharing-access-database.html
Relevancy 49.02%

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.

A: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...

http://www.computing.net/answers/office/how-to-do-access-database-repair/20192.html
Relevancy 49.02%

I have a option contract to recieve up to 10 apples per day for the next year. I share this contract with other people. I am creating a database that will let me know how many apples are available on any given day throughout the next year.

I am thinking that I will have to set up a table with a field for date and capacity. Then subtract 1 each time someone takes an apple on that day.

Is there a better way?
 

A:Solved: Access database help

So you want something like stock control? So when someone takesan apple you want it taking from stock?
 

https://forums.techguy.org/threads/solved-access-database-help.969410/
Relevancy 49.02%

A Grocery Database that allows you to compare prices for various grocers in youe area including the impact of 1. Coupons and 2 coupon doubling and tripling. Last would be historical data of pricing. From this you couls create a shopping listfor each store each week and predict when prices will be at their lowest and coupons have the reatest impact.
I'm a newbie to Access and had a VB class over 16 yrs ago. I've done a lot of input to the main table just trying to get an idea of how to manage it with queries & reports. Any ideas? I know it's a lot so i'll understand if it's 2 much.
 

Relevancy 49.02%

When I go to generate a report in an Access database that consists of about 10 plain text pages, the program crashes. Task manager says not responding. ONLY Access is open, nothing else. And this is a 1.3 Ghz with 256 megs ! Any pointers ? Thanks !!
 

Relevancy 49.02%

I am setting up a database and I would like to get some ideas on what would be the best way to it and compare it with mine.

I have a list of shareholders (ID #, name, address) that I am going to import in the new database.

Each shareholder has to vote for a maximum of three candidates for each terms (3 terms in all) and the list of candidates for each term is different.

I have to report daily who is winning for each term.

Thanks
 

A:Access Database Setup

3 tables

Shareholders (shID, Name, Address)
Candidate (canID, Name, OtherStuff)
Vote (canID,shID)

The shareholder and the candidate tables are static and the vote table is updated. YOu need some kind of validation to ensure that each shareholder only casts 3 votes and that they don't vote for the same cadidate twice. Unless you are doing all of the data entry and then it should be fine.
 

https://forums.techguy.org/threads/access-database-setup.62417/
Relevancy 49.02%

I'm trying to import a database to an existing database. Both are identical, aside from their WO_NUM field, which distinguishes each record (and is primary key).

I have enough information in the database fields to make the database I want to import match. The problem is that the database is not allowing me to manually enter data. When I try a manual increment of the WO_NUM table, I am getting the following message:

ODBC-call failed.

[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UC_TASKS_WOID_1'. Cannot insert duplicate key in object 'TASKS'.(#2627)[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. (#3621)

Any help is appreciated. Thank you.
 

A:importing database in access

I'm assuming you are importing the tables, it seems like you are importing the primary key also, that will cause a problem because there will be duplicates.

You can try dumping the table into Excel and strip off the ID column and then import the excel table or Paste it into the table. Access will create new ID's for it.
 

https://forums.techguy.org/threads/importing-database-in-access.295647/
Relevancy 49.02%

Ive been trying to put a copy of my database onto a cd-r. "save & save as" on the file menu are always in faint writting and i can not select them. Any idea's as i desprately need to give a copy to my unie teacher? Help Me Please
 

A:Access- Cant save database?

First, make sure it is not Read-Only (right-click, Properties). If you are trying to save the whole database, then you should be able to save as to the CD. If you are trying to just save a table (or some other portions of the database), make a blank database and import those items into it.
Good luck.
 

https://forums.techguy.org/threads/access-cant-save-database.302068/