Search results

Hi all, I looked but couldn't find a way to rename the backend of my db. I tried making a copy with a new name then using link manager but ended up with links to both the old and new one. How can I rename my DB backend? Thanks

I've noticed that my split form for entering new records sometimes opens populated with the first record in the table instead of beginning with a new record. Any idea how to mitigate this? Thanks :o

I have a subform in continuous form format that currently has no edits and no deletions. The user uses a split form to enter the data which displays in the continuous form. However, i am noticing that user would like to be able to edit a couple of fields only, but maintain no deletions or...

Hi all, I would like to add a value to the summary line of my report that is part of another query and not the query the report is based on. Both queries will use the same where clause dependent on a form variable being passed to the report. Is this possible? thank you :rolleyes:

I am wondering how to print a report that is rendering inside of a tab within a form. I have tried a print-preview macro tied to a button, which works on the standalone report, but throws a "You can't switch views error" when clicked while rendering the report inside of a tab. Any advice is...

I have a set of 3 Tabs: first is PO entry form. 2nd is the summary list of sales orders against PO. 3rd Tab for the moment is a detailed report of all PO's and related sales orders. what i'd like to do is allow user to click a PO# in the 2nd Tab (summary report) which opens the 3rd tab...

I have a project worksheet (parent) that has a list of PO's in the main form based on project Id. The sales order worksheet subform has a combobox that I want to only include PO's for the current project. I'm querying the PO table which has a project_id fk. Where clause for the PO combobox...

Morning colleagues, I have built a couple of modules in Access 2016 using the split db method. A couple of questions now come to mind as more functionality is being asked for... 1. The client would like to log all activity 2. They're going to need more transactional type functionality as...

I have a form used for data entry by several persons, and i would like to automatically insert the windows username into a user column for the record they are inserting. I have figured out how to get the username, but how do you pass it into the username column behind the scenes? Thanks!

I have a parent form with 2 sub-reports providing sub-totals based on data shown in a subform(datasheet). Currently i have to position mouse in each sub-report and click 'refresh-all'. Cumbersome. When user adds new records or updates the amounts, i'd like the sub-reports to auto update...

I have a parent form that holds contract data and then a sub form that captures sales order entries against the project. There's a notes field in the subform. To start with it is only 1 line deep. Can it be set to expand depth-wise to display all the content after a refresh while subsequent...

I have created a module for project estimating and split that database into a FE & BE. I am now wanting to create a project billing module using some of the existing tables plus new tables. I want to keep one BE. I would like the same FE as well but with a different home tab ie. "Billing" vs...

Can I have one FE link to various other BE's for different purposes? 1 fronted with a generic app that stores the data in back-ends dedicated to line of business, such as a finance BE, project BE, inventory BE. Thus allowing cross functional querying between tables in different BE's...

Hello gurus, Well my app is almost completed. I have set a few things such as custom menu, display a certain form on open etc, but I'd like to show MORE THAN ONE form/tab on opening, such as user guide and the initial list form. How can I achieve this? TIA

I have created a main report with 2 sub reports. The first subreport contains the list of items and the 2nd sub report contains a series of spec sheets and dwgs for each item if the record has one. The final report is usually sent to PDF format. Is there a way to create hyperlinks in...

I found an eloquent method of choosing and storing imagepath/name for a record as opposed to storing the image in the db. I need the ability to choose multiple images in the same dialog and not require the user to choose individual files over and over again. On most occasions the user needs to...

I just got in to work, started up ACCESS 2016 and my default PROJECT form shows up :) I choose a project, the form is populated with a dozen or so records, including attachments with the icons showing up. However when I choose report the images don't appear. only the file names. I return to...

I only 2 Tables: Project and LineItems. Lineitems contains a bunch of text fields to hold size, qty, mfr, model, sub-model, notes etc. tied to one project (1 to many) I currently choose a project and then open a form/continuous subform where user enters the lineitems. without being a fully...

This one is confusing to me... I have a report iterating through several saved images in the items table just fine. When I close access and re-open that db, the pages iterate but no images show up. Only when I go and re-add ONE image in a record does Access remember where to find the images...

Traditionally in the web world i would create a list page with a few fields and an 'edit' button on the end, appending a url parameter to pass to a form whereupon displaying the record to be edited. Can this be achieved in Access? Currently I have a combo box at the top of the edit form...