Recent content by JaedenRuiner

I can do this in like 5 seconds in SQL Server but I can't get the query to even ALLOW me to update records. Table1 - Columns Query1 - ColumnDesc SELECT DISTINCT C.Column FROM Columns C INNER JOIN ( SELECT Cols.Column, Count(Cols.DataType) FROM (SELECT DISTINCT Columns.Column...

FOUND IT!!!! Hah, so it may be a hack, but it works exactly as planned. for some reason the acDialog is completely wonky in the Access architecture, but the Form.Modal property behaves as expected. So, my solution was simple: public sub ShowForm(formName as string, optional args as string =...

Re: Brint Report To Front Like a real application would It isn't the sequence, it's the limitation of Access. I have 5 primary forms. The application starts and the Main form is displayed. it has 4 command buttons for the different sections of the application. Machines, Operators...

Re: Brint Report To Front Like a real application would vbaInet, thanks for the prompt reply. I had atually thought of something like that. I have a module procedure that show's my reports, so from the forms I call: ShowReport(reportName, filterString) and it handles it for me. So what I did...

Okay, Not to be picky or critical of Access (well maybe a little) but I am having a problem in meeting the customer's desires within the design of my applicaiton. I have several forms which have command buttons that spawn reports in a "Preview" window. Initially I had these reports show as...

So, There are listboxes, and buttons, and all sorts of controls. No imagine a method: DoSomething(byval lb as ListBox) in this method we do some affects, add some values to the underlying datasource, and execute a lb.Requery. that part works fine, however, some of these listboxes have their...

Yea, I discovered that when looking at other code i had written similarly that apparently the CurrentDb moniker is not treated the same. once I set a local variable to the currentdb all worked fine. THanks J"SD"a'RR

Update: Updated all references in my code to parameter, variable, or property names: Name, Table, Value. Compacted & Repaired both application and database MDB files. tried a few other code variations, like not using "tdf" for my first for each loop and the local variable in the second loop...

Ah. I will check on the usage of reserved words as variable names. but to answer questions: dp_Prefs is a Collection that retains some preferences loaded at the start. it is a global variable contained in my MainModule and is used to contain certain system information, including the Path and...

Okay, So my system is one that has a MDB database file that is linked into the MDE application at run time. part of the system is to allow me to update the "app" side of things while leaving the data separated. However, at boot up I want to verify that all of the table links are refreshed and...

Negative on any fix so far. You have Access 2007. {u]I Don't.[/u] I have developed a professional Application with Access 2003 and my client NEEDS to be able to export the reports into an excel spread sheet. I cannot utilize anything 2007 related because I am developing on 2003. Why oh why...

Well, Here's the thing. I've designed the database as a 2002-2003 compliant mdb (not 2000). I then designed the front end in a separate 2002-2003 mdb that I've compiled into an MDE which uses link tables to access the mdb database. I think setup my own custom popup menus which for the...

Ahh, Well I do thank you all for the help you've given me on this project, because I was definitely a little behind on my Access skills. I've come across a minor glitch that appears to be hindering the overall project at its completion. I am developing in and using Access 2003. I've compiled...

yea, my bad in the typing. It is DateSerial, not DateValue. The issue seems to be that it's attempting to compare the datediff() and DateSerial() on rows that have a NULL PurchaseDate. When NONE of the PurchaseDates are NULL the criteria works fine. But when PurchaseDate is NULL, it comes...

Meaning what exactly? I mean this is a QUERY, not a table. Can't i do evaluations on calculated columns in a QUERY? Can you propose an example, because i'm finding myself wishing this was done in SQL server at the moment, because i know how to manipulate that, but the MSSQL is being a little...