Recent content by ChipsIT

I too am getting this error. The database can be accessed locally on either machine, but not from a client across an XP Pro network, even though the client can create and delete a text file in the same shared folder. I'll report back if I find the answer, but would be grateful of assistance. Steve

Hi To filter the records in the Machines combo; Sub cboCustomer_AfterUpdate Dim strSQL As String strSQL="SELECT Machines.Mach_ID FROM Machines" _ & "WHERE Machines.Cust_ID=" & me.cboCustomer cboMachine.Rowsource=strSQL cboMachine.Requery End Sub To amend the...

Hi If the form suits the display of both record types (ie all the controls and labels are identical) then all you need is one button on the form to change its record source: Sub Command1_Click If Me.RecordSource="qryFindCredits" Then...

Hi To popup a message box and ask a user whether they want to do one thing or another, get their response and react accordingly, response = msgbox("Do you wish to continue to next form", VBYESNO, "Message Title") If response = vbYes then ' Do this Else '...

Hi You probably need to use the CDO libraries to access Exchange public folders. You can get the details of what you can do with CDO here (http://msdn.microsoft.com/library/en-us/cdo/html/_olemsg_overview_of_cdo.asp) CDO is used from within your VBA application but has (obviously)...

Hi I'm not an Excel expert but if I understand your post correctly, can you not place a formula in your original sheet, outside of the main workspace, to reference the required cell in the second ie. a dynamic link to the other sheet? Your code can then update the original cell by adding the...

Hi I don't know whether this will help, but take a copy of your database and try renaming the field so that you don't use the '#' and see if that makes a difference. Being from the UK we use 'No' to signify number rather than '#' but I know that '#' is a special character and is likely to give...

Mike Don't know much about these, but accessing them seems to require serialization or streaming (GetChunk). Do a search on Binary Large Objects at MSDN or Google and you come up with lots of possibilities that hopefully may answer your question. (BLOB) Binary Large Object : A large block of...

My intention is not to criticise the code of people who try to assist Mike. With a little tinkering I got it working and it lead me to the conclusion that fitted my original problem. Thanks for your input. Steve

Mike The Exit event should be on the textbox. You also need to set InsertPosition on the KeyUp event as if you type into the text field, the Insertion Point is set to zero. I'm not going to spend time comparing this to my code, but I got the following seemingly working using SendKeys rather...

Is it possible that in setting the enabled property of the buttons, txtAddress is losing the focus and therefore your keypresses are going into the ether? The OnDirty event occurs when the first key is pressed and maybe before it is sent to the application (a la KeyDown). Try txtAddress.setFocus...

My first star! No problems Tony. I find it frustrating myself to locate a thread you are looking for only to find it hanging with no answers. I believe the answer here is Rich Textbox and have completed what I was doing with that. I haven't answered the question on why the insertion point seems...

So as not to leave this thread hanging, I think the answer to my question lies in using a toolbar rather than buttons as the control doesn't lose the focus when you click a toolbar button. However, I opted to go the ActiveX route and use a Rich Textbox (richtx32.ocx) which gives me far more...

Rob The Type Mismatch error suggests to me that your [Preliminary Design Review Status] is not expecting a string value. If it's a combo box, have you an index column and therefore need to set the value as 0,1,2 etc? Just for clarity and ease of maintenance, I would also set each of your...

Hi John I've tried writing the code in Exit, LostFocus, KeyPress and KeyUp but the basic problem exists in all. There seems to only be an insertion point when the textbox is clicked. If I click at a point within the textbox the insertion point is correct, but if I type anything following the...