Search results for query: *

Is there a way to have the parameter for a report be from a dropdown box of predefined values? For Example, When opening a report I want an input box to display a drop down box populated with: Carpenters CDLS Electricians Thanks, KellyPutty

I would simply like to enable/disable controls based on whether a checkbox is checked. However, the following code creates a record even before the actual update. For example, if I check the checkbox, then change my mind and uncheck it, there is a blank record inserted into table...

When using a form wizard. Psuedo-orphanded-foriegn keys are created when appending a new record across multiple tables. Is there a way to prevent this from occurring in the first place? Extra Info: All relationships across at most 3 tables are one-to-one. Cascade updates and deletes are...

Wonderful, I thought it might be something like that. However, I created this form thru the form wizard. How does one do the above via a form generated by the wizard. Best, KellyPutty

Yes, ClientID is autonumber and the foriegn keys (ClientID in all other tables are number, long integer)

SELECT Clients.ClientID AS Clients_ClientID, Clients.LastName, Academics.ClientID AS Academics_ClientID, Academics.CurrentlyEnrolled, Tribals.ClientID AS Tribals_ClientID, Tribals.TribalAffiliation, Vocations.ClientID AS Vocations_ClientID, Vocations.Carpenter, Carpenters.ClientID AS...

For some reason when appending a new record, if I don't add a value to every table involved with the form. The empty tables when later given data will cause the tables that were given data previously to contain a Null value fortheir foreign key field. This is why there are issues appending...

Why if your query can perfectly update and delete records would I have problems inserting a new record. (multiple tables, all one- to- one relationship)

I think I have to write some code to get my form to automatically enter the correct foriegn keys in my tables. I am new/rusty on VBA. Is there a built in way to do this? If not, does anyone know of an Access VBA online (free) tutorial?

The following tables: Clients: ClientID(P autonumber)*** LastName FirstName SSNum AcademicEducations: ClientID(F , number, long integer)**** HighestObtained AcademicEducationsID (P autonumber) Institutions: ClientID(F , number, long integer)**** Where StillAttending InstitutionsID(P...

Anyone know of a site with free tutorials preferribly at the intermediate level?

I am displaying records using a data grid from VB6. I allow the user to edit individual entries. I would like to add user error control so that: Record: Field1: Account Field2: Balance Field3: MinBalance If the user wanted to edit the Balance but put in an amount lower than the the...

Never mind, in another area I closed the connection and that is why I was getting that error. Oops! Thanks, Kelly Tessitore

sure: Private Sub Form_Load() Set conMB = New ADODB.Connection Set rsCustomer = New ADODB.Recordset Set rsCustomerAccount = New ADODB.Recordset conMB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Persist Security Info=False;Data Source=" & App.Path & _...

I get the following error message from my VB interface when attempting to change an entry in a textbox (Balance): Binding Collection Error: Field not updatable, Bound Property Name: Text, Field Name: Balance I think it either has to do with the text box itself (it is not locked) or the...

Is there some sort of move method in which I can move the pointer to a specific record at run-time? Here is my problem: Table1:Customer CusterID LastName FirstName ..... Table2:CustomerAccount AccountID CustomerID Many-to-Many relationship: Many customers can have Many accounts...

I am stumped. If I use a literal string in my SQL query below I get the correct result. If I use the value in a textbox, I get nothing. Not sure why. Below: if instead of what I have in bold I insert 1001009, my dbcAccountID populates correctly, but not with txtCustomerID.text. Any...

Nope. -KellyPutty

My program crashes once with every change I make but then seems to work fine until the next change??? Any thoughts? KellyPutty

Skip this last question, I took out all formatting in Access. It doesn't belong there anyways. Kelly