I have form that was completely functional yesterday. Today when I opened it, the entire form is greyed-out in Form/Layout views. All the details can been seen in design view.
Tried decompi...
I have a Menu Form which has a subform which displays the current users outstanding actions. On this main form I have a command button which brings up a popup form taht allows users to updtae ...
Experts,
I have an Access Treeview Control. I have about 200 different records in the treeview so a search function is now becoming necessary. My TreeView is called "xTree". I have some co...
Depending on certain user input, I want to move a number of controls from a (hidden) Footer section to the detail section. (I will then set position and formatting, but this is not a problem)....
I have two subforms on an Access Main Form. I need to get two calculated values from each subform footer and add together on the main form. One of the subforms is embedded into a second subfo...
I have a form that has a text field that we use to type somebodys name. On the form is another field that has a drop-down box where you can choose from a list of names. Can I link both fields...
Hi,
I have a login form that looks for a username and password from a table. When found the switchboard is opened up.
The problem I can't resolve is after the match is found, a different...
Hello,
I am opening the same .mdb file on two separate machines. One machine is 2003 version and the other 2007. When I choose a button on a switchboard to open a form in version 2003, it ref...
I have a table in access 2003 which is linked to an SQL datasource. I have a need to update 7000+ records in a bulk update process. My form gathers a list of primary keys then applies the se...
I am completing an in-house developed Access system which will be used as our Courier Dispatch Ticket system. The Main form allows the user to input the information about a call. There is a ...
Is there a property that can be set to limit the number of characters that can be entered into an unbound text box? If not, what do you suggest as a validation rule or mask ?
Thanks,
Hello,
I'm creating a simple db that is like a ledger. There are multiple Accounts and then multiple transactions in each Account. I'm using the MS Ledger template as a starting point. I've...
Ok everybody heres my dilema, I have written a onclick code for one of my buttons to print out some pivot tables in the DB. The pivots are actually forms, som I'm just using a basic open for...
Hi Experts,
Thanks for the assistance in advance.
I have a combo box that acts as a quickfind box; ie quickly locates a record and populates the rest of the form and the subform with dat...
I have created a "reading test results" table with 6 columns that will eventually have around 400 records. These are for primary school reading test results for the 6 different years. I have c...
I need to print a single page layout of an Access Form page for a client. He has An Access Database that includes the form for all his data items. He wishes to get the form formatted to print ...
I've created a custom help file for my Access 200 application. I've found the pressing the F1 key in any form brings up Access help instead of my custom file. To make things simple, i've creat...
Hi
I have a form and a subform, in the form i have to field COST, and in the subform i have many records, so i would like to assign to COST the sum of all the records cost in the subform.
Pr...
My form "FRM_Menu" footer is invisible by default. I have a button btnShowFooter and when I click the button it visible the footer. All I want is to get the cursor to a field "txtSearch" on ...
I have a database which is updated by a few users on the network, but all day a form is shown on a monitor which is connected to a pc just showing a form view for everyone to read.
This is ...
Is it true that in Access 2007 radio buttons (option group) can only be displayed in a vertical format?
I need the choices displayed ona form in horizontal format so that data entry is easy f...
Hi experts,
I am trying to a Marquee style or ticker tape scrolling of information across MS Access form. A little while ago I found the following code on the net but have mislaid the name...
I have a form with 3 text boxes fields, 1 combo box field and 8 check boxes fields. The text boxes, the combo box and 6 check boxes have a tag name "Req". After the last checkbox, the user pre...
I have a form that has all the relevant fields for entering data into a table and into its related table, which is embedded in a subform. Currently, it shows all the related records properly, ...
I have a form which asks the user to specify an event via a combox selection, when the appropriate event is selected the subform is populated with the people associated with this event. What I...
