Recent content by meldrape

Many thanks to you Tarwn. I will clean up the HTML and apply your ideas. I can't thank you enough for taking so much time to analyze this and help me out.

Hello, I am using the following code to group menu items with categories and subcategories, this one being entrees. This code works great, but since there are 6 entree groups, there are too many columns spread across. What I need is to take the following code one step further and split the...

Hi PCLewis, yes, that's what I ended up doing. A query on my tmpfile. It's working fine now. Many thanks for your reply!

Hello there, my company is converting to a new inventory system. I have the following query that eventually produces an export file. I hesitate to post it because it's huge but I have to. tblExport.Execute "SELECT qyNewExport.cQty, qyNewExport.CUNIT, qyNewExport.CCATGORDR, qyNewExport.CCATG...

Yes, I understand now. And yes, it worked. Thank you VERY much for your help!!

chopstik, please accept my apology. It DID NOT refresh the parent window. I'll do the redirect to an unsecure page, and then run the script. I'll let you know whatever works. Thanks so much for your help.

Hi Chopstick, yes, it reloads the parent page. It's weird, if I take off the "s" from https and refresh the page, it closes the window. Frustrating. I guess I can do a redirect to the child page without the https then run the script again... How clunky! but if it work, who cares, ha!

Still no luck. I need to close the secure window... I need to close the child widow. I thought about posting to the Javascript forum but didn't want to get into trouble. Since it's in an ASP page, I figured I'd have my best luck here. If you have any other ideas, please let me know. Thanks.

I tried window.close without any luck, I'll try the other one and see what happens. thanks very much!

Hi all, I'm using the following in a child page after it posts info to a database: 'refresh parent, close self With Response .Write "<script language=javascript>" .Write "window.opener.location.reload();" .Write "self.close();" .Write "</script>" End With This worked perfectly...

Wow, that totally worked. Many many thanks for your help.

Greetings, I have a simple query I need to export as "qte.mat" and I am getting a database or object read only error. When I change the name to "qte.txt" it exports perfectly. Anybody know how I can handle this? it HAS to have the "mat" extension. here's my code...

thanks, Chris. That's what we did and it's working great now.

Thanks Roy, that's what I did and it worked!

Hi there, I need to export a report to RTF format but can't figure where to put the "where" condition. Here's my code: DoCmd.OutputTo acOutputReport, "rptMaterialsLoad", acFormatRTF, "c:\xfer\Report.rtf", True When I print the report I use this code: DoCmd.OpenReport ("rptMaterialsLoad")...