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

    Network cannot find the database

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

    Filters on combo boxes

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

    Two cmd buttons call same form, different record set?

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

    Forms and Macros

    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 '...
  5. ChipsIT

    Posting to Outlook Public Folders

    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)...
  6. ChipsIT

    Cut Paste Problem

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

    JET Error Upon Exiting Form

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

    Access 2000 reading Foxpro

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

    Insertion point in textbox

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

    Insertion point in textbox

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

    Problem when using form OnDirty property in Access2000

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

    Insertion point in textbox

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

    Insertion point in textbox

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

    Simple IIf statement Problem involving multiple combo boxes

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

    Insertion point in textbox

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

    Insertion point in textbox

    Hi I have a form with a textbox attached to a memo field and several buttons which insert specific text into the textbox. (Imagine a simple HTML Editor on an Access form). When I click a button, the textbox loses the focus so I write the insertion point to a variable in the textbox_Exit event...

Part and Inventory Search

Back
Top