Windows Support Forum

Access 97 database in Access 2000?

Q: Access 97 database in Access 2000?

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.

Relevancy 100%
Preferred Solution: Access 97 database in Access 2000?

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

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.
Relevancy 97.18%

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 90.3%

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 _____________

Relevancy 89.44%

When I run comcheck I get the following error (see
below). When I search for info on odbc32.dll it says I
need to reinstall MDAC files.

I have updated all my service packs and all the latest
updates to Windows 2000 have been installed. But I don't
know how to update MDAC 2.7 (I have reloaded it several times)--- and everything I read says
I can ruin my entire system if I am not careful.

It seems I need to uninstall 2.7 and then reinstall it but
I have no idea how to do that.

Any help would be greatly appreciated!


Item Name,Item Type,ErrorString,Status

odbc32.dll,File,Field 'FileVersion' mismatch:
Expect '3.520.9001.0' Got '3.520.8504.0',Error
Relevancy 89.44%

I have an Access 2000 database with two tables. Table 1 is the master with 78000 records. Table 2 is a sub set of table 1 with about 15000 records.

What I am trying to do, is create a 3rd table. This table will also be a subset of table 1, but will be a list of the records that are not listed in table 2.

Thanks in Advance

Relevancy 89.44%

Can someone help me conceptualize what database concept help (Access Need 2000) I m trying to do here Our organization keeps track for grant funding purposes of statistical information In this particular instance we track the number of telephone calls we receive requesting assistance that we are unable to provide These calls need to be tracked by the following date of call caller s sex and county of origin one of five which agency s the caller was referred to different possibilities and what services the caller requested This information is compiled at the end of each Need help database concept (Access 2000) quarter grouped by month and totaled by number of callers per sex per each county and by the total number of calls to any particular referral agency can be one of This is currently being tracked on a large Excel spreadsheet The receptionist completes information by hand on a tracking sheet and I am expected to compile and enter the data on the spreadsheet each month At the end of the quarter results are totaled and the spreadsheet is forwarded to the requesting grant provider I would like to set this up in a little Access database so the receptionist could enter the information once on a pop-up form At the end of the quarter I want to be able to produce a report that provides the same results we ve been getting by using the spreadsheet Initially this seemed pretty simple until I realized that each call could be referred to as few as none or as many as different agencies Typically callers are referred to an average of - different agencies Am I trying to reinvent the wheel or would I be better off continuing to do what we are doing with the Excel spreadsheet Please keep in mind that I am not a programmer and my skills with Access are intermediate at best Thanks nbsp

A:Need help database concept (Access 2000)

Database is a far better solution and it wouldn't be that hard. One table for the caller and any info pertaining to them. One table with the agencies, and one for services. Then one last table to track the activity for each client. The one thing you need to try to avoid is duplicating client records by setting up a search page where you can verify the client being in the db or whether they are a new client.
Relevancy 88.15%

I have a 3 PCs peer-to-peer network sharing to use a Access DB file which resides in say PC-A. Most of the time PC-B and PC-C would open file to do data entry.

PC-B never has any problem.
PC-C the person has been complaining records missing... say she puts in new records 2 days ago, now when she opens the file she cannot find those records. This case does not happen all the time, just hit & miss!
All PCs are WIN98 running Office 2000.

1. Do I need to apply any fixes (SR1?)
2. Is there any sharing issue that I missed?

Currently all I am doing is making PC-A with a shared folder to house the Access data file.

Pls advise.


Relevancy 88.15%

When I try to compact and repair my database, I get the following error:

Table 'TempMSysAccessObjects' already exists.

Kindly inform me how to get around this... My database is starting to get too big...

Relevancy 88.15%

Can someone tell me the most efficient and secure way to backup a secured database?

I have a secured database (usergroups, names, etc.) and I want to be able to back-up the db's info in the event that the database crashes. Currently, I'm exporting the necessary tables to an outside database (which is in a different directory). However, I don't think this is the best way to go about backing-up the db because the db that the information is going to IS NOT secured. As a result, someone can obtain the db's info from there.

Please help!

A:MS Access 2000: Backup A Secure Database

