Forms
in [Access]
|
Setting up Price Quote to go to Purchase Order Hello, I would like to generate purchase orders from my price quote form (frmPQ). On the price quote form is price quote details (frmPQDetails) (continuous form). The price quote details lists all of the items that the user has chosen to be quoted to our customer. Each record on price quote details will contain t... 25 Mar 2010 11:30
Can you add a Tab Control on the page of another tab control? I have I would like to add a tab control in the page of another tab control. I when I run the form the internal tab control works fine but the control is visible on other pages. I have had this problem before of controls being visible on other pages. I have fixed the problem by deleting and recreating the co... 25 Mar 2010 12:39
Form Security Thanks in advance. I'm using 2003, I've set up security, I want to prevent a specific user from being able to modify specific fields in a form that opens up in datasheet view. I've attempted the following behind the form & it's not working: Private Sub Form_Load() If CurrentUser() = "blackman" Then M... 26 Mar 2010 19:15
Open one form with different queries Is it possible to open one form using a different query depending on what button the user selects. For example: Sort High/Low Sort Old/New Search MRN Search Account# Search SSN I should also mention that this form has a subform. ... 24 Mar 2010 17:03
simple can't find form question I have a form with some simple code behind it which reads like this: with Forms![frmNextFixtureTypeOption] .[lblNextAlpha].Caption = strNextAlpha .[lblNextNumeric].Caption = strNextNumeric end with stDocName = "frmNextFixtureTypeOption" DoCmd.OpenForm st... 24 Mar 2010 18:11
Compound Index I have created a compound index on a table that does not allow duplicates of two fields match. When a duplicate match is identified when inputting a record on the form, is it possible to replace the long standard error message assocaited with the compound index with a smaller one? ... 24 Mar 2010 11:12
Grid control only displays 1 record I have a form with a subform that has a grid control. If I run the sql for the recordsource of the grid control in an access query, many records are returned. However, only one record displays in the gridcontrol. ANy assistance appreciated. ... 24 Mar 2010 15:52
Passing values of listbox to other form's combobox I have a form(frm2), in which i use a listbox(list1). The listbox is blank and it takes values from ather text boxes and comboboxes through vba code. All i want, is when i push a button, to move the listbox values to a blank table tbl1. In another form (frm2), i am going to use a combobox, which must have as row... 24 Mar 2010 08:53
Error 3021 but records exist Hi all, When I try and open a report I keep getting the 3021 error. It's specifically one group of records (vehicle bookings in the 'Area Office Pool'), selected thru the second of two combo boxes on a form. The first combo box filters by suburb. Yet when I run the query (which is the recordsource for the re... 24 Mar 2010 00:02 |