Search results for query: *

'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...

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...

'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.

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...

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...

'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...

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...

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=3431 It works fine in 2000, but I recieve an ambiguous name detected: iFilterType when using it in 97. I am rather lowly in my skillz currently, so I apologize for the simplicity (i hope) of the question. I would use 2000 but the entire office...

Is this a common bug? I'm in the code builder area. I type As and it crashes. I can also do this in the debug window.

This may seem very simple but it is being rather aggravating. Maybe its just being new to the coding side of Access. I'm using a query's criteria applying a filter through a form. However the IIF(IsNull(forms!form!cboBox), [querycolumn],forms!form!cboBox) code that i use automatically knocks...

I have a filter form for a query. The intent is to filter the query for input into a report. It works except for one item: any value in the originating table wich has no value, ie. a box which has not been given any data. It automatically filters out data that does not contain a value. This...