Dear All, I have a continuous form that has attachments for some records. I use a command button to export the records to excel. But the attachment field is...
This worked perfectly! (although I'm a little confused as to why-I guess once you've selected a value in the Combo, it becomes the first one listed?) Thanks...
Hello John, Thank you.. Just a small clarification, the "MyField" on your below expression, would you please feed me more info on this. What is this field, it...
I have a client that has been using an Access Database for years. Now the company has Sharepoint and wants to put the database in Sharepoint. Since Sharepoint...
Looks like John took a break so I'll jump in. MyField should be replaced with the name of the field you use in your table. Whenever we post examples and don't...
Hurray! I tried the decompile and recompile per the instructions (including the compact and repair part), I have made an accde, copied it to the local...
Curses! I went to copy the working accde file to the other client computers, and when I open it on those computers, and open the form I've been working on, I...
Well, I made some progress by installing this update: http://www.microsoft.com/en-us/download/details.aspx?id=28521 which supposedly updates the VBE7.dll from...
Shot in the dark, I just ran Windows Update on the troublesome computer, restarted, deleted the local copy of the front end file, copied over the one on the...
Hi Chris, There are two ways of storing data in Access tables in SharePoint. 1) A "Hybrid" Database This is an Access 2010 or 2013 desktop database where the...
Kumar- The FileName property of an Attachment field will give you the original file name, but that won't include the full path to the file, so it won't work as...
Thanks, Bill. John Viescas, Author Microsoft Access 2010 Inside Out Microsoft Access 2007 Inside Out Microsoft Access 2003 Inside Out Building Microsoft Access...
Dear All, I have inherited a DB (simple Registration & Tracking) and I was ask to see and update what ever necessary.. So, first thing I noticed is the code...
Hello All, Could someone help me please, What is the missing part of the below expression? I want to calculate the expiry date from my EffectiveDate (EffDate)....
zjubias, I expect it is just a missing comma. =DateAdd("yyyy",1,[EffDate])+1 With a question like this, you should be providing us with the business rule...
Duane, Sorry I left your last paragraph. With regards with business rule of our company, yes we are having 1 day plus as a grace period.. Regards, zjubias ...
It did work Duane, huh, it seems my first mail did not come to you.. It works, thanks a lot.. Definitely, I will be needing lots of assistance from the pros...
I have a multiuser database how to control the user when open a form to "view, edit or delete" ONLY the records that he previously recorded thanks in advance...
I have a multiuser database how to control the user when open a form to "view, edit or delete" ONLY the records that he previously recorded thanks in advance...
Youssef- See the sample database you can download from: ftp://ftp.viescas.com/Download/Housing2000.zip Users can make reservations but can only see / edit...
Hi Youssef, You will need to store the UserName in all records that have been recorded by each particular user. You can then either filter the records...
Hello Clive, Thank you for your suggestion, let me try that if I can put it to works. Thank you, zjubias From: MS_Access_Professionals@yahoogroups.com ...
