Windows Support Forum

Access Database query

Q: Access Database query

Hi folks i am relatively new to using Access Databases and have a query

i have created a form in Access which users manually input data into and i trying to work out if its possible that when data is entered into 2 fields called actual hours and hourly target (both long integers) then a calculation can be done and put into another field within the same form

The calculation would be actual hours/hourly target

Hope that makes sense

Thanks in advance

Relevancy 100%
Preferred Solution: Access Database query

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

Relevancy 77.4%


I'm currently creating a simple database program using as for my API and Ms Access as for my database.

I'm doing a log-in window in my program where there is a username and password textbox.

I have created an account table (with 3 attributes - id, username and password) in MS Access and it's properly connected to my program (I just tested it a while ago by inserting id, username, and password using the program that i've created in

My problem now is I can't figure out how to check the inputs in username and password textbox (in my log-in program) and check if it's equal to the records of username and password in my database in MS Access.

Any help is highly appreciated.

A:Database query problem in VB.NET (via Ms Access)

This is how I'm doing the log-in form

Dim main As New Main

Dim cnOledb As OleDbConnection
Dim cmOledb As OleDbCommand
Dim result As Integer
Dim sql As String

sql = "SELECT account_username FROM users WHERE account_username = " & PrepareStr(txtUser.Text) & " "

cnOledb = New OleDbConnection(ConnectionString)

cmOledb = New OleDbCommand(sql, cnOledb)
result = cmOledb.ExecuteNonQuery()

MsgBox(result, MsgBoxStyle.OKOnly)
MsgBox(sql, MsgBoxStyle.OKOnly)
If result = 0 Then
MsgBox("Invalid Password", MsgBoxStyle.OKOnly)
ElseIf result = 1 Then
End If

Catch Exp As Exception
MsgBox(Exp.Message, MsgBoxStyle.Critical, "OLEDB Error")
Catch Exp As Exception
MsgBox(Exp.Message, MsgBoxStyle.Critical, "General Error")
End Try

I want the cmOledb.executenonquery() to return a value 1 when he found a match in my sql statement, however it always keeps returning 0 even if my sql statement is correct
Relevancy 77.4%

In Excel, I want to type a SKU into A1. This SKU will query a access database and import specific data into cells B1 C1 and D1. A2 will have a different SKU, A3 yet another one, etc. The query must pull information based on what I type into the A* fields.

Relevancy 77.4%


Don't even know if this is possible...

If i create an access databse and save it as db1.db (for example), upload this to my webspace, can i then query the file from my webpage??

I know a bit of SQL, but don't know how to set up a query with HTML?

Basically, i've got a table (table1, for example), with 2 fields - Name and Score. I want to bring back the top 5 names with the highest score and display them on my page... can this be done... could someone give me some basic sample code and i can then prob work it out from there...


A:How to query access database from webpage?

yes this can be done -

what version of access?

I dont if its viable on a public ISP - as i used it on a company site where I had full control over the server.
i'm sure someone will provide details
Relevancy 77.4%

Hi I m trying to design an Access database to store details about projects and related resources My idea was to have a projects table Project and a resources table Resource Project has a field called TechnicalLeadID and another called ProjectManagerID Both of these fields are related to the primary key in Resource i e Resource ID Any of the resources can Query Database Design Access and be assigned as a Project Manager or a Technical Lead I can t figure out how to write a query that selects fields from the Project table as well as the names of the Technical Lead Access Database and Query Design and Project Manager from the Resource table I ve been trying something like this SELECT Project WorkReqeustID Access Database and Query Design Resource FirstName AS TLFN Resource LastName AS TLLN Resource ResourceID AS TLID Resource FirstName AS PMFN Resource LastName AS PMLN Resource ResourceID AS PMID WHERE TLID Project TechnicalLeadID AND PMID Project ProjectManagerID FROM Project Resource but it s not returning any results I m open to changing the design of the table to something better if anyone has any suggestions Any help would be much appreciated nbsp

Relevancy 76.54%

