Search results

I have set up a form with two text boxes for the user to input the issue date or delivery date and lookup for that values in a tblOrders. User can type a date (or choose from the pop-up date picker) and then clicking on a button he populates a list box which shows the orders for that date. I...

Perfect solution, succesfully implemented and joy generating! :D I'm building a new form named frm_NavOrdini in which the user chooses a date from the combobox named cboData and the listbox below (named lstOrdiniPerData) is populated with the orders for selected day. The cboData has the...

I'm afraid since the button refers to a value stored in a subform, I need to somehow sync the value, or put the button in the subform itself.

I tried this on my own, but as usual my lacking knowledge of VB prevented me from succeeding. I am trying to add the button that will let me pop up the frmOrders for the selected record in the frmCustomer (the one with the search function you gave me a few days ago). I tried with adding the...

No need to apolgize! In fact I'm surprised your version worked regardless of that issue, i think that appeals more to informagics than computer science but meh :)

Thank you, I'll follow your advice as I get to work tomorrow. Honestly, though, I think this is caused by an access bug or something, because I set that field as Text since that's what you had used for your example CustomerOrders.mdb.

I'm just a newbie, but I think you could achieve that with a junction table: Add a table and name it tblUpdate_Junction or whatever you see fit, with the following fields: pkUpdateID AutoNumber fkPatientID Number (foreign key to your parent table) fkEntryID Number (foreign key to your child...

ok this is in access 2000 if you don't have 2007 installed

here you go It's in access 2007, I'm posting a compatible version, just in case.

I'm so upset I'm tempted to ask you if you could check out what's wrong with my db.. I just can't wrap my mind about it. I checked control names, column sources, I don't know what stops the code from putting that value in the proper field.

I am unable to get the after update event to work properly, I get an error message after the update and the field is filled with "#Name?". I'm afraid there might be multiple causes to that, I checked that the column in the combo box corresponds to the row where the value is stored (in my case...

That of the subform would be very neat. Also, as you told me in your earlier posts, I better avoid lookup fields in my tables, but I can't find a valid alternative so that entering order details is not a pain and doesn't require user to type productsID's rather than comfortably selecting them...

Jzwp22, let's say we got the customers from 1 or more regions using the form and code you provided, is there a way to add a button to that form that lets the user enter order details on another form or subform? Like let's say user filters 3 names with their phone numbers, then calls them and...

You have a strict logic and always get to the point with the design, I hope to get just about half as skilled as you are and I'd be fine :) The database is for internal use only, no information about it and the customers' actions is supposed to ever be used in other contexts. We put barcode...

The customers who have prescriptions are given a new one each month, and some of them have it directly delivered to us. Sometimes new customers come to the place and give us their prescription. Sometimes (we're in Italy and it's already a miracle such a system exists) customers show up with a...

Luckily I managed on my own, I guess the more I get into access the more I need to learn some VB :( My boss just asked me to implement a new feature into the database: some customers pay by cash, and some others have a prescription (since we make products for people with coeliac disease...

this is precisely what I had on my mind. I had to find the best way to do that yet, so I was waiting for your advice: thank you!

Hello, I'm just starting with access, and I'm setting up a simple database to manage customers and orders for a small sized company. I have the following table structure: Ideally, the user will perform a filtering on the clienti (=customers) table with the use of a form and zone-based...

cheers, best explanation. I am having a bad time with forms, as I'm probably trying to achieve a result beyond my capabilities: checkboxes to filter results. user has a number of checkboxes to specify the area she/he wants to look for customers in. The result should then be loaded in a subform...

I think this should be it then. It's still not very clear to me what the order_products table's purpose is, I just saw it on an example sales db and basically copy pasted it from there. I guess it stores the orders product-wise, that is, how many item A orders and how many item B orders there...