There is a light border that is still there after I remove the text that was in the box. I want to remove the ghost image, for lack of a better name, that is left.
Also all the images, fields, are locked together. I want to remove some individually,without moving everything.
I'm in the "LayOut View" of Access 15.0.4551 Office 365 Home Premium.
I seem to be having an issue with a split form I've been working on. I created this split form on Monday and it was working just fine but today, I have added a couple minor text boxes. Since then, I can view the form contents in Design View but when I switch to "Form View" or "Layout View", it's all gone minus the logo in the top left corner and the title for the split form.
View 12 Replies View RelatedMy form was working fine but when I added an extra tab it started showing as completely blank in design view. When I deleted the tab I had added I still was left with the same problem!
I've attached an image of the form properties. I want to use the form to enter data so it needs to show even if there are no records.
I had read that it could be if there is no data but typing data in the tables hasn't worked either.
I created a form with a continuous default view and created labels in the page header of the form. When I view the form, I can see the data from the form detail, but the lables in the page header do not appear. Why can't I see the labes in the page header ?
View 3 Replies View RelatedHi all,
title says it all!
I've got a form with numerous controls and labels. When i first open the form, all looks fine - all labels are Black Arial 8 Bold. But when i start scrolling through the records, the text on three of my text labels gets bolder. I haven't a clue what is causing this - the labels are just standard - two are associated with controls and one is all on its own.
I have no code written to do this, and in fact i'm not sure you could write code to do this. I've tried renaming the labels, changing the font, deleting and recreating them, but it's always the same three that get darker.
Ideas?
P.
Views show design view, datasheet view, pivot table view, and pivot chart view. Where did layout view go, and how do I replace it?
View 3 Replies View RelatedI am working on adding a layer of security to my current DB. I've got usernames and passwords set up, along with access info (controlling what aspects of my DB certain users are able to interact with)....
I've managed to disable the navigation pane and ribbon for most users (only me and another user will have access) and now i want to try and disable editing....
Cannot find any VBA coding online to allow me to prevent people from editing forms/reports/queries in Design or Layout view.... How this can be accomplished?
How can I see what they will finally look like while I am formatting them? All the views on offer (form/layout/design) are all displays within the the context of the access programing screens, with other windows and menus and ribbons etc. I want to see how it will look full screen. I know I can change a lot of options, change to the form as a default to open with, resave, reopen and then reverse it all but that's not really any good for doing every time you make a minor change.
View 14 Replies View RelatedHard to see the image but basically, I can't seem to bring the database behind the form to the front to view it when I click on it. I've never encountered this before.
View 5 Replies View Related[URL] .....
In the Lesson tutorial shown above I am clicking on tools and adding existing fields. I get a lot of output label and text box pairs for each field that I add.
However, they are all on right below the other. That is no problem just move them. No way.
Whenever, I move it a label and test box for say Order Status, I get ... nothing. It stays where it is.
They (label and text box) do not move together. So how do I get them to move together.
I have read a lot about the rnd function to succesfully randomize the order of records in a db.
I want to randomize 2 columns separately . These are Q's and A's so if the db is 2 fields (the second -small- letter is supposed to be under Field 2!)
Field1 Field2
A a
B b
C c
D d
etc...
I want it to look like
Field1 Field2
B c
A d
D b
C a
I have managed to construct two separate queries which obviously give 2 random lists for each field but how to put them both together to achieve the above?
I have tried applying a rank order to each list and then linking them on that but the rank number keeps changing hence no link there. All I want is to link them and keep each column in the same order as it has been randomized.
Thanks
So you make this nice continuous form (or report) using the tabular layout, layout/format the whole enchilada... and then at some stage you need to add one more field to the display.
You could change the layout to stacked, drag the field from the Add Existing Fields list onto the layout and then change the layout back to tabular.
Is there any other smart way to add a field to a tabular layout in A2007, so that the label winds up in the header section and the textbox (or other control) in the detail section?
When I drop a field into a form I'd like to take the Lable Box and put in into the Page Header section and leave the data field or control box in the detail field.Sometimes I have available "Remove Layout" function to split the 2 so I can manipulate them around.
View 3 Replies View RelatedI have searched and searched... but I just cannot find this. I know it has to be in here somewhere. Any help is greatly appreciated.
I have a query called "MyLateProjects" that shows results based on a specific number of days since the "project" was entered in to the database. I need to be able to send a "You are late X days" email to each of the project submitters from the values in the records of the query result. I have the fields, for example, of "emailaddress" and "Projectnumber" that I need to include in the To: line and Subject line, respectively. So, if I get five results, I need it to send five separate emails.
Like I said, I have searched and searched, and I cannot find a way of getting this done. I can send the first one from a button if I show the results in a form... but I don't know to automate the send operation as part of the query, nor how to get a separate email sent for each record (would this be a loop of some sort??).
THANKS!! ALL HELP IS APPRECIATED!!
Tom
I have debit & credit column. Which I use this in the report -->
=IIf([PaymentMet_trans]=2,"",[Amount])
debit = 1 , credit = 2
Now, i would like to have the total sum of it. according to the debit & credit separately instead of the whole total sum.
I developed a database for a group and i want to be able to prevent anyone from mucking things up.
View 4 Replies View RelatedI want to place a text box at the right bottom corner of a form. I tried but its position is changing as per moinitor sizes.
View 1 Replies View RelatedI have two tables one with all the personnel (tblPersonnel) I'm tracking, another with different report names (tblReports).
For each report, there are different years that it's valid for.
On the reports table, I have three columns, ReportID, Report_Title, and Years_Valid
I'm using a lookup on the personnel table that stores the report name as the ReportID.
What I want to do is in a query use the Years_Valid column to automatically generate review dates bases on dates already in the database.
I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.
View 1 Replies View RelatedWhy the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:
View 2 Replies View RelatedI have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?
I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.
Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!
I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.
View 1 Replies View RelatedI have made an unbound check box, named "myckeck" in a form which shows data from a table in tabular layout.
1- When I check one check box, all check boxes are checked. How can I solve that? I mean I want to check or clear check boxes independently.
2- I made a text box, named "jobdate" to sow todays date automatically upon checking a check box.
Code:
Private sub mycheck_afterupdate()
jobdate = date
End
But this is not working and checking a check box does not make anything to happen.
3- Then I made this expression in the default value of "jobdate" properties:
iif( mycheck = true, date(), null)
This not working either.
Hi,
I have a command button that opens a report. The report has many subforms in it. I am sending open args which existingstewardship. I want one of the labels of the labels to be visible if the me.openargs = "existingstewardship". the code is not working. I have tried to debug when I do this I have found the open args are null and I am wondering if the open args are null is this because they were sent to the main report from the command button and the subforms in the main report do not get passed the open args.
Does anyone have any idea ? how I could make the box visible or not visible in subreport from the command button. The other option I have would be two different reports. Thanks PWF
I cannot link a label with a control. I don't know how it happens, or rather how I do it, but on various forms the label is not linked to the proper control. I try to do it by clicking on the warning popup on the right side and indicate I want to associate the label with the control, but sometimes it just doesn't work. That is, if I set the visibility of the control to True or False depending on the value of another control, the label still appears.
I've looked in the properties of each, but there doesn't seem to be anything there to indicate the link or association. Other than laboriously copying and pasting the label back on the form with the control highlighted, is there any way else to do this?