Search results

  1. A

    .IDB Creating

    So I have split my database, and have a couple of front-ends accessing the back. The problem is that when one of the front-ends is opened it is creating a lock file, preventing it from being opened again. The front-end can still be accessed if I open access and open it from there, however, I...
  2. A

    Filter

    Wanting to make a filter that looks in multiples fields for a set word. For example a "cat" filter, where if the word cat appears in any of 6 designated fields, it would filter to those results. I have been using me.filter = "[field1] = 'cat'" filteron = true but I am unsure of how to...
  3. A

    Opening Pop-Up Form From Sub-Form

    So the structure essentially is view only form from tbl_data. Then a subform to set the characteristics of that entry referencing tbl_chars The characteristics are all yes/no except one, which is a memo. The memo is triggered if yes is answered as one of the chars. How I want it work is a...
  4. A

    Dynamic Invisible fields event

    Forms are being used for survey entry. Some fields are visible/invisible based on the input of other fields. For example, question 1b only turns visible if 1a is "3". My issue is actually with tabbing. Because I used LOSTFOCUS as my event, the tab already occurs before field is visible, even...
  5. A

    Open form carrying forward data

    Here is what I would like to do. I have a "client center" where you bring up the demo data on a client. On frm_cli_center, I have buttons to open 4 different forms. When a button is clicked, I would like it to open the form, carrying forward the empl_id of the current record on the client...
  6. A

    Search, if no record - pop-up

    So I have a search function that work great. However, now if my search returns no results, I would like to have a pop-up that tells the user no results were found. (Ideally I would like to from the pop-up to ask them if they want to enter the user, but I don't think that is possible) Here is my...
  7. A

    Report open without data

    Opening my report from form: DoCmd.OpenReport "rptcurrent_openings", acViewReport, , , acDialog Then on the report itself: Private Sub Report_Load() DoCmd.MoveSize 28000 DoCmd.Maximize End Sub When the report loads, no data is there. If I scroll over, then everything appears. Otherwise...
  8. A

    Filter Report

    I have report 1, which gives basic information about job openings, sorted by position, then it lists the employer, # of openings etc. On report 2 I have the requirements that the employer has sent us. User would start on report 1, then click button which loads report 2, filtered based on...
  9. A

    Creating a template

    So I have always done this the long way. Lets say I have a theme for my reports/forms. Green header, certain font, etc. I have always just set the properties of each individually every time I make a new form/report. Something tells me there has to be an eaiser way, so that when the report or...
  10. A

    Display fields if not null

    I have about 25 fields on a form all locked. If any of the fields are null, I do not want that field to display. I was able to create this on one field by attaching it to the on load event, however, I am not sure how to add the other fields. Thanks! Private Sub Form_Load() If...
  11. A

    E-mail Selective Report

    So I have done things like this, but never this exact scenario and cannot figure out how to design it. I have a report that is displaying a department, and a list of students who meet X criteria in that department. What I want to do is this: E-mail the report to the department where students...
  12. A

    Selection

    On my table I have 12 different locations, each location have 5-20 providers. I need to assign a provider to a client (one to many). On the form what I would like to do is first select a location, then have only the providers at that location populate in the provider box. Then when the location...
  13. A

    Question Separating Bio Data Into Separate DB

    3 different programs run on the same set of biographical data. These programs perform surveys and track participants progress. Ideally I wanted to create three separate front ends so that each program could be customized to fit the specific needs. However, the front ends want to be able to come...
  14. A

    Splitting The Database

    So here is what I am thinking about doing, I just want to know if a) it is feasible b) anyone has done it that can tell me whether I'm going down the wrong path So I have one set of demographic data. However, for many of these people they are involved in 3 programs (A,B,C). Sometimes one...
  15. A

    Open In Design Mode

    So I know that someone can hold shift to open in design mode. What I am wondering is if there is a way to always open access databases in design mode. Thanks
  16. A

    Save Button On Form

    Form is used to "check" out customers from an auction. Field "payment method" is selected on form, and report "receipt" is printed. For some reason payment method does not update instantly after selection, and requires me to basically go from one customer and then back and then when I click...
  17. A

    Data Type In Calculated Field

    Select query pulls in two fields from same table, both are currency type fields. Then I have a calculated field in the query finding the difference between the two, but the output is not currency. Is there some way to make the calculated field a currency data type?
  18. A

    Lookup Source

    Here is the basic layout of the data: There are 4 tables, 1. Dept (contains a list of departments) Key: DID 2. Contacts (A list of people who work) Key: CID 3. Dept_Cont (Links CID & DID) Key: DCID 4. Assn (Assigns a DCID to existing data) What I am wondering is how to make DCID in the Assn...
Back
Top Bottom