Search results for query: *

I have the same or similat issue with a unbound check box stays on after you move to the next record. I always want the check box to not toggle but be off when a record opens. my question is "onclose" and "onunload" I do not have either of those events ??? access 2003 what gives thanks David

Thanks I did not know about the F1 your comment implied i might have been asking questions incorrectly? I am sorry for that. I jump into and out of access and as last hope i do a post to the forum. I'll do the reading you suggested but i thought I was detailing the question in a polite and...

PERFECT - thanks followup -why does access not give you syntax help when you click on build event. i have tried every combo of clicking and i never get "me." or Forms!. it leads you to believe that it will format the code correctly. Calculations of fields on a form do not seem to need the...

I am trying to use the build event by RC on a field of a form. when the window comes up i get lots of options to click on that will build a command line for me. I need to understand the syntax of entering information.i need the syntax of the following when a field is changed. I have a form =...

Can you give me an eample of the jet sql code to add a record for this example table "abs" fielda="123" fieldb="567" fieldc= tableG[field7] I feel if I can get the basic format tied to real data i can take it from there. I have added VB code on a button before. I am an ol "c" coder SQL & VB...

I have 3 tables in access with NO SQL just an access DB 1 = customer table 2 = generator table 3 = location table "2" & "3" relate to ID of "1". there can be many 3s to one 2 and many 2s to one 1. I have all three on a form. when I add a "1" record I want to hit a button that will make a...

OK, that works except for one small detail if the memo field is too big for a page it still cuts off the text. is there a way to make it overflow the page to another page. there is no way to know how bug the membo field will be. it varies from 1 line to many many lines. thanks david

I have a report that prints a query with a memo field that varies in length quite a bit from record to record. For each record that prints i only want to allow space for the memo characters that exist for that record. right now my notes in the memo field either get truncated or too much white...

I solved the problem with a properties value to start a new page on detail line thanks,

I have a form with a print button on it. the 1st form print fine and then gets off 2 lines a form as you print the next forms. its as if i have too many lines on the from for the printer setup. but I have take off 10 -15 lines from bottom just to test and i still gfet the form printing wrong as...

Yes - thats exactly right. I made an enmty form, added tabs then made a subform and insert my form. it all worked except for this one field. out side of the tab it works OK. here is some background. the main table of the form is a query "job query" with a field that points to a client table...

I have several forms that I have on a menu. they all work perfect. I thought I would try a new form with tabs that each tab had loaded as a subform the indiviual forms from the menu. kind try a different look. the form on page 1 has a subform in it. i have a field in that sub form that is set...

I am not sure if this is on FAQ as i could not find a subject line that matches. I have a form to add records to a query called "jobs". hte 1st field is a key "clientno" to a master table called "clients" when they enter the clientno I want it to beep and reject the entry immediately if no...

Yes I used the wizard, everything went fine. but NO code everything seems OK as i have done this a few times.

Yes I used the wizard, everything went fine. but NO code I did goto another database and copied and pasted, edited the code and everything works - but something is causing access to not create code on this situation. i'll do some more tests and report back on this thread thanks for the quick...

I am using a combox to display 2 fields of a query used on a form. It all seems to work except that after a while making some minor form field format changes i noticed my combo box displays the list but when i click the form does not change to the selected query record. i looked at the code and...

NO how is that possible - I look in access help. makes sence like sub forms thanks

Leslie, i understand what you are saying, however in this situation its different, so I will just figure out another way to do what i need since i am unable to explain something in your terms. here let me try again. just thought of this idea! In this app. the person puts in a percent of say...

Leslie, in this situation it not applicable because we want to keep track of previous calculations so historical data is not changed. as prices change we do not wnt previous records change even though margins, costs go up and down. thanks for you input though david

i am nit sure what you mean about "lespaul is absolutely correct" we do agree? 115% is correct thats ewhy its called add_on here is the table info you ask for MY TABLE named parts partno descrip price addon_pct cost textbox with calculated field =addon_pct*cost i just need this "textbox" to...