Search results

Thank you very much. I will try that.

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

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?

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

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.

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

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

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

Thanks. That should work.

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

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

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?

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

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

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

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

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

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

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

Thank you KenHigg and ghudson. I really appreciate it!