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

Great thanks for the tip. I'm new to combo boxes with 2 fields, but it's very useful.

Great idea, unfortunately I have joined other tables for drop down selections using FK's :( Oh well.

Thanks, I realized that property had been changed back to no.:o Solved.

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

That worked brilliantly. Thanks Pat :D

Thanks Pat. I'm having trouble with the syntax though. here's the query I want to add the sum of PO_amount from. SELECT Purchase_Orders_T.project_id, Sum(Purchase_Orders_T.PO_amount) AS SumOfPO_amount FROM Purchase_Orders_T WHERE (((Purchase_Orders_T.project_id)=[Forms]![PROJECT...

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

Thanks Pat. Is it possible for the details report to default to all PO's when user clicks that tab without coming from the summary tab? Or am I stretching the limits of access tabs?

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

Great, thanks Paul. Currently I show both the PO number and the corresponding PO Type in the drop-down, but only the PO number shows up after selected. Is it Possible to show the matching 'po type' in the combobox field alongside the #?

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

Thank you CJ!

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

Thanks for the tips. I've got it working. Unfortunately the network here is set up using non-personal names, so I'll have to do some swapping during the insert. I've created a table of users that contains their personal name and their pc login username. What would you recommend the best way...

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!

LMAO, sorry about that. I spend too much time texting and coding. Is that considered distracted coding? If I wanted to refresh all the sub-reports in the dashboard at once, what's the best way to achieve this? TIA (Thanks in advance:)

Oic. I know there's functionality to do so for a subform when the master is changed, was just hoping similar functionality might be available for sub-report based on a subform change. Wishful thinking I know, but hey, never hurts to ask. The dashboard has a combination of data entry and...