Search results

Bob, I really appreciate the information! The tutorial link didn't show up. To assign a new, single autonumber field as the primary key, I have to remove the relationships attached to the three fields combined as a key currently. Doing so, and then reassigning the relationships when...

We already have a web database running on our SP Server 2010, so we do have this capability. I have it set up with a lot of calculations already, so I'm assuming changing to this format would be a major undertaking? How is each calculation changed over? Although, I just remembered using a web...

Bob, Thanks for verifying that. By Access services, you mean web database correct? That option is unfortunately out because of the inabililty to perform calculations in queries. Also looked at "Move the database to SharePoint" and convert the tables to lists, but SharePoint converted all...

Bob, I am in Access 2010. Some users might be in 2007, although they could be upgraded if needed. The source database file that will be split is: .accdb. Thanks!

Hello, I have a large database mostly built and close to ready to deploy. The database will be split with the backend on a server. I was just told that they want to enter data offline and sync later. I am not sure how this would be achieved, since the tables are located on the server. Any...

Anyone have any guidance here? I tried all the "save as text" and Word-related options I could locate. I have to simply be overlooking the right option. When I send the report to word, only text is kept. Not lines/rules, not graphs, nothing.... Thank you!

So in my table, I would need fields [Rep1], [Rep2], [Rep3] for however many different Rep could be selected. Then when I code, I guess I should maybe use a calculated field? Not sure what you meant by calling the parameter in a memo field. That's where i'm getting hung up. Thanks, Alex

Hello, I finally got my report worked out with graphs and all, and now when I export to word, (via PrintPreview > More > Word), there are just empty spaces where the graphs were. Not good! The user has to put some final edits and verbiage in certain places in the report, and change the...

Hello, I have a database, and at some point Access has added a bunch of tables: MySysAccessStorage MySysXML MySysACEs MySysComplexColumns MySysNameMap MySysNavPaneCategories MySysNavPaneGroups MySysNavPaneGroupToObjects MySysNavPaneObjectIDs MySysObjects MySysQueries MySysRelationships...

Hello, Can anyone provide a little more guidance on how to combine all of the text? Also, for the text that may have more than one selection (Our representatives [RepName], [RepName], and [RepName]) should I go with one field that allows multiple values, or a separate table with one...

This is solved. Thanks!!

Just wanted to follow up on this and briefly provide some answers in case someone else has the same issue. First, the number output of the query should be formatted to a number format. Didn't realize they were not. Also, It is important (of course) to pick the right values in the query for...

Thanks. They want to use FTP, but I don't think that will work. Your article mentions using SQL and then being able to link the database over http. Does this also work for https (our SharePoint site), and are major modifications needed to convert the existing access DB to SQL? Thanks.

Hi Guus, Thanks but I'm not sure I understand. I already have a query that shows the values (the 5,000; 4,000; etc.) that should be displayed: Several rows will match each clerk on both the DepartmentID (report section) and ClerkID (report subsection). When the row matches the ClerkID...

Hello, I am trying to insert graphs based on a query into a report, but doesn't seem to be working. Here is my setup: Report: Year:2010 DepartmentA Clerk1 - graph all history for [DeparmtentID=A, ClerkID=1] Clerk3 - graph all history for [DeparmtentID=A, ClerkID=3] DepartmentB Clerk1 -...

Regarding the last section above - would you do that with Visual Basic somehow? On the report I assume? Also is there a way to support multiple values? I.e.: Our representative [RepName] Our representatives [RepName] and [RepName] Our representatives [RepName], [RepName], and [RepName]...

Hello, I have a database set up with all the information, but I can't get the output the way I need it. I have to get this done today and I'm totally lost. Everything resides around a customer-Engagement. There will be a lot of customers, and a number of customers will be on each...

Yes, exactly. The text might say, for example, (where red is variable) Our representative John Smith met with Sally Ford on 5/15/2011 to discuss quality concerns. They determined that quality is sufficient, and will continue to monitor quality. or Our representative Jack Boxer met with...

Thanks - I'm trying to figure them out. I know how to design the form and all that, and I have a report that asks for a user-input value when you open it. I'm trying to figure out how to pass the value on to the form when you click to open it from the splash screen/main form.

Well, now I've come across an interesting stumbling block. I wonder how you can put these together into paragraphs? Each output phrase is different in length.