Search results

Have an EDIT and LOCK button which allow editing of records and lock editing of records in a form. Editing is also locked when navigating to another record. Is there any way of adding a timer to the locking of edits? Ideally, if the EDIT button is clicked to allow editing is it possible to...

Have an unbound combo box which by default is not visible. When the user clicks on an "EDIT" button the combo box becomes visible using the following bit fo code: Forms![Frm_Main]![Subform_Capacity].Form![Cmb_RangeSelector].Visible = TrueThe opposite happens if the record is changed (On...

Have posted a similar question over in the Forms forum but this may be more relevant to Tables: http://www.access-programmers.co.uk/forums/showpost.php?p=1018824&postcount=16 It would seem I should not be running multiple subforms over multiple tabs from the same record source. Does anyone...

Realise this has been asked before but I'm struggling to get a subform to update it's recordset when a new record is added. Have one main form with sevral tabs and some of these tabs I've placed subforms. The three recordsets are linked by a one-many ID table from each of the two other tables...

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

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

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

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

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

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

Table containing ID field on following format: GEF001 GEF002 . . . GEF800 I'm wanting to add a new autonumber field to the table but want the table to be ordered by the existing ID field before adding this new field. Right clicking on the field in Datasheet view, order the ID field in...

Essentially two related question, a workaround for either would be appreciated. Trying to format an autonumber field: "GEF"#### e.g. GEF0015, GEF1258, etc Alternatively is there anyway around finding the max of a field of the format "GEF"#? The issue is that when I run a query to find the...

Hi, Posted a short thread the other day with regards picking up an error message if the file length was null. I've managed to get halfway there but am still having some issues and was hoping someone could help. Here's the code I'm runing off a button in a form: Private Sub ViewLogImage_Click()...

Have the following bit of code which opens an Excel file related to an entry in a form when the user clicks a button: Private Sub Cmd_OpenExcel_CoreLoc_Click() Dim CorePath CorePath = "W:\Core Data\" & Me.WELLNAME.Value & ".xls" Shell "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE...

One form two search combo boxes created with the wizard which finds a record on the form based on the value selected in the combo box. Combo box works a treat. However, when I add a new record the combo box list does not update with the new record. It does if I close the form or put it in...

Have created a bit of code so when a user clicks on a button it open Explorer in the correct folder location, here's my code: Private Sub Cmd_OpenExp_MEDLoc_Click() Dim ProjPath ProjPath = "G:\MED Data\" & Me.MED_FolderLink.Value Shell "C:\WINDOWS\explorer.exe """ & ProjPath & ""...

Am having problems with images that are too large to display in allowed form space. Basically I have a log image for each record which is fairly long and the form in which the image is viewed cannot be made long enough to view the entire image on scrolling down. The width is fine. Using Clipped...