Hello. I am using access to track what classes part-time professors at a college teach each term. My boss wants a report on the last term they taught. I have about 400 records, and the each term I have the amount of credits they have taught each term - That is how I know if they taught that term or not. I need to build a query that looks at those records and tells me the last one that is greater than 0. Or is that something I should export into a spreadsheet and build it there? Thanks

Relevancy 75.68%

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

I have a database with about 900K records of data like this:

Six fields of data including one field which is a unique value (serial number). I'm presented with a new database (new set of data) every day, the same fields and data format but brand new data.

On a daily basis, from each new database/set of data, I need to pull only those records (about 300 records for a report) which match certain serial numbers. Example: (serial number 234235 OR 23412 ... etc...about 300 serial numbers.

I'm a query design beginner so I dont know exactly how to approach this problem in ms access.

Should I just use query design in ACCESS and type in the 300 serial numbers as criteria & save that as a query? I may need to change the serial numbers queried from time to time

Any & all tips are very much appreciated!


A:Best way to perform a query with many (300+) criteria ('OR')? [Access 2013 Database]

Place the special serial numbers in their own table and in the query join the 2 tables via the serial number.
Relevancy 75.68%

Hi guys just a quick question I have created a database that allows me to keep track of all the purchases i make each month i work out of country blank Access up Solved: coming database query and need to provide budget sheets each month So instead of filling in everything on a exel sheet we have Solved: Access database query coming up blank created i thought i will create an access sheet that allows me to do all this I have tried creating multiple tables Payments from company Solved: Access database query coming up blank a payments from company b and Solved: Access database query coming up blank then invoices but to no success as none of them can be linked to one another for my final report they have no field in common Now i have created one table with all the fields i need overall but when i run a query on a specific companies payments it comes up blank how do i fix this i need a report at the end of the month that shows all the invoices for a specific company along with their payments to compare income and outcome how do i accomplish this Also bare in mind that i am a noob at access and everything i hve learned comes from the internet so access specific terms will have no meaning to me Any help would be greatly appreciated regards nbsp

A:Solved: Access database query coming up blank

Welcome to the Forum.
What version of Access are you using?

Access is a "Relational Database" system so the Tables that you create have to be related for it to work.
Ideally the tables would be set up something like this.
Company Products (for choosing to go your Invoices, so prices would probably be included).
Invoices. This table would only hold an invoice number and it's date plus the Company ID if it is a one invoice to one company system.
Invoice details, holding ProductIDs and Quantities.

If you want to set it up in that way let me know and I will assist you.

However back to your current problem, if you only have one table and a query it should show all the data in the table, so how are choosing a Company?
Relevancy 74.82%

Good morning Here are my computer specifications OS Version Microsoft Windows XP Professional Service Pack bit Processor AMD Athlon tm II X Processor x Family Model Stepping Processor Count RAM Mb Graphics Card NVIDIA GeForce SE nForce Mb Hard Drives C Total - MB Free - MB D Total - MB Free - MB Motherboard database multiple forms tables Access for Creating query, with PEGATRON CORPORATION A h X Antivirus eTrust ITM Updated Yes On-Demand Scanner Enabled Here are my questions I am trying to set up an Access database that takes information from tables Customer Info Ad Data Issue Dates and makes one form with all information included I have a quot Complete quot table with the Customer Info Ad Data and Issue dates all included that works well with Creating Access database with multiple tables for query, forms the form The problem with this is that this will easily become Creating Access database with multiple tables for query, forms a huge unmanageable database I want to be able to update the form which also updates the tables as well as being able to pull up past records I don t want to use a subform because the Ad Data are all calculated fields I also want to be able to group each ad by issue date The Customer Info table should be the master table When I try to run a query using Customer Info Ad Data and Issue Dates as a record source I get a blank query not populated with data I am not able to create relationships between the Customer Info Ad Data and Issue Date tables for the query I want to have a one-to-many relationship customer many ads Access won t let me create a Primary Key for the Ad Data table When I try to use quot Member Number quot as my Primary Key I get the following error message quot The changes you requested to the table were not successful as they would create duplicate values in the index primary key or relationship Change the data in the field or fields that contain duplicate data remove the index or redefine the index to permit duplicate entries and try again quot When I change the quot Indexed quot field to read quot Yes duplicates okay quot or quot No quot it saves the change but inserting the Primary Key makes it default back to quot Yes no duplicates I apologize if this is not clear I tried to make it as concise as possible I have been working on this piecemeal between issue deadlines since July I have read the other threads on Access databases tables relationships etc on this forum but am completely confused when I try to apply it to my own database because it still doesn t work My boss would like this ready to run by December th so I m under the wire here Any help would be greatly appreciated Thank you nbsp

A:Creating Access database with multiple tables for query, forms

sorry, forgot to add I'm working in Access 2003
Relevancy 65.79%

NOTE I could not post code because I must be really careful to protect proprietary information I work in an assembly plant and I ve designed an Access program to deliver a set of crucial parts to the floor all within code Based rerun query 2003 to Query earlier need on Access Query a very narrow degree of tolerance Further the program integrates FIFO I ve done this by assigning each of the essential measurements codes and then running a series of queries Query identifies the oldest Part A by sorting the available parts by the date they were inspected then by serial number to break ties and delivering the TOP Query identifies the oldest Part B that is compatible with that Part A using the same method Query identifies the oldest Part C that is compatible with that Part B Query identifies the oldest Part Access 2003 Query Based on Query need code to rerun earlier query D that is compatible with the other end of Part A I have the parts in this order because we can begin assembly if we don t have a Part D on hand but we must have Parts A B and C Finally query simply pulls the information from those queries into one location for a report As long as we Access 2003 Query Based on Query need code to rerun earlier query have enough stock life is good but the moment a match cannot be made it blows up I cannot figure out how to make it go back to choose the next Part A I need to figure out how and where to add code to each query to tell it that if no stock is compatible with the Part A produced by Query to go back and pick the next one in line Can anyone help Is the way I ve gone about matching parts completely wrong Thank you LDW nbsp

Relevancy 63.64%

Hi transfer (how Access 2007 to query) Query a data to another from query there I m very new to access and I hope I will get the simplest solution on my question below I have a table named quot PurchaseOrder quot and I d want to create a query that will display the invoices that will due Eg Table PONo Customer Quantity SalesPrice InvoiceDueDate A -Oct- B -Oct- C -Oct- D -Oct- I want to create queries The first query will display Query Access 2007 (how to transfer data from a query to another query) all the invoices that will due days before the exact due date Eg The invoice due date is -Oct- The query will display information on and For Query Access 2007 (how to transfer data from a query to another query) the second query I want to display all the invoices that have exceeded the due date The information on the respective invoices will be transfered from the query as mentioned earlier to the new query The scenario is as below Date -Oct- Query PONo Customer Quantity SalesPrice InvoiceDueDate A -Oct- D Query Access 2007 (how to transfer data from a query to another query) -Oct- Query PONo Customer Quantity SalesPrice InvoiceDueDate B -Oct- C -Oct- Date -Oct- Query PONo Customer Quantity SalesPrice InvoiceDueDate D -Oct- Query PONo Customer Quantity SalesPrice InvoiceDueDate B -Oct- C -Oct- A -Oct- Hope someone can help me with this Really appreciate and hoping for ur help nbsp

A:Query Access 2007 (how to transfer data from a query to another query)

The first query needs the following first Criteria Row of the InvoiceDueDate
between date() and date() + 5
The second query needs
< date()

I haven't tested it, just worked from memory. so let me know how it goes.
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


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

Google: import access to sql server
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.
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.
Relevancy 59.34%

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

Hi - am having trouble trying to perform some calculations using SQL, querying a lotus notes database. The field TotalContractValueAUS is a numeric field.

This statement:

SQL = "SELECT CustomerName, SUM(TotalContractValueAUS) FROM Bids_Open_Bids_4_Export GROUP by CustomerName"

Returns this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Lotus][ODBC Lotus Notes]Incompatible data types in expression
Does anyone know a way around this? Are there any helpful websites you know of concerning SQL querying of a LN database?

