Search results

Hi, I have a control on a form which opens up Word and completes fields in the Word document with data on the form. It basically fills in an invoice form. Everything works ok apart from when the invoice date and order date fields are passed. In the tables and in the forms, the dates are in...

Hello, Please bear with me in my explanation. I have a report which summarises appointments for salespersons. There are headers for the Sales persons name and then the Lead Type and below this there is summary number for three types of appointment: Held, Sold & Other. It looks like: Name #...

Thank you for your reply. Form 2 could have a number of items purchased. Whilst each item is totalled, form 3 provides the total of all items in form 2. I have experimented with: Me.Parent.form3.Requery. However I have tied on Before Update, After Update, On Close etc. but cannot achieve the...

Hello, I am looking for a way to ensure a sub form is refreshed or requeried. I have forms as follows: 1.form for Purchases 2.subform for all items purchased 3.subform which has the total purchase price ie the total of all items in the subform 2 above A save is forced in 1 before data in 2...

Thanks for the reply. I have linked all field and I do check for mandatory fields on both the main & subforms (BeforeUpdate). However, I did not check that the OrderID was complete. I have adapted my code as follows but would appreciate some help on how I could refocus onto a field on the main...

Hello, I have an Orders form (frmOrders) which has a subform (frmOrderDetails) detailing the individual order items. For example, there is one order which may consist of many items. The problem I have experienced is that if someone completes frmOrderDetails first and then moves to frmOrders...

I have a Customer database which allows input of name and address details of the main contact and their partner. On the form, when you get to the partners details, the address is often identical. Is there a way of having a default value being the main contacts address. If this is the case there...

Thanks pat for your reply. Where would you suggest I place this code. I have tried on OnCurrent, AfterUpdate, OnFocus etc on the main form frmSales and on each of the subforms but frmsubfrmCalcCommSunnByClient is not updating once subfrmSalesItemsForSubfrm is updated. Thanks

Hi, I have searched various solutions from this forum, but am still not getting the result I am after. I have a form detailing sales (frmSales). Within this form there are two subforms (subfrmSalesItemsForSubfrm) and (frmsubfrmCalcCommSunnByClient). The first offers options to select products...

Hi, Thanks for your replies. I can get into security using my logon and everything works ok. The Admin user is a member of the Users group with no permissions and has a logon password! I am just a bit perplexed as to why I can open the system.mdw file! I was considering importing all objects...

Hello, I have secured a database using the steps 1 to 10 within the Frequently Asked Questions About Microsoft® Access Security for Microsoft Access versions 2.0 through 2000. I have followed the steps methodically, however when testing the security I find I can open the database using my...

I have a sub form and the SQL is: SELECT qryAppointments.ApptDate, qryAppointments.ApptStartTime, qryAppointments.ApptEndTime, qryAppointments.ClientID, qryAppointments.ClientPCTitle, qryAppointments.ClientFullName, qryAppointments.ClientPCForename, qryAppointments.ClientPCSurname...

Thanks for your reply. The second piece of code works except when there is only a primary client name and no partner name. In these circumstances the primary client name is no shown at all. I apologise if I did not make this clear in my original posting. There may be a primary client name only...

Hello, I have some mailing lables which currently use the code: =Trim([ClientTitle] & " " & [ClientSurname]) We now would like to add into this line a partners name, if there is one, which may have a different surname. There are additional fields: ClientPartnerTitle & ClientPartner Surname...

Hello, I have a Forename and Surname fields on a form and our company has asked to have any names entered amended to Proper Case. I have searched this forum and found solutions using StrConv([Enter Your String],vbProperCase). As many users indicate this will not work with hyphenated names...

I am still trying to get my head around this one. On the OnClick to open rmProductsOwnRecords I have the following code: DoCmd.RunCommand acCmdSaveRecord Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmProtectionPolicyDetailsOC" stLinkCriteria =...

I have a customer database which has a form (frmproducts) linked to the main customer form (frmcustomers) by client id. Records are shown for all salespeople. In addition to this I have been asked to show customer records by salesperson. In a new query behind a new frmProductsOwnRecords I...

I have placed this under General, although it covers queries, forms and security. I have a database where clients are assigned to different sales people. Currently all sales staff can only enter new client details only. There security profile consequently opens the client form in Data Entry...

Hello, I need to write a query where the result depends upon the heart rate and then the sex. I have so far: FARHRResult: IIf([FARestingHR]<55 And [Sex] =Male,"Excellent",IIf([FARestingHR] Between 56 And 83 And [Sex] =Male,"Poor", IIf([FARestingHR]>83 And [Sex] =Male,"Very...

I am struggling with an expression I am trying to bulid in a query. There is a band of answers I would like to be entered depending on the value in another box. The current expression I have is: Systolic: IIf([FABloodPressure]<130,"Normal",[FABloodPressure]Between 130 And 139,"High...