General Discussion | Forum profile

Jo - This sounds like an option group with radio buttons - only one can be selected, rather than two checkboxes. -- Daryl S "jo" wrote: Hi I have two check boxes on my form, and what I would like to happen is if one of the check boxes has been selected then the other check box is disabled so that the user can not check both boxes at the same time? Does any one have any code that can be put in place to do this? thanks Jo

"(PeteCresswell)" wrote in message ... Per Armen Stein: Even the free Express version can be made much more secure than Access if configured properly. Speaking as one with only limited knowledge of SQL Server: "Even"?.... I thought the Express version was full-blown SQL Server, but throttled to limit concurrent users. Sounds like there are other considerations.... Essentially, any time a user can get direct...

Looks like it could be an incorrect error message. It should be complaining about duplicate fields. Another possible problem (less likely) is aliasing Outage.[WO-Number] AS [WO-Number] when you also have [Current Comments].[WO-Number]. SELECT Outage.WORK_ORDER_NBR , Outage.WORK_ORDER_TASK , Outage.WO_TSK_STATUS_DATE , Outage.SYSTEM_CODE , Outage.DISCIPLINE , Outage.WO_TSK_STATUS , Outage.[WO-Number] AS [WO-Number] , Outage.WORK_ORDER_TYPE ,...

Try this -- Open form in design view, click on combo, double click on combo, scroll to near the bottom, select Properties. Scroll to Column Widths and change it form something like this 0.25"; 0" to 0"; 1.5" in order to not display first column but show the second. -- Build a little, test a little. "Dee" wrote: I have a text field that is based on what is selected in a combo box. The text...

On Mon, 23 Nov 2009 14:10:02 -0800, PPCO wrote: What this is for is a delivery route with the deliveries listed in the order they'll be serviced. What I was hoping was when we start delivering to a new customer, we could insert that customer in the order they should appear on the route. I was thinking of ordering the customer sequence with a number. Perhaps there's a much better way though... Thanks for all your insight! You'll...

Have you looked into the Northwind db that comes with Access? I believe they have "employee photo" capabilities in that. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as...

On Sat, 21 Nov 2009 06:51:17 -0500, "Douglas J. Steele" wrote: Yes, that's possible. I did mine as an expression in the ControlSource of the control on the report, and I did get the full memo text, not just the first 255 chars. -Tom. Microsoft Access MVP I suspect that the OP had "Note:" & " " & [Note] in the query that's used as the report's RecordSource,...

Come to think of a query which joins the tables on BETWEEN…..AND criteria would not be updatable, do you would not be able to create an UPDATE query in fact. However, as I said in my final paragraph you don't need to do so in any case as you can just join the tables in a SELECT query and avoid the redundancy. This would not be updatable, but if you did want to update the item rows in a form which shows the category for each item,...

On Tue, 24 Nov 2009 01:35:59 -0000, "Kieron Capehorn" wrote: We have an Access file that we believe is corrupt. The Access file contains one table with 21 records and one form that shows all the fields in the table. We can open the file, but when we open the table, Access crashes instantly (it says Access has to close and do we want to send an error report, no error message more descriptive than that I'm afraid). A box...

creo ke estan con su abuela mejor porque me kedo mas trankila "kikeman" escribió en el mensaje de noticias ... Hi I am new using Access, and this may be an elemental question, but anyway, I have three tables: Customers. Orders. Payments. (Customers' payments) Customers has as primary key the name of the customer and the other two tables have as a primary key an automatic ID integer. How can I configure Access in the...