Search results

Thanks for the speedy reply. This has given me the number of total records in the database, rather than the total number of records of each project.

What I have is report that lists all the project names, below there is a total of the projects and under that is a grand total number of all the records under every project. What I am trying to achieve is having a total number of records for each project. Table tblProject – contains the...

Thanks @ridders I will bear this in mind.

Will this need to be done on 'all' PCs that want to use the database? or will this setting be saved within the .accdb file?

I am not sure what you mean.

Thanks @arnelgp this is just what I am after, but the code comes up with Error 2001, is there something that needs to be added to the code to solve the error?

I have hidden the ribbon and database window adding the following code to the OnLoad event of a SplashScreen Access 2013 Form. DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.RunCommand acCmdWindowHide I would like to remove/disable the option to select 'Design View' (right-click menu) on a...

I have found the following code has solved my issue. =DCount("*","tblExample","ProjectID=Car")

I have reopened this, the above solved my issue for a bound report, but now I have the same problem for an unbound report. I have managed to get to code for a TextBox that displays total records within table which is shown below, but I would still like to find all the records within ‘ProjectID’...

I have just found the following that works, I hope this helps someone else with the same issue. =Count(IIf([Project]="Car",0))

I have a report with a record source coming from a query, within the query there is a field called ‘Project’. What I would like to do is count all records with the project called ‘Car’ and display that number in a textbox within the report. So far I have tried the following, neither of them...

I that a character was missing from the code Followhyperlink spli(me.field2, "#")(1) should be: Followhyperlink split(me.field2, "#")(1) This solution now works, thanks. :)

The textbox is on a ‘Report’, once double clicked it needs to open the URL.

I have tried the code above, which gives a Compile Error: Sub or Function not defined.

I have two fields on a form, text and hyperlink which are saved in a table. When I call up a report I am looking at overlaying the text (field1) over the hyperlink (field2). What I have found so far is to change the properties of the field on the report to: Forecolour: Hyperlink Color Is...

Can I overlay text from Field1 over a hyperlink that is in Field2 from a table/query, and then display within a text box on a report?

Thank you very much guys, you have both been extremely helpful. :)

Someone may/or may not select the project they are interested in, and may/or may not select a date range. Additional searching can be done by selecting either one or multiple checkboxes to display records that have only been checked. If none of the checkboxes have been selected, then all...

Thanks for replying. I have looked through the code from the example you gave, I can only see that it works on one checkbox as below. If Me.chkCharity = True Then strFilter = AppendFilter("([Charity] = TRUE)", strFilter) End If My knowledge of VBA is very limited, which is how I have...

I have expanded on the code a bit to enable all the checkboxes. What I have managed to do is to search using only one checkbox with the code below. What I am trying to achive is the ability of searching on any checkbox or a selection of checkboxes, I am wondering if I need a ‘Else’ or ‘And’...