A:Using SQL in asp page to query Lotus Notes database

Check that TotalContractValueAUS does have numeric values in it on each form that you are looking at and that any forms with no value in this field have a 0 in them. It sound to me like one of the forms has a text value in or a null value. You could create a view in the notes database to show the forms and have a column with the following formula in
@If(@IsNumber(TotalContractValueAUS); "OK"; "Not num")

sort the column so all the Not nums are together and you can see if any of the docs have this problem. If this is not the case, come back to me and I will think of something else
Relevancy 58.91%

I am trying to check database. a string checking a Help a with record to in query my database to see if a entered email address has already been entered But I am having trouble with the script any ideas of what I am doing wrong lt Dim GetId objConn objRS strSql GetId Request QueryString quot Id quot Response Write GetId Response Write quot lt Bracket Return gt quot strSql quot SELECT FROM NL WHERE AD quot amp GetId Set objconn Server CreateObject quot ADODB Connection quot objconn ConnectionString quot DRIVER Microsoft Access Driver mdb DBQ quot amp Server MapPath quot FPDB database mdb quot objconn Open set objrs server Help with checking a query string to a record in a database. createobject quot ADODB Recordset quot objRs Open strSql objconn adLockOptimistic If Request QueryString strSql then Response Write quot Your are already on the list quot Else Response Write quot You are not on the list quot End If objRs Help with checking a query string to a record in a database. Close set objRs Nothing objConn Close set objConn Nothing gt Here is the error email protected Microsoft OLE DB Provider for ODBC Drivers error e Microsoft ODBC Microsoft Access Driver Syntax error missing operator in query expression email protected Edited by Talismanic on - - at PM nbsp

