Search results

I'm using Access to chart scrap cost but it does not chart in descending order. Anyone know how to get an Access chart to sort on the "Y" axis? The chart/report is based on a query and is already sorted in the query but this does not seem to matter in the report.

I have a chart report based on a query that I thought would be very simple. All I'm charting is scrap cost by part number and I just want the chart to display the cost from highest to lowest. It is charting in numeric order of the "X" axis (part number). I thought this would be very simple...

coyote, I really appreciate your help. The calendar option is great!

Bob, Thank you very much! Worked great.

I'm using the date diff .... DateDiff("h",[Start time],[End time]) in a query and then I report the results in a report. I have run into a problem for the first time. I had a start time of 7:00pm, and an end time of 7:00am. This was calculated in the query as (-12) which is messing up my...

I have attached my DB so you can see what I'm trying to do and not very successful at it either.

I have created a report based on a query and I need help with pulling a report based on a date range. I used the "Type beginning date and ending date" in the field of the query but this was not liked by the users. So I have tried to create a date rage selector form and use my calendar to...

Bob, Thanks for your help,its fixed.

Print Issue (Help!) Bob, I'm still having an issue. I changed the code to: Private Sub cmdPrint_Click() On Error GoTo Err_cmdPrint_Click DoCmd.OpenReport "R-NCM Red Tag", acViewNormal, , "[ID] = " & Me.ID & "" Exit_cmdPrint_Click: Exit Sub Err_cmdPrint_Click: MsgBox...

Print Cmd Can anyone tell me why this isn't working? Private Sub cmdPrint_Click() Dim strWhere As String If Me.Dirty Then 'Save any edits. Me.Dirty = False End If If Me.NewRecord Then 'Check there is a record to print MsgBox "Select a record to print"...

How do I do this? Do I have modify the query to ask for the pk. I've worked in Access databases in the past that would print a report for ever record you had open but I don't how it was done.

I have created a report using a query. How can I print a single record report while I'm in the form? I would like to be able to print the current record I have open.

How To Search I attached my database for reference.

I need help creating a search field. I have searched the forum and there are so many ways to do this. I am not a programmer so I'm having a real hard time. What is the easies way to set up a search? When I open my NCM new record screen I open it to enter new records. How do I set up a...

Thanks Bob! I think I understand now.

I have a form that I pull a part number from a query and store it in a table. I would like to be able to have the part description pull in when i pick the part number. How can I do this?

I have created a database to track our defects and was asked if we get link pictures to the defect. How can I create a field in a form that I can import or link a picture?

themurph2000, Thanks for the help, it worked fine.

I've tried that is does not work. Is it because it an unbound text box

I'm having a problem getting a total in a report. I have a "Start Time" and an "End Time" field that I used a date diff formula "=DateDiff("h",[Start time],[End time])" in an unbound text box to calculate the elapsed time. This works fine for the individual time difference. How do I get a...