I presume that the database is not located on a server that gets backed up nightly, right? Can you just copy the database to another location? It should bring the security with it.
Relevancy 88.15%

I have an access 2000 database containing robust information for our neighborhood association directory. Someone is taking over responsibilities for the directory and he uses a Mac and doesn't know or want to know access. Does anyone have a suggestion as to a database program that we can transfer the current access information (including reports) to that would work on a Mac?
Relevancy 88.15%

Hello all After a long hiatus I am trying to get a hockey 2000 Error Access Database 2488 in database working It was originally created in Access and was recently converted to Access One of the key forms in the database is one that I use to enter the results of each game The primary form records basic information such as how many goals were scored in what period and a Error 2488 in Access 2000 Database recap There is a subform that looks like a spreadsheet with columns for team name player and individual actions so there is one row for each goal or Error 2488 in Access 2000 Database penalty that occurred in the game In the subform when you select a team from the drop-down the next field the player drop-down is populated with the valid list of players on that team I did this by running the following after someone selects Error 2488 in Access 2000 Database a team Option Compare Database Option Explicit Private Sub Team AfterUpdate DoCmd Requery quot Player ID quot DoCmd Requery quot Assist quot DoCmd Requery quot Assist quot End Sub This worked fine last year but once I opened it and converted it to I get the following error as soon as I select a team from the list Runtime error You can t use the ApplyFilter action on this window When I go into debug mode it s hung up on the first DoCmd Requery row in the above sub Now this thing was put together originally with much help from much more talented people than me and I literally have not touched Access since then so what little expertise I had has flown out the window So I might be hard-pressed to explain in more detail Does anyone have any quick ideas as to what might be the problem If it comes to that it s a very small database less than K unzipped Thanks all Steve Battisti nbsp

Relevancy 88.15%

