Over 1 million tech questions and answers.

MS Access 2007 - select items shopping cart-style, then update table?

Q: MS Access 2007 - select items shopping cart-style, then update table?

I have a (currently) simple Access database with Search form, to which I've added a multi-field filter, based on a nice bit of code I found online.

The next stage is to reproduce this form with added functionality, for issuing and receiving goods into stock.
I'd like for the user to be able to select multiple stock items, see them added to something in a "shopping cart"-style and then click a button to issue the selected items (subtract from stock) or receipt them (add to stock) and, print the details.

The way I'm imagining it, I'd add Issue Qty and Receipt Qty fields to the existing Stock search form. Anything that had been given an Issue Qty or Receipt Qty would populate a query. The query would simultaneously feed a subform, displaying the slected items & quantities for the user to see, and then buttons for Issue and Receive (or a single button, maybe) would allow the user to confirm their changes, updating the stock quantity accordingly, printing a report showing what they'd issued or receipted and emptying the query for next use.

I'm not sure if this is the best way to go about it. Perhaps rather than populating a query, it could or should be done with a sort of temporary recordset.
There might be difficulties in undoing, too. I'd need to have something in place to allow the user to either delete items from the "cart" subform or set the Issue / Receipt Qty on the main form to zero. In either case, it'd be necessary to ensure the stock wasn't affected when the button was clicked.

Any advice, or links to similar existing dbs?

Cheers.

RELEVANCY SCORE 200
Preferred Solution: MS Access 2007 - select items shopping cart-style, then update table?

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

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

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

A: MS Access 2007 - select items shopping cart-style, then update table?

Read other 16 answers
RELEVANCY SCORE 104.4

I am running XP home SP1 and IE 6. When I try to add something to a shopping cart I get this error "We're sorry, more information is needed to order this item. Please complete Step 2, then continue your order" on one site (llbean.com). On another site (victoriassecret.com) it acts like it adds it to the shopping bag, but when I view the bag it is empty.

I had SP2 installed and uninstalled it, and have the same results. I also have done the registry tweak to fool the system into thinking that IE6 is not installed and reinstalled it. I was able to add something to my LLBean shopping cart after doing that. The item was backordered, and when I went back to change my choice, it gave me the "We're sorry, more information is needed to order this item. Please complete Step 2, then continue your order" error again. I have run the latest Spybot S&D, and Adaware versions and deleted some spy/adware. Still having the problems. Hijackthis 1.99 log below:

Logfile of HijackThis v1.99.0
Scan saved at 8:13:46 PM, on 1/3/2005
Platform: Windows XP SP1 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\LEXBCES.EXE
C:\WINDOWS\system32\LEXPPS.EXE
C:\WINDOWS\system32\spoolsv.exe
C:\PROGRA~1\COMMON~1\AOL\ACS\acsd.exe
c:\... Read more

A:IE 6 wont let me add items to shopping cart

got this working by deleting all of Dell's mcaffee security center which for some reason was not allowing me to shop online after installing XP SP2
 

Read other 1 answers
RELEVANCY SCORE 94

I have IE7. I connect through road runner. I have not made any changes to my computer. everything was fine. Did a virus scan. talked to road runner.. etc. I cannot get to the site that hosts my shopping cart. www.ecartsoft.com from my computer. also I cannot log on to access my shopping cart account. I talked extensively to my shopping cart tech. all is fine there. we did a tracert and traced my steps to their server.. seems like somehow their server is not allowing my computer in. I also cannot use the shopping cart on my own site to test it.. It times out, can't find site..etc.
I deleted all temp files, history, cookies, turned off firewall.. etc. etc. checked internet options. we went over it all! this is sudden. I have had this cart site for almost a year with no problems. can anyone shed some light. I can access all other sites.. My bank, aol, ebay, etc.. etc. no problems. seems like it is my computer??

A:can't access my shopping cart or their site

Please do this

Click Start => Run and copy and paste the following line into the run box: regsvr32 urlmon.dll, press OK. Once it is copmpleted you will get this message DllRegisterServer in urlmon.dll succeeded, repeat the above steps, but replace regsvr32 urlmon.dll with:

regsvr32 actxprxy.dll
regsvr32 shdocvw.dll
regsvr32 mshtml.dll
regsvr32 browseui.dll
regsvr32 jscript.dll
regsvr32 vbscript.dll
regsvr32 oleaut32.dll

Read other 3 answers
RELEVANCY SCORE 91.6

I am (a novice and) trying to make a shopping cart for a bookstore (using visual studio and visual basic). The shopping cart page shows a gridview where all the items the customer wants to purchase is listed (the gridveiw has columns for isbn, title, price and amount). The amount column is a text box, where the user can change the amount. Under the grid view I have a button <update amount>. A click on this button is supposed to go through the gridview to see if the user has changed the amount of any of the books. If so, the price of this item(book) is to be changed (prise * amount of the item). If the amount of one book is set to 0 the row is to be deleted from the gridview. Can some one help me with the code needed to accomplish this???

