Search results

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

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

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.

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

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

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

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

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

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

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?

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.

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

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

Thanks for the information Doc.

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

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

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

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.

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.

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