Search results

  1. T

    2 min Help Needed very simple 1-Table 1-Query

    I haven't touched Access in a long time and can't seem to get started. I have the following report to produce. See attachment image. I'm pulling the data from a list in SharePoint. My table is called Assignments and I have the following fields; Category = "Legislative Communications", "Media...
  2. T

    Subform Help staying with current record

    Good morning all, I'm trying to use a subform and I cannot get the Position combo box on my Post survey form to sync with my current record. (Works great on the pre survey) Simply put, the combo box is pulling all positions from table and I need it only pull the data from my current record as...
  3. T

    Linked Combo Boxes - Need Help Please

    Hello World! Looking for Combo Box guidance please. A while back I posted a message (Combobox Brain Poot) and received lots of assistance linking two boxes. That scenario is still working great to this date. However, mgt. is now asking me to create three new linked combo boxes. (unrelated to...
  4. T

    Hide a From

    err...that's "Hide a Form" I am using Ken's code: http://www.access-programmers.co.uk/forums/showpost.php?p=454581&postcount=8 and wanted to know if there is a simple way after the user enters the dates for the form to automatically close? It works great, but is a little annoying blocking the...
  5. T

    Combobox Brain Poot

    I'm using Access 2003 and want to display a series of items in a drop down list. They are codes (A, B, C) For code, A = 2 (these are for two days) B = 3 (days) and C = 4 (days) The values (2,3,4) will not be visible to the user. I then want a text box displaying today's date. Lastly a...
  6. T

    How do you do a simple Push/Pull on 1 page

    I want to do this <see attachment> How is this accomplished on one ASP page (not .net) It seems that if I create a form, I cannot pull from a database. Please help.
  7. T

    IIF number exists, then subtract

    (hard being a rookie) On my Form, I want to have a query look at one specific field for a number (1). If the number is found then I would like to have the query do basic subtraction on two other fields. (one from each table) What I have so far is one unbound text box with the following...
  8. T

    ACC2000: How to Create a Password Protected Form or Report

    Article ID : 209871 Last Review : June 23, 2005 Revision : 3.0 I'm a rookie, and found this code on the MS site. I followed the steps and it works great. I am only protecting one form and it does what I need. Very simple. My question is, how in the wild world of sports do you change the...
  9. T

    How do you add two fields and return a message?

    I know I have seen it somewhere... and yes, I am a rookie. I have built a report that uses a sub report. My dream is to take a field from the main report section and match it against a specific field in my subreport. (Main Report) Box A (numerical value) (Sub Report) Box E (numberical value)...
  10. T

    Rookie Needs Query Date Field Help

    I have three tables. Each table has the following TblAA - aaDate, AAFS, AAFT, AAFU TblBB - bbDate, BBFS, BBFT, BBFU TblCC - ccDate, CCFS, CCFT, CCFU The "xxDate" fields are (mm/dd/yyyy) all other fields contain numerical data. (1,5,10 etc.) I have linked the tables and it returns all of the...
Back
Top Bottom