Relevancy 58.91%

I am running VB to query Oracle using ado 2.6 and I have noticed that Windows Explorer does not respond when a long query is being processed by the server, however I am still able to run/sswitch-to programs using task manager.

Why is this happening? Is it a driver problem?
Relevancy 58.48%

I ve got a lending table in which we lend items out now they can be loan or permanent I can run a report with the query parameter on the ReqDate Fld criteria Between Report Start Date And Report End Date The report prints and counts everything borrowed Now I want to add more records to the report to include everything borrowed that was returned paramater query Solved: use query param the report Access during that period specified by the criteria Paramenter set in the query But using the Return Date RetDate Fld How can I select rows Solved: Access query report query paramater use the param from the query based on the parameter date filled in when the query ran Report Start Date and Report End Date I can build a separate report just for the returns using the current parameter but on the RetDate Fld Between Report Start Date And Report End Date set by the query I ve got it grouping at levels to get it to break by Borrower ReqID and Request Date Does this make any sense Thanks nbsp

A:Solved: Access query report query paramater use the param

You would have to have another group for whether or not the RetDate_Fld was filled in or not.
Add a new column to the query with the following Heading

RetDatefilled: iif(not isnull(RetDate_Fld), 2, 1)

That should place a 2 in the new column when there is a date and a 1 when there isn't.
You can now group on that data.
Relevancy 58.48%

I have written a macro to make a table from data in an existing table. Then I use the data in the new table to select information in another table. That select query does not allow me to update the information in the 2nd table. It is like the records are locked. Even if I create a new table myself the select queries are locked but all my pre-existing queries work fine. Is there some type of setting I am missing that causes the information to be locked in select queries? I am thinking somehow the setting may have been changed. Any thoughts would be appreciated.

Relevancy 56.76%

I have a previously designed Access DB and there is a query that I am trying to understand. It has several tables that are queried more than once in a single query. First how do I determine the actual table name? I can only see the alias name. Also what is the purpose of using the same table twice in a query?

A:Solved: Access Query using tables more than once in same query

It is normally to do calculations or comparisons on prior or next records. It is the one weekness of Access Queries, the Totals function has some good arithmetic calculations like average, Count Sum etc but manipulating previous records like add or subtract values from the current record it can't do. So it requires more advanced SQl. Which is apperas you have.
Have you looked at the query in SQL view?
It should use the word "As" to designate the alias.
Relevancy 56.76%

