Search results

Hi Guys, Having some auto sizing issues. See attached pics. My original form (RC13) was all good then I added to it and now its not resizing (RC14). I have checked the settings and they all look the same. Any tips? Thanks! Simone.

Hi Guys, I have this code behind a save button, I'm trying to automatically update my table from a form when a user up issues a drawing to a new rev. If [LatestIssTxt] = "Latest Issue" Then DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE DWGIssueControl SET DWGIssueControl.LatestRev...

Hi Folks, I have a form with a continuous sub form in it, I'm trying to get a keyword search to work. But as the continuous form is based on a union query from 3 tables I'm having a struggle. The keyword search is for one column only 'Product'. The problem is in two of the three tables the...

Does anyone know of a way I can change the destination (targetfile) in my code so the user can choose the target file location each time. Currently its set to one folder location. I thought about a msoFolderPicker but I dont know how to integrate it into my existing code. Private Sub...

Hi! I have a form with two command buttons Save and Exit(close) both have event procedures that bring up prompt message box's e.g. Are you sure you want to save? OK or Cancel Buttons The Exit button message box; Are you sure you want to exit without saving? Yes No buttons, only pops up if the...

Hi, So I have two Tables a "Master list" and an "Up issue list" and two corresponding forms. The User inputs new records into the Master list using the form, the columns/fields are; Document number, Document name, Document status and Date. The initial Document status of all documents is IN...

Hi! When you click a button on my form the code currently opens a file viewer and copies the file selected by the user to a new folder. The original file path is displayed in a text box which is bound to a cell in my table. I want the text box (and corresponding cell in the table) to only...

Hi! So I'm trying to use FileDialog on a form, I have a created an event OnClick of a button and have a Text Box to display the result. Whenever I click said button, I get a Run-time error '13' Type Mismatch Debug takes me to this line of code: Set fDialog =...