Search results

Thanx I thank you Uncle Gizmo it works perfectly Ye I'm learning every time I open this site

Hi all I need to run a certain file from the form I create a button as follows Select in the categories "Applications" then select "Run Ms Word" I have tested it and it open Word but not even a blank page I then open the code as seen below and want to insert the filename but do not know where...

Maximize form In the design view click on the "Code" button Look for the following: Enter "DoCmd.Maximize" Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. DoCmd.Maximize ' Move to the switchboard page that is marked as the default...

Wayne It seems to me nobody have the answer Some of the Asset_Aux_Val* fiels are renamed We are using Asset_Aux_Val2 and Asset_Aux_Val3 to enter the KM from and Km To in. These are Text fields and I do not know if I can get what I want

Can you figure it out I include a zip file with part of the actual data from the database If you can figure it out I will appreciate it. A message box will pop up - KM From - (The user then enter 2.856) Then a second message box pop up - KM To (The user then enter 8.654) All I...

Hi all :confused: :confused: I have a table (In Oracle) where we store all our assets - almost 35000 of them. In the table there are fields named KM_From and KM_To These fields are Text fields on the table, Now what I tried to do is the following I want to set up a query where I query...

Why don't you do a screen print (for the table structure) or create a querry and preview it, then print the table -all the records

Thankx Thanks RichO It's working perfectly

Problem not solved I still having problems see attached db

Hi I have the following problem How do I add days to a date and then display that date? Table with field names ServiceDate Days NextDate a) Service Date – User enter the date the machine was serviced - 19-Aug-2004 b) Date – User enters the days for the next service...

Try this in your Report header ="From: " & [Start Date:] & " To " & [End Date:]

Thank you Pat Pat I thank you for your help I will look into your suggestions and do so. The report is always a one-page report and that’s not necessary to total in the footer of the report. I know how to do the calculations in the footer of a report. Do I understand correctly I can delete...

For all the EXPERTS Pat See the attached zip file I thank you in advance for your help Thanx a mil

I did try your suggestion - But still get the error message - Query too complex

I am "lost" on this one Sorry Pat but I do not know what and where to enter the "criteria" I want to eliminate the the 0.00 on the report. Display only if value is >0 Thanx

The Db is too large to post 900Kb after I have zip it The report came from a querry and yes the table do have all the 0 in it because the format is set to currency I attched a word doc with the report and some screen prints If it is OK with you I will send post my E-mail address and then you...

Can anyone suggest a solution on this? I made a report like this example Part List Situated Supply Labour Strip/Assemble Spray Total XXXXX ZZZZ 20.99 10.00 15.85 5.00 51.00 SSSSSS qqqq 45.56 12.00 21.33...

On a form I have a field where I enter a registration number. I force Access to change the case to Upper case in the table using the >. My question is now: Is it possible to force Upper case in the Input box when I do a query or a Report. Because every time when a input box appear I first have...

Hi all I am using a input box in a report (based on a querry) where I set the creteria as "Between [Date From] And [Date To]". Also in another field I Ask to Enter a [Department Code]. Then I can only get one department at a time. I need more than one but not all. The department codes is like...

Hi all I have a report and before opening the report Access prompt me for the Start Date then the End Date. This is displayed in the header. If I enter the dates from 01-11-2003 to 15-11-2003 can I calculate the days. It should display then 15 days Is this possible and how do I do this. There...