Recent content by CivilUser

Glad you found it. Sounds like it was a similar concept and solution but much simpler than mine. Ill keep that in mind for next time.

I hadn't seen that you put up example files before I replied. I wasn't able to open them though. I wonder if you are using a different version. I am currently running 2007 Access.

I hope this helps. Post your results either way. I would love to learn about it.

I remember having some issues with that. I believe I got around that by performing a requery in vba. For example, the user was forced to enter in a project number first. Once the project number was entered I ran this code: Me.Requery DoCmd.GoToRecord , , acLast I think this updates the table...

The main difference between the form and the subform as I see it is that the source for your main form is the actual table you are pulling data from and the source for your subform is a query that looks up certain values from the same table as the main form. But the query needs an index to point...

It works great! I created a query that looks up a record ID from the main form. The query is then used to populate the subform which was placed on a tab page of the main form. And the best part is that it scrolls just like I envisioned. Thanks Linq.

Thanks Linq. That is a clever workaround. I will see what I can put together. I am a little confused at how to combine the two forms so that they update a single record simultaneously. Hopefully that will be clear when I get there. I will let you know how it goes.

Is it possible to have scrolling capability within a tab page on a form? Currently I have a form with tab control. There are 7 tabs and the 7th tab has a long list of check boxes that wont fit inside the area I set aside for the tab control box. When I place the check boxes into the tab page...

I was really hoping to get an answer here seeing as how so many other questions are answered. Kind of disappointing... On the other hand I found a different way to solve my problem. Its not the best solution but it works. I created an append query and transferred the data...

Do I need to explain myself better or is what I described just not possible? Any thoughts would be greatly appreciated. Thanks.

I have 2 separate databases that contain similar information but do not share the same field names. I would like to transfer specific fields, from one record at a time, to corresponding fields (with different names than the original) in the other database. 2 questions: 1. Should I use an ADODB...

Thanks for the reply. The links were helpful. I might end up completely changing my method here because the code works fine now and I don't want a piece of code that works only half the time. I did replace the Excel Spreadsheet I was exporting to to an older backup version and it works fine...

Is there at least an alternative way to transfer a table to Excel?

I have 10 queries that I would like to export to an excel Spreadsheet called "Proposal_Report.xlsm" (with macros). Each query contains 3 columns of data: "Project Name", date, and amount (with data formats respective to their names). My code (found below) executes 2 basic functions. The first...