Search results

I don't understand what you meant by "wash themselves"? How about from the programmers point of view?

Hi, Would you hire a programmer only for their programming skills? If not, what other skills will you be looking for. Regards, B

Hi, I am using this code to export data from Access to excel: Public Function sendRep (qryName As String, pathname As String) Dim objExcel As Object Dim objWorkBook As Object Dim i As Integer Dim iRow As Integer Dim iCol As Integer Dim ColLetter As String DoCmd.TransferSpreadsheet acExport...

Thank you.

No, could not find it. Is it called differently than Wrkgadm.exe? I am running XP home edition and Access 2003. Thank you. B

i will have another look now. I am running XP home edition. Does it have to be pro?

i am wanting to follow you documents' explanation Len Boorman; however, I can't find the Wrkgadm.exe file any where in my computer. Is it copied with the intallation or do I have to copy it from some where else? Thank you, B

Alright, Thanks anyway :)

That's great. I did not realize how easy it was. Thank you very much gemma-the-husky:)

No, it did not work.

Any suggestions please.

Hi, I want to pass a value between two forms. I created a text field in one of the forms and tried to access it using: aVariable = frmSearch.txtQryName.Text It's not working for me. Is this correct? Thank you, B

I don't know what was wrong, but i deleted that copy of the DB that I made. Then, pasted a new copy, linked the BE to the FE and now it seems to work fine. Your code seems interesting though. I will try it and see what it does. Thank you for your help, B

can you explain further please? if I write "\\Servername\...", I don't have to change my path whenever I move the table or what? Thanks, B

gemma-the-husky, I don't know how to check it. What did you mean by "you have currentdb.tabledefs("tablename").connect for the connect string and currentdb.tabledefs("tablename").sourcetablename to see which table it REALLY connected to. - this is probably the problem. " I opened the query...

The query does not show any connections between the tables. My DB was divided into FE/BE in my machine; when I copied it to this machine, I relinked the FE with the BE. All of my other queries are still working perfectly apart from this one that has lost it's tables' relationships and is...

edtab, Here is a doc example that should hopefully explain what I want to do in a report. The values on the left are labels that should be displayed only once on each page. and the values under person 1...person n are records. Thank you, B

Do I need to relink tables in a query each time I move it to a new machine? I actually don't know how to do that. Why they did not stay linked? Thank you, B

Ok, will do. Thank you.

Hi, I moved my computer to another machine; however, one of my queries is returning a cartesian product because the tables in it are not linked any more. I don't understand how this happened and why? Any help will be very much appreciated. B