Search results

Genuis!! Thank you! It works like a charm! Also in a multiuser environment how do I lock the table?

Hey Bob, Thanks for answering. The year is included, where it says GYY (G11), thats the year. The reason why the year is separate is because when the year changes, ie from G11 to G12, the three digit number at the end should revert back to 000. Also, i get what you are saying about using an...

Hey, I am creating a correspondence database, where employees in the organisation keep track of their outgoing mail by entering in details and attaching the copy of the letter. I have made the Table and a user friendly input form. Now the primary key of this table is a inhouse reference...

i have a feeling I knw the reason behind the problem. For some reason it keeps automatically capitalising "i"'s but not any other letter of the alphabet. Any way I can switch off its autocorrecter?

sure, i can do that, but (sorry for the ignorance) but how do I attach it?

hey, i had a similar problem and I was able to solve it, thanks to the solution given at the link listed above by JBB. However, I need some help troubleshoot. The listbox works just fine, until when a user inputs anything being with "i" into the "searchfor" text box. Then it kinda crashes...

Thank you for your reply. Ok, so i tried this. My fullpathname is saved in the 'Links' field in the ElectronicFileDatabase. I coded my button (which is Command82) as follows: Private Sub Command82_Click() Shell "Explorer.exe " & Me![(Dlookup("[Links]", "ElectronicFileDatabase"))] End Sub I...

Thanks JBB, but maybe im not being specific enough. I have a Form that looks very similar to this: |OriginalName________|FileName_____________|DataType___|Attachments |Legislations&Bills_____|0000.Legislation_GOP__ |PDF________|[VIEW] |Registration Laws____|0013.Reg...

No offense guys but I am getting a bit frustrated here. Yes now I know what a shell out is, but can anyone tell me how I can implement it to my context IN SPECIFIC? RuralGuy, I have followed your link, and I do not understand exactly how to put that code onto my button. Also I have been trying...

Ok, thats great. However can anyone give me a shell out code i require with description? I want to understand how exactly to do this so I can trouble shoot latter if need be.

Ok, i got your first part, however I do not know what you mean by Shell Out? The attachments are various file types from images to pdfs to docs to xls. Does anyone know what coding I should do behind the button to make it work?

Command button on a continuous form opening a link from the record Hey I have a continuous form called “EFSearchForm” which has bounded fields from “ElectronicFileDatabase”. This form has fields titled “OriginalName”, “FileName”, “DataType” and “Attachment”. The attachment field has a...