Search results

So here goes :) I have made this example database to show you my problem, I have 2 tables here: 1. "items" table that works like warehouse listing items in stock and has these fields: ID autonumber Example name TEXT Sold Yes/No 2. "sales" table has these fields: ID Autonumber Example name...

OK,I did like you said. First I opened same database in 2007 final and in 2007 beta1 in 2 separate virtual computers. Then I created simple report from 1 table in the database. I set up the wizard options the same in both cases. Exported same table from the database then compared it with file...

Where should I do this exacly? I tried the External Data -> Export Text File, selected UTF-8, then tried to Import it and got error:Invalid procedure call or argument.

Perhaps there is some third party access recovery tools for 2007? I could try them for recovering reports.

Thanks the database report record source edit feature does work in final than it beta1 I think I'll have to use it like you said. Thanks.

Hmm, is there a way to fix my reports in the new final version? It was quite an effort to make them (I mean positioning things to make them all the same etc. besides the code of cause)?

Do you mean it does not work with my reports but if you create a new report with 2007 final it works?

Hmm, they seem to load fine here. try direct download: http://www.rbstudija.com/access1.png http://www.rbstudija.com/access2.png

I taught some of you may have upgraded to access 2007, and have more experience by now. Perhaps there is somebody that would help to solve me this problem with access 2007.

I cant add these related tables in final version 2007 but I can in in beta 1. So this feature was available in beta 1, you could add from query and from tables, but now in final 2007 only from tables. That is the problem.

Hi, I did'nt get any replied in the general section so I will put a link to my msg. Please reply if you can help. http://www.access-programmers.co.uk/forums/showthread.php?t=119167

I have a problem in making reports in access 2007 final. I can't add related fields into my report. I found this page here...

Hi, I have this database where I want to see stock items left adter a sell some items. I have two tables: sell table and warehouse table. I have query2 to calculate how many stock items are left in warehouse. I want to see it in my sell query hoewver after I add it I can no longer enter data...

I'm making this db for a friend's bussiness. Thanks for your reply. My idea was that if and item is sold it contains a barcode like verthing does these days, but if a service is sold it does not. Therefore you would need to scan a barcode to enter some service. At least that how I've seen it...

Done some more tweaking now, but how to integrate "query2" column "expr1" that lists remaining stock items for that item to the "sell" query? If I just drag it in the design view I get multipe ID's see "sell query integrated" see attached db example.

I read this article here: http://72.14.221.104/search?q=cache:nCB8zOQstgoJ:pubs.logicalexpressions.com/Pub0009/LPMArticle.asp%3FID%3D88+NORMALIZATION+access&hl=en&ct=clnk&cd=4 But my database doe not contain repeated rows or colums, I do not understand what dis you mean? My problem is I wan't...

Hy, I have this db where a user can purchase and item and total stock number needs to be updated. I can calculate how many items are left but how to update the warehause table? I can live without table updating, but if the same item is purchased multiple times my query return incorrect values...

I have found out how tomake multiple unique field by selecting them with Ctrl presed down, but still howto: "barcode will be entered using barcode scanner it can be only text field but information like product name must fill in automatically, Product name must be drop down box if one wan't to...

Hi, I'm crating this db: Two tables, in one there are Items and services, in the other purchases. 1st table: ID - autonumber primary key Product Name - Text Quantity - Number Barcode - Text 2ndt table: ID - autonumber primary key Product...

Solved it myself, had to change in control panel -> regiona land language options -> advanced. You select your language and works fine