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 have a "time sent" field in my database that records the time a message was sent (inter-office messaging feature being added to this app). I've formatted the field on the table itself as bob indicated. As John (big booty.. JBB) indicated, when I click in that field, I get the general date...

Yeah I pulled a stupid here. It's bound to an underlying recordset, so I don't need to even worry about running the saverecord. Do I need to use the if me.dirty then me.dirty = false? what's the purpose behind that? As soon as I execute this code, I pop open a new form which, when closed...

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

Got it.. mousedown. How did I miss that. Duh.

Yeah that's along the lines of what I was thinking. The workaround I've implemented is, in the click event of the textbox, adding: timesent.Format = Format(Date, "mm/dd/yy hh:nn AM/PM") That works, but there is a microsecond where the DB value is displayed. I tried putting that code in a...

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

Yes, I understand what a return is. I don't want to reinvent the wheel here. I already have a working return form that provides them with the core functionality they need. All I'm looking to do is to extend this functionality to make it slightly more user friendly.

Appreciate the response, but perhaps you need some more information. This isn't an application that is customer facing. It's an all encompassing application that manages payroll, inventory, reporting, and a slew of other items. And it's not quite as easy to change as your response might...

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 Coach. Thanks for the information. I do use an MDE as the front end (application) with a data back end. This is written in Access 2002 (aka office XP). It's long overdue for an upgrade to .net/sql or php/mysql. The owner of the app brought me in to stabilize the current version so it can be...

The plan is to eventually redevelop it as a web app (either .NET or PHP) with a MySQL or SQL Server back-end. In the meantime, I'm stuck with access front-end and access back-end. I think I'm just stuck with this. Queries that query queries of queries isn't exactly how I would have designed it...

No, I just have a front-end that's on every workstation, and a back-end that sits on a server. I have not considered a pass through query. Currently the application links 40 or 50 tables from our server-side data file, then processes everything locally. From my understanding of pass through...

Thanks for cleaning that up for me. I didn't know how it would render until after submission. The lkpqryLaborCost takes upwards of 30 seconds to run (on its own) and returns 567,000 rows. It seems this query doesn't concern itself with Table I/O. I would be more concerned with limiting Table...

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