Search results for query: *

I have a treeview control on one of my access forms. The first part of the code that I use to populate the control is working fine. However, the second part, or the child portion, isn't populating like it should. It actually acts more like a parent. I can't see what's wrong - maybe I've...

I set up a trigger on Friday, hoping to have a history table on my database. The trigger seemed to be working fine. Then, I started getting THOSE phone calls. We started getting the error: the data was added to the database but the data won't be displayed in the form because it doesn't...

I am attempting to use arrays for the first time. I've scanned this website and looked at Ken Getz's Developer's Guide. I'm really confused. Here's what I'm planning on doing with the information - maybe somebody can come up with a better idea? I have a subform that has a PO number combo...

I know I'm probably just missing something, but I need some assistance! I have a form with a subform on it. It's a payroll type form. If the user's regular hours > 40, then the before update routine of the subform fires - this brings up a dialog box that asks if they want paid, comp or to...

I use a combo box to help locate records on an unbound form. The combo box is based on a stored procedure that has over 40,000 records. I have set the maximum records for the stored procedure to 0 but can't get the combo box to show all of the records. I'm sure that I'm just overlooking...

I could really use some help. I can't figure out what I've done. I did a database upgrade, but copied most of my forms and code so it wouldn't take so long to finish. One of the things that I copied was a not in list event that worked fine in the old database. The not in list event is...

I have found a wonderful FAQ written by Michael Red. This is exactly what I need to do. HOWEVER, it was written for bound forms. Mine are unbound. My question is: How could I rewrite this to use it on my unbound forms? And CAN it be rewritten so that I can use it? The faq is faq181-291...

I have a question that may seem kinda stupid but I have to admit that I've worked on this for several hours and can't seem to fix it. I have a list box that includes the physical address of a property. The physical address is made up of several fields so I concatenated the fields to make it...

Hello, all! I have a question that may seem kind of stupid. I hope not but I'd really like some opinions on it. I'm developing an Assessor's database. I'm going to use a SQL backend and an Access front end. (it will actually be an access data project - hope I'm in the right forum!) Anyway...

Hello! I would appreciate any help! I have an adp form that has a "Vendor Name" combo box. The combo box is bound to a vendor table. The form that the combo box is on is actually unbound. Anyway, I have an "On Not In List" event that fires when a new vendor is put into the combo box...

I'm trying to use a script file to open my database. I found this script on the microsoft web site and it resets the security level to low and then opens the database. I need it to open the database with a runtime version. How exactly would I go about doing that? I would really appreciate...

I really need some assistance with a FAQ that I'm attempting to use in my database. The FAQ is faq181-1172 and it's about locking down your database. Unfortunately, I'm using an Access Data Project(2003 version) and it doesn't seem to like the DAO that this particular FAQ was written in. The...

Ok, I admit it - I'm a complete newbie to Triggers.[dazed] I've been trying to do this all day. I've checked through this site as well as others but can't seem to figure it out!! Ok, I have created (using the word loosely!) a trigger on tblQuanityDetail. When a user updates the field...

This is going to be very confusing but ANY help would be greatly appreciated. We have 2 instances of SQL on our server - the first is the local instance. It is not named. It doesn't have anything in it -we've never used it for anything. I'm just scared to delete it. Anyway, the 2nd instance...

I have an unbound form with a treeview control on it. When you click on a node in the treeview form, the controls become visible and the correct record populates the form through a class. The first time that I click the node, I get a Class Not Registered Error. I believe this has something...

I have an unbound form that I need to put a subform on. I need to be able to undo any changes that a user might make. thread705-769981 talks about EXACTLY what I'd like to do Would this work since the DB is going to be in a multi user environment? AND how exactly do I do this? If I'm...

I have created a couple of roles in my Sql DB. The roles are Auditor and Commission. I have a form called 'frmAdminApproval'. I would like to be able to lock or make invisible specific fields based on a user's group(role). Is it possible to query a user role?

I would really appreciate any help with this.... I have an unbound form with a tab control on it. Each page has several unbound text boxes. I have a save button on the form (in the header). I don't want the user to be able to change pages unless they have saved their work. How do I cancel...

Hello. I have just started using an ADP instead of an MDB - so I'm a complete newbie!! I'm attempting to build a SQL string to query a listbox - but I'm having some issues on the date format. The SQL statement that I'm using is: Private Sub cmdSearch_Click() Dim strSQL As String strSQL =...

I have a listbox on a popup form. The listbox has 10 columns. The rowsource is assigned when the popup form opens using an openarg parameter. After it opens, I need to change that SQL rowsource into a value list. Is there an easy way to do this? I'm not sure if this helps or not but here is...