My database has the following:
2 forms titled form1 and sub_form2
2 queries titled sortbyfirstname , sortbylastname
1 table titled Names
On form1 there is subform2 two option...
I use the attached code snippet to change field names and, optionally, to change the field's description. How can I modify the code below to optionally change the field's data type too? Assu...
How do i code the "OnClick" event of a command button to open a hyperlink. I know i can set the hyperlink address to a web site but i need this in the "OnClick" event property.
I've got a subform called "schedule data" that I'd like to show up as a continuous subform because I need to have a button for each record. But each schedule data record has a crew that can b...
I have a report that I need to display the criteria used to compile the report. I would like to be able to show the criteria in a footnote in a format such as below:
Year(s): 2005, 2006, 20...
Hi
I have a simple Access form connected to a backing table.
Is there a simple way to make certain fields mandatory on the form
entry without having to do this in the backing tables
I have a command button (cmdPurchaseOrderPrint) on my form (Orders) that opens a print dialog box for a report. When I click 'ok' to print the form I see Error # 2585, This action can't be ca...
Hi I am having an issue with a access form that I am trying to create from a query with a check box involved. Let me explain. Users can click a button to run a query that will bring up records...
Hi
I have a MS Access 2003 database with a single table (tblBasicData) and I would like to create a form where I can search by a number of fields, preferably not using combo boxes, but idea...
I have a subform that I want to give the user the ability to change the view type of this subform via buttons on the mainform. What is the proper syntax to accomplish this task.
My current ...
I have a form in MS Access 2003. On the form I have a combobox dropdown.
When the form moves to a new record, the query for the combobox list is automatically refreshed using a query that ...
Hello. I have a Microsoft Access that has a form and a subform. I want to be able to search by a field in the subform and link it to the main form and subform. So if I were to search by sub...
Hi,
I've got a hyperlink field with a browse command button to locate a file. It all works dandy except when i click on the file link nothing happens. if i type in the file path rather than ...
I'm trying to create an Access 2007 form that allows a user to work on the content of an order (tables stored in SQL Server Express). Because I want to allow the user to "change their mind" an...
I have a form - frmMain I am using for data entry. Simple, 1 text box, 1combo to look set an entity type.
Then I have a subform fsub, which shows the same two columns. I can add data and it...
How can I call an MsAccess form's subroutine or event from another module?
In VB6, I can declare a public function in a form, and call it from elsewhere. In MsAccess, I don't know a way to...
I am working with Microsoft Access 2000. The porblem I am expericing is with a subform. I am trying to use the gotorecord method to move to the next record in the subform. When I run the co...
I have an Access 2003 Porject using a MS SQL Server 2000 database, and am encountering a strange problem. I have several forms that use either checkboxes or radio buttons to collect user input...
I am making a form, on which I will have several fields. I am interested in receiving help on 3 of them in particular. Each of the 3 will be combo boxes (drop-down lists). I want to be able to...
Hello I'm using Microsoft Access 2003 and wanted to know how to get my "Control Panel" form to come up when you open the database. I would like for it to work like the Northwind example datab...
Am I missing something, or is there no way to display a split form as a subform? When I do that, only the single form view is displayed. Is there any way to make it work?
If I did this stuff more than once a year I would not need to ask such elementary questions:
I have a subform listing records and the only field in each record that is enabled is a check bo...
I work with an application that provides user data over the web. The data comes up in a small popup box which when copied into excel looks as follows:
Column 1 Column 2
---------------...
Hello,
I am fairly new to Access, so sorry if this is a basic question. I have a button on a form that runs a little process to add some values from that form to another table and refreshes ...
Ok so I have a form that currently has all the numbers on it i need to perform the "Look up" that I want to do. so here is the nuts and bolts of it. this for basicly came into existance becaus...