At the end of each row in the gridview I have put a button <remove item>, and a click on this button is supposed to delete the selected row from the gridview. The gridview is listed on the shopping cart page with this code:

GridView1.DataSource = Session("kurv")
GridView1.DataBind()

What code do I need to accomplish this removal of the selected item?
 

Read other answers
RELEVANCY SCORE 88

I have created a select query where I am attempting to update/revise data to the Table in the datasheet view. This process seems to work only when running the query is first run. When changing criteria of the query and re-running the query, the fields are locked and I can not make any changes. Why is this? Is there a better way to make Table updates rather than a select query?
 

A:Update data in Table via Select Query wit Access 2003

Read other 8 answers
RELEVANCY SCORE 82

I am currently building a database to track uniform service orders. I have created tables for Customers / Employees / uniform# / uniform options (individual tables for each option)/ Service Item (IE type of repair) etc. I have linked everything to the unique uniform #.

I have a Order ID Table which has the fields "OrderID" "Customer Name" "DateIn" "DateOut" "Uniform#". I have a Order Items Table which has the fields "OrderID" "Service Item" "Service Item Quantity".

I have created a form "Work Order". The OrderID is an Autonumber from the Order ID Table. When I type in the Uniform # the workorder autofills all the information pertaining to that uniform. Ie: Customer Name, Employee Name, Colour, Size.....etc. I input DateIn and DateOut. The items I input myself ie: uniform#, datein, dateout all update my order tracking table just fine.

The problem I am having is that the autofilled items ie: Customer Name, employee name do not update the order tracking tables.

I have subforms that have dropdown boxes to select the Service item, which in turn autofills the price.
I input the quantity of the selected item. All the inputs are linked to the Order ID Table and the Order Items table. These update the Servicetable just fine.

The whole idea of the database is so the seamstresses can fill out the order form for repairs to each uniform as well as wash rate and rental rate. Then at the end of th... Read more

A:Solved: Access 2007 Form does not update table

Read other 16 answers
RELEVANCY SCORE 82

I have created a database in Access 2007 with 4 tables, Customers, Products, Orders, and Order Details (the specific items for each order). I know you don't want to dupliate data and "calculated fields belong in reports and queries" but we change the prices frequently and I need the UnitPrice from the Product Database to "update" to the Order Details Table on the day the order is input.

I have a Order Input Form with 2 sub-forms and my relationships are set one-to-many on primary keys. All other queries and forms work great. I have tried looking at the Northwinds database to determine how they do an "AfterUpdate" event procedure but I haven't used VBA since Access 97 and am not able to convert it for use with my form.

Help is appreciated!

 

A:Access 2007 Update Table Field from Form

Cosla, have a look at the database that I posted here
http://forums.techguy.org/business-applications/931652-vba-ms-access-2007-a.html
at post #5.
 

Read other 3 answers
RELEVANCY SCORE 79.2

Ok, so I just set up a merchant account, now I need the shopping cart thing.
I have no experience doing this sort of thing, and I could use a little help getting it going.

basically I need to know:

where do I go to get a shopping cart (free would be preferable, since I already paid for the account...), and how do I integrate it into my website?

Is there somewhere I can go to just get the code so I can "copy and paste" into an html form? what language would it use? Java, php, html, etc.
 

A:shopping cart

Abdhul said:

Ok, so I just set up a merchant account, now I need the shopping cart thing.
I have no experience doing this sort of thing, and I could use a little help getting it going.

basically I need to know:

where do I go to get a shopping cart (free would be preferable, since I already paid for the account...), and how do I integrate it into my website?

Is there somewhere I can go to just get the code so I can "copy and paste" into an html form? what language would it use? Java, php, html, etc.Click to expand...

How about this? http://www.online-store.co.uk/
 

Read other 2 answers
RELEVANCY SCORE 79.2

I downloaded CubeCart and am trying to work on it in either Dreamweaver or the File Manager on my server. Either one will work but I'm CLUELESS as to where to start.

I don't know how to put this all together and make it work and the installation instructions may has well be written in Greek. I don't know where to start...there are two header.php and two index.php and two of this and two of that and you get the drift. HELP....I need someone to walk me thru this or I may just lose my mind.

I downloaded Cube Cart cause I can *mangle* the logo easier than I can the one on osCommerce. At least I did when I was using the server I had before but that one had it laid out where I could identify which files were which...now I am on my own. This isn't a Fantasico or C-panel. Liz
 

A:Okay, I am trying to put together my shopping cart

First off, does your web server or web site meet the requirements for using CubeCart? PHP 1, MySQL on a Unix/Linux Server?
 

