Replies

One other way is to link the subform to both the customer and the product. Then you could modify the LinkMasterFields and LinkChildFields (I forget the exact names offhand) to show the selected customer and all products or the selected customer and selected product. Just another way to do it – and probably the way I’d approach it.

Could you really Edit the linked tables in Access?
Microsoft says you can’t. They had to remove that a few years ago for legal resons.

You are right. Can’t edit. It only looked like I could .

I’m not sure this helps, but here goes. I’m using Office 2007, but suspect it is much the same. I used Review – Changes – Share Workbook. Then under the editing tab, I selected “Allow changes by more than one user at the same time.” I then linked to the workbook in two different Access applications. I could open both and view and edit. Without the selection in the editing tab checked, I could open the table in only one instance at a time.

Look up “Type Conversions functions” in help. You’ll find cint (for converting to integers), cdbl (for converting to doubles), etc.

Probably I’m wasting your time, but my netgear router’s address is 192.168.0.1.

stLinkCriteria = “[Quote_ID] = ” & Forms!frmQuotes_List!subQuotes_List!Quote_ID _
& ” AND [Version_No] = ” & Forms!frmQuotes_List!subQuotes_List![Version_No]

I don’t know if this has anything to do with it, but the syntax is not usual when referring to a control within a subform. Here is a more historically standard syntax:

stLinkCriteria = “[Quote_ID] = ” & forms(“frmQuotes_list”)!subQuotes_List.form![Quote_ID] & …

I prefer using the dot notation myself. You have to make sure your control on the form does not have the same name as the field or Access can get confused (and maybe exit?). When you do this, the dot notation works well and you get syntax checking at compile time – which is always nicer than run time!

And if you are running this code within the form “frmQuotes_List”, then change “forms(“frmQuotes_List”) to “me”. Then we get “me.subQuotes_list.form.Quote_ID”. Way simpler and clearer.

I think I have all this right. If you have questions about syntax, any of the Access xxxx Developer’s Handbooks by Litwin, Getz, and company are excellent references (xxxx = Access version).

You nailed it! That was a 30MB file. When recreated, it was 2 KB! I’ve rebooted and printed a couple times to make sure the fix sticks – and it has.

I opened the 30 MB file in Notepad. From what I could see, it was repeating exactly the same little snippet of info over and over and over.

I cannot thank you enough!

Of course I should have zipped it! Head slapper! It would have been nice if a reason would have been given for the failed upload. Oh well. Here it is.

I appreciate your help Josh. Thanks.

Anyway, Process Explorer shows the time going to the printing process (e.g. Word). I have reinstalled Process Monitor and captured the events in a log (filtered for Word only). I was really surprised to see over 13,000 events in just selecting the Epson for print. That took 45 seconds.

I attempted to attach the log file just in case that is what you want to look at. Was unable to do so (it tried to upload, then it cleared my selection and complained that no file was selected for upload). Analyzing this is not something I’ve ever done, so not sure where to go from here.

Are you using AVG? I remember that receiving HTML emails from one particular source always showed in plain text. The secret was (if I remember correctly) to change the option that appends “Checked by AVG” (or something along those lines) so it was not appended. Then the emails came in formatted at HTML from then on.

I had run across that Epson article too. Really helpful ! Just for the record tho: 1) I am using that driver (32 bit of course), 2) I have a completely defragged disk (MyDefrag) with 500+ GB free, 3) prints of 3 characters from Word are slow too.

I did more experiments as a result of your question about putting it on my Wife’s PC. I connected directly to my wife’s PC and installed that same driver. It runs quickly when directly connected. I then connected across the network from my PC to it and I get the same slow response I get when the printer is directly connected to mine. That is more evidence that it has nothing to do with my USB ports (I had tested it on a couple different USB ports on my PC without any change in response). It sure is PC specific tho. It has to be some sort of setup issue, but I’m baffled.
”
I have no success trying to run printmanagement.msc. Says “MMC could not create the snap-in.” I did use the server properties to remove the queues and all the drivers for the Epson. Then installed ONLY the correct driver (not the Windows 7 default). No difference.

I did go to the print server properties and change all the Epson R1800 driver exe’s to Vista Service Pack 2 compatibility. Made no difference.

I use Ashampoo Burning Studio 6 – the Free version. Used it on Vista and now on Windows 7. I’ve had no problems and like the interface. All I do, tho, is burn CD/DVDs, mainly for backup, but it works very well.

I need to convert an Access 2003 database into a SQL database for a large/complex application.

I’m curious what is meant by “large/complex”. If you don’t mind, what size of database is being converted?

Sounds like camera interface software to me. It may be that you need updated software from your camera manufacturer. Try just putting your camera’s card in the computer and look at the file characteristics from Windows 7. You could just copy from there without using your camera.

I have a Canon and found there was an update to all the Canon software for Windows 7. Maybe this will help. I use Windows 7 32 bit edition.