Search results for query: *

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

this ALMOST works great-- except when I do it, an error msg comes up saying Run time error 424. Then, it highlights the 2nd line of this code: With fname ----> For Each itm In .SelectedItems Me.txtFilePath = itm I guess it's not recognizing .SelectedItems??? When I click the...

One user suggested I use this coding: Dim fname As FileDialog Dim itm As Object Set fname = Application.FileDialog(msoFileDialogOpen) With fname .AllowMultiSelect = False .Show End With With fname For Each itm In .SelectedItems Me.txtFilePath...

someone please help! All I am trying to do is create a simple browser button that will search through directories and return the filepath in a textbox called "txtFilePath". I've searched high and low through the forums- but all these are either too complex or just don't work for my form. I don't...

It is not recognizing the "SET" function. Also, do I just keep the event procedure on the command button the same?

I have two option groups: one labeled opgReports with the following values: 1) $5MM Change 2) $10MM Change 3) Banking 4) Investments and the other labeled opgQuartiles with the following values: 1) Top Quartile 2) Bottom Quartile. I want the user to be able to deselect the values in the...