For question query SQL for Query 2010 Access a report I have a customer table an invoice table and a revenue or payment table I need to produce a report that shows all the invoices created during a given month and year - that part is easy But then I also need to show the first payment given on that invoice This is a situation where there is always a down payment made at the issuance of the invoice - but sometimes people will make more than one payment during a month Example I want the customer listed for each new invoice the total amount of that invoice and what the inital payment on SQL Query question for Access 2010 query that invoice was CustomerID Customer Name Invoice No Total Invoice Amount Payment Amt So if there was an invoice issued for and they paid and during the month it was issued and the balance on the next month I still want to show it on this report as a invoice with a downpayment only The tables are established and populated so it is too late to change the payment table to allow for a unique downpayment field They all go in as SQL Query question for Access 2010 query payments My problem is that if they made more than one payment during the month the whole line with the customer name and invoice number shows up for each payment made I only wnat the FIRST SQL Query question for Access 2010 query payment I need a payment query that shows only the first payment in the month of invoice issuance Does that make sense nbsp

A:SQL Query question for Access 2010 query

Yes it makes sense, I would create a pre-query that uses the Month & Year but is set to "Totals" and Date Minimum.
Then create the Report query using the pre-query linked to the new query's table via the InvoiceID this will limit both the month, year and minimum payment.
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.

Relevancy 55.04%

Hi Access bods.
Can anyone tell me how to do an expression to query from DATATABLE (the name of table), containing

ID: Auto ID key for the table
SITEID: There are multiple sites
ITEMID: Each site will have multiple Items
QUALITYID: This is set to either F, or is left blank
Id like to find the Percentage of Non-F, to each SITEID and ITEMID combo. I hope this makes sense.

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

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

I would like to be able to have a module that does the following for an Access 2000 database

1) Identifies all objects where the dependency no longer exists,(ie a report or form with a query or table that no longer exists, a query that is based on a query or table that does not exist)

2) Identify all query dependencies (ie a query or file that lists all queries or tables that are being used in a query)

Is there any way to do items 1 and/or 2?
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.


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%

I m allowing the user to choose the key from Select combo - my bound column is the key I want a second section of the form to go and fetch ALL occurances from another table that has the key from my first step as part of the combined key I ve tried a column sql access to access bound Wanting query Solved: in subform subreport which I felt would be the ideal - I only want to display But nothing comes up I ve also tried to use a combo box and populate it with a requery but no luck there either So now I ve decided that my error is in the query I Solved: Wanting to access bound column in query access sql use for Solved: Wanting to access bound column in query access sql the combo box SELECT Tenders TENDER NO Tenders TENDERDESCRIPTION Resolutions RESOLUTION NO Resolutions MEETING DATE Resolutions RECOMMENDATION Resolutions TENDER VALUE FROM Resolutions INNER JOIN Tenders ON Resolutions Tender No Tenders tender no WHERE Tenders tender no Forms nd Copy of Find Tender Number and Resolutions Combo ORDER BY tenders tenderdescription resolutions resolution no resolutions meeting date I want tender no to be the bound column in combo in vb I d put combo column How do I put that in a query nbsp

Relevancy 51.6%


Can anyone help me design airlines website like calendar in access.

Like, when it shows, the date and the availability and the price of ticket.


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

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


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


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

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



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

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

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


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


Relevancy 49.88%

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

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


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

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

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

Hi,can smb help me with sites that have tutorials about the relation of with access databases or sql databases.
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. .

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

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

I have a huge MS Access 2000 database (about 33meg in size). How do I split that up into 10meg "chunks?" Or is that even possible?

A:Splitting an MS Access Database

33M is not that big for an Access database, but they are generally stored on a server. I assume you have this one at home and suspect that your tables are not properly normalized. Why don't you export one of them, preferably your biggest one and email it to me (zipped probably) and I'll check it out for you.

Otherwise, you could create a new blank database and export a table or two to it, then link the table to your existing database. However, linked tables can only be changed in its own database.
Relevancy 49.02%

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

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

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,


