Search results

thanks jzwp22 I am using Dsum on the form that gets the data from the user input. there are product ID, ProductName, UnitCost, StockLevel (table product) and I use those fields to be fileds in query which is the query stocktake in order to calculate StockLevel*UnitCost. in this query I create...

thanks it works

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

thank you for your answer

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...

thank you for your advice :)

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...

thanks for your reply well i dont understand that code However method is also dynamiclly cheers

thanks for your tip

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

oohh thanks James :)

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...

Reports![samplereport].Filter = "" why I got the error that the reportname 'samplereport' I entered misspelled or refers to a report that isnt open or doesnt exit? it is spelled correctly and the report exists why i got that warning ...

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...

thank you for your answer pbaldy However I dont understand that method Could u pls explain abit more? sitll open any suggestion thank you ============================================ thanks guy problem was solved I just put filter on the report before calling ConvertReportToPDF()...

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...