Search results

Hi folks I have an unbound form that contains three graph objects - Graph1, Graph2 Graph3. Each graph serves as a dashboard report and is linked to individual queries, each containing a field called 'Academic Year'. I would be grateful for pointers on how I can set the form up so that the...

Hi all I manage an apprenticeship programme for a college. Students attend from multiple Local Authority areas, multiple schools per LA area. We require to report attendance by school after each day of the course. Currently this is particularly time consuming because attendance is marked by...

Hi folks I have a college information system that manages two-year courses. At present we have three blocks running 15-17, 16-18 and 17-19. I have an Autoexec Menu with buttons where users select buttons to administer data. One of these buttons is called 'Enrols'. This opens up a form...

Folks I work for a college. I'm looking to get my workplace to develop a Web Form that can submit Applications from their website directly to an Access database. Website is controlled by someone in Marketing and I'm being told that this isn't possible, which I know to be bollocks as I've used...

Hi all I work in a college and have developed an attendance management report. Within this is a breakdown of students attendance from particular schools which we then circulate to each school via email. Currently it is a very cumbersome process eg: User runs the report per school Save...

Working on an absence database. Start Date and End dates are recorded. From this I then calculate the number of days absent. However when reporting I need to display absent days per month. So if Joe is off from 27/07/12 thru to 04/08/12 I need it to show x days in July and y days in...

:confused: Folks I'm working on a Travel and Expenses system and trying to come up with a solution to the following. Company has three bases. Company policy dictates that if departing from home to work at a location not your base, then you should clain the smallest distance between either...

Folks I've been asked to identify an alternative reporting tool instead of Crystal Reports for that staff can gain access to more immediate and user friendly informaiton. the plan is to link this back to a SQL database and user could then choose the informaiton they wish to access and the...

I have a form on my system. I know how to include a subform on this and I also know how to use a button to open a form. What I want to know is how do you go about using a button to open a subform. Previous attempts to do this do not insert the common data to the subform control and and such...

Hi I've recently deployed a system across my network. Problem is when users access it simultaneously it crashes. All my forms, reports, macros and modules disappeared etc. Would creating a BE and FE solution resolve this? Any other clues would be much appreciated Thanks Frank

Hey folks Trying for some time to resolve this issue but in short i'm not a programmer and simply getting nowhere. I'm happy to pay for an hour of someones time to resolve if at all possible. Payment will be made immediately through paypal. Please let me know. Link below contains further...

Folks In my system users enter their timesheet weekly. It seems that on the first week of every month the following code falls over. Returning a Runtime Error 3021 'No Current Record' Option Compare Database Function GetFlexiMax(FDate As Date, FId As IdleEnum, Username As String, Maxlimit...

Hi Users identify organisations against a project from a pull down list which pulls from TBL_Organisations. If the user has an organisation that is not already in the pull down list, can they add to it from the pull-down, thereby adding to the table or do they have to exit the form, add to the...

Hi all I'm developing a small football site and would like my home page populated with summary pages from all the other pages on the site. For example, a summary from Latest News, Match Reports, Results etc... Using WebPlus to develop the site as I know little about Web Development Thanks Fozi

Hi folks In my form there's an email button. This pulls through certain form data to the email combined with generic text. I have a block of controls on my form which are comments boxes. I need the email to pull through any comments in these boxes unless the box is empty - null or "". I've...

Hi I need to create a record source for a report containing calculated fields. Advice I have been given is to do this through creating a temp table from which to serve my report. Currently I have a control in a Form which has a module generating a value I need for a report but the module...

I have a form called FRM_FlexiEntries. There are two controls on that form called [Staff Name] and [EmpID]. I am trying to get DLookup to compare the [Staff Name] on the form to its counterpart called [Fullname] in [QRY_StaffDetailswithFullname]. Upon matching I want it to return the...

Hi all Those close to this board will know I've been working on a Timesheet system recently. I'm self taught in access and know very little VBA so when it gets to doing clever stuff I rely heavy on the support from the good people her - so thanks to all who have helped thus far. Such is my...

Hi all Currently if a user clicks on the Forward record selector it will create a new record. Parent Form has two subforms, some controls have default values. Is it the Default values that are enabling this or something else? More importantly, how would one go about preventing it? Thought...

Folks Following up my many posts on this (thanks to all) is there any way of limiting the Running Sum to a max limit - in my case 864? So that upon exceeding 864 it is set at 864. Thereafter reducing accordingly if subsequent weeks are in deficit. See Mick example below. 1160 should be 864...