Recent content by Sashanan2

I am developing an Access application for a client. I'm using Access 2003 SP2, but the database is saved in Access 2000 format. Said client has an existing Access application, developed under their version of Access (2002 SP3) but also in Access 2000 format. Since my app will draw some data...

If you find yourself in the situation where you get the blame for other people's mistakes, the methodology for software development is inherently flawed and any attempts at making this visible or bringing changes about is rebuked, I'd say it's high time to start polishing up that resume. If this...

Welcome to Tek-Tips! :) A WHERE component like this one should do the trick: WHERE EventStartDate < #[searchdate]# AND EventEndDate > #[searchdate]# "Any fool can defend his or her mistakes; and most fools do." -- Dale Carnegie

7 sure sounds fun :D But it's inevitable that the differences between SQL implementations (and having different forums for each) is going to cause confusion to those who aren't yet aware that these differences are in place, so you can't really prevent questions from showing up in the wrong...

Works fine as well and is certainly a lot less code. Thanks! "Any fool can defend his or her mistakes; and most fools do." -- Dale Carnegie

Found a working solution at: http://www.mvps.org/access/api/api0018.htm But I'm still open to suggestions for easier approaches (from what I could tell by Googling though, I'm not the first to run into this problem with FollowHyperLink and Acrobat specifically). "Any fool can defend his or...

I'm trying to open a PDF file (path and filename supplied through a string) from VBA code. I've played around with two solutions so far that both don't really do what I want: 1. Using Shell: Shell ("C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " & strFileName) This works fine on my...

Even with the subform being in datasheet format normally, can't you just open it in design mode, rightclick the field and change its Name property while leaving its Control Source and the Caption of its associated label the same? "Any fool can defend his or her mistakes; and most fools do." --...

I'd create a table for that log (with columns for user and date/time) and use VBA code and an INSERT query to write a record to it every time the button was clicked. For date, you could use the Now() function; for the user, Environ("Username"). By the way, please don't use all caps for your...

I've found that when queries work in one program but not in another, the barrier is usually restricted words. I wouldn't be surprised if Password is a restricted keyword in ASP and not properly read as part of your query. Try enclosing it in brackets like [Password] and see if that helps. If...

I can't be entirely sure without knowing the structure of your tables, but I see you joining T1 and T2 with: ((T1.Location)=T2.PreferredLocation) and again with (T1.PropertyType)=T2.PropertyType) but the only reference to T3 is ((T3.ClientStatus)=1) Without some way to tie T3 together with...

You don't seem to have actually joined the Client table (T3) to either of the other tables, and thus the database will not know which record from T3 to associate with what, and show doubles. Is this what's going wrong? "Any fool can defend his or her mistakes; and most fools do." -- Dale Carnegie

I can't really make sense of the queries I'm afraid (the column names alone give me headaches) but if the problem is getting no results back if there are no sales in a given year, you can solve that by using an outer join instead of an inner join. I see you linking several tables together in...

If I understand your question correctly, each record in tblRoasts has three columns (comp1, comp2 and comp3) which all refer to a record in tblInvTrans; three different ones. In other words, you have three relationships between the tables - all between 1 of the three comp fields and the field...

I'm aware of how to usually link/embed an OLE object to an OLE object field (Insert -> Object etc.) but would it be possible to do the same through a programmed SQL query? I've tried it by simply passing the path of the file I want to link to an INSERT or UPDATE query, but that results in the...