Search results

Hi, I have two to three queries which gives values of a de-coded engineering component and material. The code syntax is <size/Component Code / Material Code>. I have created two tables which gives descrition for different Component codes and Material codes. I have also created queries based...

My current problem is that I want to have a scrolling text in the form which indicates the 'Best team of the week'...I have a query for the this data I am able to display only the first record (team) in the query and not all the records (teams) which qualifies for the best team according to the...

Hi, I have a form with a field name "Date entered". I want date input to be the date between current week and previous week. Using the validation rule I tried " = between Datepart("ww", now()) and Datepart("ww",now())-1 " This is not working and gives an error on any entry :confused: Can...

Hi, I have a report generated through a query. Further to this, the report has text fields having calculations within the report. I want to know how to export the entire contents of the report to MS Excel. I have tried :; DoCmd.OutputTo acOutputReport, "<report name>", acFormatXLS, , -1...

Linking MDB files Hi Bob, I do understand that we can Link tables from another Access Database. But my problem here is the file size of the Master databse. For Examle; I have split the databse of file1.MDB (Master) into FE and BE. Now, the data (tables) populates in file1.MDB_be. After the...

Creating chart using fields in 'Reports' Hi Boblarson, I have already done the calcualation in the 'report' underlying the query. For example; In the database which I am working on, I have a query to get a list of 'Drawings' executed by a particular team. I have another column in the query...

Thanks for your quick reply. I have posted another thread with regards to generating chart in 'Reports' using calculated values in the report. I understand you are well versed with Access. Can you help me in this regards. Thanks again for your help. I will try this out....

Thanks Bob..That was quick.. Please let me know how to link tables within various MDB files. Do I have to create a new MDB file with the same table names? I want some more details on this. Again, Thanks for your quick reply

I have created a report using a query. Further to this, I have added some fields from the query into the report which calculates the sum of records and the count of records. My problem here is, using the chart wizard, I am only able to select the fields existing in a 'Table' or a 'Query'. Can...

I am creating an access database and I want to know the following limitations; 1. Maximum number of users who can log into the database at a time 2. Maximum size of the database. Here I understand that it is 2GB, but I am confused as to whether it is for .MDB file or for each table in the...