Search results for query: *

Not having read AceMan's code, the way I was thinking of it working: 3 combo boxes: cbo1, cbo2, cbo3 Click on cbo1 (Code filters row source to display all available options: as nothing is selected in the other cbos, every option is displayed). Select option 2. Click on cbo2 (Code filters row...

'sup I have a subform which calls a query, which contains to queries tied together by a relationship. Very simple. Very common. BUT, I cannot delete any records in it. The query tells me it is read only. But it is a dynaset, no controls are locked, referential integrity has cascade delete on...

Would you consider modifying the contents of each combo box when it is opened, so that it only displays possible options based upon already filtered criteria? I don't have any fancy code for this but attach it to the combo boxes' On Got Focus event and set the combo boxes' recordsource to an...

Ok By changing a few things I've been able to bring it down to a minute. But that is still really slow so I'll give these a go. Gracias

Anytime I use: Dim rst as recordset Set rst = currentdb.openrecordset(tblName) rst.edit/addnew ... rst.update The operation takes an exponential amount of time. Currently for a table with 600 records in it, with one field being edited, with a small amount of text being inserted, I've been...

I have the pleasure of working with a distinctly flaky odbc connection. It tends to fail on startup but it also fails randomnly throughout my time operating on the database. So I have two questions: How can I trap any and every ODBC connection failure message and deliver a custom error message...

That didn't turn out to be the problem, but thanks anyway hymn. I had a relationship in the query which was binding the .Origin field to its corresponding table. So everytime i tried to insert the numeric value of the combo box into the field, I was actually trying to overwrite the value in the...

'sup I have a form which has three combo boxes behaving rather mysteriously. The form calls qCourses, which has the fields: instructor, type, and Origin. Each of the fields is a numeric reference to a corresponding record in the tables tblInstructor, tblType, and tblOrigin. The combo boxes are...

Hi, Does anyone know of some Human Resources Trainging db's that are available for download, or at least just some pics? My boss wants some examples to go on, but google hasn't been particularly helpful.

nice. Thanks faeryfyrre. But whats with conditional formatting being limited to only 3 optional formats? That's pretty lame.

Hi, I've finished an overhaul of an old 97 database, but before it is submitted, my boss would like me to investigate the newer 2000-2003 features, and make the db just a bit more shiny for the users. So are there any tricks/tips as far as the UI in the new version of access that you like to...

ok. But would you recommend that if the reports are published several times a day?

My company has several dbs which follow the normal model of being developed and released to the users. However there is a unique and important db which is under constant developement by its owner, and is viewed by several users. So whenever the owner makes a new report, which happens rather...

A more 'traditional' approach would be to use a class to represent the data and assign the values via the class. Unless the form (design) is changing quite rapidly there is little need to asign the query fields dynamically." I'm sorry, I'm a bit new to this vba thing. Would you mind explaining...

thankyou for your more efficient code. It works quite well. Unfortunately, it does not make a noticeable change in speed. There are about fifty elements in each area, resulting in 2500 comparisons. Is it possible to remove an element from the array aName once it has been matched? I just tried...

'sup I am making an unbound entry form. I load all the names of the controls and their assigned values into an array(x, 1), and then load the names of the fields in the query where the record will be created into another field. After a bit of comparison based upon the names of the fields and...

bingo. Thanks

That is, I would like to get the names of the query columns in string form, eg. "ID", "Description

Thanks RoyVidar, that helped quite a bit. Now for just one further question: I'm using Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Q_MdrData_wLogin") To refer to a query. It works fine. But, what I need is to see the names of each column in the query...

Hi, I'm a bit new to this vba thing, so please bear with me. I'm trying to make an unbound form for data entry only. It will gather the entered information from all the fields in the form and submit it as a new record. I have managed to get this to work. However my method is EXTREMELY...