Search results for query: *

Hi, I am trying to get a row number for each record in a group using MD_ID and CreateDate (date/time). For some MD_ID groups it works and others it does not. Can anyone tell me what I am doing wrong? Thanks in advance! SELECT A.MD_ID, A.CreateDate, Count(*) AS [DefCt] FROM tblAll AS A INNER...

(Acess 97) I am having trouble recalculating and updating census records based on changing values. Census is determined by Date, Unit, Admits, Discharges, etc. Everyday you have a BeginCensus and EndCensus total (adding and subtracting the admits and discharges) for each day, by unit. The...

I have a form that I set the OnClick event to the following: Private Sub Form_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmmainform" stLinkCriteria = "[ReqID]=" & Me![ReqID] '[ReqID] actually refers to a field name in the...

The main form is patient admission info and the subform tracks ventilator data. Two date fields, [DateOnVent] and [DateWean], contain one ventilator record. However, when/if the patient returns to vent support I need to calculate days weaned (date returning to vent support [DateOnVent]new vent...

I would like to create a form or template for users to add up to four images (separate frames), picture set to zoom or stretch to fit within size (frame size)I determine. It has to be in Word as people at sister facilities would be unlikely to have MS Access, which is where i would like to...

I know you can change the backcolor of a field on the Got Focus event, but is there a way to change the backcolor when any field on a form (or database) has the focus that does not include code on the Got Focus (13434879-yellow) AND Lost Focus (16777215-back to white) events? .....thanks!

How can I display more than one picture linked to a unique ID for a record with either more than one image control or advancing through a single image control with navigation buttons? Since a saved image file cannot have the same name I am not sure how to proceed. I even tried using wildcard...

I used the below example and it works, but if a record does not have a picture on file to load, the last picture remains in the image control. How can I make this control not visible if there is no image file matching the unique ID requested? It only changes when there is a different picture...

I am trying to insert images into a bound image control and all I get is an icon, with the file name; display as icon is not selected. I have read other threads on the same problem.....anyone know how I can make what should be a simple task (I have spent an unGodly amount of time on it) simple...

I am running an SQL statement on the OnClick event of a button to first restrict the recordset by selected dates then open reports based on the recordset. Everything works great except..... How can I ask the user for date parameters within that recordset? For example, [PMdue]Between [Enter a...

Work Order#s are determined by the two-digit month, two-digit year and an incrementing number (based on the number of repairs for that month). For example, the first repair for this month would be 03021, then 03022, 03023, 03024, etc.(allowing at a glance guesstimate of month/year and placement...

Please Help!!! I need to find/print monthly Preventative Maintenance Reports for equipment where the report name is the same as a field from a query [ProcedureName] and [datedue]. My problem is that each checklist (report) is different and is determined by EquipType + ModelName=[ProceureName]...