Search results

That didn't work. What I have done so far is to create a macro that does print out, but now I'm only able to filter down to the day in my query. So instead of the whole database, I got the 25 records that were created this morning. Any suggestions on how to get it to the last record. I also...

My command button does open the report, but in my where condition, I have not been able to identify "how" to only pick the last PK? I'm sure this is simple, but I either get everything or the very first item entered. Thanks

I am wanting to print a single label after entering in an inventory item by clicking a command button. What I end up getting is the whole database (which is now more than 1,000 records). How do I narrow that down to the latest / current entry?

Working now... with the above code... wierd.

Re: Auto Updating list box Private Sub Date_RFI_GotFocus() If Len([Date_RFI] & "") <> 0 Then Me.[Transaction_Type] = 6 End If End Sub Private Sub Shiper_ID_GotFocus() If Len([Shiper_ID] & "") <> 0 Then Me.[Transaction_Type] = 3 Else Me.[Transaction_Type] = 1 End If End Sub Is the code that...

Not sure if I'm in the right area but here goes... I have two tables [Transaction Types] and [Inventory Transactions], that are linked through [Inventory Transactions Extended query]. When I print a "Load / Shipper" report based on the [Inventory Transactions Extended].[Shipper ID], I'd...

THANK YOU!!!! worked beautifully!:)

I have a query built and the original calculation field for a net sale was based on [weight]*[bid] - and it worked (in bold below), but now I need to be able to have an if statement so that my net sale column is calculated based on either weight or quantity, depended on wether or not the line...

Thanks for your help! I got it to finally work out with most of the relevant data showing. I have a new problem though now. Not all of the current records show when I run the query. Here's my sql: SELECT [Inventory Transactions].ID AS TransactionID, [Inventory Transactions].*, [Transaction...

When I do the above, it shows up in the Inventory Transactions Extended just fine, but it does not provide any new information to the Inventory Transactions table. Thus, I'm gussing that when my report is looking at the table, it still sees a null.

I have the following code in an extended query that feeds into a form. The calculated fields show up in the query and on the form, but when I go to create an invoice report... nothing shows up. I have the same problem for my Tare Weight and Net Sale fields ... I'm sure once I figure one out...

SELECT ID, COUNT(ID) AS TotalRecords FROM [Suppliers Extended] GROUP BY ID ORDER BY COUNT(ID) DESC; Resulted in only showing "1"s SELECT Recycler, COUNT(Recycler) AS TotalRecords FROM [Recyclers Query] GROUP BY Recycler ORDER BY COUNT(Recycler) DESC; Showed a 15, 3, 5, and the remaining...

I tried running through the wizard and got an error message that says that I cannot perform the query because the two tables are not related to each other (see attached). Yet I have a field "Recycler" in both tables? I'm really confused. Please advise. Thanks.

ran these - results are '1''s in the first query, mostly '1's in the second as I do have some vendors multiple times because of multiple locations (maximum is 15)

Tried both ... didn't reveal anything. I retried a union query pulling from just the tables after making sure that all the relationships were removed. I get the same results of having each item in the inventory repeated for each supplier/recycler. Here's the query I ran. SELECT [Inventory...

Please see the attached document first. I am trying to create a main query that I can then use to export all of this data into Pre-created Word documents. I have tried several ways to create the query, changed relationships, etc., but I either get 1/2 of the data at a time (Top or bottom...

worked!!! yeah! and THANKS!

I am creating an inventory / shipping database system for a local non-profit. I have it almost done, but when I select the vendor to ship to (via a combo box), all products (regardless of time) of that type are changed to the vendor selected. I need to be able to have multiple vendors for...

I thought it was bound ... under Data > control source. How can I get it bound? I obviously have missed something very basic - yet no matter what I do it remains unsolved. I can't find an answer elsewhere, thanks.