Popup Shows Up Asking For ID

Mar 31, 2015

I am getting 2 problems what I am trying to do is depending on the user logging in I want to open form (Aform) on specific record for that person ID. However where Y=1 I am getting a popup asking for AForm ID and where Y=2 I am getting run time error 3075 Syntax error (missing operator) in query expression.

Code:
Private Sub Command6_Click()
If IsNull(txtUsername) Then
MsgBox "Invalid username"
Exit Sub
End If
If IsNull(txtPassword) Then
MsgBox "Invalid password"

[Code] ......

View Replies


ADVERTISEMENT

Memo Field - Popup That Shows Dates When Changes Made

Apr 7, 2015

I once saw a video online of a Memo field showing the times in which changes had been made to it.

I believe the instructor pressed a few keys when his mouse hovered over the Memo field and a pop-up with dates came up. I do not believe he used VBA.

I have a table linked to a form where I am able to change the values of my "Comments" field in my Source Table. I want to be able to see when changes were made (ie, new comments were added to my "Comments" field).

View 2 Replies View Related

Subform Shows Up SOMETIMES...what Is Up?

Jan 18, 2006

I have 2 cascading combo boxes which control what appears in my subform (AuditYear,Company).

Once I select both, sometimes the subform info shows up and a while later I try again, and it doesn't. Then I try some other AuditYear + Company, then THAT shows up...then I try again, it doesn't.

Any ideas?

View 2 Replies View Related

Navigation Bar Shows Twice

Mar 22, 2006