Read other 2 answers
RELEVANCY SCORE 78.4

I'd just created a website with shopping cart but it always said the "shopping cart is empty" when I go to checkout. But it's fine with IE10 or FireFox.

A:ie 11 shopping cart glitch

Hi,
Please post questions about html, css and scripting for website developers to
IE Web Developer forum
Naturally include a link to your website with your question so that someone my visit the site to investigate the issues.
or
go to http://modern.ie to find some tools and downloads to troubleshoot website compatibility issues for website developers.
to debug web pages fist
display the Developer tool (f12)
then select the Debug tab, and then refresh the page to show suppressed error messages.Rob^_^

Read other 2 answers
RELEVANCY SCORE 78.4

I am wanting to do a shopping cart for my clothing line company. Standard buying and selling etc.. I have looked at a few options. I am not sure what my boss entirely wants but i enjoy the php/mysql options, though maybe I want ASP or something else? I have found myriads of these at vairous prices and some free? I was hoping someone here in the techsupportguy forums could give me some experience suggestions or ask me questions to determine my needs and then give a suggestion on that. If i can get away with inexpensive and highly flexable or powerful whatever software that would be great! The boss is kind of looking at cold fusion but thats not anything solid. we just want something excellent. He has had a bit of experience with it. Anyone Anyone ?

and um.. is this the right forum to ask this type of a q?
 

A:What are the best shopping cart programs available?

Check out http://www.oscommerce.com/
 

Read other 3 answers
RELEVANCY SCORE 77.2

When adding items to our Paypal shopping cart we can continue shopping to add more items by clicking on the continue shopping button. However, a POPUp appears notifying you that "The webpage you are viewing is trying to close the window-Do you want to close the window-yes or no"
This is confusing and is there a way to deactivate that POPUP from showing up. It only appears on internet Explorer and not Google Chrome or Firefox.
Any help would be appreciated

Thanks
Al

A:[SOLVED] Paypal Shopping Cart Pop Up

Hello and welcome to the forum.

You should be able to click on the pop up and click Allow.
Click Start = >Internet Explorer => Tools => Internet Options => Click on the tab Privacy => Under Pop up blocker click Settings => Enter Paypal and click Add

Read other 3 answers
RELEVANCY SCORE 77.2

When shopping on line nothing will go into the shopping cart! Someone walk me thru on how to allow me to do this. I have windows xp with ca suite security supplied by road runner internet with what ever e machines put in the computer when you buy it.

A:security & cookies & shopping cart

What internet browser are you using?

Read other 1 answers
RELEVANCY SCORE 77.2

The webhost for this shopping cart site creates the codes needed to make it work on a separate page for each item. I copied the codes for each individual product and pasted them onto one page.
Each item contains a form with hidden fields that consists of the product's id # so that the shopping cart processor should know which item is being purchased when the buy button is being clicked.
However, the different products are not being recognized on the page, but rather, every buy button interprets as if the first item on the page is being purchased again and again.
Being that I'm not familiar with javascripts, I don't know how to format this page so that the buy buttons for each individual item sends the right info. One thing that I did learn is that 2 forms one 1 page cannot have the same form name so I altered the name of the 2nd form to celectvar as opposed to selectvar (the default name given by the webhost).

Following is a clipping of the scripts and forms for the 2 first products on the page.
PHP:

