General :: Manipulating Dates Within A Form

Mar 2, 2013

I've been tasked to create a company client record database which permits several people at once to access and modify a communal database of clients. So far, so good. It's for a firm of solicitors, so I'd better get it RIGHT!!

One field requires the entry of a date, which the next field is supposed to automatically subtract 180 days from.

Is it possible for me to do this within the one entry form? The way I see it is that the first date would be entered, then the form would automatically display the -180 days result in the next box.

View Replies


ADVERTISEMENT

Manipulating List From Another Form

Nov 19, 2013

I have a button in formA. When I click on it I want it to show the listB.

(To show it I used the event code: ListB.Visible = True)

The thing is, listB is in formB (which is a subform of formA).

Code isn't working because listB doesn't exist in formA, got an error code.

I tried [Form]![FormB].ListB.Visible = True

But it didn't work, I don't think I can do this in an event code.

View 9 Replies View Related

Forms :: Continuous Forms - Looping Through Records / Manipulating Fields On Form

May 29, 2015

I have a bound continuous tabular form,However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown below, and I am looping through each record. To show that my code is referring to the field with required data content, I display it as a message box and it works, yet my checkbox does not enable.

I have the code in the form_load event, however, for testing purposes I have it behind a button.If I am seeing this properly, the code behind the button enables the checkbox for ALL records once the criteria in the required field is true, and based on the last record, which has no data content, it disables the checkbox in ALL records. I also have the PK ID for each record hidden in the form. Can I utilize that to target the checkbox of each individual record??

Form Detail
-Form does not allow additions or deletions. Edits allowed
-All fields are disabled and locked
-I only want the check box to unlock if data is found in the "RequiredField" as referred to below. I have also tried if not isNull(requiredfield.value) then -enable checkbox, which yields the same results

Here is my code

Code:

Dim rstMyForm As DAO.Recordset
Set rstMyForm = Forms!MyForm.Form.Recordset
rstMyForm.MoveFirst
Do While Not rstMyForm.EOF
If Not RequiredField.Value = "" Then

[code]...

View 14 Replies View Related

Manipulating Calculated Fields

May 18, 2005

I developed a query that calulates when a contract is reviewed i.e 5 weeks and 9 weeks after the commencement date. These are called CDE1 and CDE2. This works well and the CDE1 and CDE2 dates are displayed ok.

The query above is:
SELECT Contract.ContractNo, Contract.APSNo, Contract.Firstname, Contract.Surname, Contract.AgencyDesc, Contract.FacilityName, Contract.Designation, Contract.WeeklyHrs, Contract.PositionNo, Contract.ComDate, Contract.EndDate, IIf(DateAdd("ww",5,[comdate])<[enddate],DateAdd("ww",5,[comdate])) AS 1stCDE, IIf(DateAdd("ww",9,[comdate])<[enddate],DateAdd("ww",9,[comdate])) AS 2ndCDE
FROM Contract;

The problem is that I now want to access contracts under these CDE dates between two dates that is user defined (startdate) and (enddate).

As the above are calculated fields, how can I develop a new query based on the above as CDE1 and CDE2 are already calculated fields?

View 2 Replies View Related

Manipulating ListWidth Problem

Sep 8, 2005

Hi all,

I have a problem manipulating the list width of a combobox. Now i set the list width property on the toolbar, as larger then the combobox for instance listwidth = 18.5cm while the combobox is about 10cm. Now i have a combobox that when clicked changes the property of the listwidth back to the size of the combobox. If the user clicks the combobox again it should return to 18.5cm but it does not seem to want to change back, even though all the other property changes work.


Here is my code:
Code:If label1.Visible = True Then Me.label1.Visible = False Me.label2.Visible = True If Me.label1.Visible = False Then Me.Combo.ColumnCount = 1 Me.Combo.ColumnHeads = False Me.Combo.ListWidth = 10 If label1.Visible = False Then Me.label1.Visible = True Me.label2.Visible = False If Me.label1.Visible = True Then Me.Combo.ListWidth = 18.503 'this does not work Me.Combo.ColumnCount = 10 Me.Combo.ColumnHeads = True End If End If End Ifend if

