Search results

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, 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...

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, 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...

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...

Hi, I have an MDE database and the key form relies quite heavily on a filter. The only trouble is the user can right click on the form and select to turn the filter on and even change it. I can see why this is possible even though the database has been converted to an MDE but it is something I...

Hi, I am trying to write an expression in my query which, given a condition, it uses the following criteria: "Carmarthenshire" Or "Ceredigion" Or "Neath Port Talbot" Or "Pembrokeshire" Or "Swansea" So far I have come up with this: IIf([Forms]![Main Menu]![cboRegion]="West...

Hi, My situation: A front end written in Access (back end mySQL). I have made a .mde file out of this front end. There are a number of MS Word documents used (as merge documents) for running reports and letters that are linked to queries in the database. However, I can only link these...

Hi all, I have done a quick search for this on the forum so I apologise if I have missed the thread that talks about this. Basically I am interested in doing a text search on the SQL used in my Access queries. Is this possible and how? Thanks, Matt.

Hello, The scenario. Two PC's, one older than the other, both running Windows 2000 (SP4) and Office 2000 (SP3). I use Access as a front end to a MySQL database, connections are made using ODBC. I recently altered the structure of a table and attempted to re-link the table in access using the...

Hi all, this is my first post, I'll try and make it a good one :-) System: Windows 2000 Office 2000 I have a small network of PC's here which have access to our central database. I have a simple form created using the label wizard which is used to print address labels for mailing lists. On...