I am very much a novice in building databases I am trying to build a database to store test results I have created two tables so far one for Test 2000) Results database (Access details of the person performing the tests one for the test results Included in the test results table is the following quot Tested by quot Customer info Details of equipment Test Results database (Access 2000) serial number subtype Test Results database (Access 2000) etc Yes quot N A quot tickoff for test procedures carried out Output power measurements for up to ports My question is whether there is a better way of doing this There are many many fields in the test results table I tried separating the output powers into a separate table on a one-one relationship by serial number I couldn t figure out however how to enter the data into two tables from one form Another question I have is whether the format appearance of a query can be based on a word document The results were previously stored as word documents which were printed and sent to customer I want to be able to create and print the same reports from this data base Thanks in advance Michael nbsp

Relevancy 88.15%

Is it possible to rename a secured Access 2000 database without messing-up the security permissions?

A number of employees (including myself) are using a secured database that I created. I want to change the name of the database but I'm worried that the .mdw file isn't going to recognize the name of the new database. Therefore the security permissions may get messed-up. That is my concern anyway... I used Access 2000.
Relevancy 87.29%

Hi there
am finalising a database for workplace and hoping to include feature to send emails to several people at same time from Access. I understand I need a code for this, can anyone help? We're running Access 2007 but using database in Access 2000 format. Worth noting that this is a secured database and I have already tried instructions at and but no luck.

Also having problem importing data from Excel spreadsheet into that Access database. Worked several times before (including with some data in that spreadsheet) but now coming up with error (without any detaio about what's wrong). Spreadsheet contains loads of data on several worksheets and data has been worked on quite a lot (mainly for cleansing), all fields and formatting match those in Access and yet won't work any more. Any ideas as to what my be problem??

Thank you!


A:Solved: Mass emailing in Access 2000 database

Sev, I have posted various copies of the emailing VBA some of it quite recently.
The Excel problem sounds like someone has put something in a cell that doesn't belong there, it is uaually text when Access expects a number. You should have an Import Error table generated with the rows and fields that have the error.
Relevancy 87.29%

I'm not sure if I'm explaining this correctly, but it goes. I created a database that everyone in our office can view but only a few can update or edit. Just recently, I noticed that new data that has been entered into the database does not show up in our queries. Is there a fix for this problem?

Relevancy 86.43%

Hi a by opened Locked Access computer. Database 2000 - specific when again everyone I'm having some Access woes with which I have been unable to find help about around the web as my circumstances don't seem to fit other reports of this problem I get the dreaded The database has been placd in a state by user lt name gt on machine lt name gt that prevents it from being opened or locked Here's the kicker its used actively by users when user opens it user gets that error or any other person that tries to get into the database if user opens it first or any other user then Access 2000 - Database Locked when opened by a specific computer. any and all users that open Access 2000 - Database Locked when opened by a specific computer. it up can use it without any problems Now I don't have any plugins in use no VB code getting data from other sources or mail merges or anything like that everything in this database is internal Access 2000 - Database Locked when opened by a specific computer. What I can't figure out is ONLY user 's computer will lock the database and ONLY when she's the first to open it Any Ideas Avatar

A:Access 2000 - Database Locked when opened by a specific computer.

See if there is a left-over <name>.ldb file in the same directory as the <name>.mdb file. the LDB file (Lock Data Base) is where Access keeps track of who has the file open, which record is being accessed, etc. The LDB file is supposed to get deleted with the database is closed, but if there is a crash or something weird then LDB file can get left behind.

If you find an LDB file just delete it and try again.
Relevancy 86.43%

Hi there I am attempting to export a table from Access to a txt file which will then be merged into Adobe InDesign CS I am following the instructions from InDesign to accomplish this merge which requires that the file be in a txt or csv format I am trying to keep my list from the table in Access in alphabetical order which is how the design of the table is saved When I export the table to txt format it when from .txt Solved: of 2000 Problem: database design changes exported fo Access to un-alphabetizes the list When I select quot Save Formatted quot during the export process I end up with a txt file in a code that InDesign will not accept in the merge I have tried exporting the table to Excel and then to a txt file but InDesign will not let me merge the files that are created that way Any ideas about what I can do short of exporting the table anyway and then seeing how well I can manually cut paste and alphabetize the fields Thanks Stacie nbsp

A:Solved: Problem: design of database from Access 2000 changes when exported to .txt fo
Relevancy 79.98%

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 79.55%

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 the Trial Version and play around with it for quite a while.
Relevancy 77.83%

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.

Relevancy 77.83%

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.


Relevancy 74.82%

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.
Relevancy 74.82%

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


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

Google: import access to sql server
Relevancy 74.82%

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.
Relevancy 74.82%

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 74.82%

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.
Relevancy 73.96%

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:

[FirstNm]=[Forms]![MyFormName]![txtFirstNm] And [LastNm]=[Forms]![MyFormName]![txtLastNm]
Hope that helps.
Relevancy 73.96%

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.
Relevancy 72.67%

I have just installed microsoft offfice professional 2010 on a new windows 7 PC.

I would like to open access 2000 files, but when I try to I get an error message that the file cannot be converted.

My daughter has access 2010 on her laptop and it opens the access 2000 file ok.

Any thoughts?


Relevancy 70.95%


I have an access 2000 database that I cannot view in design mode in 2003. In access 2000 I used to press the shift key and open the access 2000 database. It would then open up the data base for me instead of starting it in start-up form. But now when I try that in 2003 it just gives me the startup box, basically what a user would see when entering information. I was wondering how I would be able to view the database in access 2003 as if I was pressing the shift key and opening it up like in access 2000. I imagine it has something to do with the macros?

Is there a way of setting up the database in access 2003 (so I can view the data inside) instead of starting up the form

Relevancy 70.95%

I have a well established application developed in Access 2000. I have a customer using this application in Access 2007 in Vista, and for certain reports, a couple of fields display as #Name?.

I tested the application on my kids' laptop, which also has Vista & Access 2007, but I don't see that problem. I'm on SP1 for Access 2007, but my customer is not. He claims to have updated his Access, but no luck.

I noticed that both of the problem fields used the UCase( ) function, so I removed it. One of the fields is OK now, but the other one persists.

The problem field contains:
=Mid(DayOWeek(Weekday([Date1])),1,3) & "."
"DayOWeek" is my own function that returns the day of the week spelled out.

Thanks in advance for any help.


A:Access 2000 App displays #Name? in Access 2007

I do not have Access 2007 (thank the fates) but if that is the only field using your function and it is the only field that now has a problem, that strongly suggests that 2007 does not like your function.
I am not sure what your function does, but if it is to produce the day of the week from a date, i.e. Monday, Tuesday etc then you can achieve the same thing much easier by using
format([Date1], "dddd")
which might help.
Relevancy 70.95%

I have an Access file that was created in Access 2000. I need to get this to a computer that has Access 97. When I save it to disk from the 2000 version then try to open it on the computer with the 97 version, I get the message "Unrecognized database format A:\Filename.mdb".



A:Need to transfer file from Access 2000 to Access 97. Can I??

Here is a link to help convert it to Access97
Relevancy 70.95%

Is there a way to do this? I'm trying to open an Access XP database on Access 2000 and I'm getting an error message that says "this database is in an unrecognizable format" then it goes on to say I'm possibly trying to read a file that was created in a later version of Access, which is true. But is there any way around it?

A:Reading Access XP databases on Access 2000

Get the viewer from the MS web site or save all of your Access db's in Access 2000 format.
Relevancy 70.95%

Can anyone PLEASE tell me how I go about making a field a REQUIRED field. I have created a data access page which will be access by several users via our intranet. I want a error msg to pop up if a particular field is left blank. HOW do I do this via the data access page?

A:Access 2000 Data Access Page

Go into the design view of your table. click on the field that you want to be required. At the bottom of the screen there are some properties about the fields. In the required field change it to yes.

This will automatically make a pop up box that warns the person entering data that they cannot move onto the next record without entering info in this field.

Good luck.
Relevancy 70.95%

Two years ago I found an Add-In for Access 97 which makes the Outlook 97 Database available as linked tables - on-line links to Outlook - no Outlook export files.

Unhappily this does not work with Access 2000 and Outlook 98. There are some columns missing in the Access view of the calendar table.
Mainly the columns for the date of the activity (in German "beginnt um" / "endet um" - maybe it is "begin" (Date/Time) and "end" (Date/Time) ) and the place (in German "Ort" - maybe it is "location" or "place" (Text / Comment)).

Does anyone know such an Add-In for Access 2000 which works with Outlook 98 or Outlook 2000 ?

Thanks for any hints.
Andreas / AnStr

A:Online access to Outlook 98 - with Access 2000

I don't know of a 3rd-party add-in, but you can create a procedure to do this. See;en-us;209946 for sample code.

Relevancy 69.23%

I have 2 Microsoct Access Databases in the same folder on someone in our Networks hardrive.

One I can access no problem....
The other I cannot????

Any ideas why?

I use Vista
The computer I am connecting with uses Windows XP
We both use Office 2000

The folder where the database file is located is Shared Documents.
So it shows:
\\SIDONNA\SharedDocs\Vehicle.mdb (Cannot access)
||SIDONNA|SharedDocs\WorkOrder.mdb (Can access fine)


Relevancy 67.94%

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,

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.
Relevancy 67.94%

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?


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.
Relevancy 67.94%

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual have the form blank..when entering the that you can just 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).]
Relevancy 67.94%

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.
Relevancy 67.94%

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 67.94%

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.


