Recent content by Gumby

Wayne, Thanks for your reply. I did try to enter >3.....so that they cannot enter more than 3 digits.......but that didn't worked. Any other ideas? Thanks!

This question is about validation. I have a datagrid that I am displaying in a form in C#.NET using Access 2000 database. The datagrid works fine. The datagrid has a NUMBER field called "ProdCode" that has a field size specified as "Single". I want the user to enter only 3 digits in that...

Hi, I have a problem with Microsoft Access Project file (.adp). I can't open any forms in the application. It gives me an error "There was a problem with accessing a property or method of the OLE object". The funny thing is that I can open the same forms fine in the .ADE compiled format of...

I have a problem. I am using Microsoft Access project (.ADP)....which is connecting to SQL Server database at the backend. I tested the application a month ago and it worked fine. But I tested today and it gave me an error "There was a problem in accessing a property or method of the OLE...

I have an Access Project that is in .ADP format. I need to compile it as .ADE format. When I go under 'Tools' I don't see that option under there. When i open a blank Access Project .ADP database then I see that option under 'Tools'......Why is that? I am using Access 2000. Any help would be...

I have checked the Language references and it seems to be fine. Correct refernces has been checked on each machine....but still can't open the same report on different machines. The database is on the network. Is there like a different versions of Access 2000. Like there is "Enterprise...

I can open up Microsoft Access report on one machine but I can't open it up on another machine.....Don't know why. Access 2000 is installed on both machines. Could there be a problem with components or something else. Any ideas would be greatly appreciated. Thanks!

Hi, I am having problem running the Macro from Access. I am using Access and Excel 2000. It gives the error on this line.... xlApp.Run "ThisWorkbook.DoChart" The error that it gives is: Method 'Run' of object '_Application' failed. Here is the code: Private Sub cmdDrawCharts_Click() Dim...

Hi Guys! I am having problem opening up an Excel file from Access. I am using Access 2000 and Excel 2000. The problem is that I can open it up OK on one machine but I can't open it up on another machine. The Excel file is in the folder where the Access file is looking for it. The error that it...

Hi Guys! I am having problem opening up an Excel file from Access. I am using Access 2000 and Excel 2000. The problem is that I can open it up OK on one machine but I can't open it up on another machine. The Excel file is in the folder where the Access file is looking for it. The error that it...

I am trying to create reports in Access application but all the tables are in SQL Server database. So can anybody tell me how can I connect Access application to the SQL Server database? Any help would be greatly appreciated. Thanks!

Thanks Rich. That worked. I actually tried dragging the column header to the desired position before but it didn't worked. Its kinda tricky. Oh well.... I tried again and it did worked. Thanks!

Jeff, I tried that but still that didn't work. I am using SQL server database and my subforms are in Access. I created a view in SQL server and called that view in the subform "Record source" properties.....that didn't help. In the view I entered the fields as I wanted to appear. Is there any...

I have created a subform with the fields in the "datasheet format". The order of the fields is not correct. What I mean is that some fileds should be before the other fields. How can I move the fields around.....I looked at the properties of the subform but that didn't help. Any help would be...