Merging Pdf docs using access 2007 vba

Hi



Has anyone any simple code that merges multiple pdf documents that they are willing to share. I don't seem to be able to find anything that works so far.



Thanks in anticipation.



Regards



Ian Clegg

Merging Pdf docs using access 2007 vba

Show All Records in Datasheet subform on Form with combobox Filters On Load

I am having an issue trying to show all records when I load my form. It loads correctly when I don't have a record source for the main form. However, the combobox filters will not work. My goal is to have users be able to use the datasheet, subdatasheet and combobox filters. I can get the form to work just fine when I link the Main form and subform, but when the form opens it is filtered on the first record. I have been successful with this approach when using other forms, but they didn't require a subdatasheet.



Is there anyway I can have the comboboxes to filter yet be able to show all records until the user selects filters? Is this possible? I attached some pics.



I finally got my Manager to agree to use a database instead of Excel files based on this form setup and I need to make as "user friendly" as possible (look and function like a spreadsheet) I attached some pics of the form along with the code for the filter.



I greatly appreciate any help!

Attached Files

	Form Help.doc (77.5 KB)
	Form Help Example 2.doc (83.0 KB)
	Form Code.doc (26.0 KB)

Show All Records in Datasheet subform on Form with combobox Filters On Load

How do I sort correctly

I am trying to created a concatenated date of yyyy/mmm from a MM/DD/YYYY. After concatenating I get 2014/Feb, 2014/Jan.... which is the look I want, but when I sort it, April comes before Jan. Unless someone changed things and didn't tell me, I screwed something up.

Any help would be greatly appreciated.

How do I sort correctly

Importing currently linked tables (combining front and backend)

I have a database that is designed with a front and back end, with the FE linked to the BE. Some potential customers want to play around with the database, and the easiest way for me to get them access to it would be for me to combine the FE and BE and just give them a copy of that. Long term this is not a good solution for many reasons, but it's the best way right now.



Now, I know how to link a table, and I know how to import a table. What I'm unsure of is how to cleanly convert a linked table to a local table. This is a pretty complex database, and I'm concerned that if I do this wrong it will break a LOT of stuff in the process.



Any thoughts on this?

Importing currently linked tables (combining front and backend)

Google announced purchase of Microsoft Access

http://ift.tt/1C8dLMm



FOR IMMEDIATE PUBLICATION:

Google Inc, the search engine giant from Silicon Valley, announced today the purchase of Microsoft Access from Microsoft Corporation, headquartered in Redmond Washington.



Larry Page, CEO of Google, Inc. announced today, April 1st, 2015 the purchase of Microsoft Access from Microsoft. “We have been looking for a product we can add to our online suite of apps, and Google Access, as it will be known, complements nicely with our other products, Google Docs and Sheets. We look forward to offering our customers a wonderful platform that will allow them to easily store massive amounts of data online”, remarked Mr. Page.

For his part, Satya Nadella, CEO of Microsoft, had this to say regarding the sale, “We are sorry to see Access go, but we felt it was the right time to make the transition.”

Neither executive commented on when Google Access will be available on the Google platform, but it is expected to coincide with the summer solstice.



This popped up on my smart phone. Realizing it is April Fools Day, I don't have time to look more into it.

But, it did get my attention.



It’s April the First. April Fools’ Day. Every email, every tweet, every announcement and every conversation is viewed through the lens of suspicion today.

I can't find this anywhere else.

Did see the Google announcement that Australia is Moving, that Google Maps goes Pac Man, and the Microsoft Surface Watch

http://ift.tt/1C8dOI7

Guess I will write this up as a prank.

Google announced purchase of Microsoft Access

Auto-populating form

Hi,



I am new - sort of. I use to post a long time ago when I worked with Access on a daily basis.



My post today is probably already listed somewhere in the forum so please forgive me. I am trying to have my form auto-populate a field when I select an item in a drop down list in another field. Here is the deal.



1 table, TblCarrier. I want to be able to have Carrier ID auto populate in a field on a form when I select a Carrier from drop down.



TblCarrier

Carrier Name Team# Carrier ID

CarrierOne 68105 B399120001

CarrierTwo 45847 D408523003

CarrierThree 76825 F433607400

CarrierFour 15736 I470618107

CarrierFive 69316 K561432000

CarrierSix 84102 T681122100



Easy, you say. I say, how?



Thanks.

Auto-populating form

Hello from the Carolina's

Hello all,

My name is Jim and I'm originally from Cleveland but now live in North Carolina. I'm in my early 30's and stay as busy as possible with my hobbies. I like to build furniture, improve my home (working on an addition which will be a man cave), I build motors/restore cars, I play a lot of basketball. I am by no means a proficient DB builder but am getting a lot better at it as the days go along.



Some of my DB projects include a DVD/music library/home automation program, employee management tool and an inventory inspection tool.



The DVD,music and home automation db essentially started off by taking all of my DVD's/CD's and ripping them to my home server. It was approximately 1300 DVD's and roughly 500 albums. It took a very long time to get knocked out but once I did I built a DB that I could look up a movie or song by artist, actor, genre. I can look up by multiple artists, actors or genre's as well. It then populates a report from the query results which has hyperlinks to the files location on my server. All my smart TV's are linked to the server and I have the ability to watch the same movie on all the TV's, one TV or multiple movies on multiple TV's.

The home automation is a work in progress and allows me to open and close my garage doors, automated door locks. I am working on figuring out how to incorporate my security camera's for remote view and also talk over my intercom system via my phone. Those are proving to be very difficult but fun to work.



My employee and inventory DB's are pretty basic. They are simple with only >=[forms]![formname]![txtdatestart] And <= etc. type date range query criteria along with Like & "*" [forms]![formname]![field] & "*" data isolation criteria. With those, my philosophy was to keep it as simple as possible so not much can go wrong.



Most of the stuff I've learned along the way came from this forum and I thought it was time to stop lurking and officially thank all of you for the great posts and information you all provide.



That about wraps it up so hopefully I may be able to contribute something to the collective and I wish you all a great day!

Hello from the Carolina's