Okay, here's a question that should hopefully be simple. I have a form that I am setting the default value of two text boxes based on the form previous. Here's basically the rundown of what happens
frmForm1
Input Month: February
Input Year: 2012
OK - Opens frmForm2 and then closes this one
---------
frmForm2
Month_Default_Value: #Name?
Year_Default_Value: 2012
---------
And this always happens for every month and every year. So could you tell me what could possibly be wrong with my "Month" default value? Here's the code...
Private Sub Form_Load()
Month_Query = [Forms]![frmStatementDialog]![Month]
Year_Query = [Forms]![frmStatementDialog]![Year]
Me.Month.DefaultValue = Month_Query
Me.Year.DefaultValue = Year_Query
End Sub
I have a task of managing hardware assets like desktop, monitor, HDD, routers etc. Each item is marked with a unique ID.
These items could be transferred from one city to another city; so need to track that too.
1. There will be two tables
One (say AssetDetail) will have the following fields RecordID City AssetID Description of the asset (desktop/monitor etc) ProductSerialNumber of the asset
Second (say AssetTransfer) will have the additional fields NewCity AssetTransferredDate
2. I only want to open a single form :
a) where on the basis of either AssetID or the ProductSerialNumber, I could open a particular record and edit it.
i) if the asset is transferred from city A to city B; then the "City" field value in AssetDetail table should change to "city B"(New City field value).
ii) At the same time, each asset transfer record should get appended to the AssetTransfer table even if the table has an existing record with the same AssetID or ProductSerialNumber.
3. Also need an option to make a new entry to the AssetDetail table from the above mentioned single form.
Hi. I am running a form on top of a query with around 1500 records in it. The query mostly uses tables that are joined with referential integrity.
The form has buttons and conditional formatting.
It was fine until today, when suddenly the form has stopped loading properly. It looks all fragmented on the screen and I have to scroll down and scroll back up again for it to look right.
I have searched everywhere to find out what is causing this and how it can be fixed, but no luck yet. Can you help?
I'm working in Access 97 and I've got a form that I want to use to create filters with.
There are a couple of things that I'm not clear about and I'd appreciate any suggestions that you can make:
1. The form seems to remember the last filter, so when I click on the Filter by form button it shows the last filter by default. I've included the following in the click event: RunCommand (acCmdRemoveFilterSort) Me.FilterOn = False RunCommand (acCmdFilterByForm) Surely either of the first two statements should remove the filter, shouldn't they? and if not then what are they for?
2. I can't get the 'OR' tabs to show at the bottom of the filter by form screen unless I apply the filter once and then click on the filter by form button again. Is there any way of forcing these tabs to appear?
I made a form a few years ago using Excel but it has become a major headache for anyone who wants to edit/update the content.
It's my responsibility to figure out how to fix this, but I don't really have any experience in form-creation! I'm not even sure what software to use... I've done some searching, and right now I'm thinking Access might have the tools that I need to help me complete this project (although I have no experience with the software at all right now).
I'm looking for some help on getting started.. so I will describe the project, and hopefully someone can answer a few of my questions.
This form has 3 sections: input, Q&A, and the summary. The input section is handled by the company before presenting the Q&A to a client. In the Q&A portion the client's name, company, and other personal information are pulled from the input section and placed mid-sentence in the questions. This is a personal touch we would like to keep when re-creating the form.
The Q&A portion also includes radio buttons, checkboxes, dropdown lists and input fields where the client can type out their answers sometimes. Here is an example of what the first 2 pages may look like:
PAGE 1: Question 1: Do you have a clearly defined purpose for your plan?
http://img425.imageshack.us/img425/3589/radio9sx.jpg If YES record the purpose below: _______________________________________________
http://img425.imageshack.us/img425/3589/radio9sx.jpg If NO, choose a sample purpose from the drop-down box to help get you started:
PAGE 2: Question 2: What selection critera did you use to select your service provider?
http://img71.imageshack.us/img71/2890/checked4na.jpg Investment options provided http://img200.imageshack.us/img200/5539/unchecked5rr.jpg Cost of service http://img200.imageshack.us/img200/5539/unchecked5rr.jpg Support tools proved http://img71.imageshack.us/img71/2890/checked4na.jpg Quality of service
Enter any other reasons below: _______________________________________________
One page per question.
The SUMMARY page will take client's answers and compact them into something more readable. The answers are listed one after another (no limit per page as with the questions). Also, the answers are to be displayed in sentence format. For example.. if a client checks off 3 items from a 5 item list, those three items should be listed in a sentence separated by commas. Here is an example summarizing the first 2 pages above:
Summary of Answers
1. Do you have a clearly defined purpose for your plan? A. YES. (description of plan previously entered by client)
2. What selection critera did you use to select your service provider? A. Investment options provided, and quality of service. Also (other resaons, provided by client)
This demonstrates the type of control that I need over the information. I managed to get Excel to do all these things.. but, like I said it is too complex to edit/update without accidently screwing things up. So lastly and most importantly... the final version of the form needs to be easy to edit!
So... does it look like Access the right program for the job? Maybe there are other programs out there that I should be looking at (something by Adobe maybe?)
But if you think Access can handle the job then do you have any tips to help me along my way? I'm not looking for specific step-by step instructions to help me build this of course.. I will figure most of it out by trial and error. But are there some major things I should be looking out for? Like, do I have to set up a particular kind of database, or use a particular kind of template? Is inserting the client's name mid-sentence a particularly difficult thing to do?
Any help to get started on this is much appreciated. THANKS.
I have a continuous form (FormA) which shows records from TableA. There is a button on FormA which opens FormB. FormB allows a record to be added to TableA. On closing FormB, FormA should requery to show the most recent addition to TableA. This does not happen though, it is always a record behind, unless I close and reopen the form.
I'm using;
Forms![FormA].Requery
on my close button on FormB.
Any ideas? I have done a search but cant find a solution.
I am brand new to MS Access 2013 & VBA.There is a form that collects the data and writes it to a SQL database. The form is a certificate order form for a school. There are two tables that data is written to. dbo.CertificateMaster & dbo.CertificationModules. There is a relationship between the two tables. A person will request the certificate and included in the request are the subject(modules) that the person has studied.As part of the request the college/school needs a printed copy of the request.As the report opens I need it populate certain fields with their full names. To do this I use the following script
Private Sub Report_Load() Dim strSQL1 As String, db As DAO.Database, rs As DAO.Recordset Dim strSQL2 As String, db2 As DAO.Database, rs2 As DAO.Recordset Dim strSQL3 As String, db3 As DAO.Database, rs3 As DAO.Recordset
[code]....
Problem 1:
When drawing the data from dbo_tblCourse_Department I need to populate 4 textboxes on the report. I am able to populate PgmTitle &NQFLevel, but I keep getting "Item not found in this collection error for Credits & SAQAID.
Problem 2:
I need to populate the various courses with their name which is extracted from dbo_tblCourses. However only the first course name is visible in the report. I have tried all sorts of different iterations with IF Then or Do While to get the names in the correct line of the report.
I have a pop-up modal form which is loaded (like 99% of my other forms) by a button on another form.
Unlike all of my other forms, however, it doesn't load its background properly. If I drag the window off screen and back or shrink and resize, it does look right, so I guess maybe it requires a refresh?Obviously, I don't want to rebuild the form from scratch, so maybe some vba which refreshes the screen?
I have a Main Form with a tab control. On each of the six tabs is a SubForm that takes up the entire tab. So basically I have a tabbed interface for my forms, just with a bit more control over the layout than if I just opened the forms separately in the Access window.
Anyway, on one of those subforms is a button. When you click it, it opens a separate form in a pop-up window, which is used to find a specific record. Once that record is found, you can click another button, and the idea is that this pop-up window closes, and you return to the underlying form, which jumps to the record you selected.
So far so good. Now, if I am working on my program in Access, and I open that subform's source form separately in its own tab, click the icon to open the record finding form, find a record, and then click the button to load that record, the following code runs, and it runs flawlessly - closing the pop-up window, and passing the information back to the main form which displays the proper record:
Quote:
Private Sub ViewRecord_Click() Dim RecordID As Integer RecordID = Me.ID DoCmd.OpenForm "CDLExam", , , "ID = " & RecordID DoCmd.Close acForm, "CDLExamCONT", acSaveNo End Sub
Where my program falls apart is that, in actual use, this form is not open on its own. It's open as a subform on one tab of a tab control on a Main Form. So the third line of code falls apart. Access thinks I want to open CDLExam separately, but it can't because it's already open in the subform, so instead I just end up back at the main window like I want, but the form fails to move to the proper record. Basically, line 3 just doesn't do anything.
How can I make this work? I tried replacing "CDLExam" with the name of the main window, but then it tries to move to the record in the main window, which throws an error as the main window doesn't even have a record source attached to it.
how to refer to the SUBFORM which has CDLExam open, and tell THAT to move to the proper record.
In one of my databases, I have a form and a report where the images stored in my tables are not showing properly for all entries. They show as an icon with the file name rather than the image itself. This is not true for every entry, so I don't think it would be a problem with how the form and report are set-up.
I have put much time in designing a form. After exiting and saving it, I cannot now open it. Only the Page Header shows, and I cannot get into 'Design' mode. I have tried repairing and compacting to no avail. Any ideas?
We use our CRM for entering client orders, which is done through our 'OrderEntry' form. On that form we have a subform that we use to enter order lines - as we have a range of products on offer, an order can be made up of one product or anything up to 100.We have an 'amount' textbox on the subform, that the users enter the cost of each line, and as they add more lines the total cost of the order is calculated using a textbox in the subform Footer, with the ControlSource set to =Sum([amount]).
On the main form, we have a Net textbox, that the user will add in the total cost of the order once they've added all the order lines, and providing the =Sum([amount]) textbox on the subform matches the figure in the Net textbox, a button to Proceed the order and go on to the next step appears.
The intermittent problem I have, is that the OnCurrent event I use to show the Proceed button does not seem to fire on its own - but when I stop the code and step through it, it will show the Proceed button without any problems.Here's the code:
(the Proceed button is referred to a 'Command80')
Code: Dim OS As String Dim UT As String OS = OrderStatus UT = fGetUserType
[code]....
I've made the part that refers to the Proceed button bold, but thought I'd add in the whole OnCurrent event in case there was anything in there that was blocking it.
I added in the MsgBox code at the bottom to make sure the OnCurrent was firing, and that works fine.I've searched through the rest of the code, and there's nothing else in there that references the Visible property of the button.I've been through the decompile process detailed here, and also been through this similar thread with a fine toothcomb and this still won't work.
I've saved the form out as a textfile and then imported it back in, both through the immediate window, and short of importing everything in to a new DB and starting again
I have a form (frmAddManifest) with a subform (subfrmManifestTransporters).
When creating a new record, I can enter data into frmAddManifest, but the subform doesn't update to link with the record - I presume it's because the record from the main form hasn't been completed yet.
Is there a way to requery the form and/or subform so it stays on the record I was working on, and link the subform properly?
I am designing a database for my organisation. I have done most of it but am stuck on this. Ideally I would like to have a check box (in a table) that when checked a load of data is carried across from that record to a record in another table.
Given that I can't and don;t want to use VB is there anyway that this can be done easily?
I have a form "NewMetalF" that has three combo boxes. The first one is used to choose "Precious Metal" or "Base Metal". The second one shows all the metals based on the first combo box. When I open the form in form view alone the combo boxes work flawlessly. I run the form "NewMetalF" within another form "NewExternalPartF" by clicking a button "AddMetal". When the button is clicked "NewMetalF" opens. The first combo box is selected, and when the second combo box is clicked the error "Enter Paramater Value" "Forms!NewMetalF!cboPreciousOrBase".
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
Bit of a nightmare, put loads of information into my database, and when i look in the table all information is still there but can not get it to be displayed in my form, what has gone wrong??
I am attempting to place a label on the top of a tabbed form and I am having a problem. Here are the important parts of my database:
tblInstructors InstructorID Autonumber PK RankID FK to tbl Ranks LastName FirstName
tblRanks RankID Autonumber PK Rank
I have a tabbed form with a combo box for RankID and text boxes for FirstName and LastName. Obviously there is more information than this on this form, it is tabbed and I would like a label on top of the form that shows the name and rank of the person's record that is being edited or viewed while the user is on another tab. Normally I would use =[RankID] & "" & [FirstName] & "" & [LastName], however this isn't working since the RankID control is passing the Autonumber from tblRanks instead of the actual rank (yes this is military rank abbreviation). For example I get the number six instead of TSGT. I need to find a way to show the text value instead of the autonumber that represents it.
I have searched to the best of my abilities to find anything on this forum about this as I am sure it has come up before but have been unable to find anything.
I have couple of forms where...The users enters a name of the river where he/she was fishing in, I also have an option where the user can browse for previous entered rivers.I am wondering how this works, how do I let the information entered go automatically into the browse section and how can I prevent from duplicates will appear in the browse for previous entered rivers. thanxp.s is this something that I will work with in the table it self or can I change this in the form ???
:confused: ok basically im trying to create a form for customer details for a project at college, what I want is:
select customer ID from a drop down list, which then should display all their details below such as address etc(from the linked table), which cannot be edited or nothing, like looking up information. can anyone help me please???
I have previously posted this on another message board with no responses. I am hoping that someone here can help.
I have a form that has several subforms. The forms are linked Child to Master using a Company Name Contol. In the table where the Company Name is set up, it is not indexed. It is not a primary key. When the EU (in test) enter data with the company name a second time (a second record for the same company), all the information in the first record populates the second record. If any changes are made to the second record, then it is also reflected as changed in the first record. I hope that I am clear in my explanation. What have I done to cause this?
Im having problem with my database, i have managed to set up a calcualtion so it does the sub total thanks to a query, however i want the information to be displayed in a text box on the original form. Is there anyway i can transfer the ammount over to the original forms text box?
Hello, i have managed to get my form button to open another form to a specific record but this doesnt always work, i have used to wizard in access to do it some times it works other nots.
could any body help at all. i believe it could be a problem with my relationships. i have deleted them al to start again, but i am having trouble setting them up!
