Search results

All of a sudden, code that just saves a report to PDF, which has been working for years, is throwing a seemingly random error message: "Cannot open specified file". The code just saves a PDF to a location on the local C: drive. It doesn't open the report or do anything else. The report itself...

Never mind! Found them in the "Details" section rather than in the control itself. Fixed with the following code. There's probably a less cludgy way to do this, but it works: With Me.[Field1] If .Value > 9999 Then .FontSize = 9 Else .FontSize = 12...

Where are those events? In the Property Sheet > Events tab, I see no such events. I did try conditional formatting, but size isn't an option.

I have a subreport that is fairly crowded. The fields are big enough to display four digit numbers, but not larger. This works 99% of the time, but occasionally there's a larger number that turns into #### instead of displaying. On the rare occasion of a large number, I'd like to reduce the...

Thanks @The_Doc_Man! - @isladogs's post is what I based my original loop in the first place. I tried adding the DoEvents line, but it doesn't seem to make a difference, unfortunately. I might play more with closing connections if I can figure out the right ones. This seems like the sort of...

I am trying to loop through all the records from a query and print one PDF report for each line of the query results. The data is located on a networked backend. The code below generates the dreaded "cannot open any more databases" error after the first report. I was told each report opened...

They have interactive ways as well, but nobody uses them - they prefer the speed of just entering an ID. The affected users assured me they were just typing the ID. I'm leaving it to the database to set the FK in the subform record - it has worked for a long time without issue and still mostly...

Thanks - I did this and so far...so good...fingers crossed.

I have a Single Form (Products) with a subform (Components). This has been working fine for 7+ years. However, a few weeks ago, a user said they updated the components for product A, then switched to product B and the subform continued to show the components from product A. Nobody else was...

Thanks everyone - it wasn't re-linking that was the problem. I ended up moving everything to Form_Open and changing the "settings" form to modal, and that did the trick.

I tried this first as the simplest solution, and it worked beautifully! Thank you!

When I open an Access DB, it it set to open a Welcome form which runs some code in the 'Form_Open' event. However, if the backend is offline, the 'Form_Open' code will generate an error. In my error handling to the 'Form_Open' function, I have it set to open the "Settings" form where the user...

Thank you - I think something was corrupt or indeed a strange unprintable character. I made a new blank copy of this backend and simply copied and pasted the old data into the new database. When I pasted one record, it threw an error. I retyped that record and now everything works. Thank you!

I have an Access database that can refer to multiple different backends. When users open the database, they are prompted to choose a backend from a list. When selecting all but one backend, all forms and reports work as expected. With just this one backend, everything works as expected, except...

Great idea! I immediately went and implemented this for two other forms that I was having similar issues. It won't work for this particular form for various reasons, but I am definitely going that route in other places. Thank you! Not sure why that never occurred to me but it is a beautiful...

Thank you! Very interesting solution!

Thank you! This worked! I'm still figuring out why using linkid works when using dietid didn't, but this gave me a functional result.

Thank you so much for looking into it - I really appreciate your time. It's still not working quite right. If I select Table Two and navigate (using the navigation arrows at the bottom) to diet 7, then when toggling, I should still see only records for Table Two and still be viewing Diet 7...

@isladogs We make specialized diets at different workstations (8 prep stations total). Each workstation has 100-200 diets that they make daily using a touchscreen mounted above the table. They use the "next" (and occasionally "previous") buttons to navigate from diet to diet. If the buttons...

DIETID is the unique id for the record on either form. So, it should FILTER by tableID (get all the diets for Table 1, for example), but jump to the record for "DIETID". In other words, the user should be able to use next/previous arrows (in navigation box in my example db, but with nice...