Search results for query: *

The reason why it's asking you to log on to any database you open is because I think you have changed your workgroup file from default system.mdw to the one you created yourself. What you should do is this. Create a shortcut on the desktop or in a folder to the secure database. In this...

I assume your form's recordsource is a query. If not, you have to create a query with two tables: customers, salutations. One of the columns of the query should be Salutations.description instead of the column from customer table that stores the SalutID.

On the Properties of the Option group, set the default to the desired value e.g. 1 if you want male, if you want female.

If only one needs to be chosen then why not use the radio buttons instead of check boxes?

Do an update query instead of Insert:<br>UPDATE Customers SET Customers.[Company Name] = [Customers].[Last Name];<br> <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>sign up for...

Use the PrintScreen button on the keyboard to take a snap of the form. This stores the form image on the clipboard. Then open the Word and Paste the image from the clipboard using CTRL-V or edit paste. <p>Sandeep Anand<br><a...

read this article:<br><A HREF="http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP" TARGET="_new">http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP</A> <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a...

This is because Access does not do any clean up or if it does it doesn't do it properly on close. You can set an option to compact the database on close. I use Access2000. I am not sure if this option also exists in previous versions. <p>Sandeep Anand<br><a...

You can also write a procedure that copies the data.mdb to data_bak.mdb. If you want the code email me. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>sign up for our free...

Use the TransferDatabase function. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>sign up for our free Discussion list: "Access Tips And Tricks" at www.matatechnologies.com

Sounds like the rowsource of the combo has a parameter. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>visit www.matatechnologies.com

I had several databases in 97 which I converted over to 2000 without any problems. All the subforms are working fine without any modifications. Are you sure it's not something in your data that's changed? <p>Sandeep Anand<br><a...

Use the following:<br>SendKeys &quot;^{p}&quot;, False<br> <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>visit www.matatechnologies.com

send me your datbase. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>visit www.matatechnologies.com

Simpy put: A Three Tier application is when you have a GUI on the client machine, Code on the Application Server and Data on the Database Server.<br><br> <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a...

To Register a DLL manually:<br>You need a program called regsvr32.exe on your computer. If you don't have it, you will have to download it from the Microsoft's site. Once you have located the program, open the Run dialog from the start menu. Type the following:<br><br>[path]\regsvr32.exe [name...

Define an event on the Detail Format section of the report and then place the code intNumberRepeats = Forms!... there. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>visit...

Try deleting your existing DSNs and recreating them. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=http://www.matatechnologies.com>Mata Technologies</a><br>visit www.matatechnologies.com

One way to do this is to set up a seperate table called eg.g tblDefaults and a form which will be used to enter info in the defaults table. <br>Then on the data entry screen for each person you will create a button or a check box called e.g. Fill up defaults.<br>On Click of this button you can...

For the Second Part: you can create a history table which is a duplicate of the original table but without the data. Then every time you update the info in the main table, store the old info in the history table. <p>Sandeep Anand<br><a...