Search results

Thanks jdraw, spent quite a bit of time researching and haven't found an answer. It's a strange one :) I will keep digging...

Yes it is a split database, but both parts are on the server. I can still recreate the issue with it on my USB key using their computer. There are no subforms and the error is consistent no matter what form or how complex it is. It's the simple close of the form itself.

I have never seen this error before nor can I recreate it on my computer. We currently use Access 2007. Basically, I have forms that when the user finishes entering information, another form will open and then close the current one. It's pretty simple, but on one users computer it's causing...

Thanks again! I was hoping that there was an easier way. I also solved a related problem where there seemed to be a maximum size to the chart, but solved that issue by changing the setting to zoom instead of stretch. Thanks for your help.

Thank you, I thought of that myself, the problem is that it's a generic chart, so sometimes it's not necessary to expand onto 2 pages. It's based on each project, and the more complex project will require 2 pages and some projects it's not even a full chart.

Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number...

Thank you very much, your solution works. It's an odd issue and I wonder if there's an underlying issue that needs to be resolved somehow. I have also done a repair on the DB to see if that helped. Thanks very much!

Just tried using my own computer and moving the BE to another location, but no luck :( Also, I should note that the front end is now compressed ACCDE file, but still have the same issue no matter what the FE is. The error code shows up in the forum, but I haven't found an identical situation...

Have a database with a back end that I have been working on. The database resides on a USB at the moment. I was ready to deploy and now when I try to re-link the back end tables, I repeatedly have the following error: "Your network was interrupted. To continue, close the database, and then open...

Thank you very much this was very helpful! Had a few additional things to tweak, since I'm add a new record, but it works beautifully!

Have one form that contains values AssociatedProject and AssociatedRelease that need to be passed onto another form that opens with a new record. Have tried different variations based on what I read here and couldn't get them to work. Here's what I have at the moment and any help would be...

Thanks very much! Works beautifully! The only change I had to make was in placing the code in the receiving form, had to place it on "after update" instead of "on load" due to the nature of the form.

I have several different sub-forms that have a button that opens a new form which creates a new record. Each of the different sub-forms have a field value that needs to be passed to the new record when the other form is opened. I've tried a few solutions, but to no avail. Right now I'm using the...

The solution in the database was great! Helped solve my problem! Thanks for contributing.

Excellent! Thank you very much for your help!

How do I do that?

Forgot to mention, that when I put the "order by...." clause in the associated query, the error message I get is "Run-time error "3138" Syntax error in ORDER BY clause"

In the query associated with the sub-form, I just added the sort to the field. It should've been straightforward, but for some reason I get an error. I should mention that I've inherited this database, so I'm not a guru by any means. Any help is greatly appreciated. Thanks, Don I added the...

In my database, the user can select certain fields to search the records. Everything works fine, except the list is not sorted. I've tried placing the sort within the associated query, but this causes an error when I try to run it. How do I sort the results of the requery? I should note, that...

Thanks for your help. I'm pretty sure the problem is associated with the type of bullets we're using (i.e. (a), (b),...). I'm still looking for a solution, even a 3rd party solution that would work, but to no avail. Essentially I'm looking for an editor that behaves like MS Word.