Search results

Yes, although it's calculated. The Field is called 'TIME: Date()-[DECIDD]' I'll try changing the field name, although the query runs no problem as it is, problem only when I enter a value into the criteria box of another field - 'Letter: LetType([TIME])' Thanks for the suggestion, FrankyG

Hello all, I have a field in a query(make table) which calculates the number of days between 2 dates[TIME], then I have the query determine the value of two other fields 'Letter: LetType([TIME])' and 'range: PeriodChecker([TIME])' depending on the value of [TIME]. I do this by using a function...

Hi, I have a button which launches a make table query, starts MS Word, which reads from the table and mail merge's some of the results. The query will typically return a good number of records, but I only want to mail merge ones where the field 'LetType' equals 6M or 30M. Often, there are no...

Hi, I have an 'Events' Database in which I'm trying to record time spent by various staff members at each event. tables; tblAppDetails, tblEmployee, tblHours I have already made a good start on the main input form, but need some help of the employee/hours sub-form. It's a relationship...

Thats the ticket....couldn't see it for looking at it :rolleyes: Cheers! FrankyG

Hi, I have a form on which I have 5 tabbed pages each page having a few controls on it. Problem is that I really need to rename my form, but most of my query's/reports reference the controls on the form. Is there any way to change the name of the form and update all the query's accordingly...

Thanks, What does DateValue function do? I tried it and got an error about the expression being to complicated. It's a bit trial and error at the moment! Cheers, Frank

Can anyone tell me what this does; In the field (QBE grid) Format(DateAdd("yyyy",3,[CASEDT]),"mmyyyy") and in the criteria field there is; Format(DateAdd("m",2,Date()),"mmyyyy") The field [CASEDT] Is a date field, and as far I can see, this criteria will pull results that have dates which...

Hi, I have a form which has an optional combo-box field which can be selected prior to running a report. I would like my report to pull through the selection from the combo box, or if the combo-box was left blank, to display 'No team selected' I have done this before and am searching through...

Hi..and thanks for that starter. I've set up the tables but I'm still having a few problems. First, the lookup tables; LookupTables: tblPropertyType tblActionType tblCorrespondenceType Am I right in thinking that there only needs to be one field in each table? Thats what I have done, and...

Hi all, I have three tables, Property, Owner and LetType For each property, there can be multiple owners. For each owner, there can be multiple letter types sent on different dates. The letter types will be limited to 3 or 4 types. I need to record when we sent the letters to each owner, the...

Hi, I would like to produce a report (actually need a graph, but haven't even looked at that!) that will allow me to compare data from 2 years side by side. I want to total various fields (9 in total) recieved in a 4 week period. Then I want to see cumulative totals over the year, for both...

Hi, I'm starting from scratch with an events database but need some advice on tables/relationships. The main purpose of the database is to calculate/record the hours spent and fees generated by our staff members who attend the events. Each EVENT may be spread over a few SITES (eg New years eve...

Ok....that works but why do you add the 'filtered' to the end of the IIf statement? Also, when the form is loaded and record 1 is displayed, the Me.txtTotalRecs field shows 1. It only updates when another record is selected. It's a minor point, but is that normal behaviour? thx Frank

Hi, How do I display which record is currently being viewed? I don't want to display the standard Record Selectors, I want to create custom controls. I want to show 'Viewing Record 'x' of 'y' on the form. I've got the second part, a text box with control =Count([File No]), how would I get the...

I also wanted to use a combo box on a form and be able to type directly into the combo box, and add this new value to the underlying table. This worked good for me; Private Sub Event_ Yourfieldname_NotInList(NewData As String, Response As Integer) Dim rec As Recordset If MsgBox("Site is not in...

I tried using a query (based on the Applicant list Table) as the row source for the combo box and this worked. Why it didn't work using the Applicant list table I have no idea. Anyway, problem solved. Thanks Frank

Hi I have two tables; 'Menu List - Applicant' and 'App Details'. I'm trying to build a query that searches for a specific Applicant. The Applicant is chosen from a combo box[Appname] on a search form [Searches]. The Combo box has as it's row source SELECT [Menu List - Applicant].App FROM...

Hello, I would like to run a report which will tell me the fees received in 4 weekly periods, starting 01/04/2001. So I would end up with a list like Period 1 - 01/04/2001 to 28/04/2001 : £2m , followed by Period 2 - etc etc. I know how to extract the fee information, but I don't know how best...

Hi, I'm modifying someone else's macro do to what I want. At the moment, the autoexec macro opens and prints report 1, then report 2 and then closes access. I would like to give the user the option of whether to continue with Report 2 or quit. If there are 3 reports, how would I give options...