Search results

  1. S

    How do I prevent duplicates being created from an import of directory listing?

    I found this very helpful bit of code to 'import' the filename and filepath of files into an access table: Option Compare Database Option Explicit 'list files to tables 'http://allenbrowne.com/ser-59alt.html Dim gCount As Long ' added by Crystal Sub runListFiles() 'Usage example. Dim...
  2. S

    Solved How to cause a checkbox to become enabled when another checkbox is checked?

    Hi Arnel, Thanks for the suggestion and attached form as example. Using the GotFocus event does work for me. Cheers for that.
  3. S

    Solved How to cause a checkbox to become enabled when another checkbox is checked?

    My form is a single form, will that be affected too? And how do I go about simulating the conditionalformatting with a textbox.. sorry I'm not too familiar with that process.
  4. S

    Solved How to cause a checkbox to become enabled when another checkbox is checked?

    Is there a way to do it for each item. So in my example it was 'Fruit'. So when Apple has no tick on the 'Completed' checkbox, then the 'Required' checkbox stays disabled. But if it is ticked, then it will enable. But this should pertain to only that particular fruit. So the next line is...
  5. S

    Solved How to cause a checkbox to become enabled when another checkbox is checked?

    I have a list of items that have a range of checkboxes to be checked. I have two specific checkboxes; 'Required' and 'Completed'. I need the 'Required' checkbox to enable only once the Completed checkbox has been ticked/checked. That is, I need one of the checkboxes to stay disabled until...
  6. S

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

    Hi Pat, I think you misunderstood my query. The BE isn't necessarily different. But only the admin (me) would re-link BE tables to the master FE and then redistribute FE copy to users. I was just wondering if in the scenario a folder name or location changed for a particular reason, how could I...
  7. S

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

    Thanks DB. I may implement this in the near-future and report back my progress.
  8. S

    Calculating login username using given name and the first letter of surname?

    Hi Cronk, So how would I populate my contacts table with those user names? Is that simply done with some query or..?
  9. S

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

    Hi everyone. Thankyou all for the suggestions. Just to clarify further, yes I have my BE on the server. The users are distributed the FE to their local machines. So it's not the end of the world to simply re-link tables. And then redistribute the FE. But was just curious if there was a simple...
  10. S

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

    So if the folder was changed for example, all I would need to do is change the folder name back so I wouldn't need to re-link tables?
  11. S

    Solved How to get a startup form to open with blank fields but once in the database it open the specific record?

    Hi Vlad, Thankyou so much for your responses. I'll continue to work on this further tonight. I'll keep you updated if I'm stuck again.
  12. S

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

    Oh I never knew that! So my current FE/BE are in different folders. It just occurred to me that in the event of a folder change or BE moved, that I would have to re-link manually. Hence why my curiosity led me here. I could put them in the same folder. That would certainly be the quickest...
  13. S

    Solved How to get a startup form to open with blank fields but once in the database it open the specific record?

    HI Vlad, I'm having another issue on the same database. You may have noticed I had a form called "Login". The idea behind it was to restrict users who open the "Issue List" form using their user ID and access level. In the table "Contacts", there is two fields to be noted. One called 'Access...
  14. S

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

    I've had a doubt for a while now, not sure if this has already been answered in a different context or thread. If in the event the location of a BE changes or the folder structure that contains the BE and/or FE changes, how could I avoid having to manually re-link the tables again? As in is...
  15. S

    Solved How to get a startup form to open with blank fields but once in the database it open the specific record?

    Hi Vlad, Thank you for your patience and advice. Your attached database worked for me! And with TempVars, I had most of my stuff as macros; so when I converted to code there were a bunch of TempVars everywhere. I'll fix it up. Thanks, Sam
  16. S

    Calculating login username using given name and the first letter of surname?

    No you guys are completely right, I should never treat the employee list as rigid. Anything can happen and staff can change anytime.
  17. S

    Solved How to get a startup form to open with blank fields but once in the database it open the specific record?

    Here is the database template with some generic names. I haven't added any of the code that you guys have suggested. This is just fresh so you can play around with it. Thanks.
  18. S

    Solved How to get a startup form to open with blank fields but once in the database it open the specific record?

    Hi Pat. So this ensures the form will open blank in general. But what do I add in my 'ID' click for it to open to a specific record? In my above reply, I added the code I made for the ID_click, can you please see what needs to be done further. As it's still opening blank.. thanks.
  19. S

    Solved How to get a startup form to open with blank fields but once in the database it open the specific record?

    In my ID's on_click event I have: Private Sub ID_Click() On Error Resume Next If (Form.Dirty) Then DoCmd.RunCommand acCmdSaveRecord End If DoCmd.OpenForm "Issue Details", acNormal, "", "[ID] = " & Nz(ID, 0), , acDialog If (IsNull(ID)) Then TempVars.Add...
Top Bottom