Search results

Worked perfectly. Thank you, HiTechCoach. Duluter

HiTechCoach: No, I have not tried that. Though I'm not really sure what that would look like (I'm sorry, I'm not very skilled at SQL). Could you demonstrate? Duluter

I have two tables, tblWorkOrder and tblSubWorkOrder. There is a one to many relationship between them. I want to pull the work order ID from the tblWorkOrder table and the Acres field from the tblSubWorkOrder table. Here's my query: SELECT tblWorkOrder.pkWorkOrderID, tblSubWorkOrder.Acres FROM...

WayPay: Your first suggestion did not work--it says that it is not a valid path when I include the dbf file name with the path. Your second suggestion worked perfectly. I don't have a problem dropping and recreating the tables because I'm dumping all the existing data anyway. Thanks, Duluter

I want to import data from three DBF files into three existing tables in my database. Following a suggestion from another forum user, I am using the following code, where tblA, tblB, and tblC are my tables and DBF-A, DBF-B, and DBF-C are my three DBF files. CurrentDb.Execute "DELETE * FROM...

OK, jumping from the general to the specific, here's the code I tried: CurrentDb.Execute "DELETE * FROM tblRareFindELM" DoCmd.TransferDatabase acImport, "dBase IV", "C:\Resources\Databases", acTable, "ELM", "tblRareFindELM", False CurrentDb.Execute "DELETE * FROM tblRareFindFED"...

@boblarson: So is this what the code would look like? CurrentDb.Execute "DELETE * FROM tblA" DoCmd.TransferDatabase acImport, "dBase IV", "c:\my\a.dbf", acTable, "", "tblA", False CurrentDb.Execute "DELETE * FROM tblB" DoCmd.TransferDatabase acImport, "dBase IV", "c:\my\b.dbf", acTable, ""...

Wow. Yes. That is exactly what I need. Thanks a million. Duluter

Here's my scenario: I have an Access database into which I import data from three DBF files on a regular basis. I get the DBF files from a third party and I replace my existing data with the updated data when I get them. I import the files as three separate tables, call them tblA, tblB, and...

Good to know. Thanks for the quick and helpful reply.

Max: That worked, thank you. I wonder, in order to do this, does the subform have to be based on a query? It can't just be based directly off of the table?

Hi, all. This seems easy, but I've looked up and down and can't locate posts that clearly answer this question (though perhaps my search terms weren't good). My Situation I have two tables, Client and Project. There is a one-to-many relationship: each client can have many projects associated...

This issue started out as a thread in the Query forum, but the focus of the question drifted more to reports, so I'm starting a new thread here. I have three tables: tblFarm tblTract tblSection Farms can have 0, 1, or more tracts registered to them. Farms can have 0, 1, or more sections...

Perhaps the format of my response made it appear that there is a logical disconnect. Consider the Tracts list to be completely separate from the Sections list, even though they're side by side to save space.

Great. Now we're getting somewhere. I now have a query with nested left joins, which gives me all the farms, all of the tracts registered to those farms, and all of the sections registered to those farms. Note that tracts and sections do not have a relationship to each other--they are...

A little bit harder outer join What if I make things a little more complicated? tblFarm tblTract tblSection I need an outer join between tblFarm and tblTract. And I also need an outer join between tblFarm and tblSection. TblSection works just like tblTract -- a farm may have multiple sections...

Thanks. It's the perfect reply. Thank you. Duluter

I have two tables: tblFarm and tblTract. The relationship between them is that multiple tracts may be associated with a single farm. However, there may be farms that have no tracts associated with them. I need to build a report that returns all the farms in the database and also shows all the...

UPDATE: I just tried saving the farm name in a string variable, closing the recordset, and then changing the Text property of the combobox (it's now the last thing I do in the procedure) and it runs. Weird. Was it not working because the recordset was still open before?

Thanks for the reply, Wayne. But I just built a quick form to check my Text property syntax, and everything worked ok. On my quick form, I put a combobox and a command button. In the click event of the command button, I wrote: me.combo0.setfocus me.combo0.text = "This" and the procedure ran...