Where if label1.visible = true then listwidth = 18.5 else label2.visible = true listwidth = 10.

Thanks in advance for any help

M-.

View 4 Replies View Related

Manipulating Table Data From Code

Feb 12, 2005

I’m working on an Access 2002 project where I need some help with coding. I’m a neebie to Access and Visual basic so a few pointers to get me on my way would be much appreciated.

The project is dealing with logging vehicles on and off site. I have one database that contains a list of all regular traffic in three fields – Registration Number, Company Name and Type. After the last update this contained about 300 records. I called this MAINDATABASE.mdb.

I have another database that runs as a user input screen and front end called WORK.mdb. This contains the above three fields and three others, Time In, Number of Occupants and Time Out.

I have already done the coding for Time In and Time Out where the user just double clicks the field and the system time is entered. The important field is Registration Number. What I need is the following:

When a vehicle comes on site the user double-clicks Time In on the form which inserts the present time (done). The user then tabs to or clicks on Registration Number. An input box comes up where the user types the reg number. I need the code to take this input, search the MAINDATABASE database and if the reg number is found return the values for Registration Number,Company Name and Type in that row of the database and then insert those values into the corresponding rows in the WORK database. If the reg number isn’t found then a message box comes up telling the user to enter details manually and input the string entered by the user into Registration Number field on the WORK database and leave the user to enter the values for Company Name and Type. I have the code for the Input Box and the Message Box at the end!:


Private Sub REGISTRATION_GotFocus()

InputBox("Enter Reg number...")
……..

MsgBox "Registration number not found. Please enter details manually"

End Sub


I just need the stuff to do the work in between!!
Any pointers are very welcome……

View 4 Replies View Related

General :: DAVG Between Dates

Nov 16, 2012

I'm using DAVG to look up average days in a query. All works fine but I'd like additional functionality. Here's what I have so far:

Code:
=DAvg("[kitted2completed]","KittedComp")

What I would like is the above to return an average based on dates from and to in column "Comp".I might want only data with a value between now() and 14 days ago. (ie jobs completed in the last two weeks)

View 2 Replies View Related

General :: Conditional Formatting Dates

Oct 29, 2013

I am trying to get my expiration date field to highlight a certain color once the date comes closer.I have weapons qualification dates. The user will input the date he/she qualified and then a expiration date (6 months from that day) automatically pops up.

Now what I want to do is once the expiration dates gets closer is change the color. So when it is 90 days from expiration it would highlight yellow, and when its 30 days away it would highlight red. I believe this can all be done through conditional formatting, but for the life of me I cant figure it out!!

View 5 Replies View Related

General :: Converting Strings To Dates?

Sep 18, 2014

I am trying to manipulate some Ebay data, which returns a string like "1d 00h 29m"

Is there a function I can use to convert this string to relevant hours in total?

View 14 Replies View Related

General :: Creating Pop Up Based On Conflicting Dates

Nov 12, 2014

- I currently have a table that is labeled WorkSchedule. I then Created a query called WorkSchedule Query.

- The column labels are as follows (listed from right to left): Project, Event (something inside of the project), Employee1, Employee2, StartDate, EndDate

- I created a split form that shows each record.

- On each record I made the employee1, and employee2 as a drop down box that allows you to pick from all employees.

*MY QUESTION*

How do I make a pop up form appear when there is a conflicting date based on the employee I picked?

For example: If I had assigned Rebecca to an event that went on from 11/12/2014 - 11/14/2014. Then I tried to assign her to another event from 11/13/2104-11/15/2014. I want a pop up message saying that these dates conflict.

View 2 Replies View Related

General :: Arrays - Sequential Dates Onto A Calendar

Aug 28, 2012

Are there no arrays in Access? I am looking for a way to put sequential dates onto a calendar. An array would work fine, with an offset for Weekday(FirstDayOfMonth).

View 1 Replies View Related

General :: Dates As Text From Archival Database

Jan 8, 2014

