Search results

It seems to work. The output of the query includes all 5 of the regions. The OR's seem to work but I agree it doesn't look right. What would the best syntax be? Matt

Ok, I've been fiddling and I've come up with this: IIf([Forms]![Main Menu]![cboRegion]="West Wales","Carmarthenshire") OR IIf([Forms]![Main Menu]![cboRegion]="West Wales","Ceredigion") OR IIf([Forms]![Main Menu]![cboRegion]="West Wales","Neath Port Talbot") OR IIf([Forms]![Main...

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

Solved :-) It looks like I've answered my own question :-) Yes, it does wok with parameter based queries as well. Thanks for all your, lol. Matt.

OMG, stupidly, this actually works! You rename the .mde file .mdb and magically you can link to the queries within :-/ The .mdb file now has all the same characteristics as the .mde file (locked to the user for editing). So you have to be careful that you don’t overwrite your original .mdb file...

Just found this by searching Google: http://support.microsoft.com/kb/180663 I'm going to try it out now, I'll post back. Matt.

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

Ok, I like this. What would be the best way to loop through all the queries in a database? Matt.

Good plan ;-)

Hi, Your problem is in the HTML The correct syntax for a checkbox is: <INPUT TYPE="CHECKBOX" NAME="YOURNAME" VALUE="YOURVALUE" CHECKED> Where you have a checkbox that is 'checked' you need only include the parameter CHECKED in the tag. Leave it out for it to be unchecked. Something like this...

Yes. Using an update and simple maths to add two integers. However, I would use a script as my SQL isn't very strong. Matt.

I would say this is best achieved using VBA or similar script. If I have read your question correctly it doesn't seem like something you would naturally do in SQL. Purely because it is iterative and recursive. Do you see what I mean? Matt

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.

Anyone? Matt.

Hi Robert, I discovered the answer to this was in my ODBC connections, thanks for your reply. I removed all my old connections and remade them and all seems fine now. 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...

Ok, amendment to the above. I just realised I posted this in the wrong forum, this should be in the reports forum as the text box with the trim function is in the report and not the form and it was removing it from the report which stopped the error. Can I move this post to the Reports forum or...

Anyone got any ideas on this? I am imagening that it is something that either the Windows installation is missing or the Office installation being as some PC's don't have the error and others do! The Trim function only removes white space from either end of the string so I don't think it's...

Thanks for the advice but it's no problem, this is purely a front end access application which references a MySQL database on our central server. The ODBC error (which isn't an ODBC error) if you see what I mean, still persists. Well, only if I leave the Trim function in :-/ Thanks, Matt.

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