Search results

  1. C

    Ignoring blank fields

    Sorry Ruralguy i started to type reply and had to leave computer. Should have refreshed screen to see if someonelse had already posted. Don't mean to leave same info twice. Ash
  2. C

    Ignoring blank fields

    How are you copying data from fields. i.e vba or expression. You need to put more information in the forum. Ash
  3. C

    start date and an end date

    Have a look at the assest tracking template that comes with access. In report section on switchboard it has what you are trying to do. Look at it in design view look at the queries look at the vba code. Ash
  4. C

    How to populate a field in a new form

    i don't quite understand what you are trying to do. Do you want the form p1 or p2 to open when you select the ssn or do you want it to appear on the search page. Ash
  5. C

    data tranfer from one form to another without storing data in db table

    I made a mistake when i said code i ment property fields for *required field* However by making the tab invisible it allows you the adminstrator to have more control. I believe that this is for a survey db. (i could be wrong) if so then i would make the tabs invisible. If it where for simply...
  6. C

    dlookup in a form

    You need to specify table and form. Perhaps a little more info as to what is the table name, form name and the object that is on the form. For example if weekday and counter are fields that you want to check on the form currently open. You would use if me!weekday = 6 then me!counter =...
  7. C

    Pop Message in form based on query results

    This can be done. It would take alot to explain. You need to use code "isnull" command. Without object names or what triigers the code i can't really offer code suggestions. Ash
  8. C

    data tranfer from one form to another without storing data in db table

    Ceh The reason i suggested the code is that usually in questions and answer forms you don't whant your user to skip pages. This code allows the user to answer a page at a time. If it was me i would put further code in to make sure all required fields are filled in before it would let you...
  9. C

    data tranfer from one form to another without storing data in db table

    ok 1st create a form in design view. then click on propeties of form and bind it to the table that holds records. then on toolbox select tab option. it usually alows two tab pages. to insert more pages just right click insert page. you will have to play around with sizing. when you bound the...
  10. C

    How to assign a row a number? Help please!

    Try creating two tables one for students and one for course. Then create a table for both information setting the relationships you will then be able to set a primary key on both Ash
  11. C

    data tranfer from one form to another without storing data in db table

    why doen't you create a continous form. One form with many pages. Put a command button at the bottom of each page that continues to next page. Simply one form that saves to one table Ash
  12. C

    dlookup in a form

    Bascially the same as above but this sets string filter Dim strfilter As String strfilter = "driverid = " & Me!driverid 'driverid is the primary key for your drivers table Me!txtdepot = DLookup(Depot", "Drivers", "FullName" strfilter) Ash
  13. C

    Queried in Forms

    i would first make a 2 queires 1) that gives you all the information that you want un filtered. Then 2) create a query that has filters based on the form.(create an unbound form with the drop down boxes that you are after to filter query). Then down the bottom create a print button.(that will...
  14. C

    Close a form after all report have printed

    the only way i could think is to cancel the close form and instead put in an message box that asks the user has all forms printed. If the user clicks ok to have the code close the form. hope this helps ash
  15. C

    Pop Message in form based on query results

    what code do you have currently ash
  16. C

    Basic Form Help

    yes you need to create a relationship between the two tables. Both tables should have a supplier id. In the supplier table the supplier id needs to be the primary key. Hope this helps Ash
  17. C

    Problems with subform

    Ok i have a prob. When updating a field in subform i get the error message "form cannot be updated" the i click ok and it updates the from. the whole project works i just am getting annoyed by this message. i have no vb code that would becausing this and have no records locked. any help...
  18. C

    How do I use submit button to add details to a table?

    Yes this can be done: first use the wizard to make a form based on the table(add all objects) on form in design view create drop down boxes that use a query to look for products already existing in the table. After you have done this use the command wizard button to save form, rename save to...
  19. C

    I want a form like in Northwind sample database: Summary of Sales by Year Report.

    i need a little more information on what you are trying to do. thanks ash
  20. C

    Visibility of Forms

    On main form: on form_load set me.subform.visible = false then on the control box that you want subform revealed set after_update me.subform.visible = true Ash
Back
Top Bottom