I'm bringing an archived db into Access, with entry forms to continue on into the future for maintenance. In the past, some dates were recorded only to year (yyyy). Obviously, I won't continue that, but I need to integrate the old and new in a fashion that will sort. For instance, one form has a subform section based on a report to show the old entries, while below are unbounded text fields for making new entries (with a Save command button).

How to integrate partial old text dates with newly recorded dates.

View 3 Replies View Related

General :: Linking A Set Of Dates For A Time Sheet

Jul 17, 2013

The project I am currently working on requires me to build a database for checking off if a certain person has submitted a time sheet for a certain date. I have a table for the dates that has the fields "date" and "Submitted time sheet?". The time sheet field is a checkbox.

I also have a table for employees with fields "employee last name", "employee first name" and "location".What I want to know is how to link each employee with the dates and whether or not they submitted a time sheet.

View 4 Replies View Related

General :: Sending Auto Alert On Certain Dates

Jul 16, 2014

Any way to send auto alert without opening Ms. Access program.

I have created a program which requires to send auto alert on certain dates. Due to some travel plans manager might not be able to open the program every day (might not open the program on certain dates where I set the alerts) and the chances are he will miss those alerts if he won't open the program.

View 2 Replies View Related

General :: Outlook Event Based On Query Dates

Dec 2, 2014

I have a query that has some reminder dates. 10 days before an event and 5 days after. I was wondering if it would be feasible to create an outlook reminder based on the query and if so how would I go about it?

View 1 Replies View Related

General :: Query To Calculate Points Based On Dates

Jul 1, 2015

I am trying to create an attendance database, our company introducing the point system attendance,

Called Off (CO) 2 points
Left Early (LE) 1 Point
Tardy (Tar) 1 point

Employee can reduce point if they have perfect attendance for 90 days from the last day of violation. For example, an employee absent on 01/01/2015, he will received 2 points, the credit will giving on 04/01/2015, if there is no violation, but if he absent again on 03/31/2015 not only he will received 2 more points his 90 days will start from 03/31/2015, now he will eligible to get credit on 06/29/2015 and so on.So far I have created 3 tables and 1 query.

Tables

Employees: Id, Last Name, First Name
Points: Id, Description Points
Attendance:Id, Date, Employee ID, Points ID

Query
Date
Employee ID
Last Name
First Name
Point Description
Points

how and which formula to use which calculate the points based on above example.

View 14 Replies View Related

General :: Set Up Conditional Format To Highlight Any Dates Within January Red

Jun 17, 2015

I have a report and i'm trying to set up the conditional format to highlight any dates within January red.

View 1 Replies View Related

General :: Entries With Dates - Track Price Changes On Items

Oct 21, 2013

Im trying to create a database so I can Monitor grocery items from different supermarkets in my area.

I have been doing this on Excel for a while now, and its time to do it properly.

The only issue I would have is when I enter data.

I want to be able to track the price changes on items. I have my own.

So for example. Each time i enter the price of an item, I want a time stamp with it. (being the date when i entered the item, should be automatic).

View 4 Replies View Related

General :: Concatenate - Combine Dates Into One Cell To Have One Row Of Order Data

Feb 25, 2013

I have 2 gig of order data which has duplicates due to different invoice dates. How can I combine the dates into one cell so I only had one row of Order data.

i.e. order number, price, order date, invoice date

same order number, same price, same order date, different invoice date.

How do I combine the second line with the first so that I only have the data once.

View 10 Replies View Related

General :: How To Implement Query Into Table To Prevent Overlapping Dates

Jun 30, 2014

I'm creating an equipment hire database, and I was wondering how I would not permit overlaps of equipment hire ie. equipment being borrowed before it is returned. I have a query that lists all bookings that overlap, but I am unsure of how to implement this into the table to prevent overlaps.

The SQL for the query is as follows:

SELECT Bookings.[Booking ID], Bookings.[Instrument ID], Bookings.[Borrow Date], Bookings.[Return Date], Bookings_1.[Booking ID], Bookings_1.[Instrument ID], Bookings_1.[Borrow Date], Bookings_1.[Return Date], ([Bookings_1].[Borrow Date]>[Bookings].[Return Date]) Or ([Bookings_1].[Return Date]<[Bookings].[Borrow Date]) Or ([Bookings].[Instrument ID]<>[Bookings_1].[Instrument ID]) Or ([Bookings].[Booking ID]=[Bookings_1].[Booking ID])

