Search results

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...

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...

thanx much! works great. thanx again!

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 &...

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...

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...

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...

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]...

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...

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...

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. :)

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...

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

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. :)

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...

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...

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...

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. :)

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

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. ;)