Group:  Microsoft Access ยป microsoft.public.access.forms

Geek News

Threads Replies Last Post
612 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  
funeral check list
funeral : guest lists. car lists. floral. food....
2 12/13/2008 5:59:42 PM
When A User Brings Up Access, Is There A Way To Hide The Office Access background?
Hi, I have an access database application and I would like to hide the actual program so the user can only see the form he is currently on. Is that possible? I really hope so......
5 12/13/2008 4:06:48 PM
TabControl "Button" style broken?
I change the Style property on a TabControl from Tabs to Buttons but the tabs still look like tabs, not buttons. If I open the database on another computer, they look like buttons as they should. I have unchecked the "Use Windows Themed Controls" option. Any idea what is happening? ...
2 12/13/2008 1:38:26 PM
Prevent duplicates - 4 fields together
tblInspections ---------------- InspectionID - Autonumber AddressID - Foreign key InspDate Initials InspTypeID - Foreign key How can I prevent the user from entering a new Inspection record with the same combination of Address, Date, Initials, and Type as another? -Brad...
4 12/13/2008 6:35:33 AM
Click record to open form
How do I click on a record and have it open that record's form?...
2 12/13/2008 3:43:16 AM
syncronizing forms
hi I want to synchronize two forms that have the same record source one data sheet the other single form in an unbound form I used this code in the load event Set ajobs_sht.Form.Recordset = ajobs_form.Form.Recordset I'm getting run time error 424 object needed i'm using access 2003 is there another way to do it? or can it be fixed thanks ...
4 12/13/2008 2:45:21 AM
how many subforms?
I'm trying to set up a new form incorporating data five separate tables. 1 - tbl sample (location info) 2 - tbl pool (site info within a location) 3 - tbl sample type (collection technique used at a site - we use several at each site) 4 - tbl fish taxonomy (nickname (=FISH_NAME), genus, species, ETC) 5 - tbl fish count (number of fish at a given site within a location) The first three...
2 12/13/2008 12:57:36 AM
When I open a form, I get a dialogue box that says "enter paramet.
When I open a form, I get a dialogue box that says "enter parameter value" for a field that I deleted from a table used by the form subsequent to creating the form. I want to get rid of the dialog box....
3 12/12/2008 11:22:01 PM
Form pop up at open of a form . . .?
I would like to set a form to open up with a pop that asks if they would like to go to a new entry screen or not. If they click yes, it does so. If they click no, it opens as if they never had to deal with the pop up question. Is there a way to do that in Access 2000? -- Thanks and God bless you and yours, Gabriella777_2 ...
3 12/12/2008 10:30:10 PM
Max Function in Row Source Coding
I am having a minor problem with some coding I have for the Row Source in a database. The current code is based on filtering the dropdown list an the last month's data: SELECT tblA.REVCENTER, tblA.FACILITY, Sum(tblA.TOTAL_AMT) AS SumOfTOTAL_AMT FROM tblA WHERE (((tblA.MONTH)=DateSerial(Year(Date()),Month(Date())-1,1))) GROUP BY tblA.REVCENTER, tblA.FACILITY HAVING (((tblA.REVCENTER) I...
3 12/12/2008 10:02:07 PM
Conditional Formating Question
Hi, what should I put in a text box "equal to" if I want a condition work when the control value is equal to NULL? Thanks in advance, AK ...
4 12/12/2008 9:34:28 PM
Global Error Handling?
I know you can handle errors using the On Error process within Functions and Subroutines, but is there a way to say that if an error is encountered on any form, report, etc then go to one common function to handle it? Thanks!...
4 12/12/2008 9:12:57 PM
Access Form automatic scrolling
Is there a way to have an Access form automatically scroll down as fields are filled? Thanks in advance for any assistance provided -- Byron Gomez...
8 12/12/2008 8:55:01 PM
Pull Down Coding Not Working Well
I have two boxes, Search by & Search For. Search by has the topic, such as company name, then search for shows the records based on search by. When you select it, it takes you to that record. However, while back, it started become glitchy. Now, all of a sudden it gives me this error message every so often: The only way to fix it is to close the form and reopen it. I think somethi...
5 12/12/2008 7:14:03 PM
Random form presentation
I need the ability to randomly present records to end users who are utilizng the same form. I would like to avoid the possiblity of two people working the same record at the same time... Thanks, -- Chris Unger Analyst - Tyler, TX...
6 12/12/2008 5:00:47 PM
Lookup not showing records, also captions not displaying correctly
Hi, We are using Access 2007. I wasn't sure if this should be posted to the forms group, or queries, so please let me know if I should repost to the queries group. I have a form with a query as a source. There are many lookup fields used on the form - these were created through the lookup wizard in the table design, not as combo boxes on the form. The fields are not showing the ...
5 12/12/2008 4:35:01 PM
Linking Subform Error
If this question had been answered I do apologize..I read through the questions and I still cannot resolve my issue. I have 2 tables - dist id field and customer field. I am trying to create a form with 2 subforms.... in the first form the use selects a district id and district information is displayed. using the selected district I open form 2 to display customer information for the ...
4 12/12/2008 4:30:44 PM
Triggering a sub-form linked to the record
We have a form that has a drop list that contains a value that when selected will activate a command button. The sub form has a field that links to an identifying number on the original form. I need to know how to activate a button based on a combo box selection, How to keep the button deactivated for all other options, and how to link the field on the main form to the sub form....
1 12/12/2008 3:47:01 PM
Combo Box to open forms
On my switchboard in access 2000 I want to have a combo box that when i click a value it will open the a form. I imagine that it is easy but everything is hard for me. Thanks in advance!...
6 12/12/2008 3:45:38 PM
Tab with 'X' in it - Access 2007
Is it possible to get the tab controls with x's in it like in Windows Explorer 7? Now it is just 1 'x' and it is in right of the screen...
4 12/12/2008 3:30:24 PM
form to form
my many form is called sales and my one form is called inventory. after I enter a value in my many table field called ProductCode how can I get the related field in the inventory form ProductCode to show up-...
2 12/12/2008 3:23:02 PM
Special Object
Hi guys, How can I created an object to select record, like the ones used to choose the records to create reports in access, those that you select the record from a list, press the arrow and the record move to another list to the right and those to the right are the ones you are working with, you can also return the record to the left list. Any help will be appreciated Thanks ...
2 12/12/2008 3:11:01 PM
Create a form with fields from multiple tables
How do I create a form for each record in a table that also pulls information from other tables?...
2 12/12/2008 3:10:05 PM
Align Controls by Center or Middle
Is it possible to align selected controls by their middle or center (as in other layout programs)? This is possible in Excel Userform Design.. Thanks, Matthew Pfluger...
1 12/12/2008 2:38:03 PM
Printer Issue
Hi All, I have an access database in which I need to print to a specific client auto created printer. It's not the default printer. In Access i can setup the specific printer. However everytime the user logs in via Citrix their printer is assigned a "session #" following the printer name. This breaks my setting in Access. This is a remote user and they are not on our local network. Otherw...
4 12/12/2008 1:00:25 PM
612 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net