Search results

Friends, I have a continuous form, a bound control 'PercentProgress' into which the user enters a value to represent their progress with the task & an unbound textbox 'txtProgress' into which I wish to populate some kind of progress bar to visualise the task progress. I have simulated this with...

Hi, I have a mainform 'frmPersons' on it are a number of tabbed subforms. As an example one is called 'frmAddress_Subform, and the subform control is called 'SubfrmTab' to be original! My intention is to pass the form name to the below function to assign user rights. All works on the main...

Friends, So I have a combobox 'ContactPurpose' on a bound continuous subform. I wish to populate the combobox with all records except when the user enters a new record, in which case I wish to restrict their selection to only 'Active' records. So, i have 2 select queries as below on the...

Friends, I intend to use 'modNotInList' to manage user additions to comboboxes. I did not write this code, but cannot remember where it came from!. I have a form 'frmOrganisations' on which is a combobox 'OrganisationCategoryID'. My intention is for the user to add a unique additional Category...

'Hi, on 'tblOrganisations', I have a tabbed 'subform' on tab 'Personal' of that subform is a combobox 'cboClassification' that I wish to update whenever a user selects the button 'BttnOpenCategory_Jobs' on the main form. This opens up form 'frmOrganisationCategory_JobRoles' , checks that...

Hi, I'm working on my CRM project. I have a problem where the wrong fields are hidden/displayed upon initial opening of the next form after the initial form is opened. Difficult to explain, but open frmMain, open either of the top two options & the correct controls are displayed (that is Nav...

Friends, I’ve started a new project which is to be a CRM system along the lines of that published by CRM Design Tutorial. I like the flexibility that this design provides. I have built the database tables and relationships. A design consideration is the 1:1 relationship of PartyID to both...

All, The 'PartyID' passed to the where statement is causing me grief. the value is not being passed, rather the text 'PartyID' is being passed. I suspect its simple syntax issue but I haven't figured it. Appreciate some help. Public Function DeleteRecord(PartyID As Long) On Error GoTo...

This maybe simple but i could not find an example. If i have a form 'main' and wish to open either of 2 different bound subforms, say 'subform1' or 'subform2' by button press. How would i do it? Or is this the wrong approach? Appreciate the heads up.

Friends, i've been passing the foreign key to the related form i wish to open & on the receiving form using the onload event of the form to populate that key to the new form. I realised that ifthe user closes the form without entering data, then a 'fantom' record is added that contains the fk...

All, this is driving me nuts!. I have a report that includes a linked subreport & within that another linked subreport. When I preview the report all is well, but when I print the report to either a printer or as a PDF it is formatted so that upon change in the record on the subform (inspection...

All, I've just completed a project that I estimate has taken about 500hrs & has been a labour of love. I've been forced from my comfort zone, taken all sorts of twists and turns, learnt a stack of good techniques, gotten some great support & had a lot of fun. Now it's done & in use, I'm at a...

I am in the final stages of developing my “Beekeeping” database and shout out to all the people who made it a reality. To describe the project, I purchased a ‘FlowHive’ some 18 months ago. This type of hive is unique in that it dispenses honey without the need to remove (and disrupt the bees)...

Hi, I'm using the below code to open outlook from a command button on a popup form. All works well but outlook always opens minimized. I have another routine that uses the sendobject method (for different reason) and it works well. So what I do is check whether outlook is installed, if so use...

Hi, I have a report that has a 1:many relationship with image paths as a sub form. I have an image control on the many form that references the appropriate path. All works good. but as expected, prints each image below each other. I'd really like to print 2 images across the page then start...

Hi, I'm considering using field column History for capturing changes to a record 'Notes' on form 'frmPersons'. The record source is 'tblPersons'. I found this code by Googling and like the fact that it generates the history to a listbox. Code ceases where I attempt to parse datDate about 2/3...

So, I have the following code that worked fine when the rs,findfirst line was hard coded (now commented out). I wish to make the function more universal by passing the 'find' part as a strwhere that I've built up. But, it doesn't work & returns an invalid argument error 3001. Clearly, there is...

All, I found, what I thought was a useful bit of code in the Access 2019 Bible "Deployment" section & thought it may be useful to others. What it does is write the error code etc to a text file. Previously, I'd always appended to an error log table within access, using an append to the error log...

To date, my projects have been limited to a split database with maybe up to 6 or so concurrent users. I'm keen to know the 'scope' of some of the applications running an access front end. If you feel inclined i'd like to know what you've done. Obviously no propriatory or intellectual details...

So, I have a form containing a subform. That subform is a continuous form including a control to open a popup/modal form to display filtered records, based upon the [HiveID]. The PK of that subform. I use DoCmd.OpenForm "frmHivePhotos", , , "HiveID = " & HiveID, , , Me.[HiveID] on the subform...