Search results for query: *

I have a formula on a subreport. When I right click on it I don't get any summary options. I have seen some sample reports where they accomplish this task but I can't figure out how to do it. this is my formula extcost = {Part Stock.QTYOH_06}* FetchNumberVar ("price")

I have a form that data is diplayed on the following way APPLES SPANISH APPLES ENGLISH APPLES BRITISH I would like to be able to select aples spanish and to show only this record on the next form and not the other 2. Is this possible in access. thank you for any suggestions

Is it possible to run an access 2.0 query from an acces 97 using query def. Can someone please help me out. The tables that this query is using are in access 2.0 thank you

I have text file that imported into access using the DoCmd.TransferText acImportDelim, "LABOR IMPORT SPECIFICATION", "LABOR", "O:\LABOR.TXT", 0 This textfile is created using a software called scan books, so all the forms are scanned and the information goes...

I have imported a textfile this is is sample of the TEXT FILE MAY, 5 ,2001,Rocky, ,5555, T 89 I have a form with the following event to remove blanks but it is not working properly when I view the table there is still space on space in between for example T 89...

Sorry everyone I am posting this one againg, I don't think I explained too well the first time I posted it. I apologize.I need to be able to store the line number in the database everytime the user enters and order on a subform form. I need to store in a database because I will be using crystal...

I have database that was created a while ago. Because of some new reports that need to be produced I need to add a line number to the database. I basically have two questions. I tried to add a field lineno to a table with index duplicates ok but I could not save the table it kept changing to...

I have search form. When the user cliks any of the record I would like to be able to go back to main form with the record they selected. I can't seem to be able to do it with the following code. My main form has two subforms. The main form is boud to 3 tables since there is two subforms. I just...

Can anyone please help me create the code for an edit button on a form with 2 subforms or please suggest some samples that I can look at. When the form is loaded the record is locked. thank you all you

I have a form with two subforms on it. Every time that I click on the id which is a list box I get the following error messge, the record can not be deleted or changed becasue table cco detail includes related recods. All I am doing is selecting a record from the list box . What can posssibly be...

Can you call a crystal report from a button on an acccess form. Thank you for any suggestions

How can I solve this problem. I have 2 tables linked by id. Link is one to many relantionship. I created the form and the subform using the form wizard. The suborm is datasheet. What is happenning righ now is that sometimes the record on on the main table won't have have any reocord to link for...

Can anyone help me figure out what is wrong with this select stament. If I take the last line out, everything works but I need the last line. Is there a syntax error that I can't see . Any suggestions please Set dbs = CurrentDb Set qdf = dbs.QueryDefs("TEST") strsql = "SELECT...

I have form with a calculated field on it. It should calculate the values from the subform. The way the tables are stored are as follow It is one to many relationship ID TOTAL TIME (FORM) 12345 35 ID CODE TIME (SUBFORM ) 12345 A 15 record 1 on...

I have a form with a calculated field. Under the control source of one the fields of the forms I have a formula. Can the results I see on the form be stored on a the table. Maybe this is not the best design but my boss wants to see the results on the form and the table. any suggestions, help...

Is it possible to select a table from a database at run time and do a cross tab on the table selected. Help please thank you