Search results

Please help... Has anyone got a copy of the solutions.mdb for Access 97 or a Access 2000 version manipulated for Access 97 as I really need to get going on this. If anyone has any ideas on how to make this work I would greatly appreciate it. Regards Jason

Hi I am trying to build a crosstab report which generates the columns from a query on the fly. THe reason for this is to record any issues we have on each day so for example We first call the report on the 1st of March and we had Issue----------------Total Issues-----01/03/06 Printer...

Hi I am trying to pass some details from a combo box into an email I am creating as part of a call logging system for my company. I want to pass the text relating to the combo and not the actual bound column so I thought that an IF statement would be the way to go. I have used message boxes...

Hi I am trying to pass some details from a combo box into an email I am creating as part of a call logging system for my company. I want to pass the text relating to the combo and not the actual bound column so I thought that an IF statement would be the way to go. I have used message boxes...

Hi Sandpiper You can't use a combo box for multiple selections. You need to use a list box with the multi-select option set to either simple or extended. Hope this helps Regards Jason

Access 97 versions Does anyone have any access 97 versions of these databases. Particularly the "Manytomany artists" file as I am trying to create a skills list where a contractor can have one or many skills and a skill can be for one or many contractors. I realise I need to have a link table...

hi RG Sorry I've not had chance to look sooner but I've just had a look on Candace's site and couldn't find anything of any relevance to what I'm trying to do. I want to pick a company from a combo. Then select the skills which are relevant to them, and finally have all this data stored in a...

Superb Nice one Smart. That's just what I needed to make things work. I removed the resetpw variable as it was now redundant and created an update query to pass the information back to my table. Many thanks Jason

Hi, Can someone please have a look at the below code and see where I'm going wrong. The code works and I have tested it with message boxes to prove that but the new password isn't being returned to the table. Option Compare Database Option Explicit Dim pwcount As Integer Private Sub...

Aaaaaaaaarrrrrrrrrrgggggggggggghhhhhhhhh!!!! Ok I've reset my If statement to produce a listbox instead of go to either the report or form for testing purposes Here is the code If IsNull("forms!frmcalmain." & subformname & ".form!scheduledmain") Then SFNull = True Else SFNull = False...

Right, I have completely redone the code. The On_enter event now solely passes the subform name to the function: OpenCalRep(SF1) The Function now reads: Private Sub OpenCalRep(subformname As String) If IsNull("Forms!frmcalmain." & subformname & ".Form!ScheduledMain") Then...

requerying Very eloquently put I must say. However, due to the fact that each month is selected from a combo box at the top of the screen (cbo_month) the whole form is requeried on selection. This means that only those subforms that have data to be imported are tampered with in any way...

Has anyone got any ideas on how to assign a value (even a null value) to a subform when there is no data to prefill it. i.e. if subform is blank then... I need to do this so that I can open an input form if the blank subform is entered. Regards Jason

Just an old handle. Non offensive yet different enough to make people like yourself ask questions. :)

scheduling issues Ok, I've had a play with the coding and it now kindo of works. Attatched is a screen shot of the scheduler itself so that you guys can further understand what I am trying to do. I want to open an input form if a blank subform is entered. To do this I have added an extra if...

Spot On You were right OldSoftBoss. I didn't need to reference the variables which was why a boolean result was returned. I also used the txtbox name as a choice instead of the tag line. This is because I am still having some issues as you will see below. The report link now works...

Ok I've amended the code. I just can't figure out why I am getting a boolean result returning. Here it is: Private Sub OpenCalRep(date1 As Date, subformname As String) If IsNull(date1) Then DoCmd.OpenForm "maintenance1", , , , acFormAdd Else DoCmd.OpenReport "calendarreport", acViewPreview, ...

Issue still the same I have tried the IsNull(date1) piece of code but I seem to recieve the same result. Any more ideas? This has really got me stumped. Between this and trying to get my listboxes running properly I am running out of ideas Regards Jason

I think there is a problem with the referencing of the date field in my subform. (SF1) The form itself is named "frmcalsite" but is referenced as SF1 as it is being used as a subform. At present SF1 is blank so it should open my maintenance input form (frmmaintenance) with the date box filled in...

Morning guys and gals I am trying to create a sceduling calendar for my department which displays given events day by day. I have created this using subforms for each day and a combo box to select the month. For display purposes it works fine but I am having a little difficulty with the...