Recent content by turkee

Thank you Mr. Big Booty, but that's not exactly what my user wants. He wants to select multi customers and run a report to a pdf file for each and every customer, so if he selects 5 customers in the listbox, 5 pdf' files will magically appear in his directory. The report and the query that runs...

OK I worked this out so I can get a multi selection list box. Now how can I use the selections in a report?

OK I want to make a form with a list box. The list box values are customer codes for each sales rep. I can make the listr box but how do I get the values? Each customer is associated with a salesrep and each salesrep has a sales assistant. A sales assistant can be associated with several sales...

Thanks Samantha, but I didn't see anything about exporting to multiple pdf files each with it's own unique name. Example: If I input customer numbers 1350,1351,1352,et al i want to run a report for each customer and export the results to files 1350.pdf,1351.pdf,1352.pdf etc. All while clicking...

Hello. I have an Access2010 front end with a SQL backend. I have a report that a user runs where user can enter Customer Number and begin and end date. They now want to run that same report for multiple customers of their choosing and ouput 1 pdf file for each customer. Is that even possible? If...

Problem solved, although I don't know how. It was not Access or SQL, but apparently had someyhing to do with the permissions on the Windows server side.

This is nuts. I have a SQL Server 2005 back end and a Access2010 front end. I linked all the tables I needed with an ODBC connection a couple of weeks ago and it worked fine. Now I made 2 more tables on the backend that I need to link in Access, but they won't show. I made a new connection...

How did you get 21 items on a standard switchboard??

Isn't that interesting? I tried it, too and you're right it works fine. I'll try making a new switchboard. I should probably be using a menu form anyway. Hey, thanks a bunch for checking into this!

maybe this is better....it's switchboard 1 item 6 "Edit Swutchboard".

Sorry, this is the best I can do listing Switchboard tableSwitchboard Items. The switchboard is 1 and the switchboard item is 6. The command is 5 "Design Application" and the argument is blank SwitchboardID ItemNumber ItemText Command Argument 1 0 Garden Menu 0 Default 1 1 View/Edit/Add...

ok, The switchboardid is 1, item 6 "Edit Switchboard". Command 5 is "Design Application". I don't what the argument shoud be, if any. Switchboard Items Switchboard ItemsSwitchboardIDItemNumberItemTextCommandArgument10Garden Menu0Default11View/Edit/Add Garden Items3New Garden12Update...

I have an access 2007 app that uses a switchboard command "design application". Every time that button is pressed I get "Command Not Available". It workrd fine in 2003, what's up with 2007? I couldn't find the answer anywhere on the internet including microsoft. Anybody know why this command...