Recent content by Jacobingram

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...

Thanks very much - Exactly what I needed!! :)

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 haven't actually implemented that particular field yet...Sounds like a Good idea though!

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...

I do have a "hyperlink" field. How might I make a query that counts the files in the folder though? Please note : I am not a particularly experienced user in access...

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...

OK - Update Managed to get it so that the "Prospect Name" combo box controls which prospect record is selected. When changing the prospect name, it also changes the other combo boxes in the form to match the information it has on that prospect - great! Problem - Lets say you open the form and...

This is what i am having trouble with. Simple, I know - but I am a beginner!! When not in data entry mode, the form has the record navigation buttons at the bottom...If you use the combo boxes, it simply edits the record that is currently selected (ie record 1 of 90). I want to use the combo...

OK Thanks Here is the link - www.geocities.com/edd_23/db1.zip It is about 330kb Any help would be greatly appreciated...The form in question is named form/document. I am a complete novice so if there are any other glaring errors please feel free to highlight them!! Cheers Jacob

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...