Search results

Hello all, I have the following code for a button: Private Sub Command16_Click() On Error GoTo Err_Command16_Click Dim varItem As Variant, strSQL As String DoCmd.SetWarnings False If MsgBox("Are you sure you want to append " & Me.[lstRequirements].ItemsSelected.Count & " records?", vbYesNo +...

Help! I've split my database and posted the back-end on the network, and rolled out the front-end to other users. It works great on my machine, but other users, when they open the front end, get a message that the database is read-only, and cannot make any alterations to the back-end (even some...

Hello all, I am using MS Access security, and it works fine, but I have an asthetic problem... I would like to integrate the login screen/password prompt into my startup form, rather than having someone enter their password to get into the database. Is this possible? Thanks, Chris

Hello all, There is a lot of info about the database splitting process, for which I am duly thankful as I am about to take the plunge. However, I can't seem to find the answer to a simple question - if I (as the developer) want to add a new table or modify the structure of an existing table...

Hello all, I have a table (tblComponentCriticality) with the following fields: SystemNumber Tagnumber compclass The SystemNumber and Tagnumber fields make up a concatenated PK. SystemNumber is also an FK for another table, which lists all systems by number and name. The field complcass can...

Hi all, I have put an If statement into a subform in the AfterUpdate property of a checkbox, telling it to update a combo box field if it is checked. All very simple. However, since it is in the subform, whenever it runs the code, it gives me an Active X error. I've looked through the posts...

A simple query question (for someone else). I have an option box on a form with three choices. The query I have written takes the numerical option box value and uses it to filter values. The first two choices are specific, but for the third one I want the query to return all the values in the...

Hello all, I have a question for everyone. I am deep into programming a database, with many forms, queries, tables, etc. I was a good boy and drew out an Entity Relationship Diagram for my database, so I know the relationship between the tables. However, I didn't keep good track of what fields...

Hello all, I need help with something that I am not sure is possible. What I would like to do is the following: I have two list boxes on the same form, call 'em List 1 and List 2. They might look like this: List 1 List 2 A 1 B 2 C 6 D 10 What I...

Hello everyone! I have the following code for a multi-select list box. It worrks great, but for every record, the user has to click "Yes" to the "You are about to add one record" question. How do I get Access to stop asking that? There must be a simple answer. Thanks! Chris Private Sub...

Hello all, I created a replica of my database in Access 2000, but when a user tries to open forms in it in 2002, she gets a read-only message and the database closes. Is there a compatibility issue here? Thanks, Chris

Hello all, I would like to disable the close shortcut command - AltF4, so that users can't bypass security by simply closing out the form to get to the back end of the database... anyone know how to do this? Thanks, Chris

How do you set the property for a list box to deselect the currently selected record after you leave the box? Anyone know offhand? Thanks! Chris

Hello all, I have a form with a text box that I want to use for a keyword search. Entering text in this box opens up a pop-up form that will display a list box of the records returned based on a query using the keyword value. I want the user to be able to double-click on a record in the list...

Hello all, I have written a query which takes values from two tables: tblPIDjoin: Index, PIDNumber, SystemNumber tblPID: PIDNumber, DrawingTitle The query takes the SystemNumber and PIDnumber fields from the one table and the DrawingTitle field from the other table. I then have as the...

Hello all, I've got a form with a list box and a button that opens another form. If you double-click on the list box, the form opens to that record. If you click the "add new record" button, I want the form to open blank and change the recordsource to the table where I want the new data to come...

Hello all, I have a form with a command button that will open up another form, which will allow a user to enter data. Both forms have a common field "System Number". I would like the forms to be synchronized, such that the value from the system number field of the first form is set as the...

Hello all, I have a combo box called "cbobuildingcodes" and a text box called "Description". The value in the Description text box is dlookup'ed based on the value for the combo box. This works fine. However, I'd like some error-checking code in there so when the combo box is empty, I don't get...

Hello all -- I have a table named tblSystemInformation and a table named tblBuildingCodes. Items in the SystemInformation table have a code assigned to them; I would like the description matching this code, in the BuildingCodes table to appear in a text box (called BuildingName) when the combo...

Hello all, I have a report that I would like to make that will display records that have been filtered by a user selection. I.E., I have a bunch of records that have associated attributes. I would like the user to open the report, select from a combo box (or some other list) displaying which...