Hello,
i am really struggling in access creating an order form and an invoice report.
the attached example shows what i have so far.
however for the order form what i would like to do is have a drop down menu at the top which will have a list of invoice reference number for that particular student. which will in in the format of surname/date eg Bannister11/01/2006
as people will be ordering things at different times and need a new invoice each time. i see this as the easiest way. could any body help me with this??
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function Public Function Sort_1(SortName As String, FieldName1 As String) DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'" End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
I've been trying to sort out my order form for quite a while now with no luck but i am hoping someone will be able to help me so that i can complete the form and finish off the system. I want the order form to have combo boxes that actually work (At the moment all my combo boxes bring up a message at the bottom saying something like 'control cannot be edited'), The product subform does not work where i want to be able to created the order (and i need the rest of the boxes in the row to be updated some how with the product information when i choose the product), Also non of the other boxes seem to work either and need to know how to update fields when employee and customer are selected in the combo boxes. Also i want to be able to show previous customer orders in the 'View Customer' form.
Here is the system: Gamez System (http://www.savefile.com/files/6926006)
Any help is appreciated but please try and keep any help simple as i haven't really been using access for very long.:)
I have a form/subform linked to 2 tables, staff and training. The subform lists training done and is sorted by course. How can I change the sort order to a different field? E.g. date?
I have a form containing several fields for users to import data. The data comes from multiple sources, and I have arranged my layout the way I want it on the page. I have noticed though, that when you are using the database and pressing the TAB key, it isn't in a particular order (shoots to different fields across the form). Can you change the order of the fields that are selected when the TAB key is pressed?
Guys, please save me!!!! I have an order form called OrderForm. It has multiple combo boxes, where i select data. e.g i have a page in this form, where i select the company details, and a second page, where i select the order specifications, all based on combo boxes. The form is linked to 2 tables, Order and Customers. First page is linked to Customers, second to OrderForm. When i open the form, i can select the company name in the first page, where the fields are automatically filled. When i go to the second page, i select the type of product, e.t.c. Ok by now. What i can do to save this new order? I mean the Order specs to create a new order at Order table, and link this order to Customers table. The tables are linked correct. Thanks in advance Iannisro9
On a form i have a combo box called DATE The row source for this box is SELECT tblCleftClinics.Date FROM tblCleftClinics ORDER BY tblCleftClinics.Date DESC;
On the form what do i put in the "Order by" field to make the dates appear in descending order?
OK....I have done a search but am still none the wiser regards allowing for VAT (added to an old thread but no luck!).
I am designing a little DB for an accountant at work. He wants to be able to keep tabs on orders he places with various vendors (currently uses excel) but he needs to generate reports etc. I have done this but would like to afford him the ability to add VAT to the order total if required.
So here is what I want to do. I want to add a check box to an Order Form that will add VAT at the current rate. If the VAT rate changes at some point in the future I do not want historic data updated to the new rate.
I want to add it to the Order Form as not all companies being invoiced are VAT registered. This will give the user the option to add VAT or not.
I have had a little play (see attached) but do not know how to get it all working!
Help, advice appreciated (or if anybody has a working example of VAT?). Cheers, Phil.
I realise I could do it by basing the form on a query like:
Select * from table order by field
But I have allready made andlaid out the form, after basing it just on the table. Is there a way I can now order the data on the form, after having created it?
I've sorted out a problem that I had with a Form that had a subtable on it, by setting on the properties of the form for the 'Order by' criteria to equal the Id number of the form. eg: if each record has an Idnumber I have put [Idnumber] as the Order by property.
I have no idea what this does though, even though it seems intuitive? it's a form... so what is there to order? hope i'm not just being very stupid!
Hi, could someone please help me, I don't know how to put a total on my order form, heres my system: Gamez System (http://www.savefile.com/files/8723782) Thanks, Bob
I am having so much trouble with a order-line form.
I have a table that has the following information. The Table is Called ORDER LINE: Its attributes are, Order No, Product No, Quantity Ordered, line-item cost.
I need the line-item cost to automatically update when someone changes the quantity ordered. How would I go about doing this?
Now I am pretty new to SQL statements and I am assuming that this is how I would go about doing that.
I have and order entry/lookup form with a subform to view the line items on the order. Once an order has been saved and status is ‘placed’ I want the records for that order to be locked.
I would also like to display a message box with a yes/no answer to confirm that they want to issue the order and if they confirm then lock the record otherwise return them to the open order.
I can't find out how to do this, but I'm sure it can be done.
Hi all, i have a form with a subform, the main form has a field named: "shiftname" and i would like it so that when the form is opened the cursor is on that field but instead the cursor is on the first field of my subform. Ive tried changing the tab order on the main form (selecting form header, then shiftname) but this doesnt seem to work :( is there a bit of code i can use to force the form to open with the cursor in the "shiftname" field instead?
I have a form based on a query. In this query I sorted the columns year and month in a chronological order. However, on the form this does not appear that way on the form. How can I enforce this? Thank you Stacey
I am trying to add a total to my order form but i am finding it a bit tricky, but once i have done this i also need to create an invoice, which should be simple enough but is quite difficult because of the way the system has been put together....
I have just created a combo box to list and select all of the records in my database so they can be selected quickly, however for some reason the list is not in the correct order.
I have been back to the table and sorted all of the records into ascending order based on the field that is being used in the combo drop down box, but it is still not correct.
There must be an easy way to put them in order. Do i need to change the primary key so that it corresponds the field i am using to search or is it more comlicated than this??
Also, I created a form using the form creation wizard and now i have a grey stone background that i would like to get rid of. How do i do this? There only seem to be 9 or 10 pre-made formats to choose from?
I am working with Access 2003 and want to save the sort order in a subform. The new sort order would be different from that of the underlying table. The Order By property has been set but isn't working the way I expected. I have tried replacing the underlying table with a query but that hasn't worked out either. I don't want to change the order of the table because other programs that access it would be affected.
I've been reading about an Order By On switch that might do the trick but apparently it's not contained in Access 2003. There must be some other way to skin this cat!
I have a table with about 290 record. When I'm in the "Form View" and click the "Next Record" arrow it scrolls by order of Employee instead of the primary key "Record Number".
I have a column in my table for day of the week (Monday, Tuesday, etc.). What can I enter in the "Order By" table-property to order the records by their chronological weekdays? Additionally, is there a similar type of action I can perform within a related form?
