Search results

Zip and post your db. Lets take a look.

:D OK, onwards & upwards :) thanks

Hello Ian Yes it cant be changed, I was just checking, if I needed to restore from a cd, that I would not have any dificulty. If this is normal than thats fine. Thanks

I have the following code on my “On Open” command, this all runs fine. I have noticed if I back up on CD, then open any forms with the code below (in read only), I get “Run-time error ‘2105’ You can’t go to the specified record” “On Open” command `maximize form` DoCmd.Maximize `open form on...

Pat, I have tried your before update code, Private Sub Order_Details_ProductsID_BeforeUpdate(Cancel As Integer) If Me.Order_Details_ProductsID.Column(4) = Date Then MsgBox "You cannot select this item. It is already sold.", vbOKOnly Me.Order_Details_ProductsID.Undo Cancel = True End If End...

Pat, Thank you so much! Yes it was a wizard, I used a command button. I thought the code looked a bit odd. Thanks again

Thanks Pat, I have gone with option .1, but I cant get code to work in the “BeforeUpdate event of the combo to prevent someone from selecting something already sold” could you help me with this code??? I have also found if an item is selected from the combo, but then the record needs to be...

:( Would a DLookup get me round this problem? I have to get something done by the end of the week :eek:

Hello Rich DB in 97. Thank you again.

Thanks Rich I am trying to select items not sold (sold date in Products table) from my Products table with a query (Stock (Q)), all items are one off, and are serial numbered, no multiples. In Delivery form I want a subform Order Details, which with a combo selects items from my stock query...

Please HELP!! :confused:

I have a products table, all items are listed by serial number (primary key). I have a query which filters out sold items, leaving me products in stock. My difficulty starts when I select via a combo, an item from the Stock query to an Order Detail subform, this works till I add a sold date to...

Hello Pat I have tried your suggestions, I just cant get a query to update “order detail” from “products”. I am really struggling with this. Could it be my table construction is faulty?? Or I am just not getting it! I have attached a slimmed down version of my db. Very confused Trevor

Pat, just what I needed. Thank you!

I could do with your help I have a “delivery” form/table, with a sub form “order detail”. What I want to do, possibly via a combo, is to pick an item from the “products” table and update it to the “order detail” sub form, and on exit or with a command button, change the status of the item in...

Thanks for that!!! I am going to try it out. Sounds like just the information I needed. Best wishes Trevor

Hello Yeatmanj Thanks for your reply, you have confirmed my suspicion that I am trying to do something beyond my ability. SQL is something I have no experience of sadly but will take a look. I think I will have to re-think my layout. If you or anyone else have any other suggestions I will be...

Hello everyone I have a “GoodsIn” form (linked to GoodsIn table) which holds common supplier data such as SupplierName and OrderNo’s, with a subform “Products” linked to “Products” table. My “Products” subform is my form of interest, I enter new items in list form (all items entered on indexed...

Hello "jfgambit" That’s great thanks for your help! Trevor

Hi all Is there a standard list of country names I could download and paste into my Country table, to save typing them all in! Thanks! Trevor