Search results for query: *

I'd asked a technical support person for some help and they forward me the following text: In the desktop database, create two views (a.k.a. "queries"), FOO_A and FOO_B, both built on top of FOO. The FOO_A view (query) would have four fields: OID - derived from OID_A Name -...

I've got a database of active patients with several tables. I want to be able to add a discharge function that automatically transfers discharged patient data to a new database and deletes data from the current database. This would include all data that matches the patient identifier. The...

I've got a database of active patients with several tables. I want to be able to add a discharge function that automatically transfers discharged patient data to a new database and deletes data from the current database. This would include all data that matches the patient identifier. The...

I don't wish to create an installation package via developer's edition.. Rather, I just want to copy my MDB to a different computer and allow it to be used. Access 2000 is installed on both computers. I tried this but first it won't let me edit the database on the other computer because of...

The chr(13) & chr(10) has been a life saver for carriage returns, is there a similar method for using a tab in a string expression. I'm concanating two strings but the first string has variable length, but I'd still like the second string to match up in alignment. IE:

On my form I have a command to display records in a table based on whether the date the user enters equals that in the table.. BUT I don't care about time, just if it's the same day.. So assuming 'uptime' is the name of the date variable in the table and 'userday,month,year' is the users...

I think it's a matter of referencing the proper library.. I've referenced DAO 3.6 but none of my RST.Findfirst, Rst.Findnext or Rst.NoMatch functions will work.. I keep getting data member not found.. I regret upgrading from 97! cheers, shawn

Is it possible without using a subform to refer to the expression builder / table for a control source? When I try writing an expression "=[Table]![variable]" as a control source, it asks for a parameter value and displays an #error? Basically I need to refer to many tables in one...

I've got three subreports.. each with a line of text, then a carriage return, a line of space, a carriage return etc.. I want to line each subreport up so that the carriage return on the previous form lines up seamlessly with the next subform with the space between each equalling a carriage...

Two report questions: 1) Regarding filters. I've created a physician orders query that pulls the data I need from several different tables. I need to create a filter that looks something like this: DatePart("yyyy", date1)="2001" AND DatePart("m&quot...

I've received a database that is in Access 2000 and I only have version 97. The person who sent it is now away for a month and I need to read this asap. The 2000 version is at http://www.vru.com/adrift/pocketneo.mdb If someone could convert it to 97 and place it on a temporary ftp for me...

I checked Ebay but no luck and obviously it's not sold retail anymore that I know.. does anyone have a copy they'd like to sell or can direct to a place that does? cheers, shawn

At the moment I have record numbers that can be a combination of text and numerics. Ie: 1908308a I need a fairly rudimentary way of scrambling the record number. I've tried converting to HEX, or OCT, but this won't work on record numbers with both alpha and numeric characters. Any further...

Is this possible? I'd rather not build a help file, but have a context tip appear that can me multi line and beyond 255 characters? do i need to write soem vb code? ideas? thanks shawn