[Code]...

View 7 Replies View Related

General :: Display Previous Dates In Field And Also Introduce A Date Picker

Aug 24, 2012

I have managed to develop a database for my small business and am feeling very proud of myself. However, on fine tuning I would like to introduce a Date Picker for ease of use. I have a Check in Date and a Check out Date. At the moment they are working perfectly using the Date/Time field. I want to change that field to a datepicker. I have found out how to insert the date picker and it works great when inserted on a new record BUT all the previous dates in the database change to the current date. Is there a way I can still display the previous dates in the field and also introduce a date picker?

View 3 Replies View Related

General :: Syncing Table Holding Reservation Dates To MS Outlook Calendar Automatically

Oct 10, 2014

I have been looking for a way to sync a table holding reservation dates to MS outlook calendar automatically when dates are inserted in the table.

View 2 Replies View Related

Forms :: Dates As Column Headers To Update Table With Dates As Rows

May 12, 2014

Any way to have a form with Dates as column headers to update a table where the dates are stored in rows???

The table set up is like this:
tblOpHdr
DiaryID (PK) - OpDate (Date)

tblOpDetail
DiaryID (FK) - CostCode - MachineNumber - MachineHours - etc

I'm just wondering if there's any way I can do this with a datasheet or a crosstab type setup?

It's Access 2010.

View 1 Replies View Related

Queries :: Calculate Expiry Dates Of Training Courses - Due Dates Not Shown

Aug 28, 2013

I have built a query to calculate the expiry dates of training courses but I am trying to input a criteria so that only dates within 90 days of todays date show. I am using Date()<90 but it doesn't return the correct information. What the criteria should be for this?

View 1 Replies View Related

Queries :: Access 2007 - Select All Dates Between Two Dates?

Apr 9, 2015

I have a table of records, which has within it two date fields (effectively, a 'start' and 'end' date for that particular record)

I now need to create a query to perform a calculation for each date between the 'start' date and the 'end' date

So the first step (as I see it anyway) is to try to create a query which will give me each date between the two reference dates, in the hope that I can then JOIN that onto another query to perform the necessary calculation for each of the returned dates.

Is there a way to do this?

So basically, if for a particular record, the 'start' date is 01-Apr-2015 and the 'end' date is 09-Apr-2015, can I produce a dataset of 9 records as follows :01-Apr-2015

02-Apr-2015
03-Apr-2015
04-Apr-2015
05-Apr-2015
06-Apr-2015
07-Apr-2015
08-Apr-2015
09-Apr-2015

(The *obvious* solution would be to create a separate table of dates, from which I could just SELECT DISTINCT <Date> Between #04/01/2015# And #04/09/2015# - but that seems like a dreadful waste of space, if that table is only required to generate the above? And it would have to cover all possible options; so it would either have to be massive, and contain every possible date - ever! - or maintained, adding new dates as necessary when they are required. Seems horribly inefficient!)

Is it possible to just select each date between the two reference dates? Or can you only query something which exists somewhere in a table?

View 4 Replies View Related

In A Form, Some Dates Work, Some Don't

Jun 27, 2006

I've got a form with several date fields (in Medium date format), with each field bound to fields in a table, where also the dates are in medium format.

I also have the form set up where I can enter dates manually, or I can double-click and pick dates from a calendar form, or I can click on an icon and pick dates from the calendar form. Each date goes through the same bunch of processes (i.e., queries and code).

My problem: Some dates work, and some dates don't. On some date fields, I can key in a date, exit the form, re-open the form, and my dates show up (since they were processed into my table.) However, some other date fields do not get processed! I enter dates into these fields, exit the form, re-open the form, and there are no dates!!

I have checked all fields in my table..... they are all date fields, of medium date format. Same for my form.

Why would some dates work just fine while others don't work? If anyone has some suggestions I could try, I would be grateful. What might I look at in my application?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved