Search results

i guess its just a little too difficult...or impossible I am genuinely surprised that there is no one to give me any advice. I guess that probably means that it is not possible to do. Many Thanks for looking anyway Dave

Hello everyone and happy New year. Ii have a database running on Access 10.0, I am using the insert hyperlink dialog box (access by Ctrl K) to allow users to insert a hyperlink to a file (could be any sort of file), into a text box. The problem I have is most of the files are held many...

I had a few thoughts of my own and now it works OK I used the following code strMySql = "INSERT INTO tblArchiveAdHocAssocDocuments ( DocID, TaskNo, DocumentName, DocumentDescription, DocumentLocation )" strMySql = strMySql + " SELECT tblAdHocAssocDocuments.DocID...

about 3. But then its more about the speed of the network I am running it on, well when I say running its more of a jog

thinking out loud Colin We could generate a large number of records (tasks) so I felt it was best to keep the overheads to a minimum to get them out of the main table. I was thinking something along the lines (and this is conceptual as i have no idea how to do it!!!) of Writing some code to...

I have a database for tracking tasks. each task may have associated documents for it which are kept in a separate table. I have an archiving procedure which takes closed or completed tasks (from the main table) and appends them to an archive table but it leaves the associated documents in the...

Hello All and thankyou for taking the time to read. I have been using vb to take entries from a form and populate a bookmarked (pre prepared) document(template) and thanks to some advice on here and learning as I go it has been very sucessful, so far. I am now stepping up a gear and want to...

I have a form for entering data and to aid people inputting data into a text box I would like a pop up form to appear to enable them to refresh their memories as it were with some information. I was going to use the got focus event of the text box to open the popup but how do i then pass the...

Is it possible to hide text boxes/controls on forms dependant on the user ? I have a had a (quick) look at access security and it appears that it just enables read/write access to objects not controls on the objects. Many Thanks in anticipation Dave Smith

Hello All is there a way (i guess using VBA) to import an excel spreadsheet into an access table without having to go through the wizards, if you know all the field names and other variables ?? Yours in anticipation DJS

Thanks for your help, and i didn't know I had posted it multiple times.....

having used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of...

having used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of...