Recent content by lawsonium

I am doing my first ever UNION query now, getting there slowly I think. Thanks very much for pointing me in the correct direction. One question though. Why did I suddenly get a message saying that one of my data types could come from more than one table/query even though it only appears once...

Hi, My SQL is fairly basic so excuse me if this is something simple. This isn't my database, I am trying to create a report on someone else's and it's a poor structure (sound familiar :-). If I have created two queries; one of which selects results on students from one table and the other...

Hi there, did you ever get a resolution to this? I'm having the same trouble with Total's in the Footer not appearing in the Excel output. Anyone? Matt

Hmmm. Not sure what you mean quite. Just to get it straight, it might not be ALL the other counties all of the time, that's why I wanted to name them individually. Does that change things? Thanks, Matt.

Hi, I am trying to write an IIF statement in the criteria of my query. I want to do something like this but can't get the syntax right. Can anyone help? IIf([Forms]![Main Menu]![cboCountySelecter]="All Wales","Anglesey" Or "Blaenau Gwent" Or "Cardiff" Or etc etc...,[Forms]![Main...

To expand on this post (sorry to hijack you here). Can anyone tell me how you can use a combobox on a report to alter the output of the report. e.g. select a new value in the combobox and refresh the form usnig the new value selection. Thanks, Matt.

I know this sounds like stating the obvious but have you checked the following: Page Margins Page orientation/setup Local settings (US/UK etc.) It is much better (talking form experience) to just create the Avery label template again using the Label wizard though. You still have the query that...

Small point, you example doesn't work if you have your sheet trimming the leading zero!

Am in a rush, sorry. Have a report grouped by Course then Month. It then lists dates of courses in Acending order for a given course in a given month. I would like to alter the output for the first date so it lists subsequent dates one oafter the other. i.e. If Course 1234 session = 1 then...

Hi, thanks for your reply. The problem with this is that I won't automatically know what the fields are. I would like to take a dump of all the data in the current record without prior knowledge of the fields used. Thanks, Matt.

ok, that sounds interesting, unfortunately I have never heard of it. Can yuo enlarge on it's usage or point me somewhere that covers it. Thanks, Matt.

Hi, I have failed to get the clipboard manipulating VBA working so can anyone tell me of another way that I can write the current record to a variable. i.e. I am viewing a record on a form (not all fields are shown) I want to write the entire record (all fields) to a variable using VBA. How...

Hi, Yeah, I got it. What I actually needed to do was gt it to automatically drop down and start showing what I was searching on. I have got that now. Thanks.

What I would like to do is be able to type directly nito a combo box but have the combo box expand and locate the record you are looking for. e.g. If you have a series of records with ID's 1 to 10,000 and you type in 985 for the record ID you are searching for, when you hit the 9 it locates the...

I take it that FilterOn is set only through VBA as it isn't in the properties list? Thanks, Matt.