Search results for query: *

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

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

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

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

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

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

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

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

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)

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

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

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