Search results

Thanks for the link Tim. Interesting method for reading the seat details without clicking. I may find a use for that... It's a shame that Access doesn't have a few more graphical tools so that we could develop applications and not just databases... Thanks again.. Dave

Hi All, I am in the process of creating a Room Bookings database using the limited graphical tools of Access 2003. I intend to break up the day from 0700 to 1900 into 48 X 15 minute chunks (the minimum bookable time) and have these graphically represented on the form as boxes whose colour...

I've scanned the forum and can't find any solutions or suggestions for this one... I have set up a form and subform. On the subform I have used conditional formatting to change the back colour of the field depending on one of 3 possible string contents - Lost, Found and Disposed. Sadly, when...

If I was doing this... I would place the calendar and combo on the same form... Then the user could select the relevant department....so far so good. Then they would click on the start date (in the calendar) and action would transfer the start date to a field (say Date1) if the field Date1...

Do you need to use IrFanViewer to view your pics? Although it's a quality viewer and free, wouldn't Access' own image field be sufficient for your needs? If it would then I would suggest - 1. In an admin page somewhere in your database, have the facility to input and store the usual path name...

It's always good when it comes together, don't you think? The trouble I've had with Nulls and Nothings!!! Dave Eyley

I think this will work... If Not IsNull(Me!Checkbox) Then If IsNothing(Searchstr) Then Searchstr = "[Checkbox]= " & Me!Checkbox Else Searchstr = Searchstr & " AND [Checkbox]= " & Me!Checkbox End If End If It tests for a Null Checkbox and if it's Null omits the...

Still working on this one, eh? Well I think your problem is just one of brackets. Using brackets will determine which parts of the logical search string will be resolved first. So, Exp1 or Exp2 and Exp3 - will get your result... While, Exp1 or (Exp2 and Exp3) - will achieve your aim, I...

I have a database which has been split. I notice that the FE and BE both show Relationships but not the same relationships. In a Split Db, which relationships are valid? Any thoughts? Dave E

But then you lose the option to sort columns on datasheets too, don't you. Dave Eyley

How about - Before the code execution that deletes the record - Dim MyReply As Integer MyReply=MsgBox("Confirm Delete? Y/N,vbYesNo,"Delete") If MyReply=7 Then Exit Sub . . .Delete Code goes here... Does that help? Dave E

mbentle, If you can understand the multisearchcriteria example in this thread then adding another subform to show the full details of one of the filtered records should be relatively easy. Start by looking at the way the existing example selects individual records to view. (The area where it...

OK - so nobody was interested... I decided to create a new blank database and import all of the objects and try that. It worked fine - Just in case anybody is interested....that is Dave Eyley

Morning All, The probelm I am having is this - Created a form with no recordsource and no controls other than an exit button. Into this form I have place 3 subforms - AdminSub1, AdminSub2, AdminSub3 When I save the form - AdminSub3 changes and when the form is opened again the AdminSub3...

Yes thanks, I've created a new form called 'Template' and pulled each of the controls onto it and set each one at Arial 10 and set these as the control defaults. I did think there would be an easier way though. Like setting a font in Office or even the Registry? As for the datasheet tab in...

I'm using MS Access 2002 on a network and I would like to change the default font on forms from Tahoma 8 to Arial 10. Any idea how I do this? There's no font list in Tools/Options/Fonts for datasheets either. Is this a common problem? Would be grateful any help on this? Dave E

The money I'm on, I can afford to be laid back.... :D Dave E

I wouldn't...they both worked, eventually..... :p As I said earlier, the problem was elsewhere; not the routine...but the forum did confirm that it had to be something else - not the code. And that's the useful bit... Thanks again

The reason for the clock is that the application is a Security Desk Information database and pretty much everything is time related - they want a clock on the screen they can see from across the room - they get a clock on the screen they can see from across the room...who am I to argue with the...

Is there a quicker or more efficient way to display a clock in a form? Why worry about slow code when speed isn't an issue? :rolleyes: Dave E