Search results

I have a report that generates a graph that is so long that it flows across several paper pages. This isn't a problem, except that when printing/print previewing, page 1 just shows the report header, but is otherwise blank, and then the graph starts on page 2. I've tried: Putting the graph...

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

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

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

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

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

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

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

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

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

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

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

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

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

I am trying to code a button that switches between two nearly identical forms for a touchscreen interface. The content is identical, but one layout (form) is for left-handed folks and the other is for right-handed folks. I'm trying to make it so that clicking the button toggles from one form...

I have a VBA script that (a) deletes the contents of 2 tables and (b) runs 4 VBA-encoded queries that insert records into the same tables (i.e. refreshes the contents of those two tables). The first time I run the script after opening the database, it takes about 2 minutes to run. If I run the...

I basically want a simple form that I can filter by three variables (SUPPLIER, FOOD, ANALYSIS). There are three comboboxes that let you pick from our short lists of suppliers, foods, and analyses, and a subform based on a query of those tables. This is a webform where I can't refer to the...

I am querying a table (tblMeasurements) with the following format: ItemID MeasurementID MeasValue 1 23 10 1 24 1.5 1 25 2.3 2 23 20 2 24...

I have an option group of buttons and I can't seem to get their appearance to be "flat". No matter what settings I choose in Properties, they retain their "raised" appearance. This does not hold true for regular buttons (not part of an option group). Does anyone have any suggestions for how...

I'm having trouble with a query criteria causing SUM fields to not add up as I wish. Basically, I need to run criteria on a field, but I don't show that field in the resulting data table. I want it to ignore that field (NOTES) when summing the prices. Test Table: NAME CATEGORY PRICE...