Recent content by cpuSmoker

  1. C

    Will Access do this????

    Am i missing something? I don't see a download here. Please correct so I can help. :cool:
  2. C

    Change form recordset remotely from another form

    Ahh, yes Yes i believe you are right, but I am reading his question as he wants to permanantly change the recordset associated with a form. And since all the fields on a given form are linked to that specific table, unless the new recordset is just a specific query based on data held in that...
  3. C

    Change form recordset remotely from another form

    Change recordsource remotely For what purpose? To change the forms recordsource property permanantly? If you want to change a remote forms record source from another form you shou be able to do it like so: Private Sub cmdChangeForm_Click() Dim Sql as String sql = "SELECT * FROM...
  4. C

    simple claculations and if - elses

    Sample Would you mind posting a sample? That way I can debug? What version of access? :(
  5. C

    Control over the expressions field size

    Field size Change the field type in the table to memo. Then there is no character limit. Hope this helps. :cool:
  6. C

    Spell Checking subforms from main form

    Spell check The spell check routine could be made to run on the subform when closed. The routine could then be trapped that if it found errors, it wouldnt close. Hope that helps. :cool:
  7. C

    Entering a field from a hidden form

    Not Necessary? I have a routine I can give you that will get the computer's name and the name the user logged in under that can be used everytime an entry is made. That way you can track when they logged in, off, etc too. Interested? Let me know.
  8. C

    Re-Using Search Form

    Let me see... Regarding the slow bit, when was the last time you 'repaired and compacted' the database? Not sure how? Start database, Click tools menu, Database Utilities, Compact & Repair database. This will help alot with the 'slow' problem and should be done regularly. Regarding the find...
  9. C

    vbSystemModal won't work

    Okay Here is the syntax I used on my db and it works OK MsgBox "hello, now respond", vbSystemModal, "hello" If you are trying to combine request, IE ask for a yes or no then combine like this: MsgBox "hello, now respond", vbSystemModal + vbYesNoCancel, "hello" then you can trap response...
  10. C

    date autofill

    Sure Sure, if the ssn field and or date field is a combo box, or thiey can be changed to one, the rowsource property can then be set to lookup entries in the database, IE the same field in the same table you are entering data into, it would then autofill the ssn or date field by what you start...
  11. C

    Looking at a table for particular field before updating

    Let's see what u got It doesnt sound that difficult, but may require some vb coding behind the scenes to make it work. Would you mind posting what you have so i can chat with you about getting it to work for you? :cool:
  12. C

    Output data to another format

    sure, why not Will Delrina import data from comma delimited? Access by default will only export as mdb, of course, xls (Excel), csv (Comma Seperated Value), or txt. using the docmd.transfer(database/spreadsheet/text) method. However, if you open excel, yes another step, it can export these...
  13. C

    table design changes

    umm, why? I believe it may be possible to update the default value of a field, but not delete a field. Why would you need to delete a field in a table more than once? All data contained would be irratrevable. If this field is temporary in nature, why not simply update the data in that field...
  14. C

    sendkeys

    Suggestion Have you thought about importing the cells.mdb table/forms collections into the main.mdb file? Then you wouldnt have to use the sendkeys function.
  15. C

    Shell Function

    what's wrong Are you sure of the Ms-DOS style filepath? It doesnt have to be a ~1. It can be a ~2 or ~9. It also isnt necessary for the shell command. It does support long filenames. IE: C:\Program Files\IBM\Client Connect Software\cwbtf.exe You can manually type this it in like the...
See more
Back
Top Bottom