I just copied a form from one database to another and for some reason the copied form in the new database does not display. the form opens but the area with all the info is blank... When I choosed design mode it all shows up correctly but in form mode it is just blank.
View RepliesI've recently decided to move a database that had all its information on 1 table and divided it into multiple tables.
Attached is the relationship as well as the form.
The issue I have is that when I click the form, it only shows a blank record with none of previous records.
Data entry is already set to NO. I'm wondering if it's an issue with my relationships, tblStudioDescription is the parent table and the others are child tables so I linked them with the ID and set referential integrity.
I'm working on a project that has two tables. "Calls" and "Customers". The Customers form has a subform, "Calls Subform" in it. When you click on the (New) Hyperlink a new form opens, "Call Details". I would like to pull information off of the "Customers" Form and insert it into the newly opened "Call Details" form.
Problem #1) Home Phone (named "Phone" and Text223 (named "CID"): are both bound controls so I have to do this in an OpenArgs type process.
Further details:
On "Customers" the following is true:
"25" is the "ID" for that customer on the "customers" table
"Home Phone" is the home phone number on the "Customers" table
On Call Details the following is true:
Home Phone is Bound to a table "Calls" and needs to pull it's data from Customers Form..Text223 is CID and bound to the table "Calls" and needs to pull it's data from "Customers" form.
I am a novice to Access so bear with me please. I've just created a form to populate some tables.
When I switch from design view to form view, the detail area in the form view is blank. :mad:
The header is fine but fields, which are present in design view are not present in form view.
Any suggestions, I've tried font/background colors and searching for a switch setting.
Thanks in advance,
JA
I have a database that lists all the books I have read. The Table "Books" holds "AuthorId' "Title" etc. I have another table that is called "Whats Next To Read" which I store the next book that I will read from that author. It also uses "AuthorId" and "Title" etc. In the form, how can I look to see if the title put in for that author in "Whats Next" does not have the same title already in "Books" table. I can use Dcount to find the title but it could be same title different author. I need same title with same author.
This is what I have so far.
If DCount("Title", "Books", "Title = '" & forms!Whatsnexttoread!Title & "' > 0 Then
Msgbox "Title is already in books.", vbInformation
End If
I need it to only look at the same author.
I have a form with two fields, work_email and home_email. If after entering work_email, I would like to click on a check box if the home_email field is going to be the same information and have it copy what I entered in work_email into home_email.
Please help!
:confused:
I'm working on a form with almost a hundred various fields (it's what my employer needs). He wants to be able to create new records with much of the same information as the old ones by clicking on a button that will copy the information to a new record, then clear certain specific fields (or some process that will safely create the same result). I don't need specifics on how to write the same line of code for each and every field I wish to clear.
Say I have a form with 5 fields: part_number, part_owner, procedure, file_name, and date.
How could I copy the record to keep the fields part_owner and procedure the same, but clear part_number, file_name, and date?
All of the fields are from the same table (no, it's not normalized...).
Hi all,
I decided to create a switchboard using tools---> DB utilts---> SW manager.
i have managed to get this on the front end, altho the first button the contacts does't work properly. when i click it using that i cannot see any of the data that is in the database? but if i go out the switchboard without pressing anything on it. and goto contacts form the data is there?
Wired? or is it something simple i have missed?
Thanks
Shrew
www.dsltech.co.uk/310506.zip
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
View 7 Replies View RelatedHow can I get a form to open when the database opens?
View 5 Replies View RelatedWhenever I open this form I get this message. Form opens a web page.If I open that web page with browser I don't get this message.
View 2 Replies View RelatedI open a form (EntryBasic) for users to enter data in, which is then saved to the only table in the database (MasterTable). The form (EntryBasic) has a list box with four choices: red, white, blue, orange. The button that opens the form is placed on another form (MainForm) The form (EntryBasic) record source is MasterTable.
A user is on the MainForm and needs to add a new record related to red. When user clicks on the button (NewRedEntry), I need the form to open and the list box pre-selected to red.
Is there a macro or VBA code that might simply execute this action, preferably something that can be attached to the NewRedEntry button?Even better, if there are two list boxes, code such code be applied to same NewRedEntry button, where both list box values are pre-selcted with the click of this button?
I am having a hard time with this project that I'm working on at the moment.
I have created a modal dialogue form that has a macro set to open another form and close the current form at the same time. The form that is being opened has textbox controls that have the default value set to hold the data that is in the textbox controls in the modal dialogue form that is closing. The problem is, is that when the modal closes, the controls in the next form display #Name? and the data is not copied to the next form.
I have a table which holds information relating to a fleet of vehicles; each of these vehicles is currently physically checked on a daily basis for a number of items, one of which being to check that the vehicle has valid VED (tax disc).
With the paper disc being abolished now, we have a situation where the individual using the vehicle cannot be certain about its VED status (the chances of one not being taxed is next to nil, but we are talking a fleet of nearly 1000 vehicles here, so anything is possible)
Our current database has most of the vehicle information stored already, so in theory I think I only need to add a couple of fields, which will make the table structure (roughly):
FleetID
RegistrationNumber
CallSign
MobileTelNo
MOTExpiry
VEDExpiry
With the latter two being the added fields.
Now, what I was wondering.....
Is it possible that when a Form (not related to the table, and most likely the main switchboard form) is opened that both the MOTExpiry and VEDExpiry dates are checked, and if either or both of them are due to expire within 7 days or have already expired that a warning appears (vbaOKOnly messagebox would do fine) stating that there are vehicles that require their MOT & VED dates to be checked and updated accordingly)?
I have a form that opens from a different form based on the primary key within the original form. Unfortunately it seems to be opening a new record every time I open the form--not only from the original form but also straight from the sidebar.
The command button that opens the second form from the first uses the following VBA:
DoCmd.OpenForm "ZooMobile Incomplete Booking-Return Client", , , "[Event_ID] = " & Me.EventID
This exact coding worded perfectly in a similar set of forms that I had created; the only difference is a change in the form name & primary key field.
Add onto this, I think that the code DOES work, but then it immediately opens another new record. When I open the second form from the command button, then change to Design View, the form's Filter property is set to [Event_ID]=X (where X is the proper key from the first form) and Filter On Load is set to Yes. The X in the Filter changes accordingly when it changes in the first form. Also, every time I open the form a new record is added to the underlying table.
I've tried setting "Allow Additions" in the second form to No, but then when I open the form nothing appears. Literally; the entire form is blank, no labels, textboxes, combos, buttons or anything. When going to Design View it's still all there.
I've also checked the On_Load, On_Current & Form_Current events and found nothing. I even deleted them and the problem still occurred.
I'm using a navigation control to switch between forms. In one of those forms, I have a continuous subform which is a list of Projects (source is a query) that is read-only. To edit a project, I can click on its name, which switches the form displayed in the navigation control via docmd.BrowseTo (with acEditForm as the last parameter). This works fine. The proper form opens, with the proper project being displayed.
Now, on this second form, I have on the right the list of tasks contained in the project in a continuous subform (source is a query), and on the left another subform which is kind of an "edit bar" that I use to actually edit the individual tasks. So, when I click on a task in the task list, the OnCurrent event triggers a docmd.BrowseTo command that updates the "edit bar" subform and passes the ID of the task as the WhereCondition parameter. This updates the values displayed in the Edit Bar to that of the selected task, which I can then edit.
Now here's the thing: depending on the project I open, the Edit Bar doesn't work. Actually, it looks like only one of the projects is working, while the others are not (and I managed to have a different project working, but only one works at any given try). When it doesn't work, the Edit Bar is in "NewRecord = True" for some reason. All the other properties of that subform seem to be the same between when it works and when it doesn't.
So, it looks like the same command (docmd.BrowseTo with acEditForm) opens the subform properly in acEditMode when it works, and in something else when it doesn't, depending on the parent record that's being opened.
This really gets me, I really can't figure out how that's even possible.
I suspect it might have something to do with locked records, maybe?
I've got a huge table with one column that shows a lot of duplicate
info in it. How can I let it identify the unique names and "hide" all the
duplicate info that falls under it e.g.
Columns:
Col.1:Fruit Col.2 Col.3
Apples A 1
Pears B 2
Peach C 3
Apples D 4
Apples
Apples
Pears
Pears
Pears
I would like the table only to show the say Fruit column with Apple, Pears,Peach
and list when you click on it all the related data to it. Along with this I would like to
associate all this info in the form. If I select Fruit in the form the related data should appear
below in maybe a subtable or something which I should be able to select from which info I need.
Having a problem where information from staff worksheets has some constant data and other info is static.
I have added file for your viewing. The Propagation form 1 is the original form I was using to input the data, this was time consuming. I am trying to upgrade the form so that constant data can be entered in once and static data entered onto a sub table within the for.
Problem is that when I view the table to make sure everything is working the constant data is only recorded for one record not the balance(pls go to last record to see problem). ie date is not repeating in propagation table
Can ANYBODY help with this as this problem occurs in other forms as well.
Hi,
I've been given an existing database to modify, and I'm struggling somewhat to see how the author has implemented certain functions.
On a main menu form (autoexecs on starting the database), there are various "Search By" option buttons to generate a report, ordered in various ways. The "On Click" field for each of them refers to a macro, called Buttons, and a line in that macro dependant on the type of search (e.g. OnClick = Buttons.byPerson).
The Buttons macro runs an OpenReport command, the report corresponding to the search type (e.g. Buttons.byPerson has an OpenReport command for the "Report by Person" report).
However, when I click the search buttons (or indeed run the corresponding reports) I instead get another form which allows the search criteria to be specified - this then generates the report (I would assume based on the relevant query - e.g. Person Query), but I cannot understand how this works.
Google searches have not helped much as I can't seem to find an adequate search phrase to use, and I've been staring at the thing for some hours now. Any help getting me off in the right direction would be much appreciated!
I have a button placed on a form, but it is only clickable a few pixels along the bottom of the button. If you hover anywhere above this, the button is not clickable and does not highlight as if it is clickable.
I have deleted the offended button and recreated it, but the same strange behavior occurs?
If I move the button up a few pixels or more, then the clickable area shifts to the top of the button and the bottom becomes unclickable.
The buttons are in the header of the form and is completely visible when the form is in normal form view. I also can not see anything that could be sitting ontop of the button (no transparent controls or anything) that could be obscuring it.
Is it possible, and if so, how, to change the colors of the background area where the navigation bar is?
(Area marked within included image)
I have searched for an answer and spent some hours but still not getting it.
I have played about with the query joins and still nothing?
I have never had this problem with my database in 5 years (well not that i have noticed).
Some records are fine others are triplicated and quite a lot are blank?
This is the SQL for the query.
SELECT Employee.EmployeeID, Employee.FirstName, Employee.Surname, Employee.Address, Employee.[Town/City], Employee.Region, Employee.DateofBirth, Employee.Nationality, Employee.MaritalStatus, Employee.PassportNo, Employee.ExpiryDate, Employee.Nextofkin, Employee.Relationship, Employee.NOKAddress, Employee.ContactNo, Certificate.CertName, EmployeeCert.Level, Trade.TradeName
FROM Certificate INNER JOIN (Trade INNER JOIN ((Employee INNER JOIN EmployeeCert ON Employee.EmployeeID = EmployeeCert.EmployeeID) INNER JOIN EmpTrade ON Employee.EmployeeID = EmpTrade.EmployeeID) ON Trade.TradeID = EmpTrade.TradeID) ON Certificate.CertID = EmployeeCert.CertID
WHERE (((Employee.EmployeeID)=[Forms]![Employee]![EmployeeID]) AND ((Certificate.CertName)="IRATA"));
Basically i have to solve this problem.
I have a report that is based on this query and if the employee is not displayed correctly instead of the employees Name and Surname i am getting "#Error" ?
Many thanks in advance
I have a report that spits out several names of individuals, I have it in ascending order and if there happens to be a duplicate the second, third etc. are all left blank on the report, is there anyway to prevent this from happening.
View 4 Replies View RelatedHow do I move combo box label into the form header area while leaving the actual field title in the detail area in a subform so they looked stacked like the other items??
View 1 Replies View RelatedI'm quite new to using Access 2007 and I'm trying to create a form from different tables which have relationships. I've used the form wizard and added all the fields I need from the different tables, however, when I click form view it only shows the title and nothing else. When I'm in design view everything is showing..
View 1 Replies View RelatedI have a [New Job Number] form in my database. In this [New Job Number] form, I have a [Purchase Orders] subform showing all open Purchase Orders. I have a button in the [New Job Number] form to open another form called [New Purchase Order]. How can I transfer all of that information from [New Job Number] into the [New Purchase Order] form through a macro? I don't know how to use VBA. Also I do know how to use basic Macros, though.
The fields I would like to transfer from [New Job Number] into [New Purchase Order] are JobName, JobNumber, and CustomerAccountNumber.