Search results

I created a query with monthly performance. The problem is the arrangement for monthname is alphabetical so the first became the month of April considering its first letter. How can i make it arrange that January is the first and so on....

I have a database with an average monthly performance summary. How can i format to show the summary per week in a month? For example in January, instead of showing the January average from January 1~31, how can i format to show the average per week, say Jan1~7;Jan8~14;etc. Please help me...

I have a query that creates average data per day and also summarized on a per month basis. But i am now requiring to create a summary where instead of monthly summary, the database will show per workweek. For example: Workweek1 is 1st week of january, that will show an average; workweek2 is 2nd...

I have a database for product ordering. What i want to do is a code to check if a specific product have order history for the last 3 months. I dont know how to translate it into code. Something like, when i input product name on the order form, a code will check that in the database table and...

I am creating formulas for my form, unfortunately I amnot that good in access programming especially vb codes. How can I translate this formula into vb code: IIf([QTYperHr]>0,(IIf([SetupTime],[SetupTime]+([QTYToRun]/[QTYperHr]),0)),[SetupTime]) I used this formula under the expression builder...

Good Day. I am really not so good in access so please help me.:o:o:o I have this database where i entered data per job order. Each job order has up to 10 operations and per operation has different kinds of machine used. The total Operations and total machine used are depending on every Job...

Good Day. I am really not so good in access so please help me.:o:o:o I have this database where i entered data per job order. Each job order has up to 10 operations and per operation has different kinds of machine used. The total Operations and total machine used are depending on every Job...

Hello, I don't understand why my database keeps showing an error everytime i tried to save my form. Previously i can save my forms without any trouble and then all of a sudden an error message keeps showing when i hit the save command on my project. Please see attached png files... By the...

:mad: Is there a way to recover deleted table for access 2003? My database has a table split into back-end and placed on the network drive. Unfortunately the backend table where my project was referenced was accidentally deleted! I have no backup for that, now my database was a messed!:mad:

How can i make an average for a certain record that only when a data for an item reaches 30 then the query will give an average. I already created a query that shows what are the items from my table that has 30 data records. I just dont know how to create an average data per item that reaches 30...

How can i make a query on my table that when a certain single item reaches 30 records it will show an "average records" in a query. I cannot find a way to make such formula in a query. I can only make a list where it shows what are those items that already reaches 30 data points. But averaging...

Please help me on my project. I created a table based on 3 different processes, all the required data from process A, process B, and Process C are combined in a single table. Then i created Forms each for every process wherein the data are those selected fields from the Table. Is this really...

Hello. I am having problem with my current project. I dont know how to merge two database and combine all the data for the table, and also use only one Form to update data on the two tables. We currently have two database, one is for parameter entry and the other is for performance monitoring...

May i ask from anyone a sample dbase for "make-table query".

Hello to all. Is there any possible way to retrieve password for the vb code? I have an access dbase endorsed to me but i forgot the password. :confused:

Re: Dynamically search multiple fields HI sir John. I am using this search criteria. May i ask for your help for this matter. How can i make the search results to be transfered to excel format? many thnks in advance....

HI, is it possible to have a portion on my form that i can see who is currently viewing that current form? Maybe a vb code that shows all user currently viewing a form?

Hello to all again. I found a code on this forum that creates a log file and saved it automatically on c: drive everytime the database opens. I tried it on my form but i got an error and my form becomes hidden. Please verify the code on how to apply on my project: CODE>: Private Sub...

Hi to all, I have a code for opening a password of a form, but the password that i type is not hidden on the dialog box. How can i modify the code such that the password that i type will be shown as asterisk or other character and not the actual values that i typed. Here is my code: Private...

I use tab control on my form for the monthname and created queries for the monthly summary of records. Can i set the default tab to always open on the current month? When i open the form it is always showing the January tab, and i have to click on March which is the current month..