Search results

Hey all - I'm going to be migrating an application from Access 2002 to Access 2010 in the near future, as we're running into problems with this app on Win7 machines. First step - get connectivity working. I've mapped a folder named 'SERVER' on my local machine to W:. Inside this folder sits...

Hey all - I feel like this should be pretty easy. I have a text field that allows 200 characters. I want to display this field on a form. If the text field has a length of longer than 20 characters, I want to truncate the display of the field, showing only the first 20 characters, plus ...

I understand that the form has to change in order for this event to be available. I have a hidden checkbox named wasRead, with a Control Source of (appropriately!) wasRead. It's a simple boolean field to see if this line item was read. in the message_dblClick event, I have the following...

Hey all - I have a date field bound to a textbox on a continuous form. The format (mm/dd/yy hh:nn AM/PM) results in 08/17/2010 5:03 PM It works fabulously on load. However, when I click into the field, I lose that formatting, and it reverts to: 08/17/2010 5:03:08 PM Which is the...

I'm working on an archive utility I've inherited. At the beginning of the archive, two temp tables are built: 1) List of Shop_ID's to archive (from Shop table), where CompleteDate < ArchiveDateSelected 2) List of Time_ID's to archive (from timeMain & timeDetail). List is based on pay periods...

Rather than beat my head against a wall, I figured I'd post the question here, then work on some other stuff while waiting for an answer :) I 'get' the logic in subqueries. If I was joining one table, I'd get it here too. But when I start joining joins of joined joins, I get confused. Can...

Hey All - I'm running a sort (via command button) on the results of a query located in a listbox. I want to return only records in a field that are numeric, then sort asc/desc on that field. When I run this as a standalone query, it works fine (and I can toggle asc/desc no worries). When I run...

Hey all - I have a continuous form within my project that displays the inventory for a particular job. For each of the parts listed, I present the end user with "Quantity Ordered" & "Quantity Received" labels (these values are filled in previously). The application then presents the user with...

Hey all - I have a number of queries that take a long time to execute (30-60 seconds). I'm hoping y'all can help me with one of them, and I can then apply that knowledge to the rest. I'm a native .NET programmer, so my SQL work generally is visual, not hard coded like this. I know this is a...

Hey experts - A brief history - I inherited an application that has tens of thousands of lines of code, more than a hundred forms, even more tables/queries, etc etc. It's far exceed what I would have put into an Access 2002 application (honestly it should be on .NET or converted to web app)...