Search results

id like each site to have a unique reference that is made up of the Account Reference and a unique number for that site for example an account which has 2 sites would work like this; (first site for each account is always 001 and ascending from there) RHMP/001 RHMP/002 AASX/001 AASX/002

thanks for the quick reply :D also is there a possibility of having the following TEST1/001 TEST2/001 so that the first site on each of the records has 001 and the second 002 and so on?

Hi is there a way of merging 2 fields together to create an additional field my database consists of 4 main tables (in order of relationships) *HeadOfficeDetails *SiteDetails *ContainersOnSite *Contracts2015-2016 for example; Account Reference: TEST Site Number: 001 and the field i...

Thanks for the reply, unfortunately im new to coding and i dont quite understand that well, is there any way of explaining the code a bit more simple way.

i have a subform with a field that i double click which opens a list of items, would it be possible to double click an item in that list to enter it into the field on the subform?

Hi apologies if this has been asked before... :banghead: i have a subform 2SiteList (Datasheet View) with the field SiteName... i also have another form SiteDetails. if possible i would like to be able to double click on a SiteName on the subform and have the SiteDetails form to open to show...

Still getting the same problem...

just tried that but it's still the same, anything else i could try... :banghead:

Can anyone help me out, i have a problem pop up on my database this morning that i haven't seen before: The LinkMasterFields property has produced an error: 'A problem occured while System was communication with the OLE server or ActiveX Control'

Hi apologies if this has been asked before but is there any way to use an account reference from one field in a table on a second table and add a number after it... e.g. :confused: Table 1 Table 2 PEFA PEFA/001 PEFA PEFA/002 PEFA PEFA/003 PEFA...

Hi im attempting to build a database for bin weights by customer i currently have the database model as below; * Customers * Customer Sites * Bins on Site on the 'bins on site' table i have for example A/c Waste Type Quantity Customer 1 General Waste...

Hi i was just looking at the sample that someone provided and was wondering if a similar thing was possible but clicking on a text box (for a postcode) will open up the postcode location in google maps? Thanks in advance

Hi i needed to copy my database file over to another computer but on the laptop i copied it to when i open it i get a message (see attached) any ideas on whats causing this error and how i can fix it? :banghead:

Hi i was just wondering if it was possible to have the sub report displayed without any gridlines or anything? Thanks

Hi is is possible to open a form to add a child record related to the highlighted record in the subform? Thanks in advance

Hi, sorry if theres a post like this already. i have a main form for customers and a subform for sites which is set to locked so its displayed as just a list. I have a button on my main form to add a new site for the current customer displayed... How can i get the Main form '1CustomerDetails'...

Hi i would like to have a form on my database that selects which criteria to put into a query/report (like the sales report on the northwind sample db) is there an easy way of doing this?

i have a list box called "SearchResults" which has 2 columns Account and Name and a text box which filters the list, i would like to be able to double click the list box item to open the detailed form "1CustomerDetails" using the account. :banghead: could anyone post the code on here (i'm...

Hi, i have a main customer form, then a second form with the customer sites, linked by an account reference. is it possible to have a button on the second form (for the sites) to add a new record but to auto fill the account reference from the selected record from the main customer form (i have...