Microsoft Access Forums

Command button "Detail for specific entry"

Daimios — Sat, 25 May 2013 16:46:16 GMT

Hi everyone,

I'm new at Access and currently try to basically create a form that will display all my entries, but with a button next to each entry that will open a "detail" form for this specific one.

I have placed a button with the action "OpenForm" but it keeps opening the details for all entries on the same screen, I don't find the switch to make sure it displays only the details to the entry to which it is related.

Could anyone help ? That'd be highly appreciated ;)

Thanks !

database

yiega — Sat, 25 May 2013 16:01:24 GMT

hi guys,i have an access 2007 problem that i need help with...i am making a school database and i have reached a wall,okay heres the scenario.this school rewards the best performing students at the end of every term. The top 3 students in each class are awarded book vouchers whose values are as shown.on the tabel below.
i have a table with student details, a table with the schools "form" and an already calculated table of students marks,and average scores.so my question is,how do i make access to choose only the top 3 best performing students in each "form" and award them correctly with the book vouchers..plz help

class	postion 1	postion 2	postion 3
Form 1	1,100	900	600
Form 2	1,300	1000	700
Form 3	1,600	1,200	800
Form 4	2,000	1,500	1,000

[Solved] Problem with tab key on last control on a form page

akotronis — Sat, 25 May 2013 12:24:26 GMT

Hello everybody.

I have made a form for data entry which has some pages. A next page button is the last control on each page and a go to next page command is triggered on click event (which has been entered using vba) and it works fine. Now the bad thing is:

If the user hits tab or enter when the next page button is on focus, he/she goes to the next record which is something I don't want, as he/she may not realize it and continue entering values as if he/she was in the previous record.

I tried entering on key press event for the next page buttons

Code:

If KeyCode = 9 Then PageWhatever.SetFocus End If

but it just ignores it... Any ideas on why this may happen?

Thanks in advance

button for youtube in access 2003

chezster1234 — Sat, 25 May 2013 09:20:56 GMT

Hi there I am a newby, and I have been asked by my manager to create a database for LP's (ancient i know). what i am trying to do is cretae a button that will take data out of A and B text box and put this in the youtube search bar and search automaticly. i am not sure if this can be done but would appreciate any help on this issue.

Thanks

James

how to display the last order date

JRCharlie — Sat, 25 May 2013 06:42:33 GMT

Hi all I have a customer table with an address Column and an Order table with a OrderDate column .
I would like to create a Query that would display the customer address and only the Last order made.
So far I was only able to display the address and and all the Order dates

Grouping Query getting multiple rows in access with vb6

sathyguy — Sat, 25 May 2013 05:53:40 GMT

friends...

can anybody check this query and tell me where i am making mistake...i have to get a single row for each record...but i am getting mutiple rows...this is ms-access query with vb6 as front end.

Code:

"select [stdentry.sno],[stdentry.branch],[stdentry.stdname],[stdentry.amtobepaid]," _

& "iif([feesdetail.paytype]='DD',sum([feesdetail.paidamt]),0) as totpaid," _

& "iif([feesdetail.paytype]='CASH',sum([feesdetail.paidamt]),0) as totpaid1 " _

& "from stdentry,feesdetail where " _

& "([feesdetail.delstat]='N') and [stdentry.sno]=[feesdetail.sno] and [stdentry.refundstat]='N' " _

& "group by [stdentry.sno],[stdentry.branch],[stdentry.stdname],[stdentry.amtobepaid],[feesdetail.paytype]"

thanks and waiting for somebody's help.

Query records where date/time field value is close or equal

Bdowns — Sat, 25 May 2013 01:37:56 GMT

Table A has a Date/Time field and a field with a bunch of measurements. Table B has a Date/Time field and bunch of other miscellaneous fields. I want to create a query that includes the measurement values from Table A where the Date/Time field is closest to that of Table B, but not greater. Also, sometimes the values are equal and I want those measurement values too. Any ideas?

Print Preview Pages

ripwest — Sat, 25 May 2013 01:05:03 GMT

Using Access 7. When generating a report and reading it in Print Preview, I can only see the first page of 3, and can't find a way to see the other two pages in print preview mode. This happens when I run the report or generate it using embedded macro.

Create month end date, from Month(Numberic) and Year(Numeric)

mike02 — Sat, 25 May 2013 00:06:43 GMT

Hey,

I have a crosstab query which sets up the Year (yyyy) and Month(mm) and i need it to create the month end date. What i have done is create a regular query and am trying to find an expression i can use to put the dates together and make it month end. I have used the date Part formula before but never had to go in this order, any ideas? cheers,

I inserted a new field and seems not linked to next number.

leexiuxi — Fri, 24 May 2013 22:14:55 GMT

