Search results

Thank you for seeing through my questions to the real issue - it is darn hard to let a beloved project go off into the wild without me. Thank you for your advice and feedback.

Our database (split fe/be, 80 users, Office 365, in use for 6 years, regular small modifications to add features or new reports) has become mission-critical enough that folks are rightly nervous about the backend living "loose" on a shared network drive. I'm being asked to move it to SQL server...

Aha! That worked! Thank you!

Thanks! You are correct! They are not closing! When I type that same code in the immediate window (using a real form name, of course), it works. Why isn't it working in this function?

I am taking a large database (split front/back, 85 forms) and creating a script so that users can switch all of the button and label captions on each form to their local language. The eventual script will use a table like this: TableName ControlName LanguageCode CaptionText Form1 Button1 en...

Wow - this is so helpful! I've been trying to implement something like this for ages and this worked so easily! Thank you!

Yes! That did it! Thank you so much!!!!

Here's an example

Thanks! I tried that and got a new error: Runtime error 438 Object doesn't support this property or method.

I'm trying to create a setting that cycles through all my reports and changes them all to A4 (or vice versa to Letter). The following code almost works, but I can't seem to refer to the reports correctly. What am I missing? Public Sub UpdateReportPageSize(pSize As Integer) ' 1 = Letter; 9 =...

It works fine every time except upon opening the form. The error isn't being thrown by the code - it's being thrown by Access doing some sort of typecheck on the entry, but it doesn't seem to do that after you use the combobox.

Thanks all! The control is not bound. The rowsource is a query. I cannot post the database, unfortunately.

I have a combobox that looks up the employeeid (user sees a list of employee names) to navigate to that record. Many folks who know the employee's ID number just type the ID number itself rather than scroll, and that works great too. However, some folks occasionally type the user's name...

Thanks everyone - IT wouldn't roll back to an earlier version of Access, but they would bump us up a release, and the issue seems to have resolved. I never got an errors to show up in the various places one sees errors, so I think it might have been more OS-level errors that I have no ability to...

I have no control over our updates and versions, including no ability to roll back patches, unfortunately. Any ideas how to stop the popup?

Oooh - I like that way. I will experiment.

I have the handy Allen Browne function ShowUserRosterMultipleUsers installed in the frontend and backend of my database. When run, it tells you the computer names of the logged in users for that db. Is there a way to run this on the backend FROM the frontend? I.e. see who is connected to the...

Yes - the filenames have not changed and none contain illegal characters.

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...