I have an Access database main form with several subforms (separated on tabbed pages) on it. All of my subforms are built using queries I've created to link the tables behind the scenes. All o...
Currently when I design Access forms I leave the properties windows shrunken up near my toolbar area. Unfortunately its floating and is too small for me. Is it possible to dock the propertie...
I have a search problem with my database. I have tables that are connected via keys. In each of my forms I have a field called UsedBy. In each of these forms I would like to be able to search ...
I am working with Access 2003.
I am a novice.
I have a form and subform setup and cannot get the main form to add a new record. My subform will allow as many records as you wish. I c...
Hello,
I want my subform to show all records and my form to only show one record at a time. Is this possible.
I thought It was and am not how I did it.
Can you help?
thank you
Hello,
Is there a way to create a command button on a form that will delete all records in the table?
also first warn the user are they sure they want to.
Thank you
I need example all about to use <authentication mode="Forms"> in my place
I currently have a form (frmCalcLoss) with a commandbutton cmdQuerytest2. This runs qrytest2_0. qrytest2_0 always has caseno=1. The textboxs at the top of frmCalcLoss are linked to tblCaseL...
I am getting an error I nave never seen before. It seems random in that 30% of the time for the same form it does not happen and 70% of the time it does and in all cases when it happens the o...
Hello,
I am working on a form in access.
I enter an item number and a few other txtboxes are filled automatically.
One of txtboxes is a date. Another txtbox is a number for number of days.
...
hi experts :)
hopefully someone would be kind enough to help me with this problem
i have records in a table where i have a group of names seperated by a ; symbol.
what i need to be ab...
Ok, so I posted my db as that is probably the only way you can help me is to look at it.
The forms that have the issue are AS9100RequirementAdd and CMMIRequirementAdd.
So for me, being my fi...
I don't know if this is possible but within my database I have a table with items that users will select from a combobox. However the most popular need to be at the top of the combobox list an...
I have a form on a tab (frm_Notes) which allows for the entry of notes, which are timestamped. The user enters one note at a time. I have a command button which allows the user to open another...
I am attaching my test database. In tbl_AHC, I used the Lookup Wizard to set the data type and lookup values for state and state2. The lookup wizard created the following statement:
SELECT ...
I am working on a form that has a tab set with connections to multiple tables (one per tab) that is connected to the primary screen by the company no. Each tab has a table connected via the C...
I have a table called productTbl with severel fields including an item# field, memo (descriptive) field and an updated (date ) field. Every day I import an updated productTbl from our website...
In a case where I have form A open in design mode and need to copy code from form A to form B, form B opens in design mode behind form A. That irritates me to the Nth degree. Is there any wa...
After creating security using the Wizard, I want one computer to only access a time sheet entry form.
This form is a main form with employee number and date with a subform for the time sheet ...
I have a form that includes 2 subforms. One subform is used for data entry and the second subform will display calculations based on the data. I have the calculations stored as text in diffe...
I am attaching a test database, which mimics the size of my actual form. My form takes up the entire page and I would like to set properties so that it comes up full size every time it is open...
I have a form with a subform. When a change occurs on the form, I want to do requery on the subform. The error I'm getting is "wrong data type," # 2498. I've done research, and I'm writing ...
Hello-
I am trying to create a table that calculates the number of open records in a given month, and then displays the data in graph. Here is the background:
Unique records are initiated an...
Hello All,
I would like to allow users of the database to select fields, add custom criteria, and print a report showing the custom criteria and fields selected from the current database. ...
I have a form with a subform on it. I am trying to make the form smaller vertically so it will fit on smaller screens. The subform footer I reduced to nothing but there is a good 3/4 inches o...
