Search results

Hi, The following control in a report displays the number of people with surnames the same as those who served onboard HMS Victory during the battle of Trafalgar: [In VICTORY.CountOfCountOfSurname] & " " & [surname] & " - in VICTORY." It works fine but if there are no matches, it just...

Thanks mainly to John K I have the following code from a previous post which identifies when a 'Unit' has been entered at 2 different 'JettyNumber' on the same 'StartDate' SELECT Qry_All_Ops.StartDate, Qry_All_Ops.Unit, Count(Qry_All_Ops.Unit) AS CountOfUnit, Sum(Qry_All_Ops.JettyNumber) AS...

The attached file shows a screen shot of my query. I need now to isolate only those results that are not whole numbers. I think it will be MOD or INT but I can't get it to work in the query. Also, do I add this "where expression" to the Result column or do I need to create a new Expr: column ...

I have one table which contains the following fields: StartDate, Unit, Location, Operation. I want to run 2 checks: 1. To show if a Unit is in two different locations on the same day ? Eg. 23 May 07, Ship A, Jetty B, Fuelling 23 May 07, Ship A, Jetty B, Water - Is permitted. 23 May...

I have spent hours trying to sort this via searching here and elsewhere. A button on a diary form sends an email containing the day's events. I have been asked to send the current day and the next day. This has me stumped! Form_OpenDate = Format(Me.Text62, "MM/DD/YYYY") ' Gets the date being...

All, I have a search form (continuous) which filters results from the main table. I can then double click on one of the filtered results to open a new form (single) showing all the fields for that entry. Fine so far. My question - There are ten different types of operation that can be...

I have a database containing shipping details. As part of the error checking system I am trying to write a query that will identify if a ship is incorrectly recorded in two locations on the same day. There are approx 50 ships and 60 locations all entered in one table in the following format...

I am calling a continous form from a combo box on another form. The code below used to warn me that there were no records and shut the form down to avoid showing a blank form. Private Sub Form_Load() If IsNull(Me.TxtUnit) Then MsgBox "There are no operations recorded for this Unit", vbOKOnly...

I have spent most of the day on this and despite searching through the Forum I have not found an answer :( stLinkCriteria1 and stLinkCriteria2 work on their own, but when I try to join them to use both the date and text I get a type mismatch.... stDocName = "Operations_By_Unit" testdate =...

I have recently added a standard access switchboard to my database. Now one of the forms flatly refuses to open from the switchboard giving "No Current Record" error. The form opens fine when opened directly. There must be a conflict between the S/B and the Open Form code but I can't see...

Fellas, This is driving me nuts & despite searching I can't get it. I have very similar code in other forms which updates numbers and text variables to the underlying table but I can't get this one which updates the time (short time) to work. I am pretty sure that it is a formatting issue but...

I have copied some nice code from this site (sorry can't remember who posted it). It moves through records in a continous form, producing a message box that informs you when you are at the begining or end of the records. It works fine going back through the records to the beginning but when...

Openform at specific record (again) - Example added Sorry about this. I know there is loads on here about this but I just can't get it to work. I have a basic table of dates. One form based on the dates via a query When the form opens, I want it to show today's date but allowing access to...

Hi, I am sure this is a simple error but I just can't get it. I want to open a form with information based on today's date. I then want to have the ability to click buttons to advance or retard the date and then show the appropriate data for the new selected date. I thought the best way would...

I am trying to build a form that accepts either a single date for start and stop dates whilst allowing a range of dates to be selected for operations that cover several days. I am using the Access 2003 calendar which is fine for selecting a single date but how do I select several dates (4-7 Mar...

Hi, I am a novice with Access and would like a steer with what I am sure is a simple issue but I can't find an answer. :confused: I currently have 2 queries based on 2 separate tables. Ops_Log_996_Query SELECT [996_Table].Unit, [996_Table].Location, [996_Table].hiredate FROM 996_Table WHERE...