Recent content by jamesT

This is the problem, I have a database that is used by sales reps to add orders and produce invoices for customers. A salesman earns commission on every sale (This rate is defined in the salesman table) to work out the total value of the invoice I did a calculated field, To work out the...

I have a print options dlg box. A user can select which employees details they want to print out by selecting the Employee No. from a combo box. Within the same combo box Can I inserted the text "All" so that if the user selectes that option all employees details are printed. Thanks

I have a form which hold details of for sales orders. I want to be able to tick a box in the list and that record gets stored in an array. I can then printout a list of of the orders stored in that array. No idea how to start can anyone help Thanks

I am creating a sales order DB which will be used by 4 different people. I have split the db already, but I don't know how to use transaction can any one give me some pointers

I have a form with a tab structure on it I want to be able to open the form and go to a set page I though u could use docmd.gotopage (2) but it does not work Am i doing something wrong??

I in my database for my dissertation I used a Case Select system for the security (Which was introduced to me by this excellent forum) I have to explain in the write up why I used this method over the standard Access Security features. The real reason is that I did not know how Access...

Thanks for the help I put this into a module Public strOpenedForm As String Then in the on Opend event of the form they are in I put strOpenedForm = Me.form But I get a type mis match error here not sure why

I have two forms 1) Current Projects 2) Completed Projects Both e of these form access the third form 3) Project details When I press the close button on the thrid form how do i make the user go back to the form they (either 1 or 2) they came from Thanks

i use a DLookup on a form to check whether a username and password are valid, it worins fins until you add or delete a user. It will not accept the new data. does anybody know why????

If you have the fields from a query on a form can you not show the records through those fields. I only want the user to be able to add a record and not see the previos records.

hi I have a sub form with several records (invoice Numbers) by the side of each record i have a button (Details) I want to be able to press this button in the sub form and it opens another form /subform with the selected invoice number and details of that invoice Not sure how to do this...

I have a sub form which has a filed call txtNetTotal This txt boc calculates the number or products * the price =Sum (SellingPrice]*[Quanitiy] That works then in the Footer I have a txt box called grand total Which totals the lot. =Sum[txtNetTotal] But I get the #Error in the txtbox Not sure...

Hi all I have a form which displays students results. Each student can take a module in different Terms and years. I have created a filter to filter the Years and terms. But i get duplicate values in the main form and subform and the filter will not work If any one thinks they an fix this It...

Hi I am using a button with a DoCmd to move forward and back through the recordset. If the user come to the end of the recordset and tries to move forward the program crashed, is the a way to handle this error so that it loops back to the first record Thanks

When i open a report from a form the report open behind the form and you can not see it, Any know how to fix this Thanks