Search results

I have a large database with many tables, forms and queries. One of the most important tables is the document table, which lists various properties of a document. One of the fields in this table is the doc location, and it is of the file type HYPERLINK. The only reason I have used this file type...

I wish to have one of my make-table queries run automatically at midnight every day. The access database will be running on the server at this time. I have searched for a solution but found them quite hard to understand. Thanks in advance for your help :)

I have a piece of file counting code : Private Function filesearch() Set fs = Application.filesearch With fs .LookIn = "C:\Windows" .FileName = "*.*" .searchsubfolders = True fs.Execute Dim filecount As Integer filecount = fs.Execute MsgBox...

I am a beginner to VBA and relatively inexperienced in access. I have spent the last month creating a quite large and intricate database with an asp frontend. I have two more things I need to do to complete it. 1) Add a field to one of my tables which tells the user how many files are in a...

I have a database with a form to add pieces of data. There is then an ASP frontend which acts as a browser to the database. One of the fields is called 'format' and only has two options - hard & electronic. Rather than the words "hard" and "electronic" to be on the form (and the ASP frontend) I...

My boss gave asked if I could add this function to the database I have created. The database consists of thousands of document names, with about ten more fields with the corresponding details. The database has an ASP front-end and is basically intended to run as a slightly more functional...

The result I am looking for is this: The user selects a prospect which is made up of Prospect Name, Country, Company and Prospect Type. They can then use the subform to add records into the database with the above information already there. At the moment I have four combo boxes in the...