Search results

  1. J

    Last Record Field

    Thank you very much. I will try that.
  2. J

    Last Record Field

    Yes, I do realize all of those things you said, and normally, I wouldn't even consider trying to do this. I didn't explain why I need to do this because I was trying to spare everyone a long story. But here it is... If you can tell me a different way to do this, I would be happy to hear it...
  3. J

    Last Record Field

    I would like to add a field to a query that has true for its value if the record is the last record in the query or false if the record is not the last record in the query. How would I do this?
  4. J

    Report Wizard

    I am using the following code to run the report wizard: DoCmd.RunCommand acCmdNewObjectReport This opens the wizard, and then the user has to select which wizard should be used and then select the table or query. Is there any way to specify in the code which wizard should be used and also...
  5. J

    Close Another Database

    I finally got it to work. First I had to open the other instance of Access myself rather than letting Word open it: Dim ObjAccess As Object Set ObjAccess = GetObject("H:\Access\Database2.mdb") Then I was able to use: ObjAccess.Quit Thanks for your help.
  6. J

    Close Another Database

    I already have a reference to the Microsoft Word Object Library.
  7. J

    Close Another Database

    Unfortunately, that didn't work. I get the following error message: "Object doesn't support this property."
  8. J

    Close Another Database

    I am using code in Access to run a merge in Word. I'll call the database containing the function (MergeWord) that runs the merge Database1. The table used in the merge is in a different database. I'll call the database that contains the table Database2. When the merge is run, another...
  9. J

    Instr With a Wildcard

    Thanks. That should work.
  10. J

    Instr With a Wildcard

    Is it possible to use a wildcard with the Instr() function? For example, if I want to determine if a string contains a string that has any alphabetic character followed by a hyphen, how would I do that? I need to use a wildcard because I want it to return false if the string contains a space...
  11. J

    Auto fill fields in web form from Access

    It turns out that DoEvents does not very well by itself, but it does work most of the time with the extra code I added (see below). When it doesn't work, it's the same problem that I mentioned before where the keys get sent to the page before the page is fully loaded. What we really need is...
  12. J

    Subform Tab Control Problem

    I understand and appreciate what you're saying, but in this instance, there will NEVER be more than two individuals. This would work except that there is not always one female and one male. There can be two females or two males. Do you have any other suggestions?
  13. J

    Subform Tab Control Problem

    Thanks. O.K. Let's forget about the tabs for a minute. They're really not the issue here. If you know that there are always two and only two individuals per household, how would you create an updateable subform that shows only the first individual in the household and another updateable...
  14. J

    Subform Tab Control Problem

    This is probably simple, but I can't figure it out. I have a table called Household that has a one-to-many relationship with a table called Individuals. The Individuals table has fields called FirstName and LastName. I have a main form based on Household. I want to have subforms in a Tab...
  15. J

    Auto fill fields in web form from Access

    DoEvents appears to be working. Thanks very much for your help.
  16. J

    Auto fill fields in web form from Access

    Sorry I wasn't more clear. Here's what I'm trying to do. I have an Access database. I am opening an external web page that I don't own or have any control over from within Access using the following code in a module: Call Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE...
  17. J

    Auto fill fields in web form from Access

    O.K. Am I supposed to put that statement in VBA? If so, I tried it, and it doesn't like it.
  18. J

    Auto fill fields in web form from Access

    Could you explain a little bit about what this code is doing? It looks to me like it is getting the values to put in the web form from a table. The values I need to input do not come from a table; they are a single value and are always the same, so they can be hard coded. Given that, do I...
  19. J

    Auto fill fields in web form from Access

    Does anyone know how to automatically fill in the fields on a web form from within Access? Here's what I have so far: Call Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE http://pageontheinternet.com", vbMaximizedFocus) That opens the page that has the fields to be filled in on it...
  20. J

    How to sell

    Thank you KenHigg and ghudson. I really appreciate it!
Back
Top Bottom