Search results

  1. M

    Issue with Clients use of Add/Edit form

    My issue has only developed as a result of a new person using my existing database program. My other employees understand how the Add/Edit function works, but this person did not; even after having explained the process. I can't seem to find a way to resolve the issue on my own, hence this new...
  2. M

    Property Sheet Issue

    this will probably be an easy fix, but for the life of me I can't seem to resolve "it". In the design mode of a report or form, the property sheet and add existing field used to stay "attached" to the report or form. However, now both the property sheet and add existing fields boxes act as pop...
  3. M

    Pop Up Form Issues

    My database has a main contact form [Architects] with a Contact button, which, when clicked on opens up an [AIAContact] form. I can search the [AIAContact] form when it opens up in “standard” mode, for example the contact name, but I can’t search it when it opens in Pop Up mode. Any ideas...
  4. M

    can't change anything in query property sheet

    I must have clicked on something to cause this but Suddenly, I can't change the property sheet values in any of my queries. As you can see from attached (.jpg), all the fields under "General" tab are empty, and yet, this particular column has the title "TSDQ-1" as it's column header. I want to...
  5. M

    query stays open when form is closed

    This has never happened to me before. Top left corner of attached (.jpg) shows the (4) buttons which I created in an idential fashion on my main form. The only time the "issue" arises is when I click on the "ASI" Button...the other three buttons work properly. When I click on the ASI button...
  6. M

    Empty Record in subform

    Not sure if this is anything that can be fixed but it's kind of annoying when my database users are looking at records. I have attached a (.jpg) illustrating the issue. I have a Project quote system which aligns each quote for a project (In this Case JT #76925 is the Project number) Each quote...
  7. M

    Change text in error message

    I have a table with a field, [Job Process].[JPGopher_ID], which requires a value in the field. The form I have developed for my users has the label, "By Whom" instead of [JPGopher_ID], which makes more sense for the users. Unfortunately, the error msg that pops up (see attached .jpg) states...
  8. M

    No query results if Field left blank

    I have set up a simply query as shown in attached (.pdf) [specjobs] is my main Project database, [Job Process] is where the users put their project notes. [Architect] is a database containing Architectural Firms that would be involved in the design of the Project The way the query is set up, I...
  9. M

    Data Not Visible In Only One table field

    I have never run into this issue before today. Please see attached (.pdf) I have imported data from Excel into my existing database as a new table. I take the data from the table and have to modify it somewhat to use it properly. One field is [ASI_mfg]which can have any one of (9) different...
  10. M

    When Clickbox is checked-automatically enter text into another field

    See attached (.jpg) I would like to have one field filled in with a specific text depending on which checkbox is clicked. In the attached example, I would like the [Which Mfg] field, filled in automatically with "Special-Lite" when the [Spec-Lite] checkbox is checked. If the [Select] checkbox...
  11. M

    Compact and Repair database Option not working

    I backup my MS Access 2007 database every night. When I went to open the copy I backed up on Tuesday night, all my macros, table and forms did not show up! I copied over the macros, tables and forms from my Monday night backup and the program started running again. Unfortunately, when I copied...
  12. M

    Issue with subform when Main Form is filtered

    The (B4-Filter.jpg) attached is a screen shot of my main form with 2 sub-forms, one on the bottom left and one on bottom right. This issue I am having has to do with the bottom right sub-form, under "Dodge Status Notes Shown Below" When I work with the data in the main form, many times I...
  13. M

    Today's date less one year query

    I have a number of quotations that I would like to follow up on and I want to base it on all quotations from the date the query is run, going back one year. I know I can manually set the query up to input a date range, but I'd like the query to run and automatically go back one year. For...
  14. M

    Issue Opening form when special character involved

    I previously had an issue using a button to open a form when the Customer name had an "&" special character in it's name, i.e. Jones & Sons. I solved that by writing following code: stLinkCriteria = "[ EUContact]=" & Chr(34) & Me![ EUContact] & Chr(34) I have run into the same issue...
  15. M

    How to save report with a specific name each time

    Currently when I go to save a report in (.pdf) form to email out, the default file name to "save as" is always: "rpt_SL_Job_Notify.pdf". This is the name of the underlying report I created. (see attached: Save_Document-1.jpg) What I would like to have happen is to have the default file name...
  16. M

    Help with DELETE query 4 unmatched records in 2 tables

    Please see attached (jpg's). One shows the query code which when run displays the records in table [1Dodge Download Note T] that do NOT have a matching record in table [specjobs]. I assumed I could just convert this query to a DELETE query and it would DELETE the records that were pulled up...
  17. M

    Open a report based on contact name

    Sorry for the lengthy description but I hope to make this issue I am having as clear as possible. I have a report that I have developed which is associated with a contact's name on an "AIA Firm Contact form". The only way I can currently get the report to open and only show that contact's info...
  18. M

    "Order by" issues when opening a form

    I have created a form (see attached form.jpg) that is opened by a macro. I have set the "Order by" criteria to be: "[specjobs].[Rev_Rept_Date] DESC" (as shown in SortOrder1.jpg) This criteria opens to form correctly time and time again UNTIL I have sorted the form, when it already open, by a...
  19. M

    Separate lines in Msg Box

    I have attached a Msg Box that pops up the way I want it to in my program, with one exception. Is there anyway to have "Do you want to continue?" be shown on a third line? Here is the code line that handles the actual Message: Msg = ("ATTENTION: The Next Form Which Opens Allows Editing of...
  20. M

    Use msg screen in a specific instance in a subform

    I have a subform that pulls information on an item up after the item number is entered. If you follow the (.jpg) I have attached: 1=Enter Qty of Product 2=Enter Product # Once those two steps are completed, everything to the "right" is pulled up automatically. Step 3 allows the user to pull up...
Top Bottom