Search results

Just a quick notification to you guys that I posted a sample database that uses an ActiveX treeview control in the Sample Databases section. I noticed a few people want to use treeview controls, but documentation is quite thin unless you search real hard. Hopefully this will help you guys a...

Just a quick question to see if any of you code gurus out there can solve this problem. The code Ive written simply opens up a recordset from a parameter query, but unfortunatly the code chucks a Data type conversion error whenever I run it. The code is listed below: Dim rstA As Recordset Dim...

Just a quick problem that I discovered with some Access 2000 vb code Im trying to write. The situation is thus: A form lists models with their respective parts in a subform. The subform is to be filtered using some command buttons (easily done). I noticed however through testing that the filters...

Really weird #Delete error As of late my large database that I have written has started to recieve errors. Before last week though, it worked nicely, and its only been in the last couple of days when everythings begun to go banana shaped. A quick bit of info; the Database is split to front/back...

Just 2 quick questions. Firstly: I have been asked by my employer to make the default value of a text box on a new record the value from a previous record. In this case, I use continuous forms as the display, and the records record an employee's leave. So the form runs like this; on the left is...

Okay, this ranks pretty high on my strange'o'meter. Firstly, the report in question simply prints out a report listing all outstanding orders (with their duedate and misc. details. The report used to work fine, then recently, every time I open the form it chucks an error. Run Time Error '2465'...

I was wondering if anyone else had a large performance drop in their databases when upgrading from Access 97 to 2000. The problem with mine is that I have a lot of code and stuff running in a particular form (it gathers an employee's details) and because there was quite a bit of information to...

A little problem has arising when trying to display particular values in a report. The setup is like this: the report displays a part number, and then any orders for that part. (Important part is underlined.) For example: SS1010: Control Box Issued: 1/2/04 Some info Quanity Issued: 2/2/03 Some...

I have this database that has a form and a subform. The main form governs the OrderID, and the subform contains the parts listing. Each order can have many parts, and a part can have many orders (many -many). Now I have to check for duplicates within the orders, meaning just after you enter an...

Hey everyone, just hoping someone can answer this problem that I have with a many to many subform. The subform is already set up, but I need to change it over to a way Ill show below, but I dont have any idea how. The list is a list of a persons skills (in a factory), and is many to many because...

Just asking for a little help with a strange problem that seems to be occouring with one of my DCount functions. The problem is as follows: DCount is returning different values in an identical situation. The first case is in a subform, the second case is in its own form. The arguments I use are...

This is a problem for all you Access gurus out there, perhaps you can help me, since Im stumped. So this is the problem: I have a large database that handles personnel data, and it happens that one particular section is very complex. So there are 2 tables, Personnel and Review, with one...