Forms :: On Every 9 Or Monday Of Any Month Form Will Open

Dec 8, 2014

I have 10 forms named

FormA - FormB ------ FormJ

I want to choose the formA and from a combo I want to choose a day so when this day come the chosen form will open automatically in the specified date when I open the database...

For example i choose FormA and for the date i choose 9 or monday

So every 9 of any month the form will open or every monday....

View Replies


ADVERTISEMENT

First Monday And Last Friday Of A Month,Ms Access

Dec 19, 2007

Hi all,
I have some records lying on ms access db, I need to find the first monday and the last friday of the months in db then select and group them .
How will I do that ?

View 5 Replies View Related

Queries :: Access 2010 - Query To Show Data On Every Monday In Current Month

Nov 8, 2013

is their a way to have a query to only show data on every monday in current month.

Month([datefield])=Month(Now()) And DateAdd("d",7,[datefield])

View 11 Replies View Related

Forms :: Getting Monday And Friday Of Current Week On Main Menu?

Jan 3, 2015

For some reason i'm having difficulty getting the Current Monday and Friday of the Current Week on my Main Menu. Monday shows 12/29/2014 ???

Here is the code for the scenario.

Monday: =CDate([AnyDate])-(Weekday(CDate([AnyDate])))-2+4+3-3
Friday: =Date()-(DatePart("w",Date(),2,1)-1)+4

AnyDate: Date()

View 8 Replies View Related

Forms :: Calendar Scrolling Month By Month

Aug 9, 2013

Using Access 2010..I have form with a date on it. For this control I have show date picker set to "For dates" and lo and behold I get calendar! I can scroll through this calendar month by month. Great if I just want to go back or forward a month or three. What I'd like to be able to do is scroll through the calendar year by year. Can I do this with the method I'm using at the moment? If not is there a way round it that isn't over complicated?

View 6 Replies View Related

Forms :: Continuous Form Filter By Month Or Age

Feb 9, 2014

I have a continuous Form named frmBirthdays that lists People with a [DateOfBirth] field.

In the Form Header I have 2 Unbound Combo Boxes 1- cboMonthFilter which list the 12 Months of the year in Text NOT Number and 2- CboAgeFilter that has a list of Ages 0 -30 (which is all i require) and a Clear Filter Command Button.

I would like to be able to filter the people list by cboMonthFilter for anyone that has a Birthday in any given month.

OR

I would also like to filter the people in the list by their age.

But never both at the same time.

View 8 Replies View Related

Forms :: Month Calendar On Main Form?

Jun 11, 2013

I want to display a month calendar on my db's main form.

View 3 Replies View Related

Counting Open Events By Month

Jan 11, 2007

I have a table, part of which includes a [start date] and [end date]. I need to be able to plot a graph that will show, for each month, how many projects were still open. they will at the start of the month have a [start date] but no [end date]. I have created another table that holds the date for the first of every month in the range that I am intrested in. I suspect I need to use a subquery in here somewehre but cant get my brain around it :(

Many thanks

Peter

View 2 Replies View Related

Forms :: When Open A Form / Want To Open Another From At Same

Jan 14, 2015

when i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.

View 2 Replies View Related

Forms :: Display Month View Control On Form?

Mar 6, 2015

I want to display a month view control on one of my forms.

I only want to use it for viewing purposes only. But I don't see the Calendar control or MonthView in Activex list.

Where I might obtain such a month view control?

I'm using Access 2010 and Windows 8.1

View 5 Replies View Related

Modules & VBA :: Open Report - Filter Month And Year

Feb 25, 2015

I have vba code

PHP Code:

    DoCmd.OpenReport "MonthlyData2", acPreview, , " YEAR(CourseDate) = '" & Me.txtCourseDateMonth & "' " 

this works sucessfuly how can I add the following to the code so it filters month and year?

PHP Code:

'" MONTH(CourseDate) = '" & Me.txtCourseDateYear & "' " 

View 5 Replies View Related

Forms :: Entering Values For Multiple People On One Form Based On Month

Jan 31, 2015

I need to enter workload counts for 10 people, and it is done on a monthly basis. So I have a table of Months (Jan-Dec), a table of names, and a joined table with the months, names and a field for the workload counts.

I would like to make a form where I could select the month and all the names show up so I could go and enter the counts for everyone at the same time. I've attached a diagram to show what it would look like

View 3 Replies View Related

Forms :: Button In Form To Open Different Form And Chose A Customer Based On Last Form

Mar 26, 2013

Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.

I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.

View 5 Replies View Related

Forms :: Open Blank Form Based On Value In Text Field In Main Form

Jun 6, 2013

I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,

Table:Restaurant
Restaurant name
Address line 1
Address line 2
Restaurant #
Website

Table:StaffContact
Staff Role
Name
speciality
email
phone

I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.

Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).

Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)

My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has

So i ran a Macro, with open form with Where condition

Code:
[Staffcontact]![Rest Name]=[Forms]![MainForm]![RestaurantName]

But, it does not work .

View 2 Replies View Related

Forms :: Continuous Form With Command Button On Each Record To Open Another Form

Jul 30, 2014

I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.

At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.

continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"

pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"

This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):

1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid

2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid

3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria

4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub

View 9 Replies View Related

Forms :: Navigation Form - BrowseTo Command To Open Up A Form In Built-in Subform Module

May 3, 2013

I'm working on the Navigation Form template in Access 2010, which is new to me. It appears that one needs to use the BrowseTo command to open up a form in the built-in subform module. I'm trying to create a couple of buttons where each button opens a form in a different data mode; one in read-only and one in add mode. Here is the syntax I used for read-only:

