Search results for query: *

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?

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

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

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

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

Hello- I am trying to create a browser button that when clicked opens the dialog box to select a file location and then places this in the text box called txtFilePath. That's all I need it to do. Right now, I have entered the code from thread702-798269 but it opens as a "Save As" dialog box...

I have an Excel table that is being auto updated by a macro that imports the new table after being given the file location. I want to know how to override or "delete" the data instead of making a new table. In other words the name of the table is "Starting Month" and every time it re-links, it...

I am trying to create a form that prompts the user to locate a linked file. Possibly a macro that leads to the linked table manager file, automatically checks off "prompt for location" and clicks "OK" so that the only thing the user does is find the file(s). I guess the outcome will be for the...

How do I just insert a field that is "input masked" to only accept date formats so that I can use this data for a report?

I have a label that contains an expression, and want to change the font size for part of the text. How would I do this?

I have three drop down boxes (Region, Team and Banker) and I only want the user to be able to select one search criterion. How do I validate the dropdowns so that only one can be chosen at once--and will it allow me to enter an "error message". Also- in formatting a label in a report- how do I...

I have a list of clients. I have a list of events. I have a list of bankers. I want to creat a form by which the banker can scroll the events (possibly by record selector just going from one to the next) and for each event his list of clients populates (possibly in datasheet view) and he can...

I have a linked table ...an Excel file called "Business Leaders" on a share drive. Every month, new data comes in and there is a new spreadsheet. Same format, different data. What coding do I need to use to set it so that when the user opens the database, a prompt is made for the new linked...

I have the following layout: Events Table: Event Name, Description, Time Account Manager: AcctMgr Client List: AcctMgr ClientName, Address, Email I want to create a query or form that does the following; 1) Looks at a specific AcctMgr, a specific event, brings up the clients for this acct...