Search results

I have a form with two subforms. The second subform is really a subform of the first subform - confused? Ok. MainForm has many records in SubForm1. SubForm2 has many records in SubForm2. I know I can have two levels of sub forms in a main form. However, the problem with this is that I want...

Hi This is kind've a re-visit to a thread I posted a few weeks back. I have stored a number of work and rest periods by position for each activity in each session. What I now need to do is summarise the contained information by position for each session. I want the following information in...

I've had a look on the site but can't find an answer to this question - then again, I may not be searching the correct terms!! I have a sub form that contains periods of work and rest for various groups in a session (mainform). I want to be able to calculate the percentage of the work that was...

I recently posted a question concerning calculating ratios on a form, and was sent some code to try out. Unfortunately, I cannot get it to work. I don't think it is a problem with the code itself, rather where and how I am attaching it to the form. I'm sorry not to be giving more...

I have a table that contains 4 pieces of info: Session Position Work Rest What I want to do is calculate the % of work that was less than 10 for each position in each session. Any ideas??

It's been a while since I built an access application and so this could be relatively simple - might just need the cobwebs cleared out of the old noggin! I have a table that contains two variables (var1 and var2) and the ratio of one to the other i.e. ratio = var1 / var2 Now I know I can...

I have created a report with two subreports. These are all linked by a CustomerID. The subreports contain subtotals that are needed for the calculation of the grand total (an unbound text box using an expression for the calculation) on the main report. In general the grand total calulation...

I've tried to calculate the total sum of key controls contained in sub reports on a form. I have used this method several times before, but now something weird is happening. The calculation is contained in an unbound control on the main form and is as follows...

I have been using the following code to update information populating a combo box, e.g. if I enter "eggs" and it is not a stored term, I get asked if I want to add it, and then the combo box is updated accordingly. 'In the data entry form ... Private Sub JournalID_NotInList(NewData As String...

I'm in the closing stages of creating my database, and as a tidy-up I want to control the visibility of forms that open other forms. for example If form "A" opened form "B", when "B" opens "A" becomes invisible, and when "B" closes "A" becomes visible again. As this happens numerous times...

I have a form (a) that can be opened through one of two others (b or c). I want the operation to work such that whichever form is used to open (a) is hidden / made invisible when (a) opens. This I have managed to do. Now when I close (a), I want the form that opened (a) - either (b) or (c) to...

Could someone please help - I'm having a no-brainer!! I have a continuous form containing basic information regarding articles. The fields are: ArticleID - unique ID Title - article title Yr - year published Print - a check box What I want to do is to have a command button that when clicked...

I am trying to build a continuous form that allows me to check off which records I want to print. However, I can't get the check box to work - it is an unbound check box and if I check one record, I check them all. Any ideas?

hi does anyone know if it is possible to format part of a concatenated field so that it appears in italics, while the rest of the concatenation is in normal font? Thanks

Having finally resolved what I thought was the more difficult issues concerning concatenation, I am once again bemused. Here's the basics... I have an unbound textbox that contains concatenated information from several fields in a table. Didn't see this as a major issue as I've done it before...

I need help in creating a reference list. I have a main 'Articles' table which forms a many-many relationship with an 'Authors' table, through an 'ArticleAuthors' table. Generally speaking, I'm not too bad with the workings of reports, but I need to create a concatenated field that will hold...

I'm building a multi criteria search form. All is well, but I now want to make one of the controls, one containing multiple selections, an OR rather than an AND variable. Does anyone know how to do this? Thanks

I have the following code: If Not IsNothing (Me!Keycodes) Then gstrArticle = "[ArticleID] IN " & " (SELECT ArticleID FROM " & " _ qryArticleKeyword" & " Keyword IN (" & Me!KeyCodes & ")" Else gstrArticle = gstrArticle & " AND [ArticleID] IN " & " (SELECT _ ArticleID FROM " & "...

Ok I've got a form that shows whether an article belongs to a book or a journal. However, when you move records the option remains on the previously selected value. Does anyone know how you could get the option to change automatically as you move through the records depending on whether...

I am creating a database to hold information pertaining to research articles. Ultimately I want to create a search form to find the article I want by certain categories. Now to the point ... I have 2 tables. 1 is a referential table of keywords, the other is the main table, holding the...