Recent content by WhiskyLima

Ok how do I use the file/folder dialog? Thanks for the help fellas

Hey all, hopefully this should be an easy one for you. If have a report which I want to save as a PDF. The reports are named based on a couple of variables IE client name and invoice number; for example, 'whiskylima inv. 12345.pdf' What I am trying to achieve is getting the save as location...

Hi All, just wanted to know how you guys would set about this kind of problem. I have a number of tables with different information in them, ie flights, transfers, hotel booking etc. Each of these is connected to a client and a particular event using a booking reference. What I would like to...

Yes that works great, I had originally just put an extra line in to make the height of the whole thing bigger than it needed to be before resizing back to the correct height but I don't like that messy way of doing things. This code works great thank you.

I have worked out my problem. It turns out that the height of the sub forms determines how many records can be seen that that determines the record count. so if the box can only fit one record visibly, it wont count any more than 1 despite the actual number of records there. I have to either...

Hey guys, I have a form with 2 sub forms in it. The first form is on the top and holds bookings and the second is under that and holds invoices. I have made it so that each time an invoice or a booking is added or removed, the code below runs to change the height of each sub form relative to the...

Ok I will give that a go and see how it works out. Thanks

Hey guys, just a quick one I'm sure, I have a date and time field in my database, which is only storing the time (I know it has the 1/1/1900 as the date too) but when I select the field to change the entry it show both the date and the time despite the formatting rule in the properties window...

Ok I think I have found the problem and the sollution. As it turns out, if the font I want to use is not part of the Font theme I am using, it will keep reverting back to those font's even when I override the font face in the properties window. My solution was to go through the database and make...

Hey all, After having a go with a new database, I have managed to get the font to work with a new report on the new database. I should mention that the database I'm working on was created when I was using windows 7 and am now on windows 10. I have been through all the settings and I cant find...

Hi Thanks for your reply. I am using a font called Lato which I downloaded from Font Squirrel. I am using windows 10 and Office 2010. Just going to try a different font from the same place and see what happens. Thanks again EDIT: So I tried another font again from font squirrel and the same...

Hey all, it's been a while since I was last here. Just been doing some work on the database and have been tasked with changing all the reports to a different style. All is going well except when I try to change the font. I have downloaded a font called Lato with a number of variants (bold...

Ok that's what I thought. To be honest I think it might be ok just to have one button to either show or hide all guests. Thank you for your help

Hi All! I have a report which shows a set of events. In this report each row has a sub report which show the guests that are attending. What I would like to do is to use a button to drill down into each individual event and hide it again on clicking the button (like a toggle button). I have used...

Hey guys, my brain isn't working at all today. I should probably have made clear it's not a sub form, it's the main form, does that make any difference? Heres what I have tried: clientFilter = "WhiskyLima" strSQL = "SELECT * FROM [Invoices] WHERE " If Not IsNull(Me.clientFilter) Then...