Relevancy 67.94%

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?


Relevancy 67.94%

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

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:

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.
Relevancy 67.94%

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.
Relevancy 67.94%


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)
Relevancy 67.94%


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

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.
Relevancy 67.94%

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 67.94%

ok , i finally got a site , with some ex. for loading jpg into ACCESS,
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.......

Relevancy 67.94%

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 67.94%

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.

Relevancy 67.94%

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.


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
Relevancy 67.94%

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 67.94%

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 67.94%

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual have the form blank..when entering the that you can just 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).]
Relevancy 67.94%

Hi,can smb help me with sites that have tutorials about the relation of with access databases or sql databases.
Relevancy 67.94%

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?
Relevancy 67.94%

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 67.94%

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)



Relevancy 67.08%

i m very much a beginner at access java database help 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 access database java help 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 NOT NULL lastName varchar 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 quot int DEFAULT AUTOINCREMENT quot and quot varchar NOT NULL quot 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 nbsp

A: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.
Relevancy 67.08%

Hi Everyone I have a couple of questions that I hope someone can help me on with Access I am Creating Database Access an shall we say quot very beginner quot I think I did ok for the small stuff but there are a few problems that I m having also I have a few questions for some other tables forms amp reports that I would like to create Question on the form I keep Creating an Access Database getting this error message when I use the switchboard to use this form quot The field project information Project Name can not contain a NULL value because the Required property for this filed is set to True Enter a value in to this filed quot I have cheeked everywhere I know to find it but I do not see it anywhere If I just enter it the information in the spreadsheet it will do fine but it won t let me use the form Question can you send an email to alert someone from access I want to set up a form for ordering amp if there is something that we do not have I want to be able to send an email to the person responsible for that product to let them know we need it Question is there somewhere I can get live help with Access database to help me through this Thanks in advance for your help nbsp

