Recent content by hmongie

Thanks all, I seems to have managed to work something out. I just did a collumn down and displayed all the inputs based on the ID fields. It looks okay. I would had like to display them horizontally but this will do. Thanks all.

hmm.. still having problems with this.. Does anyone have any other ideas. I couldn't get the others to work. The results must be displayed in a form. How about a SQL statement to say something like, Select * initials from table2 where id.table1 =id.table2. Any ideas on how to get the...

Thank you all. I will try the aboves and will let you know how it works. Thanks again for all your posts.

Jarad, Have you tried to copy the form and paste a copy of it as a different name and then try to open the new renamed form to see if there is an error?

Try a compact and repair. Sounds like the form might be corrupted. Let me know how it goes.

Hi, hope someone can help. I have two tables. Table1 and Table2 Table1 has three fields. Id, book, initials Table2 has two fields. Id, initials Table1 is linked to Table2 on the ID to ID I need to have all of Table2's initial data combined into Table1's initials field. The inputs are...

Hi, hope someone can help. I have a process and needs to find a short cut. I have many users (about ten to twenty people). These folks uses a custom crystal reports to export field from a database into excel files. All the excel files are saved in their own local machine. Ex...

I'm not too sure what you are saying. Can you help clarify?

Hi, hope someone can help. I have a only one table. Fields are: FirstName, LastName, SSN, Address, City, State, Zip, ID_Type (combo box), ID_Number, Race(combo box), Gender(combo box), and Purchase_Amount. I don't know how to do this. I need this to occur, when the user begins a new form, as...

Thanks for the Post.. Sillie me... I've tried the statement with OR and it works fine.. now.. I've did it before and it didn't work but now it does.. I probably didn't save the changes somehow.

Hello all, I'm trying to get this to work but is having a few problems. Hope someone can help. SELECT * FROM MTL_Log WHERE (((MTL_Log.AccountingName) Is Null) AND ((MTL_Log.AccountingID) Is Null) AND ((MTL_Log.AccountingDate) Is Null)); I have the above right now. But it's not working...

In my macro, it opens report BUYERREPORT, under the "Filter Name" I have it to run my query "buydaterange". buydaterange ask the user for the begin date and end date. I have it this way because I have these other macros using the same report but with different query. Such as for locations...

Paul, I think I'm probably not clear on the question. I have the query already. I have a display form. On the display form, the user clicks a button to activate a macro. The macro opens the report but the macro has a query also. The query ask the user for the dates. The user inputs in the...

Hmmm. interesting.. I have a query set up with this. Between [Type the beginning date: EX: 01/01/04] And [Type the ending date: EX: 01/30/04] When the users enters 01/03/07 and 01/05/07 as the dates, I would like the dates to appear in the report header. Something like; "Records from...

Hi Statsman, I have the criteria setup already. It's in the report header that I need the min date and max dates to show. Any ideas? I have something like =min(BuyDate) <-- unbound field and =max(BuyDate) <-- unbound field. But it errors.