Search results

Wondering what's the best way of "removing" the drop down arrow from a combo box. Ideally I'd like a control to be a text box (or act like one) equivalent when the records are locked for editing. If the user "unlocks" the records for editing I'd like the control to change to a combo box with a...

Sorted Seem to have solved by problem. Allow Edits = No on opening the main form. I have an unlock button which unlocks another subforms and fields but not this one. At least I've got one issue resolved. Gareth

Can you not add another field and assign numbers to each status, e.g. Order Field, Status Field 1,Outstanding 2,Current 3,Declined 4,Delisted 5,Cancelled Then order the form by the Order Field.

Trying to get a subform combo box to find a record but limited to the records in the subform. Main form to subform relationship is one to many. Started off using navigation keys to navigate through records which worked fine and limited the list to the subform records. But when I add a combo...

Thanks Bob for clarrifying why I needed a refresh. Thanks Galaxiom for the toggle info, seems a tidier option than coding several lines. Gareth

Solved Added a bit of Refresh code each time before locking, not entirely sure why but it's all working fine now. Gareth

Thanks, I'll take a look at the toggle option, not overly familiar with toggle buttons. The AllowEdits = False button (macro) works only if I jump to another record or click on the Record Selector bar for example. Oddly enough the AllowEdits = True button (macro) works just fine. I'm using...

Odd, just tried adding two buttons with SetValue macros attached to each. One set to "No" for locking the record the other to "Yes" for unlocking the record. The Unlock works fine but the Lock doesn't. Something else must be happening, any ideas where to look? Thanks, Gareth

Have a form which AllowEdits set to No as default. Have an "Edit" button so the user can unlock the record and have attached some simple code which is causing an issue: Private Sub Cmd_LockUnlockRecords_Click() If Me.Form.AllowEdits = False Then Me.Form.AllowEdits = True ElseIf...

Thanks again milehigh. Think I have it sorted. Created main form using Indoor_Unit table and then the subform combining the Junction and Outdoor_Unit tables into a query. Then linked the main and subforms using the Indoor_Unit ID in the main form with the corresponding ID in the subfrom from...

Thanks milehigh, All working fine except when I try to add a totally new record for the subform (junction table) I get the message that I cannot add or change a record because a related record is required in table Outdoor_Units. My Indoor_Unit table is linked to the main form while the...

Hi all, would appreciate some pointers with a table relationship I'm trying to build in Access 2003 Currently have 2 tables: 1) Indoor_Units consisting of numerous fields: Product_ID (primary key) Spec fields (height, weight, etc) Others (price, optional accessories, etc) 2) Outdoor_Units...

Thanks Boyd, I seem to have gotten around my issue with a subreport. The main report houses the labels while the subreport houses the columns of data. The only issue I'm having is aligning the labels and text box controls which is a bit of nuisance. Gareth

Have created a simple multiple column report. Have placed the labels down the lefthand side of the detail section and along side each label to the right I've placed the text box control. The report works fine except that I'm not wanting the labels repeated in every column. i.e. I want one set...

Concatenate Can you not concatenate the values together? e.g. 5&12&87&89&11 Should give 512878911

All Sorted Thanks, great reference and just what I needed. The PC with the Viewer had a missing snapshot.ocx file which I downloaded. They both work 100% now. Thx again.

Should Add One of the other PCs is running Microsoft Viewer, which crashes with a run-time error when I use code. The second machine I've been able to fix as there was a missing Reference, which I unticked and the code work just fine. As the first machine with the Viewer cannot open the code...

Most confussed. Have attached the following code to a form: Private Sub CmdToday_Click() Dim TodayDate TodayDate = Date Me.InputDate.Value = TodayDate End Sub Button works great on my machine, updates the field its meant to. Thing is, on two other machines this code doesn't work. I've...

Have no problems with running general queries Not a problem with running a query. However, I have no idea how to add an autonumber field to my table (once it's sorted) via a query. Here is the underlying issue. I already have a table with an older ID field which is a simple text field with...

Tell me about it ;) Not entireley sure how I go about adding a new autonumber field with a specific format in a query. Any pointers? Thx