Search results

I have a folder which holds 1000s of pictures organised in subfolders, for example: D:\~AI Database Print Scans\2009\family and D:\~AI Database Print Scans\2009\holiday And so forth. In total at the moment 17 main subfolders, each of which hold another 2-3 subfolders. I am putting together a...

A form in one of my databases became corrupted. I have recreated the form and it all works fine again but I thought it might be an idea to import all of this database into a newly created fresh one just in case some more minor corruption has sneaked into other forms. Well, did that and now I...

I have used the code below for about 4 years in .mdb databases. It's function is to highlight the selected record on a continuous form, worked great. I found it on this forum and I now hope other people I are using this code too and have experience with the problem I experience since I upgraded...

I can't work out how to set-up a qry based on multiple criteria on a single field without obtaining duplicate records. DISTINCT doesn't do the trick here. What should be the approach? This is for a library database holding a collection of publications. For ach publication one or more special...

I have a database which contains hundreds of publications, all listed on the main (continuous) form. To make it a little easier for the users I thought I'd let them select the main 'areas of interest' by ticking one or more radio buttons (7).Tthe result should be that only those records are...

I have a database which holds records of publications in journals, newspapers or other media. A minority of these publications are of interest to everyone in the company. Most are of interest to smaller audiences, i.e. groups of one or four individuals. I would be surprised if the total number...

I am really struggling with what I expected would not be very difficult. I just don’t get it and need a bit of help/feedback to get me on the right track. We have stacks and stacks of research papers that need to be organised so that everyone in our team of about 10-12 people can search the...

I'm combining 4 fields in a query but am running into trouble when 1 of the fields contains no data, which is sometimes correct. The result is that the field displaying the outcome of the combine query is empty, which is not what i wanted to achieve. Here's how I currently combine 3 fields...

I have 2 tabels, Docs and People Each table has about 15 check boxes to further specify the doc/user. -in tblDocs which groups of users this document is intended for and -in tblPeople which document the user should be trained in and a tickbox if training has been completed. e.g. if tblDocs chkA...

Hi all, We have documents on the server that employees frequently need to fill in, such as time sheets, expenses, training records etc. People often have a copy of these docs on their own PCs for their convenience (no more looking for the docs on the server). A problem occurs when docs are...

Hi All, users can opening a file (either .doc, exe or .pdf) with additional data to the record they're looking at by clicking on a icon on a form. The icon has code behind it that opens the document (Application.FollowHyperlink NameDocTo Open). That opens the doc OK, no problem, but what is a...

Hi all, I'm stuck with some VBA code and am hoping you can give me some suggestions what the problem might be and (more importantly) how to solve it. I have a template file on the server (StudyPlan.doc) that people need to fill in before they can start a new study. There's a button on the...

I have a form with a field ProjectNumber_StudyNumber. This field gets it data from a query in which data are combined from 2 fields: "ProjectNumber" and "StudyNumber". Format of the combined field is 1.10/005, 1.10 os the projectNumber, 005 is the StudyNumber. This all works good but when you...

Upon closing my frmInventory the amount stock of stock is checked against a minimal stock value. If the stock amount is below a set minimal value a subsequent form is opened telling you that stock is low and an email message is generated to notify a manager. I have a checkbox on that form which...

I have a label on a form with text including the word "generated". The funny thing is when I switch from Design View to Form View generated becomes genneerraat :eek: :confused: It's easy enough to use a different word but there's obviously a problem somewhere and I'm worried that Access might...

Hi All, I'd like to see a messagebox when I open a form (based on a query) that contains 0 (zero) records. I have a txtbox on the form that counts the numbers of records so I thought it'd be easiest to use that number and have the following VBA in the "on load" event: Private Sub Form_Load()...

Hi All, I'd lile to show/hide selected subforms based on the the text in a txtfield. The text in the selection field (txtSelect) I'd like to use for that may be either one of the following: book-01, book-02, book-03 etc OR, folder-01, folder-02, folder-03 etc OR, record-01, record-02 record-03...

I’m building a database of protein mutants we use in the lab. A lot of analysis is done on these proteins by various people and it’s becoming a bit of a nightmare keeping track of all the information per protein. What we need is a database. I’m getting a reasonable grip on it all I think with...

I need to able to quickly find which the last records that have been modified. I have an invisible field "txtModified" on the main form and selecting when changes where made to the record on the main form is easy using a qry on that field. The problem I face is that the form with all details of...

Can someone explain to me why the code below doesn't work? I think I'm doing everything right here. By clicking a button on frmFormsAndReports_period I open up the next form (frmBooks_Between_Dates),pass on the linkcriteria and then expect the first form to close. However, with the current code...