Relevancy 67.08%

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.

Relevancy 67.08%

I am trying to set Ebay's Item No as the primary key in Access 2000, but it will not allow me to do that. I keep getting null number errors no matter what I try. Nothing at all works. Is this a problem with this version of Access, or does anyone know how to circumvernt this? Better yet, is there anyone out there that is willing to set up a database for us, one that will also incorporate some Excel functions? Thank you.

Relevancy 67.08%


I have an access database.

I decided to make a mde file with it out of curiousity. It has now taken my database and password protected it. I never set any password and as such cannot get access to the database.

It has taken my user name from my login, but it is not using my login password.

Does anyone know how I can override this, or reopen an older version of the database.


Relevancy 67.08%

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.


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
Relevancy 67.08%

I've been tasked to set up an Access Database that will accept input from Excel spreadsheets Question Database Access from a template file that is created and distributed to several employees The files will contain about fields some inventory and some dollar amounts as well as a few contact information type fields I'm okay up until this point Now these templates will be completed once a month and turned in If the data was replacing the previous amounts in the fields I'd know how to Access Database Question do this easily but the daya needs to be tracked for each month So January will have a customer account with fields February that same customer account will have new data potentially in all fields So rather than have one record for each customer I'll need to have one for each month that goes by I may be sounding vague on this so ask questions as needed but I'm not sure how to go about this If I create a February record the customer info account number etc will all be the same so wouldn't that cause issues going forward If there's no easy way to do this does that mean Access might not be the best solution I believe Access was suggested so queries could be run to extract data

A:Access Database Question

You can have two tables in Access, one with Customer account details with a unique ID (autonumber should work fine) and the other with the monthly transaction details.
When you are adding the data from the spreadsheet, you could update the existing customer details or add new customer details, and insert the transaction details in the other table for that customer using the ID as reference.

I haven't thought about this fully, so there could be gaps in the logic

1. Whenever you are adding the data from the spreadsheet, you would need to check if the customer already exists in the customer table and insert or update as necessary (if updating, get the customer ID for inserting the transactions).

2. Even when you are updating the customer record, you will need to make sure it has to be updated (could be spelling mistakes in the new record)
Relevancy 67.08%

I have my own server and would like to know if it is possible to create a database in Access and be able to access it off the server preferably using ASP.NET.

I know i could create and sql database on there as it has my sql but would like to know if its easier to do it this way, if its possible ?


Relevancy 67.08%

I need more than help looking for someone who can create a database in Access for me

I need to track
employee time
expenses and a little more

Anyone interested in a small project?

More than just a spreadshet that I alredy use

A:Need help writing an Access database

Tom, I can do it for you, but I am not sure how long it will take as I have about 4 other posters that I am trying to help with less time to program.
It will also depend on how sophisticated you want it.
Relevancy 67.08%

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.

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

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.
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
Relevancy 67.08%

