Search results for query: *

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

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

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

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

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

I have a form with a subform for detail. I want to print just one form (the one I an on) with a print button which all seems to work OK when for is exactly 1 page long. except when there is too few detail lines in the subform of the form then the next form prints at the bottom. is there a page...

I am having trouble getting records selected from a table that I need to have a price field updated with an addon pct. basically pprice=paddon_pct* pcost. MY TABLE named parts ppartno pdescrip pprice paddon_pct pcost my update query is from table parts 1st and only column defined field =...

I have a form to print and I added a button to "print this form only. it prints perfectly except all forms not just the one i am on. i verified that i chose "print this form only" when I made the button. thanks david god i love this board- you guys are GREAT

I have a form that needs to be printed. The print format is different from the form format so i need to do a 1 page report. I want a print button on the form. I could not find any properties for a print button that will sync the form to the report and only print one page of the current form...

i cannot find in the FAQ s how you do an event for the following. I have a form with calculated fields on it like tax, totals etc etc. i want to write those solutions back to the underlying table in corresponding fields of the table. it seems the only data i can get written from the form is...

i have a query input to a form. the query is made up of 2 other queries. I want to update a field in a table with the current time that the form is displayed and update a time field in a table that is the basis for the query input. how do you update a table field from a fomr when the input to...

I have a field in a table that is a ticket # it is an incremented number constant+ record ID (unique KEY) for example 4000+ID on a form i cannot get this to work i have default =4000+[ID] in data tab of properties but only 0 is ever in field thanks

I know i have seen solution somewhere on this board but i can not find it. i have a transaction subform in an order form for sales. the subform lists all the items purchased. i have a inventory file with items in it - item#, description, price, etc. how do i on the subform enter just the item#...

I have a form whos input comes from a query with a condition. if status field = "complete" then the record is not collected by the query. displayed fields have status="normal" to update on the form they select a drop down box and click on complete option of the status field. Question how do I...

i have several contastand fields "descriptions" on a from "COLOR" "EXPANSION" " ADDITITIVE" etc etc each constant above should only display if a corresponding field is not empty for example if(exp) >0 display "EXPANSION" if(color) >0 display "COLOR" etc etc i do not know the format for the...

Hi, I have a form with multiple detail lines (10 lines) each line has qty,description,price,$$extention. how can I not display lines with a zero qty. I am not a vb programmer but I need something like if(qty >0 ) { print qty,description,price, (qty*price) else { print " " } a little...

i have a form with a sub form that calls another form I want to print. the call requires matching on 2 keys instead of the one key done by the wizard. here is the created code stDocName = "CHGTICKET" stLinkCriteria = "[jid]=" & "'" & Me![jid] & "'" DoCmd.OpenForm stDocName, , ...

I have a data entry form for a job. there is also a sub form (continious) of all the work on that job as individual entries. once they enter a transaction i need to call another form that displays the customer and the selected transaction. The button wizard only gives you a single field from...