I 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.
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.
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.
Why 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?
I 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 have a main form (tsTimeSheetMain) which contains a sub form (tsTimeSheetDataNewSub) in data sheet view. When I click off one row onto another row in the sub form, it triggers this code:
Forms!tsTimeSheetMain!ProjectMonSum.Requery
i.e. it tries to requery the ProjectMonSum field (on the main form) which is a dsum calculated field. This works fine and updates the ProjectMonSum field (which dsums values from the same datasource as the subform.
However, this seems to put the cursor back to the top left field in the subform (datasheet view), rather than leave it in the field I click on (in the subform).
Why is this happening and what is a decent workaround this issue? I just want to update the calculated dsum field each time you update values in the subform.
So I have to text boxes, one for month and one for year. Below is the control source for each box. When I go into Report View, I get January 1905....This is definitely NOT January 1905....I've checked the date on my clock, it says today's date...
After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.
After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)
I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.
Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?
(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)
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?
In design view I moved around some of the fields of a subform for them to make more sense for data entry purposes, but when I save it and go back to the main form in view, the changes are not reflected. I even tried editing it in the subform itself and it still won't reflect the changes.
I have an extremely complex database that requires 12 forms to remain open simultaneously. A command macro successfully opens all 12 forms, but 3 of the 12 are hidden from view because the window does not have enough room to display all 12. Even when I use the left / right arrows, these 3 forms are still partially hidden. How can I ensure that none of the tab controls are partially hidden behind other tabs ?
I have created a database to track our contacts for the office. I spent some time working on the relationships and making sure everything was normalized, as I've only just recently understood that concept. However, I'm afraid something got messed up in the process and I may have missed a step or done something wrong when creating the relationships.
Basically, I just created the form with all of my fields in it and when I try to view the form I see that no fields display (it's just a blank white screen). I wondered if I should actually be creating the form based off tblcontact, and then add subforms for each of the other tables.
See my attached database for further reference ...
The form is specifically made to be wider than the screen, so that there is a scroll bar at the bottom. I have an embedded picture for the background which is intended to be the size of the form, meaning that the picture is also wide.
In Design view, I can see that the background picture fits the form perfectly, which is what I want to see in Form View.
In Form view, though, the picture is squished to fit the screen. The only time it doesn't do that is if I set the Picture Size Mode to Clip, but then it only shows a portion of it, and when I scroll horizontally, the background picture doesn't scroll with it.
Is there any way to identify the Top row in a continuous view form?This changes of course as you scroll down. What I'm thinking of doing is a page jump page forward, or back. The form is based on a query and has a line number field, but I can't figure outhow to get at it in code.
There are some selection controls that require the user to enter data before the next one becomes enabled.
My form then has two different groups of controls that the user see's depending on the selections earlier, either one group or the other is made visible.
My question is how to move the view so that the appropriate group is where I want it.
If I use setfocus to a control the form moves but not how I want it to (The control that i setfocus on is half way up the screen rather than close to the top.).
I know there must be a better way, I tried move size but it didn't seem to do what i wanted.
I've created a Navigation Form and one of my tabs brings up another form bla bla but what I want is to bring this form up in datasheet view...is there a setting for this or due I have to create a query to get the look that I want?...
The Form that I attached to the tab when opening it up by itself (out of the Nav form) comes up in a datasheet type format,and when I open it up in design view it changes from the datasheet type format to texts boxes stacked on top of each other. This is also how it opens up in the Nav form...
Does it have to do with how the form I'm putting in the nav form was created?...style wise...
I have created a form with a 2 column list box. This is populated using vba but when I open the form in form view I cannot seem to select any of the items.
I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.
I have a form with a query as rowsource.When I open the form in data sheet view form header is not showing(Though it is visible in form view).Is it possible to show the form header in datasheet view?
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.