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

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

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

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

Hiya, When I make a custom data type in ACCESS for the input mask of a field in design view of a table, the data does display the correct format. However, when I create a VB interface to query the data it only finds the data without the correct mask. For example: Custom Data Type: ###-####...

I am stumped. I have an Access db that I am interfacing with VB6.0. Situation:Banking Application Clients can have several different accounts Accounts can have more than one clients I can't think of a way to display the info so that the user can add, update, delete records. ClientID1...

I have a table with only two fields. By combining those fields I will have a unique primary key for the table w/o adding another field to create a primary key. However, I don't know how to do this in MS Access. Do you? KellyPutty

The following code always ends in a runtime error instead of being handled by the On Error statement. Any idea what I am doing wrong? <code> Private Sub cmdOpenFile_Click() On Error GoTo HandleErrors Open txtPathName.Text For Input As #1 Dim S As String Input #1, S...