Search results for query: *

Is there a way i can lock certain tables and queries in MS access without using any VB CODE? I currently have the database password protected when your first try to get in.

Hello , I have a query which adds all the downtime for a given week and displays it. All i have to do is , is to type the week number and it shows be the data. However we have rolled into the new yr ( 2008). I would like it to display information for 2nd week in Jan 2008 for me. When i enter 2(...

I have a query which contains in it the vial # , product , speed , # of people and the vials/manmin. there are multiple vial # for each product and within a vial # there are duplicate entries.So the same vial # could have run on another shift and the speed could be different therby causing the...

I have a table with many fields ( 10 fields out of which 6 are for specific product issues). Each of those 6 has a number enter in it via a form.I've created a report and dont need to display these 6 fields. Instead i would like to display the maximum number entered in the fields in a group of...

I have a form where the supervisors enter the date and click a button which runs a query and displays the information. 1st problem - The information displayed is correct but when i try to view the information in pivot chart , it doesnt display the value in the bar chart for some of the fields...

I have a form with many fields. We have around 500 + records. WHen a supervisor makes an entry , he has to scroll all the way down and enter the information. I wanted to know if he could start entering in all the information in each record from top and after every record , it would create...

I have a query(consolidatedqry) which has 20 queries in it. The consolidated query has one field from each one of those 20 queries. WHen i run the consolidated query , it shows me all the information present in each one of those fields. I need to make a chart from that query and the Chart Wizard...

I have created a User - Packaging and want to get rid of it. I went to security - and to user and group accounts and selected the user to delete and the all the buttons ( like new,delete etc) are deactivated. How do i remove the user Packaging and keep only Admin as user. Everytime i open any...

I have created a User - Packaging and want to get rid of it. I went to security - and to user and group accounts and selected the user to delete and the all the buttons ( like new,delete etc) are deactivated. How do i remove the user Packaging and keep only Admin as user. Everytime i open any...

I have created a USEr - Packaging and want to get rid of it. I went to security - and to user and group accounts and selected the user to delete and the all the buttons ( like new,delete etc) are deactivated. How do i remove the user Packaging and keep only Admin as user. Everytime i open any...

I have a query with many fields populated from a form with time entered in mins. I need to convert them into time in hrs.how would i do it? Below is the code for the query. I need to convert all the fields from the 4th field onwards into time in hrs. Thanks SELECT Format([Date01],'mm/dd') AS...

I need to create a combo box with todays date , yesterdays date and day befores. How do i do it? when i use the combo box wizard , it asks me to type in the values myself and i enter =Now(); =Now()-1 ; =NOW()-2 and it doesnt work Please help.

IIf([Inspect only]=-1 ,[Actual],0) This generated one result. How do i make it generate the exact opposite result?

I have another question in queries and charts. I ran a query to count the number of records present in a field and sorted it in ascending order. WHen i make the chart , it doesnt display it in ascending order , i wonder why.Below is the code. I was trying to make a pareto chart which would...

In my Database i have a query from which i run a report. I have sorted a query . Below is the code . WHen i run the query , it works and displays the accumulated downtime for all lines in a given shift for a given week. When i generate a report though , it shows all the information in one day...

I have summed all "Actual production" in a report. I need to sum all " Packaged production " in a report. I have a check box "Inspect only " . "Packaged Production" is all the "Actual Production" minus the Actual production which have "Inspect Only" checked. How do i do this in a report? an IF...