I m looking to start creating some of my files in Access Everything I have for my work is done in Excel but I think some of it should be in Access I do not know Access very well but would like to learn I would like database Access Create to start with something fairly easy I am using Access One of my job duties is to input data for water meter readings These readings are read approximately weekly and I need to generate a report monthly Sometimes the data will come in sporadically and possibly multiple times per week maybe once per day at times The report that I would need to see is - and it would be nice if I could Create Access database choose the month to report on as well - assuming we will use the current month every meter read as of today or the last day of the month and find the difference between the readings from the first day of the month So Jan reading minus Jan reading I could make the date the unique key as there will always only be one reading per day I would need the totals for each meter who the meter belonged to Create Access database and what duration month the information was retreived from I m not worried about how it looks as long as it s there I have this in Excel but it s cumbersome and I think it s the wrong program There are Create Access database other things I use these values for Some of the metered readings are used to find irrigation flows for farm circles Those are currently kept in another spreadsheet there are lots of these spreadsheets These daily gallon figures are then used in other calculations where each day has several other possible inputs these inputs are hours put into different cells locations These figures are used with another daily number to obtain a final daily loading figure These do work in Excel so I m not in a rush to get this its currently in operation My line of thinking was that it would be better suited for an access database I would love some additional input on this Can somebody please help me setup a database that will assist in this area I can manage the table but that s about it I realize this is a large project overall if able to keep this in small bits maybe it will be easier nbsp

Relevancy 67.08%

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?

A: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:
Relevancy 67.08%

I have a database in access that I am trying to send to Excel. One of the fields within the database contains about a paragraph of text. When I send it to Excel, I am losing a portion of the text. Any idea how to change that? I have resized the excel cell and that did not work.

A:Access Database to Excel?

Microsoft Excel Specifications (Excel Help) gives the following limitations to field contents.

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar Click to expand...

Any greater than 32,767 and you will risk losing them in the conversion, but if its just a para or two you should be fine, but you will see it truncated, with the rest 'hidden', so to speak. Its an inbuilt limitation I'm afraid. You could try splitting the contents to an additional field, though that could be messy to look at and manipulate.

Relevancy 67.08%

Hello, I have a been tasked to move an entire Microsoft Access 2003 database from one computer to another.

The machine that has the database on is running Windows Xp servicepack 3

I want to transfer the entire database to a machine running Windows 7 and Microsoft Access 2007.

What is the easiest and safest way to do this?

I am a newbie at this so your help would be gratefully received.


A:Access database move

Copy the file to a thumb drive or across the network. THe only issue with Access 2007 might be the trusted locations setings for where the database would be running from.
Relevancy 67.08%

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.
Relevancy 67.08%

I have a really confounding problem Situation Small non-profit organization with workstations mostly Dell Pentium s Office network uses a Buffalo server and router I don t know for sure but assume the network is problem database Access a simple Base-T The organization runs on the MS Access databases I ve designed one of which is a reservation system The major tables for that system are the Signups table where the information for each reservation is collected and the EventSched which simply contains data for all the events for the year with event type date departure and return time location program type etc The tables contain a lot of links to auxiliary tables per the attachment The database is a client server design Forms on the workstations tables on the Buffalo Each year I go in and set up the reservation tables for the next year in this case I did that yesterday I first copied the database containing the tables to a file with the name quot PublicSailTbls mdb quot After deleting all the records in the Signups EventSched Manifest and HowPaid tables to make them ready for next year s entries on the workstation on which I was doing this I also copied the Forms client side of the split database changed the name to quot PublicSailForms mdb quot and changed the links to the tables file on the Buffalo This is the same process I have used for the last years Problem is the Signups form Access database problem will open on Access database problem only two of the workstations On the others the system goes into quot indefinite busy quot hourglass Task Manager indicates Access and everything else is quot not responding quot but attempts to quot end task quot fail Only way to restore the system is to select quot Restart quot Because it worked on two workstations we thought perhaps the network was not working properly so quot regenned quot it shut all computers down shut the Buffalo and router down waited one minute then brought the network back up Didn t change anything system still works on two of the workstations but not on the others Anybody have a clue as to what s going on where I should look for the cause of this odd problem nbsp

Relevancy 67.08%

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.

Relevancy 67.08%

