Search results

Thank you! This worked perfectly.

That quits Database B, not A, unfortunately (even if the code is in A)

I am trying to code a button that will quit the current Access database (A) and open another Access database (B). I can open database B just fine, but the quit command seems to close B instead of A. Database A knows where B is (so I can open it specifically), but B does not know where A is...

Thank you everyone - I've learned a lot. The code examples and example db were extremely helpful! I will be using both of those in several locations.

I currently have a button that launches a msgbox that asks "Which item?" and the user types "Fred", and it opens a report filtered to all the records where a field is like *Fred*.. This works perfectly. However, we now want to have users be able to type in "Fred or Ginger" (or Fred and Ginger)...

Thanks for the helpful advice :)

Thank you for helping me see this as a success and not a "taking over" and for the positive suggestions. I appreciate it!

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