Search results

I am using Dsum funtion to calculate total product cost Dsum("[Filed Name]","Table Name"). But the sum result keeps changing when i click to anoather colunm. sometime I clear all the number the sum result should zero (0) but sometime when i click on some records Dsum still have number in there...

Hi guys I would like to put the total sum in the last page of the report. right now i put the total sum on page footer it appears every pages of the report. I would like to have total sum only the last page how can i do? thank you

I would like to protect my database to use only particular pc that I allow. how can I protect the database to be copied ? I have an idea that hiding a file that the database need to read before open the main form or something. or another idea pls suggest you guys have any idea about this ? thanks

Hi there I would like to do stocktake option in my database I have a product table that has productID, product name, price/Unit and supplierName. What I have done is: I have done create another table which is stocktake table that has stocktakeID, ProductID and stocklevel. after that I...

Hi guys ! I have got a problem about adding new items iin the combo box I am developing a recipe card database In recipe table has relatioinship with IngredientRecipe and Ingredient table also has relationship with IngredientRecipe <Recipe table> RecipeID RecipeName CookingTime Cost Method...

Hi guys I created the calculating qurey to find the percentage of food cost % food cost = [ingredient cost]/[Selling Price]*100 the problem is I set the Selling Price = 0 as the default So when the items that dont provide the selling price on the % food cost will show error, That's fine...

As I used the code from http://www.lebans.com/reporttopdf.htm to create PDF I would like to change the directory of file where the files are saved the default is my doc. Can i change to save into folder in the same directory of my database thanks

I am using Date to be a part of my file name so I used strDate = Replace(date,"/",".") so I can avoid "/" in my file name However I am not sure that any computer or OS the default of Date is date/month/year or not cause if not my code wont work on others just want u guys to make sure...

Hi there I would like u guys to discuss cons and pros about Access2003 and Accesss 2007 Right now I'm using Access 2003 to develop my DB it seems good for me. I just have been using it for 6 months. However Access 2007 looks like I see it everywhere Therefore, I need to step up to...

Hi guys !! I would like to use filter property to filter the report but i dont want to fill in the propertity window, I would like it more dynamic. So I would like to add the code filter in the report form Private Sub cmdReport_Click() reportsample.Filter = [ProductCategoryID] = 2 and...

As I used the code from http://www.lebans.com/reporttopdf.htm to create PDF It works good But I have some question about it which is adding critiria in parameter of function ConvertReportToPDF. 'Public Function ConvertReportToPDF( _ 'Optional RptName As String = "", _ 'Optional SnapshotName...

I have developed the database in Admin account When I went to present my database in another user (same computer) Some queries that calculate the cost dont work It shoe ###Error the same database I reopened in the Admin account It works I attached the pic of my design view query Need you guys to...

Hi guys I create the msgbox to warn the users that the fields to append are not complete the fields to the table My append query has 4 fields ProductID, ProductName, Quantity, Cost The problem is if i run the append query which are not complete 4 fields. the append query wont append the...

Hi guys I would like to create the backup button in mainform do we have any easy command line to create one just call the backup access windows. btw I want to lock main tool bar after I finish the database so user can not backup by clicking backup on the toolbar so i need to put the button or...

I have the update query that display the items that need to be update this qury are link to the form I need this form show the Msgbox "No items need to be update" when there are not data in the update query. Private Sub Form_Load() If (qUpdateItem= Null) Then MsgBox "No Ingredients to be...

Hi guys I have a problem about Conditional Formatting I compare 2 values which are foodcost I would like to check there are the same values or not so I use the field value is not equal to [fieldname] other fields look good, except cost fields it shows the result opposit for example not equal...

Hi everyone I have a problem about unmatch query wizard I have 2 quries that I want to retrive the records that are different value I used the unmatch wizard but it doesnt list any record my queries are QueryA ProductID ProductName Quantity Unit Cost 1 AAA 1 KG $500 2 BBB 1 Kg $600...

Hi there! I have a problem about Recipe database. My database has 3 main tables <Recipe table > RecipeID (PK) RecipeName FoodCategoryID PortionYield PercentFoodCost Instructions Source Picture <Ingredient table > IngredientID (PK) IngredientName IngredientCategoryID Quantity Unit Cost...