Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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

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

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