Search results for query: *

Allan, An .adp file is a standard Access Data Project. An .ade is an Access Data Executable. All code has been compiled and removed. You will have to edit the .adp file that this .ade was created from. Sorry. -Joshua

Thank you for starting this forum! I have found Access Data Projects to be one of the most confusing and least documented pieces of software that Microsoft has put out in quite a while. I'm glad there will finally be a congregating area for those of us who use these blasted ADPs.

If you have an autonumber field (like CompanyID) in your table, this will probably be a solution. If you don't, you could add one... Select * from tblCompanies where CompanyID in (Select SELECT Min(tblCompanies.CompanyID) AS MinOfCompID FROM tblCompanies GROUP BY tblCompanies.Company)...

To highlight the current row, the solution I have used is to place a bound textbox with the unique identifier for that row (for example, an autonumber field from that table) on the detail portion of the form, calling it RecordID. I also place an unbound control on the detail portion of the...

Change your else (except your last else) to elseif and remove your ifs (except your first else) An alternate solution is If left$(mystring,2) in ('NN','ND','NS','NP') then strSearch = left$(mystring,2) elseif left$(mystring,1) in...

See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209874 Access has a "recycle bin" as long as you don't close the database.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209874

Peter, You could the first form be a login screen you designed that traps the login and password and gives access to forms based on that. You could also have certain forms request a password in the Open event and deny access if that password is wrong. However, both of these ideas are easier...

This might be what you are looking for... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cmctl198/html/vbobjtreeview.asp I've never implemented one, but plan to soon, so please let me know if it works for you. -Joshua

Even in an mde file, the autoexec still runs, doesn't it? Could the scheduler call a different mde file that contains only the macro to be run as the autoexec? Optional: have the autoexec in the regular program call a module to check the time. If it is between 2:00 am and 2:05 am, run the...

Save your record first. Autonumbers can be tricky in that they don't seem to truly exist until the record is saved.

How do you have your database architecture set up? Does the front end reside on the server or on each pc? You really don't need SQL Server for 400 rows of data. You should probably take a look at your forms and the data they are retrieving as well. Are you retrieving pictures? Are you...

If your weedregisterid is an autonumber, just append the rows. If not, two possible solutions are: 1) Copy the Regestration table structure. Modify the weedregisterid to autonumber. Use DMax("weedregisterid","Regestration")+[weedregisterid] to append the rows. 2) If you...

Which ODBC driver are you looking for? MS Access 97 to SQL 2k or SQL 2k to MS Access 97? MS Access 97 to SQL 2k will be under Client Connectivity when you are doing a SQL Server Desktop installation on each pc. If you are trying SQL 2k to Access 97, why? Just use your front end.

Also try ccur(IIf([report salary]>=60000,"$60,000",[report salary])) This should cast the results as currency. -Joshua

Do you need the combined totals information in the query? Why not just group based on region on the report and place an overall sum at the bottom?

Go to www.microsoft.com From the top menu bar, under support, choose Knowledge Base. In Search For... enter the article number. Set Search Type to article id. Click Go. HTH -Joshua

Since you didn't say how you know which date field to store the date in, I'm guessing that you want to store it in the first blank date field. Try If isnull(DateField1) then Me!Datefield1 = Date() Elseif isnull(DateField2) then Me!Datefield2 = Date() Elseif isnull(DateField3) then...

I think I've solved this problem in the past by using two queries. The first would the employees table joined to the orders table grouped on employees with a count on package. The second would be the managers table left joined to the first query grouped on managers summing the counts from the...

Access 2000 has a 255 column limit for its tables. I believe the record limit is now 4096 bytes because of the switch to Unicode, a two-byte character set.