Hi,
I am currently creating data set for survey entry.
One filed, which asking about year of born, got a problem.
Initially, I set the data type as Date/Time, but found that this type was not I wanted.
So, I changed to "Number" and set validation rule as "between 1900 and 2000".
After this, when I tried in forms, it automatically showed "1905" whatever year I entered.

I gave up to fix this problem and just deleted this row and inserted new row and also made new rule.
The other problem showed up which is that this field was no more connected to next number.
If I hit the enter in Year of born field, rather than move to next number, the page moved to next page.
I assume that the new inserted row is not connected to next number, but not sure how should I fix it.

So, I have two problems..
It would be great if any of these two problems can be solved.

Thanks!!

School Project

stuarthodgsun — Fri, 24 May 2013 21:28:59 GMT

Hello Friend

I am working on my school project and have to make a simple student information entry with school fee submission & Inventory bill that also holds stock information and so i have made a database using Access 2007 But there are alot of issue i am facing for example in the add student information form i am unable to do all the entries and i made serch button on the top ehich is not working properly so i have to hide it but that not it the contact detailas cannot be sved as well every thing got messed up so please help me with my project i am attaching the sample which i have downloaded from net and made few chanes in it but it still n working.I am attaching the file. My School - Copy (2).zip

Attached Files

My School - Copy (2).zip (1.50 MB)

Add AutoNumber Column to Query

badgerman — Fri, 24 May 2013 20:09:59 GMT

I'm just looking for a way to add an additional column to a select query that will just be autonumbered down all the way to the bottom of the data. How can I accomplish this?

Access Query Question

juanmatos — Fri, 24 May 2013 19:48:52 GMT

Good afternoon everyone.

I'm sooo stuck here at my new job and I hope somone here can help me. I have a report to do in Crystal off of an Access 2010 database and the requirement seems impossible. I need to be able to prompt for a quarter and return the output. We don't store quarters such as 1,2,3,4. Instead we store periods which are really months. So we store 1,2,3....12. I've tried just about every possible angle in CR and I just simply need to try a different approach. What I want to try now is a query that somehow brings back just the periods I need. Is this possible? Suppose I have a table named invhdr and it has fields InvNum, billname, invPer, InvYr. InvPer is the periods column. I would have to join this table to the invDetail table on invNum. Any chance someone can help me with this?

Exporting Query with rtf Fields to Excel

EddieN1 — Fri, 24 May 2013 19:22:41 GMT

I want to export a query that contains fields with rtf data, such as...

this is some text

which is interpreted as... this is some text

and have it appear as rtf data in Excel. Any ideas? Thanks, Eddie

Run-Time Error 2450

dascoli — Fri, 24 May 2013 19:21:06 GMT

I'm sure this has been hashed out many times, but I cannot figure out a solution that works for my DB. I am seriously new to coding VBA and have implemented the security features found in this tutorial: http://www.accesssecurityblog.com/po...ccess-VBA.aspx.

I have disabled the Navigation Pane, Ribbon, etc. so that way the database is only able to be edited by holding Shift and opening the DB.

The problem only exists when I open the DB like a user would.

The problem comes when I try to exit the DB with the frmMainMenu still open. If I close this form (via a command button) prior to closing the DB I don't get the 2450 error. If I close the DB while the frmMainMenu is still open I get the 2450 error.

The error states that:

Code:

"[The DB] cannot find the referenced form 'frmLogin'.

The above guide had me hide frmLogin, but not close it, so as to maintain the user-level security to be referenced by VBA code in other forms.
This is the code that was used in frmLogin to manage the security:

Code:

Private Sub txtPassword_AfterUpdate()



'Check that a user is selected

If IsNull(Me.cboUser) Then

    'If no user is selected, display message box

    MsgBox "Please select a user before entering a password.", vbCritical

    'Move cursor into USER field

    Me.cboUser.SetFocus

Else

    'Check for correct password

    If Me.txtPassword = Me.cboUser.Column(2) Then

        'Check if password needs to be reset

        If Me.cboUser.Column(3) = True Then

            DoCmd.OpenForm "frmPasswordChange", , , "[UserID] = " & Me.cboUser

        End If

        'Open MAIN MENU if PASSWORD is correct

        DoCmd.OpenForm "frmMainMenu"

        'Hide LOGIN form

        Me.Visible = False

    Else

        'Upon incorrect password, display message box

        MsgBox "Incorrect password. Please try again.", vbCritical

        'Empty PASSWORD field for re-entry

        Me.txtPassword = Null

        'Move cursor to the PASSWORD field

        Me.txtPassword.SetFocus

    End If

End If

End Sub

The code in red is where I hide the form.

I don't know what the problem is since the form is still technically open (just hidden). I have tried a couple of different approaches to solving this, but none have been successful.

I would love a solution where I don't have to remove the application close button (big 'X'). That is a lot more coding than I would like to do. ;)

Thanks for any help you guys are able to provide!