Search results

  1. BadKitty

    carry certain data from 3 forms to one printable form

    more info about my DB thanx for getting right back to me. all the forms will still be open at the time the permit will be printed, so this seems like my simplest option. i'll play around w/the info you gave me, but i'll also attach my database so you can see exactly what i mean. again, much...
  2. BadKitty

    carry certain data from 3 forms to one printable form

    thanx...a bit more info please thank you both for your suggestions. :D i apologize for being pretty much a novice & really apprecaite your help. CEH i've created the queries you suggested, but i'm not the one who will be printing the permits. i don't want the users to see the query at...
  3. BadKitty

    combining 2 buttons

    thanx much! works great. thanx again!
  4. BadKitty

    TRYING to create a simple select query

    xplainy not exactly sure if that's what i need. let me summarize my 1st idea: is there any way to carry specific data entered by the user from 3 forms to one printable form which is set up like a city permit? ideally, i'd like the user to be able to click on a button to open the permit &...
  5. BadKitty

    TRYING to create a simple select query

    i've created a database for city permits to be issued (which works perfectly thanx to alll your help), but now i need to be able to print out 1 permit at a time when it is issued (immediately after the data has been entered into the forms). i have 3 tables & 3 forms: contractors/owners...
  6. BadKitty

    all data form doesnt display records

    this will open the form in add mode: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmPermitOrderDetails" DoCmd.OpenForm stDocName, , , acFormAdd this will allow you to navigate through all the records: Dim stDocName As String Dim stLinkCriteria As String...
  7. BadKitty

    carry certain data from 3 forms to one printable form

    is there any way to carry specific data entered by the user from 3 forms to one printable form which is set up like a city permit? ideally, i'd like the user to be able to click on a button to open the permit & then click print after having entered all the data into the 3 forms (1st form opens...
  8. BadKitty

    printing parts of records in a specific format

    query in sql SELECT [tblContractors/Owners].company, [tblContractors/Owners].Lname, [tblContractors/Owners].Fname, tblPermitOrders.[permit#], tblPermitOrders.permitType, tblPermitOrders.block, tblPermitOrders.lot, tblPermitOrders.location, tblPermitOrders.dateReq, tblPermitOrders.[#ofDays]...
  9. BadKitty

    printing parts of records in a specific format

    query trouble k, i understand how it should work, but i'm not getting any results in my query when i include more than 1 table :confused: i've tried with & without the wizard. i get some results when i change the join type but then i only get results from one of the tables. :( any idea what i...
  10. BadKitty

    combining 2 buttons

    i have a form for users to enter contractor information (when appying for a city permit). on that form, i have a button to open the permit form in add mode & a button to save & close. problem is...when you click the permit button, whatever info was just entered isn't saved yet. rather than...
  11. BadKitty

    printing parts of records in a specific format

    thanx! thanx for both of your help appreciate the prompt response. i haven't been in work the past 2 days, so i'll give it a shot today. :)
  12. BadKitty

    printing parts of records in a specific format

    i've created a database for city permits to be issued (which works perfectly thanx to alll your help), but now i need to be able to print out 1 permit at a time when it is issued (immediately after the data has been entered into the forms). i have 3 tables & 3 forms: contractors/owners...
  13. BadKitty

    command button help!

    thanx! thanx a bunch...works perfectly! :D
  14. BadKitty

    command button help!

    i'd like to create a button on a form that opens another form ONLY in add mode. the command button wizard does not give you that option. :confused: please help! thanx in advance. :)
  15. BadKitty

    incremental validation rule

    one of my tables has a field called # of Days. the default (minimum) value for this field is five (5), which i set. however, if there is a case where five (5) days are not enough, the next value would be ten (10) since the permit is issued for 5 days at a time, and so on. can someone suggest...
  16. BadKitty

    adding tabs

    never mind - figured it out i played around w/it for a while and in case anyone wants to know..... you can create 1 big form using the wizard, then insert a tab control w/as many pages as you like. then just cut & paste whichever attributes you want onto each page. still, if anyone has a...
  17. BadKitty

    adding tabs

    i have a database that stores contractors/owners & the 4 types of city permits we will be issuing. i have created a form w/the wizard which contains all the info that i need the users to enter, however all info will not always be necessary. i would like to create a main tab with general...
  18. BadKitty

    Calculated Field

    Thank You! you've been alot of help through this whole process...i haven't designed anything with this much info since i was in school (an that was quite some time ago). appreciate all your help & patience. :)
  19. BadKitty

    Calculated Field

    primary key should the PermitOrderDetails table have its own primary key or have the foreign key from the PermitOrders table be the primary key as a 1-1 relationship for the details table? :o
  20. BadKitty

    Percent Format using code

    similar question i've had the same problem myself. i used a module to code my own data type, but was unable to apply it. any suggestions are appreciated. ;)
Back
Top Bottom