Search results

  1. M

    Cleanup Blank Records?

    I have a normalized database (SQL) and Access for UI (forms/data entry). When I add a new sub-record, ie a form - subform record, it starts another record, and then there is an extra new record. It seems that if a user starts a new record, but then abandons it, a record is created in the table...
  2. M

    On Combo Change - If New Record - Save In Place?

    I have form, where there is a combo that is first in line, to be set, on a new record. When that combo is changed (Change event), I want to check if we are on a new record. If we are, I want to save this record, and refresh some unbound textboxes, which are set on the form's Current code. To...
  3. M

    Set Unbound TextBox OnCurrent - Run-time 2448 Error

    I have the following onCurrent code, for a form, so I can set 2 unbound text boxes to create a dynamic string, for the user. The code checks if the form is on a new record. If so, it makes the 2 unbound text boxes be blank, so they don't show #Name errors. That is what you see, if none of the...
  4. M

    Access VBA Property Function - Subform Source Object Name?

    I received help on determining the active page of a tab control, by having the following code included in a form module: Property Get ActivePage() As Access.Page 'PROPERTY TO IDENTIFY WHICH TAB WE ARE ON, FOR FILTERING AND IDENTIFYING WHICH ACTIVE LISTBOX TO LOOK AT, FOR VALUES AND ACTIONS...
  5. M

    Cover Form Controls - Hide Form Operations?

    This application is Access 2010, with a SQL backend. I have a form, which has a tab control, with 2 pages. 1 page has 1 listbox and the other has 2 listboxes. I use some code, on change of the tab control, to determine the active page, and set the listbox(es) row source(s) for the one(s) on the...
  6. M

    Back and Forth Navigation between Access Forms?

    Forewarning. This is a very general question, though I will explain what I'm working on, to give as much context as possible. I'm looking for different ways people are handling the need to have the ability to jump back and forth and all over to different forms in an application - basically the...
  7. M

    SQL Rowsource Doesn't work in Access Query - Empty Combo?

    I have a combo box, that has the row source set by vba with a case statement on change of a different combo. Based on the selection of the first combo, the entire row source is set to a sql statement. For 4 of the 7 options, I have the row source working and populating the 2nd combo...
  8. M

    Mass Import PDF Forms

    I have a fill-in pdf form, with fields that match database table fields. My database is in SQL, but I use Access for the forms and reports. The users will go on-site (and be offline), fill out the pdf forms a bunch of times and come back with a folder of them. I am looking for a way to...
  9. M

    Average Cost Per Gallon by Grouping and Report Total Footer?

    I have a formula, but it is not calculating correctly. AvgCostPerGal: IIf([txtCarCostType]="Gas",IIf(Sum(Abs([tblCarCost]![FKCostType]<>6)*[tblCarCost]![CurCostAmount])=0,0,IIf(Sum([intGallons])=0,0,Sum(Abs([tblCarCost]![FKCostType]<>6)*[tblCarCost]![CurCostAmount])/Sum([intGallons]))),Null)...
  10. M

    Check if subform record exists before update / after update?

    I have a main form for entering new projects (cases). There is a subform that has a key table as it's control source. The key subform is for linking a case to Assets (or media received for that project). There could be a CD, DVD, etc. Each of these assets can belong to multiple cases, which...
  11. M

    Set Subform Controls Visible Based on Combo

    On a subform I have a combo (cboType) Based on the selection of that combo, I have certain controls on the form that should be visible and the rest false. I created a Case Select statement on the after update of that combo, to set the subform controls visible and invisible. A couple of...
  12. M

    Custom Search Form to Search All Records?

    I found a search form online (I think on one of these FAQs) that you can click a command button on an entry form and open up. You have the fields available for search on the top, and you can enter criteria for one or more of those. Then there is a bottom half, which is a 2nd form that shows up...
  13. M

    Reports from Form strwhere Date - subreport?

    I have a reports form. On this form, the user chooses the report that they want, by the first option group. Then they choose a date option on the second option group. They can choose today, to enter a date, a date range, or all dates. Then the "get report" command button opens the report, and...
  14. M

    Case Select - Report OnOpen - Date Range ?

    Hi, I am having some trouble. I am using a select case with option groups on a form. The first option group (grpReportType) on the form passes a variable to the button on the form (cmdOpenReport - onclick), to choose what report to open. In the report open code , I am trying this Case Select...
  15. M

    Locked main form - validate 1 subform with another?

    I have a main form that has 3 fields. They are all locked fields, only to show the user the "person" record that they are looking at. They update to subforms on a tab. The first subform is activities (like from a mailing - received return no forwarding address, received updated address...
  16. M

    referential integrity causing problems on only 1 table???

    My db is an inventory of printers in use at our company. It is to tell us where they are, and what maintenance is done on them over time. I have the following tables: tblIP* tblLocation* tblMaintenance tblMaintenanceType* tblMake* tblModel* tblOffice* tblPageCount tblPrinter The ones with...
  17. M

    I've never passed a variable between forms... this is a first!

    :D I have a form set up where a user chooses a page tab. Either statistical reports or detail reports. Then they have to choose between 2 toggle buttons. Candidate or hire. So a user chooses detail, then candidate. An option group below that shows the different groupings of detail...
  18. M

    Setting Up good report menus for end users - a lot of reports!

    I am working on stream lining reports for my application, so that I don't have a huge maze of menus. I am open to any ideas of how to best set this up. Right now I have a report menu with about 8 command buttons. Some take them to a criteria form for that report, others straight to the report...
  19. M

    check data on leaving a RECORD- record, subforms and all

    I have an application that enters candidates in, who apply for a job. I found that I can enter a candidate in, and if I dont enter at least an address type or phone type ( giving that candidate an address record, albiet a blank one (just a type of address) and a phone record) then the candidate...
  20. M

    report groups not grouping right???

    I have a database, and I am looking to add a somewhat master statistical report. The database is for candidates that apply at my work, for a job. The statistical report will be for counting who we have hired. The factors are what department they were hired to, what office, and what candidate...
Back
Top Bottom