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: *

  1. 9milla

    Supress Write Conflict error message in Access 2003

    Hi RoyVidar and missinglinq I've been to numerous forums including Google Groups and scoured Microsoft's knowledgebase and still haven't been able to find a way to supress the 'Write Conflict' error message or just to get the properties to accept a Default of 'Save Record' I've related my...
  2. 9milla

    Supress Write Conflict error message in Access 2003

    Ok...so for the convenience of everything, I've decided to repost my original question here in hope that it will get a solution. Original Post I have a very similar problem and wanting to achieve the same result as drewcp. My problem is bit more complex as it includes a trigger on one of the...
  3. 9milla

    Supress Write Conflict error message in Access 2003

    Hi As the Subject reads. How do I 'Supress Write Conflict error message in Access 2003'? I have posted my question and relevant code in another thread and don't think it will be necessary for me to repost it here. Here is the thread thread702-1507221 Apologies for any confusion. Many...
  4. 9milla

    Write Conflict / Default Yes

    I have a very similar problem and wanting to achieve the same result as drewcp. My problem is bit more complex as it includes a trigger on one of the tables im updating in sql 2005. Here's my problem. I have a user form with a tabbed control which has linked fields. On the second tab I have...
  5. 9milla

    datagrid

    Hi there vbjock I'm not sure if my input counts at all, but as per my experience, any 'DATE' value your're trying to input into an Access Rowsource i.e. 'Cell' wont work directly unless you physically type it in the cell itself. Reason for this is because Access will only take literals and...
  6. 9milla

    Dcount for multiple colunms

    I see, thanks again for the reply and advise pwise. So I'll be going then with my original code then. Private Sub cmdSearch_Click() On Error GoTo Err_cmdSearch_Click Dim stDocName As String Dim strCount As String Dim directDb As Connection Dim searchRs As ADODB.Recordset...
  7. 9milla

    Dcount for multiple colunms

    Hi there pwise, thanks for the prompt response. Muchly appreciated. Yes, your suggestion worked as simple as it looks, however, I was wondering that if by selecting "*" FROM "tblClientBase", what impact will that have on performance whereas if I only want to Dcount 3 columns out of 30+ in...
  8. 9milla

    Dcount for multiple colunms

    I've been searching the forums for something remotely helpful with regards to using Dcount for multiple colunms. I'm hopeful that I will find a solution. I have a form with 2 controls. i.e. an [/i]unbound textbox[/i] named txtNumber and a command button named cmdSearch. [highlight...
  9. 9milla

    Calculate sql recordset using access adp vba

    Ps. To get a better viewing of the code, try setting 'Zoom Options' to 90%. :) Doesn't seem to be Horizontal scrolling :( Cheers! "And so it begins!" LOTR (Battle for Helms Deep)
  10. 9milla

    Calculate sql recordset using access adp vba

    Thank you all for your input. It was most welcomed. I apologise for not replying earlier to the responses. As for the problem I posted, I am pleased to say that I have found a solution. As for PHV's response, the error message I was getting was a 'Multistep calculation error' which I...
  11. 9milla

    Calculate sql recordset using access adp vba

    Okay......after much deliberation on trying to figure out why I wasn't able to calculculate the the [Total Expenses] column, I stumbled accross a forum with regards to follwing 'Rules'/'Standards' thread669-1355446 In relation to my code snippet below with which I'm struggling with. I've...
  12. 9milla

    Calculate sql recordset using access adp vba

    I've been using the following section of code using access adp in vba with sql 2005 as the current connection. Am wanting to post the values to the current db based on certain events within the application. Private Sub BtnUpdate1_Click() 'On Error GoTo Err_BtnUpdate1_Click...

Part and Inventory Search

Back
Top