Relevancy 49.02%


I have created a new database and would like to share it among my team. However, when another user opens it, it says file already in use. How can I get the database to allow multiuser access.

I need it so that when information is entered it gets updated in real time on other users machines as well.

Please let me know if you have any solutions.



Relevancy 49.02%

In my database program the user has the option to delete clients from a list or add new ones. This works fine unless all clients are deleted and the database becomes empty. Once this happens, the user is still able to add new clients to the empty database. However, back in the forms area, it will not allow new data to be entered in the fields for the new clients.

Relevancy 49.02%

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

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

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

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

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

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

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

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

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

Is it possible to open an entire access database (reports, queries, tables, etc.) as read-only? I figured out how to make forms read only but I would like to just make the entire database read only.


Relevancy 49.02%

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

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

hi all,
i would like to ask for database performance :

currently i split my ms access database to front end (form interface) and backend. the backend file i put on shared folder on dedicated pc, which i assume as server. the database then access by 10 staff, which having the frontend file on each pc. the backend file was ~20MB in size.

there's an option, which is upsizing the backend to be sql. then install ms sql server express 2008 r2 on "server" pc, then host the backend file and modified the frontend file so, it'll access the backend database on sql connection.

is this will increase any performance from current setting?

thank you.

A:Database - MS Access Backend vs MS SQL

Hi there
probably not the answer you are looking for but if you use MySQL (FREE for non commercial users) you will improve your DB performance compared with MS ACCESS by literally ZILLIONS of percent.

It's slightly more complex to get up and running but there are tutorials all over the web.

Beats running a "cut down version" of ms sql too.

Incidentally MySQL in combination with Apache, and PHP makes a great WEB server too (WAMP). Also compatable with Linux where the same combination is called LAMP.

Relevancy 49.02%

I have to build a simple database in access with a few queries and reports. I also need a form and possibly a switchboard.

I have the start but I don't know how to build a dependent combo box and could use some help. Is there anyone out there with the time to help me get this straighten out.


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%

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

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

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

Hi all I ve just started a new job and my manager want me to build a access program I have never built a program before or have any great knowledge in doing so but I have work on access before never took a class I have started the program but I think I did things backward Building access an database I created the table just how I want it the form is working fine expect one field I can t get to work how I want The problem is first when the information is inputted into form some of the combo box and bond box with formula do not generate in table second I can t get them to show on queries either last am clues less on what to do with report and queries background information This database have to pull information from an original excel sheet Where working with retirees who is still receiving a discount for insurance discount is base on year of service I will need to generate a report for Building an access database the insurance company and also to our finance company so they can know what to pay to what department I m lost Any help will be greatly appreciated been working on this for weeks nbsp

Relevancy 49.02%

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

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

Christian K.

A:ms access database locked

Well, you could try downloading the trial version of this program:
and it will tell you the first 2 letters of your password - it might help you remember...

These guys will apparently remove the password for free if you send them the file, but I've never used it, so caveat emptor...

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

Relevancy 49.02%

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

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

I am running Microsoft Access 2002..

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

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

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

What am I missing???

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

Thanks for any help..

A:Cannot open Access database

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

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

Access database not opening completly

I have a user that is having Microsoft Access 2003 issues. There is a database created for this base only but here is what is happening.

He moved from one building to another. At the first bldg. he had all rights and access. He moved the same machine to another bldg. and tried to log on. He was able to log on but he is unable to access certain parts of the database. We have changed his permissions so that he has full permissions and we have changed the macros to that it is low. When that didn't work we reloaded Office. None of that worked. Some things will give him an "open report error" but on others it won't give him any errors at all. It just dosn't open. Any ideas?

A:Access database not opening all the way

Is that on a domain? Or just a workgroup?

If it's a domain, you have a whole mess of permissions to check. Maybe you missed just one?

As an experiment. Try to copy the whole database, COPY, to his machine directly and open it from there. If he can't even access it locally, then there has to be a problem only between Access and the DB. Usually some kind of version conflict.
Relevancy 49.02%

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