Search results

Try: iif(Forms!myform!SearchBox = "",True,mytable.TextField is like Forms!myform!Searchbox & "*") Then set criteria to 'True' When search box is empty all records are passed, otherwise they are compared with Textbox Evan

I thought that if you use a subquery you can't have an updatable query. This has always been true for me. But now I have a query that includes a subquery among its source tables and it is fully editable. Now I'm wondering if this is just a fluke, or if there is some logic behind it? Thanks...

gemma, I think I am pretty much on target with your post. I have all these tables: suppliers - to hold suppliers products - your products purchase_orders - the general order details purchase_order_items - separate items for each order purchase_order_deliveries - consignments for each...

How to deal with Status Here's what i've got so far: (these orders for materials and supplies - placed by employees in a manufacturing facility - no customers involved) TBL_REQUEST Pending Requested Authorized --OnHold --Canceled ------------------------------- TBL_ACTUAL Processed Confirmed...

Another way to figure things out in Excel is record a macro, then look at the code. Evan

I would guess that when you switch to design mode, that instance of the form goes dead, when you switch back you are not talking to the new instance, but to the old dead instance. Evan

Banana, I think i do need to have 2 different tables - Request and Actual. In OrderRequest i store: OrderRequestID ItemID Quantity JobName OrderedBy AuthorizedBy DeliverByDate OrderActual stores: OrderRequestID ItemID Quantity SupplierID ShipMethodID DOA OrderActual has the potential...

I'm wondering if you guys have any thoughts on this: tblOrderRequest stores original order as requested by user. I can easily create a separate status table as suggested above. But, when filling the order sometimes a substitue item must be used, and other times the order must be split across...

Perhaps. They are already being sent an email, so I would just like the email to include a link to the record - that way 1 click will bring them to the correct spot.

I think you are both right. The more I think about it, the more un-normalized I realize it was. The seperate Status table would also provide a trail for the order, and allow the status to take steps backwards, etc... datAdrenaline - the bitwise procedures you post will be very helpful...

When something is wrong with an order, my database generates an email to the purchasing manager, saying: Such and such is wrong with this order, etc... Is there any possible way to include a link in the email, that when user clicks will pop open access, load the correct form and goto the...

I've got an ordering database and I keep adding more and more checkboxes to the Orders table... Authorized,Processed,Confirmed,Shipping,Received,CheckedIn, RedFlagged,BackOrdered,etc... I also have a StatusField where I store a calculated value - giving the Order's current status in a...

Just wondering what solution you ended up going with on your material list database? I originally made a seperate table for each category, but my database quickly got oudated as we were continually adding new products that didn't fit any of the existing tables. I have since implemented a new...

I was planning on creating a Data Access Page for my boss. This way he could double-click and see a spending report for the month. After a bit of reading, it is apparant that DAPs are a failed experiment. What appealed to me about them was the ability to view a live report in a web browser -...

I learned from the tip in Access Help that by setting a form to popup it would not maximize when all other forms were maximized. This is why i wanted to set it as a popup - not because I wanted it to be on the top. It looks like I will have to forego using it. Thanks, Evan

I switched a form to popup, and suddenly the OnActivate event does not fire any more. When I switch it back it starts working again. Is this normal? If so, is there any easy way around this? Thank you, Evan

Yes, dlookup/elookup or dcount could work - but very slow. Hoping for a solution that stays within the SQL framework. Evan

I have 2 tables with a one to many relationship - tblItem and tblItemStock, respectively. I need to have an editable query based mostly on fields from tblItem. I would also like to have a yes/no field* that shows whether or not there are related records in tblItemStock (whether the item is a...

I've got a subform that I use an half a dozen forms. The double-click action perform a task specific to each parent form. I would like the ctrl-doubleclick to do a single global task. Evan

I was intending to use the ctrl-doubleclick to open a form - that's all. But, a right-click menu might be nice. Thanks!