Search results for query: *

Thanks for looking at it. Anybody else have any ideas?

Hi all! I have a question that seems as if it ought to be simple, yet I am having difficulty getting the results I need. Here's the situation: we have a client that issues us a purchase order for repairing units sent in by their customers. They issue their customers an RMA number for their...

You're welcome. Glad to be of help. :-)

Just in case it's not clear, Newposter is referring to two users editing the design of the form at the same time. There is no problem with two users entering or editing data using the same form at the same time, as long as they are not editing the same record. Additionally, if one user simply...

Melissa, If you look at the properties for your subreports on the main report, under the Properties Data tab, so you have the Link Child Fields and Link Master Fields set identically (presumably with ObjectCODE) on both? Fixing this should fix your problem. HTH Geekmomz

If you mean can two users enter data into the database at the same time, the answer is yes. However, there are particular steps that you can take to reduce the possibility of conflcts occurring, such as storing your tables (data) in a back end database and linking to them from a front-end...

IIf(Len([Forms].[frm ARCHIVE].[cbxTYPE])>0,[Forms].[frm ARCHIVE].[cbxTYPE],[TYPE]) might do what you're looking for.

If your form is based on a query, you can add the Equipment table to the query, join on EQ#, and add a column in the query for the old ID. Then you can add the old ID on your form in a read-only text box so your users can see it.

You need to check the JOINs on the query/ies underlying your form. Make sure that you have correctly related one-to-many, one-to-one, etc.

I'd suggest you look up Replication in Access Help. It seems that's what you need to implement.

In your criteria row, under FYQtr, enter the value for the particular quarter (2002Q3), and in the same row under Score, enter Is Null. That ought to give you the results you need. HTH Geekmomz

Yes. You can only have one destination table for any one Append query.

OK, You actually only have one criterion to use, so you don't need to use BuildCriteria. That is for if you want to check if they have made selections from multiple boxes. The result of the code you actually have is that the records will be returned if LenderName matches the choice from the...

No, the smallest increment returned is seconds, so hh:nn:ss is as precise as it will give you in a date format.

You don't need to do anything special to the report in order for it to accept the parameters. Can you post the code here that you are using to call the report so that I can take a look at it?

Great! Let me know if you have a problem trying to implement the code and I'll see if I can help you work it out. Geekmomz

Ann, Good luck with your project. You might also want to look at http://www.php.net/manual/en/faq.databases.php for information on using PHP to access Access databases. You can't use FrontPage to work with PHP, but it's pretty straightforward for anyone who has used HTML to learn, and it was...

Yes, you definitely can. See this link for more info: http://www.php.net/manual/en/faq.databases.php HTH Geekmomz

Are you actually trying to build the report dynamically or are you using the user's selections as criteria for the report? If you are trying to use the selections as criteria, the below code from one of my db's might be useful to you. There's probably a better way to do this, but this way...

Ann, Have you considered setting up a MySQL server? There's no charge for the license, it uses fairly standard SQL, and exchanging data between it and Access ought to be nearly as straightforward as between MS SQL server and Access. Alternatively, you can export your data to flat files and use...