Search results for query: *

I have an Image in a report, and I want to change the image in the report from a form. I have a drop down list of locaions of images to choose from. based upon the users choice I want to change the report. i.e. the properties ("Picture") C:\image\image1 to C:\image\image2 Thanks Walt III...

I have a date field that I want to limit to the year. I format the field in the table. however when I access that table through a query the format reverts back to the typical month day and year format. I want to limit the data by years. Thanks Walt III Walt III SAElukewl@netscape.net

I have a database that is a listing of songs, I want to do a printout of the songs in a certain order, this causes the spacing to come out weird. I would like to take the extra space and divide it evenly between the page, instead of it all being at the bottom of the page. Walt III...

when I try to declare the database variable DB to work inside a sub for a button I can not get a "database" variable it tells me: "User-defined type not defined" this is the line that I have -dim DB as Database- I have used the line before without any problems. Thanks for the help in...

I have a textbox in a report that currently has two fields from a query as the control source =[field1] & " and " & [field2] this works well except that sometimes field1 is empty and sometimes field2 is empty. How can I fix this report so that if both field's are populated then it adds the and...

I want to go to a specific, chosen by user, in one form from another. and I don't want to put a filter on the form and eliminate the other records from view. I would also like to do this without writing a small loop with if statements. basically I am looking for a "GoTo" command that allows...

I have a report that links to a report preview. I want to change one of the text labels in the report based upon a selected choice in the Form. Walt III SAElukewl@netscape.net

I have a record in a table that I am unable to delete. I have all the necesary permision and have deleted every other record in the table. I get the following error message. "The Search Key was not Found in any Record" I am at a total loss as to what to do. Thanks Walt III...

I have a query that controls several printouts. I want to change the where statement to the selected choice in a drop down list. I can get the value from the drop down box and I know how to write the SQL I just do not know how to change the query and then save it Thanks Walt III...

I have two fields in a table one that is a phone number. and the other which tells what kind of phone number 9 digit 9 digit with a 3 digit extension 15 digit phone number ect... I have setup a table with the description of the phone number and a format for the numbers. I need to take that...

I have one form and I want to take several values from that form and put them in non-editable data fields in the second form. I have not done much with access and have forgotten how to do this. Thanks. Walter L Luke III Walt III SAElukewl@netscape.net www.muc.edu/~lukewl

I have a report and sometimes I will have no value in a field so I want to automatically have it show up on my report as $0.00 and am having trouble doing this. I would like to avoid as much coding as possible. Thanks Walt III Walt III SAElukewl@netscape.net www.muc.edu/~lukewl

I am writing a program that will be dealing with audio files any comments or help would be greatly appreciated. Walter Luke III Walt III SAElukewl@netscape.net www.muc.edu/~lukewl

I have an access database in which I have several custom buttons. I would like to make a button that takes several strings concatenates them and puts them onto the "clipboard". I can get the string to concatenate and it does it properly. I however have not been able to get the...

I have a group of fields moved to a variable and I want to be able to go to microsoft word and just paste this informaton. How do you move something to the clipboard where it is copied and all you have to do in MS Word is press paste. Walt III SAElukewl@netscape.net www.muc.edu/~lukewl

I want to take multiple pieces of information and move them into one and put it in on the clip board I think I have the first general Idea. Set databs = DBEngine.Workspaces(0).Databases(0) Set forset = databs.OpenRecordset("Quoted Parts", DB_OPEN_DYNASET) toPaste =...

I am trying to export someinformation that is in a report in that format can anyone help. I am trying to do it through a button on a form.<br><br>I have tried to use <br>docmd.transfertext acExportFixed <br>with all the other parts but I cannot figure out the <br>namespecification...

I have a parameter query and I have written amodule that will update it with the parameter that I want and then export it. However when I try to use the .OpenQueryDef(&quot;&quot;) method I get a message saying vb does not support this function.<br>any help is appreciated <p>Walt III<br><a...

I have a table that has thousands of records I want to export only a selected group of those records. Specifically those records that are filtered and shown on a form I tried using a select statement in an export spreadsheet coomand as follows but could not get it to work...

i have a query that gets it's information from three different tables. I want to update and change one of the filters on this query with the push of a button. I know that there is an update command but am not sure how to make it work. suggestions are always welcome. <p>Walt III<br><a...