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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
