Search results

Hi all, I am in desperate need for an MS Access 2010 app that would calculate and set an alarm when it is time to take my medication. I am ill, bed ridden with phase 2 emphysema. The pain and/or the meds render my sleep time totally erratic. So by the time Outlook’s reminds me to take the...

Hi All! Been a while; soooo nice to be back! Hope someone as an « easy » solution! Internet search provided, Here is an example of what is needed: In Table A, the field client = Doe, John (no matter how many words, the first name(s) is/are always after the comma followed by a space. I...

Hi all, I have a text box with the following expression: =IIf([ENT_Mailbox]>=0,[ENT_MailboxRate],"") The data is entered as 4.25, 5.0, 6.5 and so on in the ENT_MailboxRate. However, I can't figure out what to put in Format or Decimal Places to the number comes out the way it was...

Hi everyone, I have had this sample database for a while. It is an ".mdb". It allows the user to select the records to be included in a report. I would like it modified so the user could also select the report he would like to print. Right now, somewhere in the event, a report is selected. I...

Hi everyone, I purchased a new computer. I had the same OS installed (Win 7 Pro) and the same MS Office installed (ver 2010) as I had before. When I open any of my databases, I find that the "Customize the Ribbon - New Group" I had created and have been adding to for a long time - is GONE...

Hi all! I have a Unit Inspection form where I would like to facilitate the data entry (many many fields). I would like to have a list - dropdown or individual text boxes at the top of the subform, that would provide the followng choices: To be repaired; To be replaced; To be...

Hi all, I am getting this error : Cannot add record(s); join key of tblOccupancy not in record set. My join key is UnitNum from the tblOccupancy. It is in both the continuous subform as well as in the main form. Also, in both queries of the main form and the subform, I can add records...

Hi, Would like to create tables for Unit (apartments) Inspections data entry – need assistance in creating tables with proper links Each section below is One-to-Many to the section below it… TABLE – Inspection InspectID PK - Autonumber UnitNum Number (PK)...

Hi everyone, Would like your opinion(s)/advice as to when do you decide to save a query for a report vs having the codes saved within the report? It is just when you plan to use that query more than for the one report? Or are there other considerations? Thank you!

Hi All, I am running MS Access 2010. I would like to have a toggle button that selects and deselects a check box field. I have this SQL but it is returning a compile error. Can you please assist? (please provide FULL coding - I did not write this one - I am at a beginner-intermediate...

Hi all! This is a module that creates a query (correct me if I am saying this wrong :(). I would like to modify it to include more fields with some criteria. I have no idea where that would go - obviously I did not write this wonderful module. These are the fields I would like to add and...

Hi all, I need to add coding to an existing event procedure. It should do two things : The event is set in the AfterUpdate of the following: Name: txtMoveOutDate Control Source: tblOccupancy.MoveOutDate If that field is updated, so not null anymore, event should say/do: 1) Set the...

Hi all, I have some coding that needs updating. I did not write the code and cannot perform the two updates required. 1) At the time the code was written the control text box name was status, same as the field name. I would like to change the control text box name to cboStatus for...

Hi everyone, I will attempt to explain this best I can by taking an example other than what I am doing... to simplify my request. Let's say you have a classroom diagram - student seat, windows, blackboard... and so on. It is in the report as a picture. I want to position the name of the...

Hi all ! I think I found the coding I need on this site. But I would not know how to adapt it. I would like an auto text completion combo box that will save NEW data entry so it can be used in the following records. This is what I found. If this coding is correct, can you please identify...

Hi everyone! I have a form: frmUnitUpd with a subform: frmUnitUpd_Parking based on tblParking. In the subform, I have a command button to open a popup form called : frmUnitUpd_ParkingFees, based on tblParkingFees. The Parking and the Parking Fees table are linked by : PkgID which is the...

Hi everyone! I have a form called – UnitUpd. It has two subforms – let’s say A and B I open the form to a specific Unit, let's say Unit 1. Subform A – lists the tenant living in that Unit with contact info, etc. Subform B – among other things, has a combo box where the user selects the...

Hi everyone! I have a continuous subform where users will enter tenant's names along with their Status. The status is selected through a limit-to-list combo box offering a choice of M, O or F. I need to ensure that ONE of the tenants has the status F and no other tenants have it. Other...

Hi everyone, In my data entry Client form, named frmUnitUpd, I have a combo box with the following codes to list all reports in the database that begin with the letters COR. Combo Box: cboReports Row Source Type: Table/Query Row Source: SELECT MSysObjects.Name FROM MsysObjects WHERE...

Hi all! I took this coding off the Internet and it works (along with a module). But I would rather have it into a macro than having to copy/paste into each report where I need it. Please provide detailed explanations as to what is to be selected in the macro drop downs. THANK YOU! Private...