Search results

Mr. Hartman: Option 1 did not work. Option 2 (so far) appears to be working. I will check the offending queries for the next few days and post again if there are problems. Thanks for all the help. fmm

Mr. Hartman: Thanks for the info on last. I've tried using Max(), but I'm having problems with that as well. Please see http://www.access-programmers.co.uk/ubb/Forum3/HTML/001978.html

I'm having a strange problem with a totals query. I have an address table containing (among others) the following fields: RecID (the link with the master table), Generation, and id1, an autonumber field. Every time a new record is added for a given RecID, the generation number is...

I still have (at least) one query where the relationships won't "stick".

Permanent relationships appear to do the trick. I also developed an alternate method (using 2 tables and some code). Thanks!

Access 2000. Query window only. I'll try building the relationship permanently.

I'm having a problem with relationships disappearing from queries. Table1 has the field RecID. Table2 has the fields RecID, Generation, and other data. The generation number is incremented each time updated data is appended for a given RecID. The tables are linked by a 1-many relationship...

I'd appreciate a copy as well. F. Michael Miller fmiller@rustconsulting.com

Alan & Mike: Thanks for the advice. I'm going to try Mike's approach. I'm pretty sure that Access could handle the taks I'm doing in FoxPro, but I don't speak VB well enoufh (yet) to acomplish what I need done. fmm

Is there a way to pause VB execution while an external program runs? My code does some stuff, runs a Visual FoxPro executable, and does more stuff with the result. I want VB to stop until VFP is done. I can use a message box that instructs the user to push a button when VFP is finished, but...

I have a report that I would like to get into Word so that I can email it to a client that does not have Access. Each field is surrounded by a border, which is lost when publishing to Word. Is there anotehr way to get this into Word? tia fmm

This is a strange one: Assume that the following directory is empty: R:\claims\projects\xxxxx xxxxx\data\V F P 12 If I try to execute the following command in VBA, it works fine: DoCmd.TransferSpreadsheet acExport, , "tblReturnedMail", "R:\claims\projects\xxxxx xxxxx\data\V F P 1234567890...

Tried that. Tried clicking on the code icon. It would not start VB. Very strange. I ended up rebuilding all of the forms, but I would still like to know what was going on. Thanks anyway. fmm

I'm working in Acess 2000 and I am having trouble importing a form. If I try to import or export the form I get the following message: "Name conflicts with existing module, project, or object library." I can rename the form to a string of random characters and I get the same message. Both...

Thanks, Rich. It was referencing the main form that fixed it.

I am having trouble copying data from one subform to another (Access 2000). Here's the setup: The subform frmPurchaseSubform has a field called SerialNumber. The subform frmSale Subform has fields Transfer Name and Transfer Serial Number. After I enter data in Transfer Name, I need the...