Recent content by lloydmav

Its telling me invalid sql statement when I use that. Here is the full query :confused: PARAMETERS [Start Date] DateTime, [End Date] DateTime; SELECT AI2.STRUC_ID, AI2.A_LYR_TYP, AI2.A_ID, AI2.A_SEQ_NO, AI2.AI_INSTL_DT, AI2.AI_REMV_DT, T1.AI_INSTL_DT "NEW...

Hi, I'm converting a couple of queries that currently have Between Date Criteria. The first query worked perfectly however my pass through query won't work when I add in the parameter instead of the date. Any ideas? Before (Works Fine) WHERE S.SLOT_DIS_LYR_TYP =...

Hi, thanks for the reply, I tried that but I get the error mentioned above. I think what its saying is the field name in the first version of the table is ambiguous with the name of the field in the alias table, or something like that

Hi, Can anyone help me solve this issue. I have a main table lets call it [product] which has a [created by] field and also a [modified by] field. I need to link both these fields to the same [employee] table and returns the surname for each. I want to return all the records from the...

I'm sure this must be an easy one, I haven't used access for years and I've forgot how to do everything. I'm designing a query based on a linked table which belongs to someone else. Unfortunately they appear to have stored a cost value (eg. 12030.30) as text. I need to group the table records...

MattS - cheers, I did realise that was the problem and so I changed them to integers etc however I forgot to remove the apostrophes. Miles - yeah I know the naming convention is crap. I only temporarily named them like this for testing purposes Thanks for the suggestions guys, I'm slowly...

Thanks for the help guys! Tried the last suggestion but had data type errors; However I've managed to solve it easier by removing the need for the action plan id in the dcount. I've put that criteria directly into the query. And for the dcount code I've used: Dim var1 As String Dim var2 As...

Ok I've managed to get it to work now. But the problem is I need to replace the value 26 in the dcount function with the variable actionplanid. Whenever I try to do this I get an error message Runtime error 2001 "You cancelled the previous operation." Help doesn't seem to be much Help...

I've given it ago Miles but I'm getting a Type Mismatch error What do you think of the effort below?, does anything stand out that looks wrong? ----------------------------------------------------------------------------- Dim var1 As String Dim var2 As String Dim actionplanid As String...

Thanks Miles, Thats a great suggestion, not sure how to go about writing that but I'll go away and do some research, and give it a go! Thanks

Hi, Its been along while since I've worked with Access, I've been using VB & SQL Server however I'm trying to repair an old database I built. So I would be very grateful for any help you could give me! I have a query which brings back lots of results with different 'Action ID Values'. Now...

Cheers guys! Seems silly now I know, I was trying things like If List1 = Null or If List1 = "" Anyway Thanks

I know this is a really simple question, but I've been away from Access for months and I feel like I've had my memory wiped! Whats the easiest way to detect whether a selection has been made in a listbox, I'm linking access to sql server tables which don't allow null values, to avoid nasty...

It works for me! You need to make sure you enter the full address eg; http://www.website.com I know it sounds daft but also make sure you have the correct name eg combo3,

Your right it didn't work, try this instead! Dim Website Website = ComboBox1 Application.FollowHyperlink Website