Search results for query: *

Here's an off-the-wall suggestion that may work if you just want it for reporting purposes. Create the crosstab query. Make another query that concatenates all the fields into a single string variable, with appropriate spacing between fields. Trim all the leading blanks. Obviously, this won't...

Not really sure what you mean by "...queries work only via forms.." If you mean they can be used only as rowsources for forms, that's incorrect. You can execute an action query from a command button on your form. Put this in the Click event of a command button: DoCmd.OpenQuery...

(aircode -- I *think* this will work) Remember, the three parts of Dlookup are: the field to return, the table to look it up in, and the criteria to apply. Therefore, you want something like: dlookup("compensation", "2002CovComp ", "DOB = " &...

>FWIW, you can still use wildcards to retrieve the file >names if you know the order of the strings you are >searching for. IE, "*DIGITAL*7*" Cool!!! That works. thanks much

Jon thanks for the reply -- and yes, I did realize that for the simple example I provided that the PropertyTests was not required. However, I had viewed it as a first step in figuring out how to do an "AND" search for multiple terms in the filename. The basic filename criteria supports...

Not sure whether this is the right place to ask this question, but here goes: Trying to put a filesearch object into my PPT97 application. As a test, I am searching for all files with a "7" in the name. Using the Search from Windows Explorer, I can search for files like: *7*.* in a...

Using the book "High Performance Visual Basic 5 Web Development" by Scott Jarol as the basis to develop a VB6 web server using the Winsock control. Essentially, I use the Winsock1_ConnectionRequest and Winsock1_DataArrival events to control the program flow. Works great on my Windows...

Had a similar situation, and dennisebotts' solution about referential integrity was correct. If you don't have cascading deletes enabled, then you can start the delete process from the "leaf" tables, and work backwards to the "root" table.

Just discovered the copyFromRecordset method myself. It was 12x faster on my export than the equivalent record-by-record loop. BTW - was done in Acc97 using DAO.

first, check your query. it should return one row for each dependent. the employee information will be repeated for each dependent. Next, check the Sorting and Grouping button in the report. What you need is a Header for each employee. Next, drop a textbox in the employee header that is bound...

Have you checked the "ownership" of the database. If it's owned by Admin, I think that you cannot lock Admin out of the database. Tools > Security > User and group permissions > Change Owner (tab) Select the Database object. You cannot change the ownership of the database, only the...

Wrote a function to create a new temporary table with the same records and primary key as the original table. Generated the running totals into the temporary table by looping thru the recordset and brute-force adding the values. Created a new query with the temporary table joined to the original...

PaulF Cool -- I had never tried putting the DoCmd.RunCommand acCmdFitToWindow in the *calling* code -- always had tried it in the Open event, where it fails. Thx!!

You could even use a UNION query, and forgo the creation of the temporary table.

AutoResize? Is that a property in Access97 reports? I don't see it anywhere in the Property Sheet. Where can I find it?

Here's a technique I've used in similar situations: Make a copy of the query so you won't damage the original Run the query -- try adding a record -- confirm that you get the "Can't add record" message. Design the query -- delete one table. Run the query -- see if the problem...

Here's a strategy that I use in one of my applications: Create a second MDB file with tables with identical structure as the tables that require archiving from the primary table. Rename all the tables in the Archive database with "zArchive..." prefix -- to distinguish them from the...

Use the BeforeInsert event of the form to count the number of existing records. If it exceeds the magic threshold, then display a message to the user and Cancel the insertion.