Recent content by jprochelle

I am trying to get the checkbox to print the words "Yes or No" instead of the checkbox being displayed. But it is not allowing me to do that, for whatever reason. When I click on properties, there is no option for me to chose yes or no in the formatting section...

I have a form with two combo boxes. I don't know what setting are messed up, but whatever it is, it keeps the combo box selection the same for each record. I just want to be able to edit and change records in the form, and every time I select from the combo box- I don't want it to change the...

I have a report with a yes/no field. In report form, it looks fine. But when I export to work the checkbox disappears and you can't view the data. How can I get the report to print "Yes" if the checkbox is not null?

Thanks- this worked great. However, now whenever I try to change and add new records...the two combo boxes stay the same for each record..instead of being saved as the ones that I chose.. Do i have to delete what's in the row source for the 2nd combo box? Is that why's it's getting confused?

The two fields being appended to are primary keys and number fields. Thus, there is no "allow zero length" field. Do you have any other ideas?

Right now the row source is based on a query: SELECT ClientsImport.CID, ClientsImport.Name, ClientsImport.Banker FROM ClientsImport GROUP BY ClientsImport.CID, ClientsImport.Name, ClientsImport.Banker HAVING (((ClientsImport.Banker)=Forms![Edit TOP 10]!cboBanker)); This was what I thought I...

I am doing an append query. When I run it, the data shows up in datasheet view. but when I actually try to do the append to the table, I get a key violation error. How would I fix this and do I need to explain my primary keys and relationships before I can get help?

I have two combo boxes. I want to do an afterupdate so that after one selection is made in the first combo box, the second combo box automatically "repopulates" with new data based on this selection. I think it will be similar to an AFTERUPDATE...requery..but it's not a query, just new data...

This is what I have: SELECT DISTINCT [In house].CUSIP, [In house].[Idssg code], [In house].[Street Address], [Commercial Loans].Description FROM [In house], [Idssg Code Query], [Commercial Loans] WHERE ((([In house].[Idssg code])="COOP")); when i perform the query, it lists the CUSIPs from In...

Yea, this didn't work. Is there any way you could tell me how to join in design view. Because doing it in SQL is giving me errors. Thanks,

I have two tables: In House and Commercial. In both tables there is a CUSIP field. I want the form to only display those CUSIPs in the "In house" table that have a certain criteria for a field in the "In house" table (i.e. only show those that have "yes" in the COOP field). At the same time, I...

Is there a way to program a macro (linked to a button on the switchboard) that when clicked, will prompt for a user name and/or password and then open the database in edit mode. basically, im trying to restrict users from accessing the workings of the database- without having a log-in for the...

I'm trying to write code so that holding shift to open the database requires a password, and/or a macro so that when the database is opened as normal-there is a command button that will open it in "edit"/database admin view, which requires the same password. Basically, I want the users to only...

This worked perfectly. Thanks!

I'm using this exact code and the same error occurs. Private Sub Command8_Click() Dim fname As FileDialog Dim itm As Object Set fname = Application.FileDialog(msoFileDialogOpen) With fname .AllowMultiSelect = False If .Show = True Then For Each itm In...