Hello everyone, Am trying to learn how to code, can anyone please put an explanation in plain English,on each line of the below code.. And at same time, please...
Dale- Sorry, I should have removed that field from the SELECT list since I removed the table from the JOIN. Do you need that field in the output? John...
Robin- Perhaps an expression like: Website: Mid([URL], Instr([URL], ".org.au/") + 8) John Viescas, Author Microsoft Access 2010 Inside Out Microsoft Access...
ZJubias- See below... John Viescas, Author Microsoft Access 2010 Inside Out Microsoft Access 2007 Inside Out Microsoft Access 2003 Inside Out Building...
Hello John, Very kind of you sir. You know I requested your book (Inside Out A2007) to my boss, but it seems he did not hear anything, so instead just go...
Hello all, Why is it that sometime I have a read only query and sometimes able to add (read/write). In cases I need to build a query from two tables as a...
Hello all, Can someone please clarify my concerns; If I created a form to get user fills the search criteria like below format, I know that if I put these...
ZJubias- When creating a query involving two tables, it is critical that there be a link (JOIN) between a Unique key in one table to a related field in the ...
ZJubias- If you want to treat a "blank" criteria as no filter (all records), then you must do: WHERE ((MyField = [forms]![frmEnterParameter]![txtFirstName]) OR...
I recently converted to a split database due to errors we were encountering with multiple users. The backend resides on the server, and the front end accde...
Welcome Amanda! I'm glad to see you made it to our group. The only thing I can think of is that the text box and/or the combo box is corrupt. I'd make a backup...
Amanda No need to use the RecordsetClone or requery the combo. This should work. Private Sub ComboSearchNames_Click() Me.Recordset.FindFirst "[Animal ID] =" &...
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...