DoCmd.BrowseTo acBrowseToForm, "frmSales","frmNavigation.NavigationSubform", , ,acFormReadOnly

frmSales is the Sales form I want both of the buttons to open and frmNavigation is the Navigation form. It seems to be ignoring the data mode part at the end however. It only will open in Edit mode. Is there something I'm doing wrong with this command?

View 3 Replies View Related

Forms :: Double Click Record In One Form To Open New Form?

Jan 27, 2014

I am trying to create a proposal log for my company to make things easier to track. I have made a multiple items form to list the proposals. I want to be able to double click the record to open up another form (that i have already created) that shows the information from the proposal table and the proposal details table. So.....

I want to double click the field named "Proposal Name" and have it open up to form i have called "proposals details form".

View 3 Replies View Related

Forms :: Open New Form With Record Data Sorted From Another Form?

Apr 2, 2014

I have a main form[frmResearchNotes] with combo box controls that filters a query populating [subfrmNotelist] containing several records from the filtered query. From there, I double click on a field within one of the remaining records, [CompanyName] for example, and it opens the new form[frmNoteDetail]. The problem is that second form is not displaying that selected record. The second form's record source has been set to the same query so when it loads, it displays the same info but it's displaying the 1st record out of the entire filtered list, not the record I clicked on in that list.

I figured I could use the strWhere function to copy the record I selected in the event procedure and then open the new form with those details. Not sure how to actually do this with VBA or if it's even the correct approach.

View 14 Replies View Related

Forms :: Open Form Directly Inside Navigation Form?

Oct 28, 2013

I would like to know if it's possible to open an specific subform inside a navigation form using an event.

I also need to to this using macros ( really can't use vba in this project =/)

Form example:

the main form has "nav_opt1", "nav_opt2", "nav_opt3"

By double clicking a record in "nav_opt1", it will open "nav_opt2" with some filters (but all in the same window), as if I was just browsing through the navigation forms usually.

View 1 Replies View Related

Forms :: Open Second Form On Related Field From First Form?

Aug 22, 2013

how to write code to open a second form on the click of a button on the first form and specifically to continue on the record set I am focusing on.

I have 2 tables. The first is tblAccount (fields: AccountID [the PK]; AccountHolder) and the 2nd is tblUser (fields: UserID [the PK]; UserName; AccountID). They are linked so that one account can have multiple users. Each has a respective form; frmAccount and frmUser.

My goal is that once the AccountHolder field has been populated in frmAccount I can click a button to open frmUser with the AccountID field already showing in the form header.

I have managed to do something similar by selecting from a combo box before but I am having trouble making this work after directly populating the AccountHolder field and using an open Form button.

View 2 Replies View Related

Forms :: Open A Form Based On Current Form?

Nov 23, 2014

When I have a form called "SiteForm" open and click a button "NewCalloutButton" I would like it to open up a form called "CalloutFormEntry"

I've done this using

Private Sub cmdOpenDetail_Click()
DoCmd.OpenForm "CalloutFormEntry", , , "CalloutID = " & Me!CalloutID
End Sub

However this brings up all the records linked to the calloutID

What I'm after is to open the CalloutFormEntry from the SiteForm in a dataentry kind of format but to carry over the current SiteID based on which site is open on the SiteForm. That way there's no user error logging callouts to incorrect sites.

View 9 Replies View Related

Forms :: Open A Form With Subform From Separate Form

Oct 23, 2014

I'm trying to open a form with a subform from a separate form. I've never had any issue before, but all of the sudden, the subform doesn't seem to open immediately. I get the error

Code:
Method 'Form' of object '_SubForm' failed.

After that, it opens (subform and all), but some calculated text fields just say "#Name?#"
The only thing I did today was add a command button to that subform.

When I try opening the form (or subform) from the navigation pane, I get

Code:
The expression On Current you entered as the event property setting produced the following error:

A problem occurred while Contracts was communicating with the OLE server or ActiveX Control

When I step through the code, it doesn't reach the On Current event.

View 5 Replies View Related

Forms :: Open A Form With Previous Forms ID

Sep 17, 2014

I am trying to have cascading forms running on my database. The first form adds a new staff member. When you press the next button this happens...

Private Sub Command12_Click()
DoCmd.Close
DoCmd.OpenForm "Frm2"
End Sub

But I want it to open Frm2 using the ID from the previous form. The stumbling block for me is I close the first form before opening the next so I cant pass the ID across.

View 2 Replies View Related

Forms Open In The Middle Of The Form

Dec 21, 2006

I have several forms that open in the middle of the form instead of at the top in the first field. Any ideas to correct this problem?

View 2 Replies View Related

Forms :: Option To Open One Or Other Form?

Dec 24, 2014

how to give the option to open either forma or formb with a command button.

View 1 Replies View Related

Forms :: Open Form From Combo Box

Jun 3, 2014

Im using the below code to open a from depending on what option is selected on a combobox.

Code:

Private Sub DirectPCombo_Click()
Dim cboVal As String
Dim stDocName As String
cboVal = Me.DirectPCombo.Value
Select Case cboVal
Case "One"

[code]....

If you select the first item [One] it will open the correct form [TestOne]. But when you select any of the others an error comes up saying that the name is no a form. So I added

Code:
DoCmd.OpenReport stDocName

But the no items would select.I know If split the reports form the forms and make two comboboxes it would work, but it would be better it both could be in the same combobox.

View 2 Replies View Related







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