Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: djayam
  • Content: Threads
  • Order by date
  1. djayam

    Shared db - can goto new record

    Hi all, I have a split Access2007 db with ACCDE front-end. With one user all is good. With 2 users it's almost all good...I wonder if you can help with this scenario: Both users create a new record at the same time. The db assigns IDs OK and both records create OK. There is a combo box on...
  2. djayam

    "Me.Detail.Visible = True" NOT WORKING!!

    Hi guys, I have a really basic table of team players (ID, PlayerName). I have built a report with tbl_Players.PlayerName in the detail section. When I run the report I get the full list - as expected. Now, I add the following code to the OnFormat property of the detail section: Private Sub...
  3. djayam

    Can't fax via Microsoft Fax - permissions issue??

    Hi all, I am using a function in MS Access to send a fax via Microsoft Fax on a 2003 server with Exchange 2003 SP2, XP Pro SP2 client using Outlook 2007: Public Function SendFax(strTo As String, strPath As String) Dim MyOutlook As Outlook.Application Dim MyMail As...
  4. djayam

    CDO email not working with Exchange Server

    Hi all, I can't seem to find a soultion to this! I know it's an Exchange issue and probably simple... I have been sucessfully using CDO to send SMTP email from my db for some time. Server died recently and I rebuilt it. Now the db won't send to external addresses. No errors at all, just...
  5. djayam

    Using strings that contain speech marks...

    Hi all, I am trying to speed up the performance of my db. One way is to define the source of controls in the OnLoad event of a form. I've hit a snag though. One of my controls is a textbox (ctl_DeliveryStatus) with the following CountrolSource...
  6. djayam

    Can't requery ComboBox when based on a Query

    Hi all, I have an unbound form that contains a combo box. This combo box has a rowsource set OnOpen: Me.Combo_Suppliers.RowSource = "SELECT DISTINCT qry_rpt_BaseData2.SupplierID, qry_rpt_BaseData2.Supplier FROM qry_rpt_BaseData2 ORDER BY [Supplier]" On 1st run this works fine. However...
  7. djayam

    Save report as a file

    Hi all, I have searched the forums in vain for a complete solution to this. Apologies if this belongs in the "Reports" forum... I have installed a PDF Printer called CutePDF. Very simple to use - select as the printer, then browse and name file then "print". Saves PDF file perfectly. What...
  8. djayam

    Updating calculate control as you type?

    Hi all, I have a control "Quantity", a control "UnitPrice", and a control "TotalPrice". In the AfterUpdate of "UnitPrice" I have "TotalPrice" = "UnitPrice" * "Quantity". Works no problem. I wondered, however, if there was a way TotalPrice could be recalculated with every key-press in...
  9. djayam

    Dynamically sort combo box data

    Hello again all, I have a combo box Combo_PreviousOrders that gets its data from a query: SELECT qry_FirstOrderPartDescr.OrderID, qry_FirstOrderPartDescr.PONumber, qry_FirstOrderPartDescr.OrderType, qry_FirstOrderPartDescr.OrderDate, qry_FirstOrderPartDescr.Supplier...
  10. djayam

    Loops, Whiles and arrays...

    Hi all, I am entering new territory and could do with some help! Main form - frm_NewOrder Subform1 - frm_OrderPart Subform2 (also nested in main form) - frm_Deliveries The Main Form has a button btn_CompleteOrder. In the OnClick event I have the following: Private Sub...
  11. djayam

    Requery control on main form without requerying subform

    Hi guys, I'm sure this has been answered in here already but with the search facility being down... On my main form I have a control ctl_InvoiceTotal. This is a DSum calculation on tbl_Invoices and works fine. When Subform frm_deliveries is updated (button clicked) it adds values into...
  12. djayam

    How do I halt code if combo box value not changed?

    Hi guys, I have a combo box where users choose an order type. Their selection will determine the visibility of subforms. Private Sub Combo_OrderType_Change() If Me.Combo_OrderType = 1 Then Me.frm_OrderPart_Purchase.Visible = True Else Me.frm_OrderPart_Purchase.Visible = False...
  13. djayam

    How do I populate a text box with the caption from the parent form?

    Hi all, I have searched amongst the posts but cannot find an answer. I have a form "frm_Header" which I nest in all main forms so that I only have to make changes to it once. I want a text-box within frm_Header to display the Caption value from its parent form but just can't get the syntax...
  14. djayam

    Update Combo with values from unsaved records

    Hi All, I have searched through and not found anything to help me on this so here goes. I have a combo box that lists [OrderID] and [OrderDate] for all orders WHERE [Orders].[CustomerID] = the CustomerID control on the form. The "On Enter" code is... Me.Combo145.Requery Me.Combo145.Dropdown...
  15. djayam

    If last record = x then y ??

    Hi all, I have a text box in the detail of a continuous form. Control: =[ShipDay] I have ordered the form by this field. If the value of this field equals the value of the same field in the previous detail record I want to hide the field. Any ideas? Cheers, Jason
  16. djayam

    Order continuous forms by text box value

    Hi all, I have a continuous form based on a table (Deliveries). I have created a text box with a control of "WeekDay(ShipDate,2)" and I want to order by this. If I put either the text box name or the expression into the Order By property I get asked for the variable on opening the form...
  17. djayam

    Group on Weekday - show all days

    Hi all, I have searched for the answer to this already but not found it although I'm sure it's a common issue! I want to report on deliveries scheduled this week. I have a date field [ShipDate]. I can group on this field easily enough and display the header OK, but I want to have a group for...
  18. djayam

    Set value of field to be same as last record?

    Hi all (again) I have my Orders subform (Record Source = Orders) within the Customers form. When I add a new order, I want the default Description field value to be the same as the Description field on the last record. Any ideas? Thanks, Jason
  19. djayam

    Order records by field value

    Hi all, I have an Orders subform within the Customers form. All I want to do is have the Order records sorted by Orders.OrderDate DESC. I have tried entering "[Orders].[OrderDate] DESC" (without the "") and variations of but it doesn't seem to work! Any ideas? Cheers, Jason
  20. djayam

    How do you conditionally disable buttons?

    Hi all, Is there a way of either hiding or disabling buttons on a form based on the value of a control? I can only see a global yes/no selection for each button. Cheers, Jason

Part and Inventory Search

Back
Top