Search results

Thanks for the queries. I've tried them in my form but the first generates an error and the second just returns all of the results, like the original query does. Your assumption was correct, zqryWarping_Data2 shows the differences already. The two halves of the query I posted on here originally...

Right, I've got the query working without generating an error now, but the results aren't as I expected, all matches are returned, rather than just the record with the lowest "Warping_Diff" for each piece number. Any ideas?

Oh, just realised why, I was using "DoCmd.RunSQL" to call the query (which wasn't an action query.) Ignore this thread then! Matt

Morning all, I've read several threads on this forum about correlated subqueries and the problems that others have had whilst creating them, but none of what I've read has seemed to help. In this query, piece number is basically an ID for a piece of fabric. Each piece of fabric can be using in...

Thank you very much for that link. I installed the patch early Friday afternoon and we haven't had any problems as of yet, so hopefully it has worked. Thanks again!

I've found why the records were being deleted: one of my forms has a delete query on its cancel button. For some reason ever since I installed the Form Resizer, this form opens with values already in it. It's odd because the default value property of each of the objects doesn't have a value in...

Thanks for the suggestion, but I don't think it is that, because I reset it about 12:00 yesterday and the user of that front end continued to use it until 15:30 without any problems. It may be something that they're doing down there, they are by no means advanced users, they may be mashing the...

I've found a work around, at least I'm fairly sure that I have (I haven't tested it on the users' machines yet, but it's working on my PC.) First a little background about the system: The number of stickers printed from the label printer depends upon a number that the user inserts into an input...

I've been looking up Printer Objects, but that all looks very long-winded too. Surely there's a concise way of coding to print with an installed and fully functional printer rather that isn't the default one. Any ideas anyone?

Yes, that's what I've been doing; it still seems to reset itself. I've just been looking online for some code to specify the printer. Can you or anyone else tell me if and if so, how, to specify a printer to print from in the code that prints a report? The affected reports don't open for the...

Interestingly enough, if I open the reports in design view, change the printer settings, save the report and then print it, it ignores the new settings and prints from the default printer. The only way I can get the report to save the changes is by changing the settings in print preview mode and...

Thanks for the reply. The users don't have access to the printer settings, I locked them out of all that kind of stuff. They just press a button and the report prints, no printer settings displayed or anything. Furthermore, the main user of the system hadn't ever used a mouse until she started...

Hi all, A DBMS that I developed in Access 2002 has recently been implemented for users to use with Access 2007. We had tested it using 2007 before we implemented it and found it to be entirely compatible. However, as time's progressed I keep getting called out for the same reoccurring problem...

Thanks for the responses. I started by trying the easiest suggestion (boblarson's), but actually all of the machines that use 2007 already have their settings like that. So I then tried missingling's suggestion and it works, to an extent. I used the Form Resizer from Jamie's Software website...

Hello, I'm working with a DBMS that I created in Access 2002. When I make amendments to it, I use Access 2002, as do some of its users. However, some users run the file using Access 2007, and it seems that every time I make changes to the file in 2002 and put the front end on their machine, the...

Can you post your database on here so that we can see it?

Just in case anybody else faces this same problem, I managed to eventually solve this issue by using the TransferText action, rather than the TransferSpreadsheet action.

There seems to have been some confusion regarding my question. I have a form that has buttons on it. One particular button, when pressed, opens the next form (which has a subform on it), and closes the current form. However, before closing the current form, it changes the visibility of several...

I'm aware of that, it was the DCount that it didn't like in there. I'm happy with it working in the format event, it functions as I'd hoped it would.

Thank you for your reply, Gemma-the-husky. I think that my main problem was that I was trying to format objects on open, because when I tried executing your code it generated errors too. However, I've tried it in the Format event for the report header and it works a treat! I never knew about...