<script> function validateSelect() {    

 var 
els Read more

A:javascript used in a shopping cart site

So what is your question exactly?? They have bad coding on their site and are only going to be selling black & white cookies. They should have tested the pages before they put them on the internet.....poor business decision.
 

Read other 3 answers
RELEVANCY SCORE 77.2

Hi I am working on a shopping cart for books in visual basic and can not figure out how to remove a selected item from the cart and adjust the price. any help would be appreciated

Thanks
 

A:Help with Shopping cart for visual basic

I don't use visual basic ... but only can give you some program idea....

on the cart screen it should have a "check box" hold the id of that item ( id should be the shopping cart id + which row in the cart)

when the "check box" is click ... and you press "Upadte" button to post..

you have the the shopping cart id and the item row value to remove it ... then refresh the screen again...
 

Read other 2 answers
RELEVANCY SCORE 77.2

Hi guys, I'd like to learn more about integrating a shopping cart application with a merchant account.

I understand the mechanics of obtaining credit card information from the user via HTML forms and whatnot. What isn't clear to me is what I would then do with this information.

I've done some searching and all I can seem to find is tutorials on making the actual shopping cart software, which I can do myself, and links to other purchasable shopping cart software.

Can someone link me to a page or book that covers this topic in detail?
 

Read other answers
RELEVANCY SCORE 76.8

Sometimes my tables in Word 2007 seem to be 'split' even thought they appear to be all one table. If I've created a table then moved rows around, I see strange behavior when I want to do an action on the whole table or a column. If I either select a column or select the whole table, only the top n rows are selected. I have to 'split' the table beginning at the row which is not selected, then tab through on the last row of the first set a couple of times to create 2 more rows, then select all the columns of the remaining table and drag those rows up to the 'main' table. Sometimes I have to do this 2 or 3 times before Word sees my whole table as a unit, as opposed to several mini-tables that appear to be a unit.
I know I must be missing something fundamental about tables in 2007. I never had this problem with Word 2003. Also, my apologies if this isn't really clear - it's hard to describe! I can't reproduce it with a dummy document so I don't have an attachment to upload.
Thanks for any help.
...Lea
 

Read other answers
RELEVANCY SCORE 76.4

Some business web pages don't display the shopping cart box on the web page on one Dell computer with WinXP using either IE or Firefox. These same pages work correctly on all our other computers. When looking at properties on a laptop alongside the Dell and comparing, all seems the same. Have tried restore back several months, have shut off pop-ups and turned back on. have updated Java, same problesm.
 

A:some web pages don't display shopping cart icon

Read other 16 answers
RELEVANCY SCORE 76.4

Yesturday the Shopping Cart on Newegg stopped working. I did have it working earlier in the day as I had compiled a list of items but when I went back later the cart was empty. I logged back in thinking it would be there but still it was empty. Now whenever I click on "Add To Cart" it takes me to the next screen saying it has added it to the cart but the $ counter in the top right corner stays at $0.00 and when clicking on the cart itself or proceeding to checkout it tells me the cart is empty. It does this whether I am logged in or not.

I tried adjusting the Cookie settings like their site advises but it didn't seem to change anything. They did suggest going into Tools, Internet Options, Security, Custom Level then scrolling down looking for Cookie options (there is no option for cookie listed there). But under privacy I found cookie options and changed it to accept all but still the problem was the same.

The weird thing is that yesturday sometime before the problem started the browser history was somehow erased. Nobody actually went through the steps and cleared the history though. The only actions that were performed between the cart working and not working were photo's being uploaded from a camera and the MyDocuments folder being accessed by another computer on the same network. The other computer on the network has no problems with Newegg's cart but this one - a laptop on a wireless network using XP and IE version 6.0 still does.

There no wer... Read more

A:Solved: Newegg Shopping Cart not working

I guess I should've researched this a little more thorough. My clock was a set to feb' instead of jan' - changed that back and all is well. Doh!
 

Read other 1 answers
RELEVANCY SCORE 76

Hey there folks...
I am in need of some assistance. Obviously!

I need a form which allows a user to select a record from one table and completely move the record to a totally separate table in the same database. I need it to transfer all the data for the selected record.

AutoNumber will not be an issue as each record has unique identifiers.

I found this article online but it seems it will append ALL data and doesn't allow a user to select the correct record. This uses an Append Query which makes sense but again it seems as though it will transfer ALL records. All I need is for it to transfer a specific record depending on the user's selection in the form.
 

A:MS Access 2007: Moving a record from one table to another table...

Is this to "Archive" the record?
It is not normally necessary to actually "Move" a record, as you can just have a tick box called archive or similar that can be used to exclude that record from normal display and to display it as an Archived record.
There are 2 ways to do what you want, if it is really necessary, one is using an Append query, you can Identify the currently selected record on the Form using
forms![Form Name]![name of Key Field]
in the First Criteria row of your Key field, where Form name is the actual name of your form and name of Key Field is the actual name of your Key Field.
The other version is to use a VBA recordset Clone to do the same thing.
The
 

Read other 1 answers
RELEVANCY SCORE 74.4

Hello,

After creating a document, I used Word 2007's Table of Contents feature to build the T of C. In the document, I had used text boxes to place some images in the document, using the text-box layout feature to wrap text next to the text boxes, whose right-hand edges align with the right-hand margin of the text.

I noticed that where those text boxes have been placed, the level 3 subheads (which have been included in the T of C set up) do not appear in the T of C when I build it. The ones on either side do, but not the one where the image in a text box is.

Any suggestions? I want to retain the text wrapping feature. Is there a way to do that and have the T of C function work?

Thanks,
Bill
 

A:Solved: Word 2007 Table of Contents Items Not Showing Where Text Box

Read other 7 answers
RELEVANCY SCORE 73.6

I have 2 tables, Table A has 16000 records all addresses in a certain region (ID, address1, address2, postcode, mailout) and Table B has about 1100 records with all unique postcodes and the number needed for each postcode (Postcode, Needed (numeric field)).

I need a query that joins the tables on postcode and then randomly selects the number specified in the needed column and update mailout to yes (mailout is a yes/no field).

So something like:
UPDATE TableA SET Mailout=True
Where Key (SELECT TOP [TableB.Needed] INNER JOIN TableA.Postcode=TableB.Postcode
ORDER BY Rnd([ID]);

I know the above syntax is total rubbish, but consider it as pseudo code
 

A:Solved: Access Select Top Table Variable

Read other 16 answers
RELEVANCY SCORE 73.2

Hi guys

I have a MS Word 2007 document, with a table of content, showing 4 levels of titles.
The problem is that the table of content shows, when I update it, some parts of the body text. It is more precisely, some titles of figures, tables, etc.. I have the feeling Word interpret them automatically as heading style 1, even they are in style normal. Maybe because they are centred??
I select the title of the figure then I click on:
- clear formating, or
- i select normal style again, or
- i select references, then add text, and select option do not show in table of content.

each time the title disapear from the TOC immediately. Then I save the document, but when i re-open, it the title is present again in the table of content....

i've tried saving the document in both .doc or .docx, same result.

Any idea what is going on??

thank you in advance for your reply
 

A:"Normal" style text permanently in table of content in MS Word 2007

The biggest thing I dislike about Word (any version) is all the automatic stuff it's by default set to do. The worst is the "Autoformat as you type" feature. Have you checked the settings there?
 

Read other 3 answers
RELEVANCY SCORE 72.8

I have a tblRecords which contains a Document field with a unique but not necessarily sequential DocumentID.
Each Document in turn has a number of records. (tblRecords has say 8 records where the DocumentID is for example 73.
Out of these 8 records:-
Am trying to select the "n"th (third,fourth, or sixth etc) record where the field is "NoRemaining"
Can I use VBA ,a query or combination of both and how do I achieve it?
Hoping a guru can help. Thanks
 

A:Select nth record from filtered Access 2010 table

Lapun, welcome to the Forum.
You should be able to do what you want with a simple query that uses the "NoRemaining" as a Criteria of the query.
 

Read other 2 answers
RELEVANCY SCORE 71.2

I am having trouble updating data from one table to another. I am not Appending the data.

I've linked the two tables on an ID field.
I created a select query to see the data I would update.
I changed the query to an Update query.
In the Update To field I placed the following: [table].[field name]

After running the query I noticed the update did not work. The data from the first Table did not get updated to the second Table it wound up being deleted from the first Table.

Your help is appreciated.

Buttercup
 

A:Solved: Access 2003 Update Table from another Table

Buttercup1, welcome to the Forum.
I am not sure why you wan to update the second table with data from the first table.
Can you show me a screenshot of your query with the table(s) in and also your Table relationships?
 

Read other 3 answers
RELEVANCY SCORE 66.8

This seems like it should be very easy to do but I must be having a brain cramp because I can't seem to make it work. I am seeking a way to parse a single large table into a group of smaller tables. Each of the smaller tables can contain no more than 98 records. So, for example, the large table may have 472 records but I need to split that up into five smaller tables, four containing 98 records each and the fifth containing the remaining 80 records.

Any suggestions are greatly appreciated!
 

A:Solved: Splitting an Access 2007 table

Read other 10 answers
RELEVANCY SCORE 66.8

Hello all! Thank you in advance for the help. The following is some sample data I will be using.
Table [MM300]
[Work Order] [Order Start Date] [Order Complete Date] [job lengths]
1 3/13/2013 3/16/2013 4hr
2 3/11/2013 7/15/2013 600hr
3 7/13/2013 9/15/2013 3hr
4 3/13/2013 3/22/2013 2hr

I want to spread the hours across every day between [Order Complete Date] and [Order Start Date] and then sum the number of hours applied to each calendar day by all [Work Order]. In the real world, this shows how much work needs to be done per day.
For example, [Work Order] 1 will have 1 hour applied to 3/13, 3/14, 3/15, 3/16 (4/4=1hr).
Since table MM300 has 80,000 records, I think my previous approach has been making too many records and the query does not complete. I have a table with a calendar, and tried to join the MM300 table based on a date range.
Help please!
 

A:Access 2007: Table Join Question

I can see a slight problem with what you want to do and that is weekends, do you really want to allocate hours to Saturdays and especially Sundays?
Also take work order 4. it will have 1 hour split between 10 days, ie 6 minutes per day, is that actually realistic for how the business will be done?
Each work order record is going to produce a number of sub table records for each day, assuming that you want to store the data, so your sub table is going to hold 80,000 x the average number of work orders days.
Probably the easiest way to create the data is using VBA code.
 

Read other 3 answers
RELEVANCY SCORE 66.8

Hello,

I want to thank you in advance for any help you can offer me. I have created a database which tracks customer contact information and customer interactions.

I have 2 tables
tblCustomers
tblEngagement

These 2 tables are linked by a junction table. I use a form to fill out both of these table. Everything appears to be working. The CustomerID shows up linked to the correct EngagementID in the junction table.

However, when I try to query the two I get an odd output.

If I have 2 customers, Steve and Bob and 2 employees Employee 1 and Employee 2 that have 2 interactions.

Steve talks with Employee 1
Bob talks with Employee 2

So My junction table looks like:

ID auto number; Steve's ID; Employee 1 ID
ID auto number; Bob's ID; Employee 2 ID

My junction table shows the correct FKs linked

When I try to do a query (I have tried multiple different ways and am at a loss at this point)

I get Steve talks to Employee 1; Steve Talks to Employee 2
Bob talks with Employee 2; Bob talks with Employee 1

I cannot figure out where the second linkage is coming from.

I hope that is enough information to get you started because I just can't figure this out.
 

A:Access 2007 Junction Table SNAFU

DrewBean, welcome to the Forum.

What Relationships do you have between the tables?
Did you create a Query based on the Junction table first and then add the other 2 tables?
 

Read other 2 answers
RELEVANCY SCORE 66.8

I have multiple fields in my table, two of which are called Customer_ID and Supplier_ID. They are just text fields. What I need to do is make sure only one of them is filled in each record. In other words, how do I constrain 2 fields to keep one from being filled when the other already has something in it? I'm using access 2007 on windows xp.

Thanks!
 

A:Solved: Table fields, one or other, Access 2007

Read other 8 answers
RELEVANCY SCORE 66.8

I am using Windows XP with Office 2007

I have two separate tables that I imported into Access that include student data for an entire school district. Each table includes some similar data (state test scores, suspensions, attendance, ethnicity,etc.), but most is different.Table 1 holds data for every student in the school (1300 students). Table 2 holds data for students that took an ESL test (300 students). The column headings are mostly different and I don't want to change them because there are too many.

I would like to use Access to combine the two tables and make one giant data source. For example, I want to take all of the columns from Table 2 that don't exist in Table 1 and add them.

Here is what I've done so far and haven't succeeded. Each table has a unique student ID that I use as the primary key. I also use the ID to create a relationship between the two tables.

I've run queries and I lose students and end up with 300 students. Which means that the query is only showing data that appears in both tables (I think). The goal is to have 1300 students with the table 2 columns added.

Trying to append, I keep getting an error message that tries to get me to rename columns so that both table have matching column titles. As stated before, I don't want to do this.

I may not need to run a query. I am really not sure how to do this...PLEASE HELP!
 

A:Solved: MS Access 2007 Table Merging

Read other 11 answers
RELEVANCY SCORE 66.8

Hi All, I have two Tables in same Access Database file. Table 1 has fields: ID, Cardno, CustomerID,Date,Frame,Prescription, and TABLE 2 has fields CustomerID, Name, Age,Address,Town.. As you can see the only common field in both Tables is Customer ID. I want to combine the fields from TABLE 1 and TABLE 2. Such that it displays me CustomerID, CardNo, Name, Date, Address,Town.. How can i do this..Either in one of the two tables, or create a third table if need be... I tried QueryWizard, it shows customerID as the common field between both tables, however on clicking RUN, it says Type Mismatch in Expression.. I am not technical person, nor have i used Access before, so please answer in simple ways, illustrations would be easier, we have 300,000 data in both tables and need to search Patient records cant go back and forth between one table and other..so thus need of one table displaying all data.. Thanks..
 

A:Combining 2 Tables in access 2007 into one Table

Read other 7 answers
RELEVANCY SCORE 66.8

Hi All,

I have one problem i want to show some fields in tabular in Form, is there any way to do like this, also i tabular item is from one table only. Its not from multiple table.
 

A:Can we make table in form in access 2007

On the Main Menu, Create section, Forms section, click Multiple Items.
 

Read other 2 answers
RELEVANCY SCORE 66.8

I'm relatively new to access, only been working with it on and off for the past few months or so and have run into a little problem now.

Basically, a date is entered in a field on a table called "Date of Entry", and another value is entered in a different field called "Serving Period". Now I have another field called "Expiry Date", and basically it's the value (date) of "Serving Period" added to the date in "Enter Date". I suppose that it would possibly have something to do with the Default Value of the "Expiry Date", but that's where I'm confused. Of course, I need not make it automatic and let the user do the math himself, but I'd rather it was done this way if possible.

I'm using Access 2007 on Windows 7.

Any help appreciated.
 

A:Default Value for table field in Access 2007

Read other 9 answers
RELEVANCY SCORE 66

I have an entry form with several combo boxes that lookup information in existing tables for ease of use. The combo boxes allow information to then be written to one main table. I would like to automatically update the tables that these combo boxes are linked to. I have managed to do this by writing the following code in a test form:

Private Sub cboSubFunction_AfterUpdate()
'Save record and requery combo control.
DoCmd.RunCommand acCmdSaveRecord
cboSubFunction.Requery
End Sub

The problem is it only works whenthe form is bound to the specific table that the combo box looks up. I need the information to be saved to the main table of data which the form is bound to as well as the table the combo box looks to. Can this be done?

Can anyone help please?
 

A:Solved: Access 2007 Table not Updating from Combo.

ginaw, what you are asking is not the way that Combo normally operate they are for "selecting" data in one table to put the Selected ID in another table.
If you want to "Add" data to both tables you use the Combo's "Not in List" Event Procedure to do so, but you also have to set it's "Limit To List" to Yes.
 

Read other 3 answers
RELEVANCY SCORE 66

Hi,

Over a month ago, I posted this topic here:

http://forums.techguy.org/business-applications/954178-default-value-table-field-access.html

However I never had the time to try out the suggestion. I've finally gotten a holiday though, and so gave it a go. Here's the code I'm using in the After Update Procedure, as advised by OBP:

currentyear = Year([DateofEntry])
newyear = currentyear + Me.[PeriodLength]
Me.[ScheduledDateofRelease] = Left(Me.[DateofEntry], 6) & newyear

It does work, so thank you for that

However, it does produce some odd errors. First of all, it only updates the "ScheduledDateofRelease" after I have clicked "Save" on the form, and once I try to close the form access gives me an error saying that:

"You cannot save this record at this time". In the same dialogue box it says "If you close this object now, the data changes you have made will be lost. Do you want to close the object anyway?"

After clicking yes on that box, and navigating to the table which is the source for this form, I find that the new record has indeed been added, contrary to what the error message was saying.

Another odd thing that occurs is that once I enter a new record into the form and click save, I can't go backwards or forwards through records on the form and am instead presented with the error stating "You can't go to the specified record."

Any help appreciated
Slikbaz.

edit: I've just rea... Read more

A:Solved: Default Value for table field in Access 2007

Read other 16 answers
RELEVANCY SCORE 66

I currently have three table joined in a database which have worked providing queries, reports. However, I cannot get the query make a table consisting of all three tables. What's wrong?
 

A:Solved: make table query in access 2007

Read other 16 answers
RELEVANCY SCORE 66

Morning all,

I have a question...my columns in my database table keep on rearranging themselves every time I make a minor change and then close the table and reopen it again. Can someone explain why it keeps on happening. Thanks.
 

A:Access 2007: Table columns order rearranging

Read other 8 answers
RELEVANCY SCORE 66

simple databe for inventory i created and 2 of the fields are not writing info to the table after they are filled in on the form. One of them is a drop down box for several choices and the other is a field for the amount of inventory left which is automatically calculated depending on the user entering what they shipped verus what they received in? I am stumped on this since all the other fields are writing to the perspective table columns. Please someone help me !!! lol

Anthony
 

A:Access 2007 Table does not contain all info from form fields

Read other 6 answers
RELEVANCY SCORE 66

Over the past several months I have been working on an Access database for my company in order to make our operations a bit more efficient. The database was coming along quite well, then my motherboard on my computer needed to be replaced. This may or may not have anything to do with the problem, but when I returned to working on the database my queries would not pull from the tables as they were before. So here is what I am experiencing:

In my Access 2007 Database, I can input information using the forms. This information then appears in the tables where it should. However, the queries are not pulling the information from the tables. Even information that I input directly in the tables (without the forms) do not appear. Because my queries are not pulling the table information, my reports also are not functioning properly to show the data present.

I have been trying to uncover the bug with this for some time and cannot figure out why they are not working. If I create a new query, these queries will work, but I have already put much time and effort in the current queries, forms, and attached report so do not want to have to redo all this work.

If you have any advice for me I would like to receive it. Your support is greatly appreciated.
 

A:Access 2007: Queries not Pulling Table Info

Read other 13 answers
RELEVANCY SCORE 65.6

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.
 

A:Solved: Access Make Table Query and Select Query

Read other 7 answers
RELEVANCY SCORE 65.2

I'm working on a database where a user can perform searches by dates and when they click my command button it saves the form's data into a table then runs an SQL sequence which creates a table. I need that table to delete the results and append when the next user performs a search. My code is as follows

'CurrentDb.Execute "Update tblFilter set InspectStart=#"
cboStartDate.Value = Null
cboEndDate.Value = Null
RunCommand acCmdSaveRecord
sql = "Select * into tblInspectionDateFilter from qryInspectionDateFilter"
DoCmd.RunSQL sql
'DoCmd.OpenQuery qryInspectionDateFilter, acNormal, acEdit'
Call MakeTables
DoCmd.OpenReport "MasterReport", acViewPreview
I am not sure how to go about it. Need help please. The qryInspectionDateFilter is the one I need to delete and append to. Thanks
 

A:Deleting a table and appending its records before a query in Access 2007

ladyvj, can I ask why you do it this way?
Why create a table to create another table?

To answer your actual question you just need to create a "Delete Query" for the table that you want to clear of records and run that at the appropriate time in your current VBA code
 

Read other 1 answers
RELEVANCY SCORE 65.2

I am working on an Access DB written by someone much cleverer than me who has use a lot of SQL which I find hard to interpret. It is a DB of client info and order info. I exported the Client Table to Excel so that I could more easily sort out the data (separate name fields into Title/First Name/Last Name, for example) and then I wanted to import the cleaned data back into the Access DB.

I renamed the existing table as Client Original and I successfully imported the new table giving it the samename as the original used to have so that there wouldn't be any issues involving queries etc which relied on it unbeknown to me.

I needed to add a field from the Client Table to an Order Form but - to my surprise - the only table available to me was the first one which I had renamed as Original; the new one which had the old name wasn't seen by the Add Fields box - it is as if it doesn't exist (but it does!!)

I then tried to import into the Client Original table instead, but get the message that it cannot overwrite this table when I get to the end of the wizard. There are no relationships at all involving the Client table (and when I show the Client Original table on the relationships screen it's name is given with _1 at the end of it which isn't in the name I gave it .) I am thinking that the guy who wrote the DB has something hidden in the SQL somewhere which is stopping me from being able to overwrite this table.

Has anyone got any ideas please?

Many tha... Read more

A:Access 2007 - will not overwrite existing table with Excel data

Read other 11 answers
RELEVANCY SCORE 64.4

Now that I have the rate information pulling from my other table, the Rate Total won't calculate unless I overtype the rate field with a new entry. What I would like to do is just press enter to confirm the field and move past it and have the total automatically recalculate.

I think that this would be an event procedure on Enter but I don't know what VBA code to use to make it happen?

Can you please tell me if this is correct and what code will make this recalculate?
 

A:Solved: Access 2007, Recalculate field after data is pulled from table. OBP??

Read other 8 answers
RELEVANCY SCORE 64

Looking for the best approach to updating/altering an Access table via DSN-less connection string.

Situation: This process will be run nightly via MS Schedule tool

Database
1 - contains 1 table which acts as a linked central datasource for
numerous databases - this cannot be change. - in some instances this
maybe left active which affects the altering of the table. Alter is
need to change 3 fields's data types or convert prior to update.

Database
2 - contains the temporary table and the code or possibly just the code
to update the data in the linked table source.

Note this code
cannot be kept in DATABASE1 - due to the fact that this database is
occasionally opened and used by other users, so I cannot have the
Autoexec fired when the user access the database - hence the need for
Database2.

Now the Oracle data source contains numerous fields
that need to be converted in 1 way or another, including converting a
date that in contains a text (varchar) datatype ie. 090822, when I
attempt to covert this and place in an Access Date/Time field - I am
getting an error.

My thought is to create the temp table then
export into Database 1 - which will replace the existing with the new
data - or possibly have the Database2-tbl linked in Database1 and do a
delete and append queries - however, then I run into the conversion
issue.

Any and all suggestions is greatly appreciated.

Note
the date field = SERVICE_DUE_DATE_CMT, LAST_SERVICE_DATE, PURCHASE_DATE
that needs the conversio... Read more

Read other answers
RELEVANCY SCORE 64

I've got a multiple item form in Microsoft Access 2007 which has an integer field displaying on it, I want to change the value of a text field on the form corresponding to the integer value for that item. I can do this in VBA with a select case when there is a single item on the form, but I can't figure out how to make it work on a multiple item form for all items other than the top one.

Just as an example if I haven't been that clear, when the integer field is 1 or 2, I want a text field to display "High", however when the integer is 3, 4 or 5 the text field should display "medium" and so on.
 

A:Solved: Access 2007 multiple items form

Unless the Text field is in the Table recordset (Bound) when you change the value it will change it for all the unbound field for all the records.
The other alternative is to do this in a Query in a new field Column Heading using IIF statements, but this would only work for old records, for new records you would need to do a Requery to display it.
So the simplest method is to create a field in the table.
Or you could go the whole hog and create a separate "Lookup" table for the value and the text and then use a combo box on the form to display the data.
 

Read other 2 answers
RELEVANCY SCORE 64

I have a simple query that sorts the item numbers in a report ascending. When I run the query everything is in 1,2, 3 order perfectly, but when I use this query in a report, the items come out descending (3,2,1). Something is overriding my sort order and I can't figure out what it is. Any help would be appreciated. ...
 

A:Solved: Access 2007 Report -not sorting items

The Report has it's own Sorting & Grouping function which completely ignores the Query (unlike a form). With the Report in design view, Main Menu>View> Sorting & Grouping ands set it there. You can also set it in the Report Wizard, but you may not have noticed it.
 

Read other 2 answers