Search results

Thanks for the reply. That post is one of the many that I have tried and can't get to work. I can't get the dll to register so I can't use it as a reference, so the code won't compile.

Assuming the query you are using has a field call "Induction" and it is a YES/NO field, then a simple form reference as Mihail suggested (Forms!FormName!CheckBoxName) will work. If it is not, then the control on the form may not be returning a Yes (-1) or a No (0). To test that, put the form...

Hello! There is a built in function called IsLoaded, but it won't check to see if a query is loaded (a.k.a. open). I suggest you make a form and base it on the query. Make the form open in datasheet mode so it looks like a query. Then, on the after update of any control that you want to...

Don't import the data directly into the table you want to update. Import the data into another table (let's call that table "ImportUpdate"), then update the data via an update query (or through code), then delete the data from "ImportUpdate". The tools to import data into Access just do that...

You can make a table with the same fields, but set the Filed Property "Indexed" to "Yes (No Duplicates)" for the column you named "Name" (I would suggest you change the name to something like "FileName" or something other than just "name"). Append the data to the new table and only ONE instance...

I need some simple code that will copy an Excel file or a table in Access to a specific location on an FTP server. I would think this would be a very simple task, but I have yet to find any sample code that is *simple*:(. I have seen lots of code that requires downloading this dll or that mda...

Hello All. I used to support MS Access for MS at a company named Stream International. I was part of the second class of employees to be trained to support Access v1.1. I did this for five years until I went off on my own to build MS Access apps for a living.:) I hope I can help and get help...