I saved my form with a particular name and I have used that name all throughout my code and it still works fine. But when I open that form, the name I see on the top of the form is not that name at all. It's actually some value I gave a combo box a while ago.
View RepliesI have a form which displays an incorrect form name in the header/tab when in form view - its always correct in design view. Somehow it chooses to display the name of another form I have in the database. I have tried saving the form to a new name, this does not solve it. I have also tried saving the other form from which the name seems to have been borrowed, but this makes no difference. Incidentally, now matter what names I give the two forms, the original (incorrect) form name persists. I have tried compact and repair and vba debug. No effect.
View 1 Replies View Relatedi want to make it equal to my forms adjusted width but i don't know how to do that. Also i thought it would look like a form enwrapped within a rectangle or a square yet its gluded onto Access with no border
View 2 Replies View RelatedI have a series of forms that become current in a certain order. For example a menu form comes up. This is followed by a search form where the user gives search parameters. Then appears the results list. If the user wants a detail form comes after that, etc. Now when the user closes the last form I want the form before that one to show up and when he closes that one the one before that and so on. That is I am going to use the close button to go back to the previous step. How can I do this.
View 5 Replies View RelatedI have an Assess 2007 database with a user table. This table holds database user names and user passwords an entry permission to the database. I also have a welcome form that activates when user enters the database using either of the user names and user password in the user table. Now, I would like to display the database user name (NOT THE SYSTEM USER NAME] on the welcome form of the user that enters the database.
View 14 Replies View RelatedI've added a label and field to a page on an existing form. However these are now also displayed on other pages on the same form.
View 1 Replies View RelatedI have a spreadsheet that my company uses that has about 20 clients presented in a single sheet in Excel so I was wondering if it was possible to display only a selected range (i.e. only one client) in a specific form in Access to cleanse this up a bit.
View 2 Replies View RelatedI am looking for displaying the totals from a query onto a form.
I have a query which has a total line showing a count of the number of entry's in each column. I would like to be able to display these totals on one of my forms in text boxes (or any other way). Is this possible and if so how do I do it ?
I've created a button on my ACCESS 2010 form that will send a PDF via email. However I only need to send the single record displayed on the form not all records.
The on click command of the button sends the PDF of the report. (I read that this is what should be sent; but still get the same results.)
I don't understand how and where to attach VBA code:
Me.Filter = "RequestsID=" & Forms![OD Reversal Requests]![RequestsID]
Me.FilterOn = True
I have a table that holds the SQL texts for ca. 1000 Select queries (mostly minor variants that are used to programmatically swap out RowSource strings for combo boxes). I'd like to have a quick and easy way to open/review/modify these queries.
One strategy would be to display the SQL strings in a field on a Datasheet form, then use an onClick event on a text box linked to the SQL-holding field (or perhaps an onClick event tied to an unbound text box on the form) to open the associated query. That would allow me to view the SQL of the query that I want to open, allow me to quickly scroll through the list of stored SQL texts, and give me options for sorting or limiting the SQL-texts displayed in the datasheet form.
But, I can't seem to get the onClick event to work. The problem seems to be that I can't figure out how to pass the SQL string contained in the field to a function that will use that string to open the query .
I wish to change the backcolor of a field on a current record being dispalyed in a 'multiple items' form. However when using me.A.backcolor = makes refrence to all fields called A on the 'multiple items' form and therefore all fields change colour not just the current record.
View 2 Replies View RelatedI am trying to sum a column on a subform named Cost of New if another column named Final = any of the values listed in my code. However, it is summing the Cost of New column regardless of the values of Final. It is summing for all values.What do I need to modify to make this correct or should I do it another way?
=IIf([Final]="RPR-RPR & RTN" Or [Final]="NFF-TST & NFF" Or [Final]="RTN-RETURN" Or [Final]="SCL-SCR LOCALLY" Or [Final]="SCR-SCR RETURN" Or [Final]="BER-BER RTN CST",Sum([Cost Of New]),Null)
Using Access 2010. I have a form on which I've placed a simple label. I try to set the label border color to black but it shows grey. I can set the border color to #000000 and it's grey. I set it to #000001 and it shows black as expected.
I'm thinking it has something to do with the themes, but shouldn't an exact color code show as expected? As a new member (<10 posts) I can't post an actual link, but here's the text of the location: [URL] ....
I have a form that lists evidence items 1, 2, 3, ect....
The form is listing them 1, 10, 11, 12, 13, 2, 3, 4, 5...
I have tried right clicking the evidence item # field and doing a sort a to z, and it is still listing them the wrong way.
Hello,
This is probably pretty simple but i can't find any info on it on this forum:
Every time i open my form the cursor automatically selects a field halfway down the page. How do i get it to open with the cursor at the first field on the form???
Also, I would like the form to be maximised upon opening anyone know how to do this?
Thanks
I have a combobox which lets you select from a list of pseudonyms. Each pseud belongs to an author; authors can have multiple pseudonyms and exactly one main pseudonym. This is the table structure (picture of relationships attached below):
Code:
tblStory: StoryID (PK), AuthorID (FK), Title, etc.
tblAuthor: AuthorID (composite PK, autonumber), MainPseudID (composite PK)
tblPseud: PseudID (PK, autonumber), Pseud, AuthorID (FK)
The combobox list shows all the pseudonyms and then stores the corresponding AuthorID. At the moment, the pseudonym displayed in the combobox (once a selection has been made) is simply the first alphabetically for that particular author: for instance, if a story has AuthorID = 5, and Author 5 goes by anon, anonymous, and unknown, the combobox for that story will display "anon".
How can I make the main pseudonym (tblAuthor.MainPseudID = tblPseud.PseudID) be displayed instead?
Control source is tblStory.AuthorID
Row source:
Code:
SELECT tblPseud.AuthorID, tblPseud.Pseud, tblAuthor.MainPseudID
FROM (tblAuthor LEFT JOIN tblPseud ON tblAuthor.AuthorID = tblPseud.AuthorID)
LEFT JOIN tblStory ON tblAuthor.AuthorID = tblStory.AuthorID
ORDER BY tblPseud.Pseud;
I'm new to Access VBA and I am having a bit of trouble. I want to find the dates between 2 dates(both inputted into textboxes), when I press a button I want them dates found to be displayed in a listbox.
View 5 Replies View RelatedI have a pivot chart that has site locations, and hours on the bottom, and then count of records with each site. Which is how many people used this site during this time for each bar. My problem is when I generate my pivot chart, every single time I have to fix the scale on the right hand side because it has decimal points in it. They only appear when I add dates/times to it.I want to give this to my boss that has access runtime, so all he has to do is click the button to get the chart and then print or send it off. How do I get rid of those decimal points when the report is generated?
View 1 Replies View RelatedI have a working combo box on a form that displays issue numbers for part number typed into a text box.This all works fine when the list of issue numbers is below the displayed list (16), but when the list is longer than 16 you cannot seem to select anything after item 16.
When the combo box has, say 25 items a scroll bar appears allowing the user to scroll down to item 25, but when you click the mouse the list just reverts back to the first 16 items? The only way to select an item after 16 is to select item 16 which then closes the combo box, then when you reopen it the list now shows items 17 to 25 which you can then select item 25.
This is the same in reverse, when you have item 25 selected, you cannot select item 1. When you click the mouse the list reverts back to items 17 - 25.The combo box is populated in code using the lost focus event on the text box for the part number.
I have successfully used an Expr code in my query to get the calculated result that I need. My problem is I can't seem to display the results on a form. I get the error "Name?"
When I try to find the query on data control which I used, it does nothing but shows me the fields from my table. How can I get a query expr column to display in my form?
the name of the query is "together" and the column's name is "everyone"
Can someone please point me in the right direction
I have a filter on a form using a combobox.I want to export the data displayed to an Excel Spreadsheet. I have used the Exportwithformatting Macro but it seems to export everything.
View 14 Replies View Relatedi have a form contains unbound listbox , that accumulates values of a field in that form "SalName" , when i move between records of this form i want the value that is in the current record is distinguished in the Listbox ( only where the SalID=SalID).distinguish by A special colour ,Font,undeline.
View 12 Replies View RelatedSome of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked (frmlocation and frmsample) these are linked by location code which is an autonumber.
These are laid out so that you fill in room data first, then location data then finally sample data. However after the location data has been filled out and a user attempts to move to the first combobox on the sample subform a message pops up saying that another user has altered the database and would you like to save changes (Impossible as they are using the database on a local drive). After this happens they reopen the form and in all the frmsample fields is "#deleted"
This doesn't happen every time...infact over the last 2 days i have been entering data myself to try and get this error with no luck. Has anyone else come across this and know how to fix it?
Thanks in advance
Matt Collins
I am having trouble getting the ID of the current record displayed on a form. The code I have written is this:
Code:
Dim ProjID As Long
ProjID = Forms![ProjectDetailsAll].CurrentRecord
The problem is that this code returns the record number relative to other records (so, this record is number 2634 of 2634). However, I am trying to get the ID of the record, which is an autonumber and is not the same as the record's order amongst other records. There have been record deletions ahead of this record, so the ID might be 3096 even though CurrentRecord tells me that this record is number 2634. Is there another way of writing this to get what I need?
I'm a newbie with Access, how to reorder the displaying of the columns in a Combo Box dropdown list of have in my Access 2007 application.
The columns that are being displayed are (in the current order):
Part Name
Unit Price
Parts.Web_Category
I want the order to be the following:
Parts.Web_Category
Part Name
Unit Price
I am designing a Web Database with a bound form to a submit table.
On the form, I have a combo box with selections that should influence the value to be displayed in a textbox also on same form.
For instance the combo box for Staff Name contains list of all Staff and I want the textbox to automatically display the level of the staff that was just selected in the combobox.
I know how to get this done using a combobox but my boss insists that the level should be automatically displayed in the textbox once combobox selection is done.
Using the combobox for level, I used the select statement in the RowSource property :
SELECT Staff_List.Level, Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Staff_Name)=[forms]![frmtest]![cboStaffName]));
I am in a dilemma of how to replicate this for the textbox because textbox only has control source and no RowSource where I can put this select statement.
Also, I will still need to bind this textbox to the submit table with the column name "TxtLevel" in the control source
Please see attached sample access db.
Also note that I cannot use action queries or VBA because it is a Web database and not a client database.