Type mismatch error

[JakeC11]

I've already recieved some very handy help from this forum, and hopefully someone has a minute they can school me again.

I'm finishing up a database that will track purchase orders. I'm down to just a couple little glitches before I feel like its good enough for what we need. My two biggest issues are 1. I'm getting an error every time I try to open/generate a printable purchase order report 2. I haven't been able to find a straightforward walkthrough on how to set up the database for multiple users.

Any time I try to open the report Purchase Order, I get the error. The report is meanto to show a printable version of the current purchase order. Any help would be greatly appreciated!

 

[Uncle Gizmo]

>>>2. I haven't been able to find a straightforward walkthrough on how to set up the database for multiple users<<<

The best way to set your database up for multiple users (assuming you are on a LAN which does not have any radio links) is to put the tables into one copy of your database, put all the other objects (forms, queries, reports, modules,) into another copy of your database.

Now the tables alone become the back end database, this is placed on the main server somewhere in a shared folder. The other database becomes your front-end, you link it to the backend database with the table linking wizard, and now you can distribute copies of this front-end to anyone else that has access to your LAN.

There are is a wizard in most versions of MS access that allows you to "split" your database, meaning you would have the back end and front-end created for you as described above.

 

[boblarson]

The Type Mismatch error has to do with this query:

SELECT Employees.*, Products.*, [Inventory Transactions].*, PurchaseOrders.*, Suppliers.*, nz([Inventory Transactions].UnitPrice)*nz([UnitsOrdered]) AS Subtotal, [Shipping Methods].ShippingMethod
FROM (Suppliers INNER JOIN ([Shipping Methods] RIGHT JOIN (Employees RIGHT JOIN PurchaseOrders ON Employees.EmployeeID = PurchaseOrders.EmployeeID) ON [Shipping Methods].ShippingMethodID = PurchaseOrders.ShippingMethodID) ON Suppliers.SupplierID = PurchaseOrders.SupplierID) INNER JOIN (Products INNER JOIN [Inventory Transactions] ON Products.ProductID = [Inventory Transactions].ProductID) ON PurchaseOrders.PurchaseOrderID = [Inventory Transactions].PurchaseOrderID
WHERE (((PurchaseOrders.PurchaseOrderID)=[forms]![PurchaseOrders]![PurchaseOrderID]));

But I'm not sure yet what.

 

[JakeC11]

Thanks for the help with the multi user setup! Does anyone have any idea what the fault is with the Join Expression? I'm still stumped!

 

[gemma-the-husky]

if Bob's right in his surmise that its that query which is failing THEN

a) either one of the joins has a clash of types or
b) maybe the calculation involves a type mismatch

is the query viewable as a visual query - its easier for you to see the errors that way, i feel.

 

[JakeC11]

The Printable PO that is having the join expression error is an original from the template I customized. Would it be more prudent to just create a new report from scratch? Really, I just need a report that shows the currently opened form as a printable report.

 

[Scooterbug]

In your Purchase Order table, you have your ShippingMethodID and EmployeeID set to text fields. They need to be set to numbers.

 

[JakeC11]

Okay, I got that part corrected. I just used the join expressions to create a query and removed the ShippingMethodID and EmployeeID from it. Thanks for tracking those down! I have one last little catch on this report that is bothering me though. I changed the name of one of my tables from Purchase Orders to PurchaseOrders. I've found every instance in the database where I needed to correct the joins, but one. This report still pops up with an error saying it can't find Purchase Orders.PurchaseOrderID and I can't find where this instance exists in the report!! Gahh!

 

[Uncle Gizmo]

>>>This report still pops up with an error saying it can't find Purchase Orders.PurchaseOrderID and I can't find where this instance exists in the report!! Gahh!<<<

I am not brilliant with reports, however it sounds like you have a reference set to that field within your report, possibly in the grouping options?

If it was a form you were talking about, I would be looking at the "filter options"

 

[JakeC11]

There is a reference in there somewhere, I just don't see it. All the references on the report itself are good to go. The only thing I can see is that there is a header and a footer that are titled as purchase orders.purchaseorderid, but all references inside them are active.

 

[Scooterbug]

You have the sorting and grouping set to have Purchase orders.purchaseorderID have it's own group header and footer. That's why it's asking you for that. You actually dont need those since you have all the data for the report on one query.

 

[JakeC11]

Ah hah! Eureka! Jenkies! Okay, thanks for all the help everybody!