Search results

I increased the number of records. No change. Still picks just the first record.

Dim MyDB As Database, rs As Recordset Dim CustomerID As Long Dim rstFiltered As DAO.Recordset Dim FName As String Dim LName As String Dim Address As String Dim Address2 As String Dim City As String Dim State As String Dim ZIP As String Dim CustomerTel As...

Sorry. What I pasted was indented. After your feedback/comment I edited the code and indented it some more. After saving it the site left-justifies everything. So, the error still isn't obvious. I attached a txt file of the code if that is helpful, with indents.

Hi, I'm stumped. I am trying to get VBA to loop through a table that is created, but it never moves past the first record after the loop. The table that is created for the test I'm running has two records in it. The code writes the first persons contact information to the Outlook Contacts...

Yes, I don't want to use API. I don't know anything about API's.

Sorry to be a pain. From what you've posted, they either use API's or they're doing things like creating an email with attachments.. I create emails every day using VBA with attachments. In my question I know the full path to the PDF file that I've created. I just want to copy to the...

Hi, I'm sure this has been answered before but after a few hours of searching, I haven't found a solution. In Access I create an invoice and I then save it as a PDF so I have a record of it. That all works great. What I want to do is after the PDF is created, I want to copy the PDF FILE to...

Pat, thank you. Can you please explain how the Switchboard Manager makes delinking easier? I know how to go to External Data, Database, etc to relink/refresh the tables, but I’m not sure what that has to do with the Switchboard Manager.

WOW! Thank you for your research on this!!! I now understand. When I added the Attachment table, that’s when the problem began. Thank you again!

I do agree. Can you point me to a method of easily changing the BE’s?

Thank you as always DBG!

I hi Lucky. I can try that later. Im sure it will work after I relink the BE. I’ll provide feedback later today. Thank you.

Thank you dbg. I'm done for the day. I got it working, but I still don't know why I've had the problem. On my Switchboard form which is started with the db starts, I added to the OnOpen event: Dim db As Database Dim tbflinked As TableDef Set db = CurrentDb...

I apologize, I know this is getting old for you and me. Both BE's are in the same folder. Let's say you developed a FE & BE db. You gave me a copy of both files. I used it. When you were doing development work on your FE, you asked me to give you a copy of my BE. I gave it to you. You...

Do you mean the two .bat files? One to access my data and one to access Ed’s data?

Again. I am the single user. I gave a copy of what I developed to Ed, both FE and BE. He lives a block away. Whatever he does on his computer never touches anything on mine. He has a non networked computer. I will occasionally get a copy of his BE so I can see what he’s doing. When I want to...

I'm really not making a copy of the BE. I'm simply changing it's name to be what the FE expects, what the FE was linked to. When I change the name, there is nothing that changes in the FE. I believe, the FE doesn't even know that it's linked to a different BE. The FE knows it is always...

Thanks CJ. Ok, I removed the attachment field in both BE's. I added a new short text field. I then started the FE using one of the icons. I deleted the linked table. I then went to External Data, New Data Source, From Database, Access and navigated to the BE and picked the linked option. I...

Hi Pat. I added a BIG RED BOX to the startup form. It shows up after I click on each/both shortcuts. There is only one FE.

Hi, Sorry on the FE. There is only one FE. Based on the icon I click on it makes sure by renaming the BE if needed, that the BE is always the same in the same folder. I just created two new blank databases and imported into each their respective BE data, and renamed the file to what it's...