I just added my third record to my new form and it is gone. However, it shows up in the table. I think it is because there are two record selector bars on my screen. I have two subforms and each one has a record selector bar on them and then there is an additional bar at the bottom that is like for my main form, which is blank. (I don't use the main form. I just have subforms over it.) I think the second record bar is goofing things up? And where is my record I just added. It only shows as two records total. Should I get rid of the subforms record selector bars?

View 1 Replies View Related

Result Set Shows A * As Last Record

Sep 4, 2006

On one of my queries, the dataset is shown with a * as the last record.
There's nothing in it apart from blank data but it is appearing on my forms.
All my other queries do not seem to have this.

Is there a setting to stop these from appearing ?

View 1 Replies View Related

Subform Shows #DELETED

Jun 14, 2005

I have a textbox on a Subform which is updated when a record is double clicked in another Subform. This works fine until i move the mouse over the updated subform. Then the updated entry is replaced with #Deleted. The data is still in the table that gives the subform its value.
Also another form running has the same subform and it and the updated value is shown perfectly in this one.
Anyone know why this may be happening?

View 2 Replies View Related

Box That Shows When A Form Was Last Updated

Aug 19, 2005

I wondering if anyone knows of an automatic way that changes can be tracked on a form.

Ex. The last time a record was updated in that specific form

View 2 Replies View Related

ListBox Shows All Records

Oct 26, 2005

I have a form with a subform which has a listbox on it which lists all the letters sent home to a student. However despite the subform being linked by admission Number the list box is showing all records and not just the ones associated with the student.

I know this is going to be really obvious but please can someone tell me what is wrong?

View 14 Replies View Related

Command Button That Shows A Query

Aug 4, 2005

Hello,
How would I go about in making a command button bring up a report to show a result of items for the end of the month?
For example, when a user clicks on this button it will bring up a report showing all the items that are out of date for the end of the month. I am having problems with the query as for months have different lengths e.g. 28/29/30/31 days. How would I make a query show the end result for each month correct as February if going to be different each time i.e. when it is a leap year. I have got far but having trouble with this part.
Hope you can help.

View 3 Replies View Related

No Selection In Combo Box Shows All Records

Feb 9, 2006

I know this is probably posted in a dozen places, but I don’t think I have the smarts to find stuff with the search.

I use the results of a combo box for the criteria in a saved query. Can anyone tell me how to make it show all the record if no selection is made?

Thanks again Folks,
Joe

View 2 Replies View Related

Need A Query That Shows Only Info With No Duplicates.

Sep 5, 2007

Okay I have a database that stores information on some payments.

Payments can be made on different dates and multiple times during the month.

There is an account number which will have duplicates in the table if there is more than one payment. This is fine.

However, I need a query which will show only those records for account numbers which appear only once.

So if it has duplicates, it is ignored, otherwise it's reported.

TIA for the help.

View 2 Replies View Related

Subform Shows A Number, Not Text...

Dec 8, 2006

It's my understanding of general database practice that an Autonumber field should be used as a primary key in normalisation tables. I realise my understanding could be wrong, and I'm quite happy to change that practice if need be.

I have my normalisation tables. For the most part these consist of an Autonumber field ([UID]) as the primary key, then an indexed, no duplicates text field with the normalisation data. For this case, we'll say it's a list of departments ([DepartmentID]).

I have a form for entering users. Again, the PK is an autonumber field. I used a wizard to create a combo box. I selected the fact that I want to store the value in [DepartmentID], NOT [UID].

This works fine, I can add my users and the combo boxes work, although I had to change the bound column to 2, as 1 is selected by default although it is [UID].

I then created a subform based on a query of all users. This subform is not bound to the main form in any way, it simply shows the result of the query.

When entering users, upon saving a record, the form is updated and the new user shown in the subform. Great, apart from "txtDepartment" in the subform showing [UID], and not [DepartmentID] as stipulated.

I have a horrible feeling this is to do with [UID] being my PK, but I'd like someone to tell me I'm wrong. I can quite happily remove the autonumber field [UID] and make the unique [DepartmentID] field the PK, but this just doesn't seem "correct" to me.

Should I do this? Should I have an autonumber field as the PK?

I realise this is more a design theory question than a form problem as such, but anything that clarifies my understanding of correct design practice will help.

EDIT:- I'd also like to say that I did it this way to get away from using the "LOOKUP" field type at table design time, specifically to avoid this very problem of numbers showing up when I want the text there!

View 3 Replies View Related

Queries :: Shows Time Slots (4) Available In A Row During Day

Sep 20, 2014

I have a mismatch Query that shows time slots available during day that have not been booked (15 minute intervals) the problem I have i want to just show the time slots that are available depending on what treatment has been chosen so if it was a one hour appointment then it checks that 4 slots available in a row and just displays that

Available
11:00
11:15
12:00
12:15
12:30

How I would try to do this
12:45
13:00
13:15
13:30

so would show for a 1 hour appointment
12:00
12:15
12:30

View 8 Replies View Related

Queries :: Recordset Shows Nothing In The Code?

Aug 21, 2013

i have a combo box ,and when i should select "all",this button after update code should show me all the column of table test ,but looks like for no reason the record set shows nothing and its not working.

Code:

Private Sub cboTaskListName_AfterUpdate()
'On Error GoTo cboTaskListName_AfterUpdate_Err
Me.Refresh
Dim db As DAO.Database
Dim SQL As String
Dim rs As DAO.Recordset
If Me.cboTaskListName = "111111" Then
Set db = CurrentDb()
SQL = "SELECT no1 from test"
Set rs = CurrentDb.OpenRecordset(SQL, dbOpenDynaset)
End If
End Sub

View 1 Replies View Related

Forms :: Subform Only Shows First Match

Nov 30, 2013

It's been a while since I last used Access but now I need to be reminded how to populate a sub-form with all rows for a query (Access 2013).

- Do I need to establish a relationship between Table A (main form) and Table B (sub-form)?
- What sub-form properties need to be set to display all retrieived rows from the main form query (select where Table A PK = Table B PK)?

View 1 Replies View Related

Queries :: Query Shows Duplicate

Dec 4, 2014

I hve a query that I want to total soldAtPrice *quantity This information is stored in my order details table and mus not change .I can do a calculated field to get the answer but the Problem is if there are 2 recodrs to be totaled the query displays 2 records if there are 3 records the query dislplays 3 records and so on .I need one record to be displayed with the total of all the recodrs

View 3 Replies View Related

Report That Shows Query Dependencies

Jan 8, 2012

I have a database that reuses many queries in several different macro's. Any way to generate a report, (or purchase an add-in), that will show for each query any other queries that use it. It would be ideal to show all of the "cascading" queries that one query is built on. It just gets confusing when I need to tweak a query to then have to figure out there are other queries that use the one that's being tweaked and the tweak will change the results of the other queries.

View 3 Replies View Related

Query That Shows Records Equalling Different Values

Aug 24, 2006

This is a very quick question. I have a query what i need it to do is show me all values that equal 2 and any records that are blank, this is what the criteria looks like currently

Field: Month([FDate])

Total:Group By

Criteria: Month([DDay1])

Now the way this works is it only shows records where the field meets the criteria, in this case Month([FDate]) = 2

I need the criteria to say if Month([DDay1])=Month([FDate]) Or is equal to "" Then display records.

EDIT: I just found out how to view blank values but what if records for it dont even exist... i still want to show the other fields..

Thanks
Jason

View 1 Replies View Related

Database Window Shows After Printing Form

Feb 16, 2005

Hello team,

My database window is hidden.

I have a form with data about an article. When I click a button, another form opens showing a sales graph of that article.

On the form with the graph, I have put another button to print it. The code behind that button is:

Private Sub printpriceevolution_Click()
On Error GoTo Err_printpriceevolution_Click

Dim stDocName As String
Dim MyForm As Form

stDocName = "frm_priceevolution"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False

Exit_printpriceevolution_Click:
Exit Sub

Err_printpriceevolution_Click:
MsgBox Err.Description
Resume Exit_printpriceevolution_Click

End Sub

The funny thing is that after the printing (which works fine) my database window is shown, where it is supposed to be hidden.

Any idea what could trigger this? Does it have to do with pop-up dialog box settings?

Thanks

View 1 Replies View Related

Combo Shows 0 For Value List Lookup On New Record

Jun 6, 2005

I have a table with some combo selections with row source No;Yes, bound column 1, column count 1, and default value "No", limit to list set to yes, required = yes, allow zero length = no.

When I create a new record though, all of the combos show 0, and I have to select No or Yes manually. The requirement is that No is the default value..

Lots of thanks in advance,

Aidan

View 5 Replies View Related

Button Shows Verify Window Before Update?

May 17, 2006

I would like to have a button on my form that would update a record to a closed status, but I want to have an "Are You Sure?" window pop up first. I did a search on "verify," "verification," "sure," and several others but haven't found what I need. I looked through my Access bible, with no luck.

Any help is GREATLY appreciated. Thanks!

View 3 Replies View Related

Properties Sheet Shows In Form View

Sep 20, 2007

A member of the Access User Group that I am associated with has asked a question that I can't answer.

In older versions of Access, when you went from Form Design View to Form View, if the Properties Sheet had been visible, it would be hidden in Form View. Since probably Access 2000, the Properties Sheet remains visible in Form View (if it was opened in Design View). Not a big problem, you say? Well, it is to this person, who is concerned about her users seeing the Properties Sheet and making changes in it.

Anyone know a way to defeat this behavior and hide the Properties Sheet in Form View?

Thanks.

View 2 Replies View Related

Forms :: Drop Down Shows Both Columns When Selected

Jun 29, 2015

I've got a form with a drop down combo box with two columns. When you hit the down arrow it shows both columns, but when you click a choice, it only shows the data in the first column. How do I make it show both columns after it has been chosen? First col is First Name, second col is Last Name.

View 3 Replies View Related

General :: How To Have A Combo Box That Shows Date And Text

Aug 22, 2012

Is it possible to have a combo box that shows date and text? I would like to have a combo box with dates that also allows the user to choose the word "unassigned." the reason for this is because sometimes we don't know dates due until a future time and that is specifically what my boss wants. They don't want the field empty either.

View 2 Replies View Related

Forms :: Disable Ribbon Randomly Shows Up

Jun 25, 2013

I have disabled the Ribbon using XML code in the USysRibbon table. Everything has worked fine, except that now when I click on two different tabs that exist on my form, the Form Tools Ribbon pops up with options to go to Layout, Design View, etc., and other options, too.

I have two subforms on this tab, but neither one has a Ribbon Name set (I didn't even know how to do that when I made them) where to look to see why this is happening. The Ribbon does not show at all on the other tabs like it is supposed to. It only shows when I click on my 3rd and 4th tabs, and then it disappears again when I click on other tabs.

View 6 Replies View Related

Modules & VBA :: Filter On A Table Shows Up Black

Apr 1, 2014

Ive created a table in Access but when I click on the filter option, it comes out blank.Im using VBA code to populate the table from SQL server.All other column work fine.There is data in that column.

View 2 Replies View Related







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