Search results

Not sure if it will work, but in the report footer have a textbox that has for its criteria: =Sum([OPTIONS])/Sum([SOLD]) HTH

Create a query show the 2 tables link by group and select group target and actions. Now use this as the feed for your report

Search for FORMAT and RED in the reports section and it wil return what you need!

Don't know about buttons in mail, but one way is if you are using Outlook, link your Inbox to Access as a linktable and then Access can read the replies. Bestway is to create a specific email account, but failing that setup a rule in Outlook that will move the message to a specific folder and...

You don't need to have all 33 fields in the listbox as it would be very hard to see it all and cumbersome to use. Suggest that you change the criteria to show only the important fields ie ID, name, drug, date and then when you double click on the record to fill the textboxes, you set the code...

Just wondering why you want a sumif statement. From whatyou have said it looks like you are wanting a normal Iif statment that returns 1 if both items are true otherwise 0. Iif([period]=1 AND [leavID]=3,1,0) HTH

First, if this is your code then you are missing an & rst.FindFirst "DateID = " & StrDateSearch And "StaffID = " & StrStaffSearch rst.FindFirst "DateID = " & StrDateSearch & " And {remove double quote}"StaffID = " & StrStaffSearch Also if it is a date then it ought to be: "DateID = #" &...

Another way is if the file that you are downloading has the same name each day then bring it in to the database as a Link file. As you are importing the data into a table then create a query that takes the data from the link file and appends it to your permanent table. Next, goto your permanent...

Not sure about this, but doesn't the DLookUp bit change the record pointer to the first instance that it finds therefore nullifying the findfirst findnext bits? Presuming that the ModID number that you are looking for is the number on the recordset where SSN = Me.SSN. If that is the case then...

Lynsey, What I suggested seems to be what you want! When you press the button, instead of the query showing in a seperate table, get the table to show in a list box ( it will be viewed as the same). Then the doctor double clicks on the record that he / she wants. This can be done in a...

As an idea, how about getting the results of the query to populate a list box (or set the value of the listbox to display the query) and then set the on double click event of the list box to display the selected record. HTH

Have a look at DLookUp function

I run a monthly code that appends data to a table, then runs a make table query which manipultaes the data into the right format for export and then loops through by building a query using the QueryDef code to create the site specific exports necessary for Excel. In 97 it works fine. In 2000...

To get the last item number for a List id use the DMax statement DMax("[Item]","TableName","[Lidst ID] = '" & Forms![FormName]![TxtBox with ListID data] & "'") Place this in a textbox on the form and refresh the box when you have selected a listID Otherwise you can use the formula in code and...

Few questions: What size is the database? (limit 2gig) Is there just one table? (Table limit 1gig) Have you repaired and compacted the database? Do you need all the historical information or can you delete anything that is over 6 months old (or move it into another table)?

Create a query where the criteria for the relevent field is =[Forms]![MyFormName]![MyFormtxtBoxName] The query will now show whatever has been entered into the textbox. Now create a report based on the query. For the button you just need to open the report and it should automaticaly select...

It's part of Access 9.0 library. Ought to work but make sure that the comma has been removed after TransferText ie should be: DoCmd.TransferText acExportDelim, etc.. HTH

To pick up data from a record: Dim MyRS as Recordset Set MyRS = Currentdb.OpenRecordset("NameOfTable",dbopendynaset) 'First Record MyRS.MoveFirst NumberOfCopies = MyRS("FieldNameOfCopies") etc. You can loop through by changing to MyRS.MoveFirst Do NumberOfCopies = MyRS("FieldNameOfCopies")...

Presume that you have something like FileName = "latest.txt" Instead have: MyDate = Format(Now,"ddmmyy") 'Or whatever format you want! FileName = "latest" & MyDate & ".txt" This will give you latest131102.txt HTH

You need the code to say If rpt then place it in lstNarrative otherwise place it in lstSummary. To do this you need to declare 2 string row source variables and add the report name to the relevant one. So within the For Next loop you want: RepName = Right(rpt.Name, Len(rpt.Name) - 3) If...