Search results

The OrderID is auto-numbered, and appears on the form in a locked text box. A new record is created when any field on the form is filled in.

Haha I did copy the code, thanks for the help. However, I still have the difficulty of the subform remaining invisible after the ID has been created....

I have a frmOrders with a subfrmOrderDetails, currently set up so that the sub form is invisible if the main form has a null ID, so when the users open to a new record they can't jump straight into adding things to a non-existent OrderID. The code for the form is Private Sub Form_Current()...

I have an enrollment database for a summer camp. The users requested that I create a report that shows the students name and the first camp they have enrolled in for the summer (so they know who is new or not.) The database is broken down into Season>Week>Classes and I've got so far as to have...

I have an enrolment database to put students in classes. On the class setup form, there are three combo boxes, to select Teacher1, Teacher2 and Teacher3 (classes have multiple teachers, but never more than 3), which all come off tblTeachers. The combo-box records the TeacherID on the...

I have a Class Enrollment Database with a Master Roster report, that details the Students Name, and what class they are enrolled in. Its quite a long document, and its sorted by student name. What I would like is to be able to assign each class a color, and then that row to have that selected...

I use Access 2010, and my co-workers use Access 2007. I created a database, btu I am the only one who can open it, so I rebuilt it as an Access 2003 file (they still can't open it, even when I save it as a 2007 file, but i know there are compatibility issues between them). Anyway, its all...

I have 2 cascading combo boxes, the first lists Productions, then the second shows the different Performances for each production, both on the same subform (frmOrderDetails). It is currently part of a subform on an Orders form, for people to buy tickets. I can use the boxes when I have just...

It does work well, and I suspected it would be difficult to do anything otherwise, but thanks for your help.

I need some creative help here, I have an enrollment database, which currently enrolls students through an order form, (that is we choose the student, the class- which lists the price, etc...). This is put onto an Orders Table, and an Order Details ID table, tblOrders has the detail of the...

The invoice displays the information recorded in the Orders, Products and Customers tables in a way that is readable by customers. I think I understand what you mean, but I'm sure its not quite what I was looking for. But thanks for your help.

Using Access 2010, I occassionally need to export a report as a PDF file. These are invoices, and I'd like the filenames to be created automatically (CustomerName then Order Number) so that there is consistency. Has anyone attempted this before, and could point me in the right direction?

I'm a little confused by what you mean.

My form code is; Private Function GetCriteria() As String Dim stDocCriteria As String Dim VarItm As Variant For Each VarItm In ListFilter.ItemsSelected stDocCriteria = stDocCriteria & "[OrderID] = " & ListFilter.Column(0, VarItm) & " OR " Next If stDocCriteria <> "" Then stDocCriteria =...

I solved my dilemma. I created a report which listed all of the orderIDs on it (formatted as I need it) and then used a form with a multiselect listbox to filter which OrderIDs would stay on the form. Thanks for the help, I was expecting this to be a massive headache, but it turned out to be a...

I'm guessing I'll need something like... A form that lets the users choose invoices from a list box, then a button that links the choices to the report... Is something like this on the right path?... SELECT RptSubInvoice FROM RptSubInvoice WHERE "[OrderID Field]=" & Nz([OrderID]...

I suspected that might cause problems, I'll keep looking at it for a little while and see what I can do.

I might be completely wrong here, but if I created a form with 5 combo boxes which the OrderID could be selected (Its usually only 2 or 3 invoices that need to be joined, never more than 5) could I use a SELECT clause with FROM and WHERE to use the results of the combo box to find the correct...

I have an invoice function on an enrollment database I'm working on. Currently we can open up a formatted invoice for a particular order, and it is all laid out and totalled properly, however we ocassionally need to combine 2 or more invoices together, usually when there are multiple children in...

And thats changed. Thanks again for the help.