Recent content by desiboy

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