Search results for query: *

Hi, I have an Access 2000 project running on XP and 2k machines. I have 3 tables with a related field called ID which has been setup for cascading delete of related recordes. The data is in a number format and is the primary key for each table. I have a main form with a delete command...

I have a multi-version environment that uses Access 2000 and Access 2002. I have a form with a command button which generates a report and Outputs the data to an RTF file. The code works just fine in Access 2000 but it gives run time errors in Access 2002. Also note that the computers with...

I will try to explain as best I can I have a continuous form displying multiple records. There is a text field formated for a medium date which displays the date the record was last updated. I want to make it so if this date is 5 days old that the back color of this field will change to...

That is my question. I have been developing a few databases and I consider consider myself to be an intermidiate developer. I was wondering though what is better to use when performing simple tasks such as requery a field on a form or oppening another form. I have been using macros but I have...

I have a query which pulls its data from a table. The table contains several fields which contain lookup values. For simplicity purposes I will keep this down to a few fields. Table1 = tblCustomerData Field1 = IssueID - primary key Field2 = CustomerName Field3 = Owner - The owner is based on a...

I have a form with a text box which is used to store notes and comments about the work done on a particular issue. The data is linked to a field in a table. What I want to do is have the date, time and a persons username inserted automatically at the beginning of the new entry in this text...

I have a table with a column that contains the nt login of the person who submitted the record. I am trying to build a query which will only populate the issues based on the nt login. I want this to be automated to the point where a user only has to open the query and it shows their issues...

I was using the code provided in FAQ181-1172 and it stops on the following line: Set prp = dbs.CreateProperty(strPropName, varPropType, varPropValue) I receive the following error: Run-Time error '13': Type mismatch. I'm no programmer and I am just learning what ever I can about access. Can...