at work we input alot of data into a single (very simple) Excel spreadsheet which is kept on a drive accessable by every computer in the office. The problem is once one person has opened it another cannot add or amend information because the file becomes "read only".

Is there a program which will allow more than 1 person at a time access and amend data in a simple database? i dont mind abandoning Excel if there is another program out there that can do what i need

A:Multiple Access Database

MS Access comes to mind since it is easy to get with MS Office. There is also the database software. I'm not sure if is multi-user, it should be and best of all its free. I happen to use MS Visual Foxpro which may be too much for you.
Relevancy 67.08%

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.

Relevancy 67.08%

Hi :

is it possible to compact a password protected Access 2000 database from code? I tried this:

DBEngine.CompactDatabase "c:\backend.mdb", "c:\backend1.mdb", ";pwd=password"

but I get an "Invalid password" error. Yet the password correctly opened the backend.mdb without a fuss in normal circumstances.

Any help would be greatly appreciated.



A:Compact Access database

I don't think you can compact a DB from code unless the code is run from another DB.

See... a DB has to BE closed to compact it.
So it stands to reason that you can't be running code while it's closed...
Relevancy 67.08%

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 67.08%

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.

Relevancy 67.08%

Trying to open a report with criteria based on input boxes on a form Want to open the report based on a name and dates cboAMName - The name of my combo box where the Account Manager Name is gotten txtSD - Text box where the start date is entered txtED - Text box where the end date is entered I have tried the following combinations without success docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between Where Clause Access Database quot amp me txtSD amp quot And quot Access Database Where Clause amp me txtED amp quot Statement Access Database Where Clause docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal WHERE tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot Without the WHERE docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot Without the WHERE with the docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName me cboAMName AND tTransaction TransactionDate Between me txtSD And me txtED docmd OpenReport rAccountManagerFeedbackReport acViewNormal tTransaction AccountManagerName quot amp me cboAMName amp quot AND tTransaction TransactionDate Between quot amp me txtSD amp quot And quot amp me txtED amp quot nbsp

A:Access Database Where Clause

Ok, I got the first part of the where clause working but cant get the second part working

Here is the code I currently have:

part1 = "([qry_Transaction_Defect_Report]![AccountManagerName]=" & Chr(34) & Me.cboAMName & Chr(34) & " )"

part2 = "AND ([qry_Transaction_Defect_Report]![TransactionDate]) BETWEEN (" & Chr(34) & Me.txtSD & Chr(34) & ") AND (" & Chr(34) & Me.txtED & Chr(34) & ")"

whereclause = part1 & part2

DoCmd.OpenReport "rAccount Manager Feedback Report", acPreview, "", whereclause
Here is the error message I am recieving:

Run-time error '3071':
This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.
Relevancy 67.08%

Hello All I am 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 Access Database Problems. this for several months now and we are currently on the implementation section which consists of Access Database Problems. 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 me So any help given will be very much appreciated as I have to hand this part of my work in tomorrow Also a few other questions while Im here I have a Telephone Number field and I would like to enforce as the starting code how do i do this In my supplier table I am unable to enter the name of a supplier with two parts to the name and have the second part have a capital how would i be able to do this What is Tab Order How do I use this I have attached a copy of my database to this thread Also I will need a detailed description of tasks as I have to print screen them for the Software and Technical Development Document Thank you very much for any help that is given I truly appreciate it Samantha nbsp

Relevancy 67.08%

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 67.08%

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.
Relevancy 67.08%

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?
Relevancy 67.08%

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

Relevancy 67.08%

Hello all,

Am trying to create an access database, which will be used in updating client records in an insurance firm. The biggest challenge is that I know very little about Access,(my I.T expertise is limited to viewing videos on youtube) I currently have the 2010 version, windows 7. 64 bit.

I would really appreciate all help in understanding how to make the database.
so far, I have been able to import the data from excel, create forms.

I need help with creating search forms, making reports and queries.

The database is for internal use, and will not be published on-line.

Thank you for your response and help.

Relevancy 67.08%

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.
Relevancy 67.08%

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.

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

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.
Relevancy 67.08%

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